public ActionResult Edit(tbl_User_info obj, HttpPostedFileBase[] files) { try { if (ModelState.IsValid) { string ImageName = null; string physicalPath = null; foreach (HttpPostedFileBase file in files) { if (file != null) { ImageName = Path.GetFileName(file.FileName); physicalPath = Path.Combine(Server.MapPath("~/Images/") + ImageName); file.SaveAs(physicalPath); List <object> parameters = new List <object>(); parameters.Add(obj.U_Image = ImageName); parameters.Add(obj.U_Name); parameters.Add(obj.U_Gender); parameters.Add(obj.U_Mobile); parameters.Add(obj.U_Email); parameters.Add(obj.U_Password); parameters.Add(obj.U_CNIC); parameters.Add(obj.C_Id); parameters.Add(obj.U_Id); object[] objectarray = parameters.ToArray(); int output = db.Database.ExecuteSqlCommand("update tbl_User_info set u_image=@p0,u_name=@p1,u_gender=@p2,u_mobile=@p3,u_email=@p4,u_password=@p5,u_cnic=@p6,c_id=@p7 where u_id=@p8", objectarray); if (output > 0) { ViewBag.Itemmsg = "Your User id " + obj.U_Id + "is Updated successfully"; } return(View()); } } } // TODO: Add update logic here return(View()); } catch { return(View()); } }
public ActionResult Create(tbl_User_info collection, HttpPostedFileBase[] files) { try { string ImageName = null; string physicalPath = null; if (ModelState.IsValid) { foreach (HttpPostedFileBase file in files) { if (file != null) { ImageName = Path.GetFileName(file.FileName); physicalPath = Path.Combine(Server.MapPath("~/Images/") + ImageName); file.SaveAs(physicalPath); List <object> lst = new List <object>(); lst.Add(collection.U_Image = ImageName); lst.Add(collection.U_Name); lst.Add(collection.U_Gender); lst.Add(collection.U_Mobile); lst.Add(collection.U_Email); lst.Add(collection.U_Password); lst.Add(collection.U_CNIC); lst.Add(collection.C_Id); object[] allitems = lst.ToArray(); int output = db.Database.ExecuteSqlCommand("insert into tbl_User_info (u_image,u_name,u_gender,u_mobile,u_email,u_password,u_cnic,c_id)values(@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7)", allitems); if (output > 0) { ViewBag.msg = "User is Add"; } return(View()); } } } // TODO: Add insert logic here return(View()); } catch { return(View()); } }
public ActionResult SignIn(tbl_User_info user) { try { if (Membership.ValidateUser(user.U_Email, user.U_Password)) { FormsAuthentication.SetAuthCookie(user.U_Email, true); var users = user.U_Id; return(RedirectToAction("Index", "Home")); } else { TempData["Msg"] = "Login Failed "; return(RedirectToAction("Index")); } } catch (Exception E1) { TempData["Msg"] = "Login Failed " + E1.Message; return(RedirectToAction("Index")); } }