jeudi 9 novembre 2017

checkbox value always 0 after insert into database

I am building a website using asp mvc. I have successfully insert my form into database. However, I got a problem with my checkbox. the value of checkbox always 0 in my database even if I check the checkbox.

@using (Html.BeginForm())
{

        <div class="modal-body">
                <div class="form-group">
                    <label for="username" class="col-form-label">Name:</label>
                    <input type="text" class="form-control" **id="username" name="username" **>

                </div>


                    <div class="row">
                           <div class="form-group">
                            <div class="col-md-6">
                                <input type="checkbox" **id="user_privilage" name="user_privilage" **>
                                <label for="user" class="col-form-label">User</label>
                            </div>
                            </div>
                        </div>
                </div> 


        <div class="modal-footer">
            <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
            <button type="submit" class="btn btn-primary">Add</button>
        </div>

        }

here is the code in controller:

 [HttpPost]
    public ActionResult UserMaintenance(User collection)
    {
        try
        {

            List<object> lst = new List<object>();
            lst.Add(collection.username);
            lst.Add(collection.user_privilage);
            object[] allitems = lst.ToArray();
            int output = db.Database.ExecuteSqlCommand("insert into DATABASE(username,user_privilage) values (@p0,@p1)", allitems);
            if(output>0)
            {
                ViewBag.msg = "User has been added";
            }

            return View();
            //return RedirectToAction("UserMaintenance");
        }
        catch {
            return View();
        }

    }

Does anyone know what happened?




Aucun commentaire:

Enregistrer un commentaire