Click here to Skip to main content
15,881,248 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi
it is such that I must have my text box contents of the database and at the same time I throw the content into the database.

Right now gives the problems that it should throw it into the database,

I have done so:

Opret.cs file - Model:

C#
public class OpretBrugere
    {

        public int UserId { get; set; }

        public string Email { get; set; }

        public string PasswordHash { get; set; }

        public string FirstName { get; set; }

        public string LastName { get; set; }

        public bool Newsletter { get; set; }

        public int Fk_role { get; set; }

        public int Fk_package { get; set; }

        public int Fk_sex { get; set; }

        public int Fk_area { get; set; }

        //den skal selv opret datetime (Altså tilføj sig selv)
        public DateTime creatadate { get; set; }

        public DateTime age { get; set; }

        public int Fk_professional { get; set; }

        public bool Approved { get; set; }

        public string img { get; set; }


    }


KontoController.cs

C#
[HttpPost]
        public ActionResult CreateUsers(OpretBrugere brugere)
        {
            if (ModelState.IsValid)
            {
                //Tjekker op på om der findes en brugere med den email.
                var CreateAnAccount = db.Users.FirstOrDefault(b => b.Email == brugere.Email);
                if(CreateAnAccount != null)
                {

                    brugere.Email = hello; //<--- Information fra textbox here
                    brugere.PasswordHash = hello; //<--- Information fra textbox here
                    brugere.FirstName = hello; //<--- Information fra textbox here
                    brugere.LastName = hello; //<--- Information fra textbox here

                    //true - False
                    brugere.Newsletter = hello;  //<--- Information fra checkbox here

                    brugere.Fk_role = dropdown; //<-- dropdown information add here
                    brugere.Fk_sex = dropdown; //<-- dropdown information add here
                    brugere.Fk_area = dropdown; //<-- dropdown information add here
                    brugere.Fk_professional = dropdown; //<-- dropdown information add here

                    //age
                    brugere.age = hello;  //<--- Information fra textbox her

                    //img users
                    brugere.img = "userimg.png";

                    brugere.creatadate = DateTime.Now;

                    //Skal finde ud af hvilke role man har valgt,
                    if(brugere.Fk_role == 6)
                    {
                        //Hvis man er Mentor, skal man ikke have adgang til siden endnu!
                        brugere.Approved = false;
                    }
                    else
                    {
                        //Er man Alm brugere eller Forældre så har man adgang til site.
                        brugere.Approved = true;
                    }

                    //skal lige indhold ind i databasen.
                    db.Users.InsertOnSubmit(brugere); // add to database
                    //Problems here!!

                    //skal gemme indholdet.
                    db.SubmitChanges(); // save

                    //sende person til log in siden.

                }
                else
                {
                    //Fremviser en fejl besked hvis der findes en email.
                    ViewBag.MessageError = "Denne brugere findes i vores system.";
                }
            }
            //return indhold til siden.
            return View();
        }
    }


opret.cshtml

C#
<div class="row">
                                    <div class="form-group">
                                        <div class="col-md-12">
                                            <label>E-Mail</label>
                                            <input type="email" placeholder="Skriv email her" class="form-control input-lg">
                                        </div>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="form-group">
                                        <div class="col-md-6">
                                            <label>Adgangskode</label>
                                            <input type="password" placeholder="Angiv Adgangskode her" class="form-control input-lg">
                                        </div>
                                        <div class="col-md-6">
                                            <label>Gentag Adgangskode</label>
                                            <input type="password" placeholder="Gentag Adgangskode" class="form-control input-lg">
                                        </div>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="form-group">
                                        <div class="col-md-6">
                                            <label>Fornavn</label>
                                            <input type="text" placeholder="Fornavn" class="form-control input-lg">
                                        </div>
                                        <div class="col-md-6">
                                            <label>Efternavn</label>
                                            <input type="text" placeholder="Efternavn" class="form-control input-lg">
                                        </div>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="form-group">
                                        <div class="col-md-12">
                                            <label>Køn</label>
                                            @Html.DropDownList("ddlSexs", new SelectList(Model.Sexs, "Id", "Name"), "Vælg", new { @class = "form-control input-lg" })
                                        </div>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="form-group">
                                        <div class="col-md-12">
                                            <label>Interesseret i?</label>
                                            @Html.DropDownList("ddlRoles", new SelectList(Model.Roles, "Id", "Name"), "Vælg", new { @class = "form-control input-lg" })
                                        </div>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="form-group">
                                        <div class="col-md-12">
                                            <label>Alderstrin</label>
                                            <input type="date" class="form-control input-lg" data-val="true" data-val-required="Date is required">
                                        </div>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="form-group">
                                        <div class="col-md-6">
                                            <label>Hvor er du fra?</label>
                                            @Html.DropDownList("ddlAreas", new SelectList(Model.Areas, "Id", "Name"), "Vælg", new { @class = "form-control input-lg" })
                                        </div>
                                        <div class="col-md-6">
                                            <label>Hvilke fag?</label>
                                            @Html.DropDownList("ddlProfessionals", new SelectList(Model.Professionals, "Id", "Name"), "Vælg", new { @class = "form-control input-lg" })
                                        </div>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-12">
                                        <span class="remember-box checkbox">
                                            <label for="rememberme">
                                                <input type="checkbox" id="rememberme" name="rememberme"> Accepterer nyhedsbrev Fra @ViewBag.navn
                                            </label>
                                        </span>
                                    </div>
                                    <div class="col-md-12">
                                        <span class="remember-box checkbox">
                                            <label for="rememberme">
                                                <input type="checkbox" id="rememberme" name="rememberme">
                                                @Html.ActionLink("Accepterer", "brugerbetingelser", "Konto") brugerbetingelser hos @ViewBag.navn
                                            </label>
                                        </span>
                                    </div>
                                    <div class="col-md-12">
                                        <input type="submit" value="Opret bruger" class="btn btn-success mr-xs mb-sm" data-loading-text="Loading...">
                                    </div>
                                </div>


The error are:

Argument 1: cannot convert from 'Hello_MVC.Models.Konto.OpretBrugere' to 'Hello_MVC.Models.Linq.User'

The best overloaded method match for 'System.Data.Linq.Table<mentorordblind_mvc.models.linq.user>.InsertOnSubmit(MentorOrdblind_MVC.Models.Linq.User)' has some invalid arguments
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900