public ActionResult Delete(int id) { if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) { return(RedirectToAction("Login", "Login", null)); } ViewBag.Logout = Session["Username"]; ViewBag.roleid = Session["RoleID"]; String Username = Session["Username"].ToString(); int UserID = Convert.ToInt32(Session["UserId"]); //ViewBag.IsConfigMenu = 0; tbluser tblusers = db.tblusers.Find(id); tblusers.IsDeleted = 1; tblusers.ModifiedBy = UserID; tblusers.ModifiedOn = System.DateTime.Now; //start Logging //string CompleteModificationdetail = "Deleted User"; //Action = "Delete"; //ActiveLogStorage Obj = new ActiveLogStorage(); //Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail); //End db.Entry(tblusers).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AddOrEdit(UserViewModel uv) { tbluser tb = new tbluser(); tb.Username = uv.Username; tb.Email = uv.Email; tb.Password = uv.Password; HttpPostedFileBase fup = Request.Files["Photo"]; if (fup != null) { if (fup.FileName != "") { tb.Photo = fup.FileName; fup.SaveAs(Server.MapPath("~/images/" + fup.FileName)); } } _db.tblusers.Add(tb); _db.SaveChanges(); tblUserRole ud = new tblUserRole(); ud.UserId = tb.UserId; ud.UserRoleId = 1; _db.tblUserRoles.Add(ud); _db.SaveChanges(); ViewBag.Message = "User Created Successfully"; return(View()); }
public ActionResult UpdatePassword() { if (Session["UserID"] == null) { return(RedirectToAction("LogIn", "User")); } else { string olpass = Request["Opass"].ToString(); string npass = Request["Npass"].ToString(); int uid = Convert.ToInt32(Session["UserID"]); tbluser u = res.tblusers.Where(t => t.UserID == uid).SingleOrDefault(); if (u.Password.Equals(olpass)) { u.Password = npass; res.SaveChanges(); Session.Abandon(); return(RedirectToAction("logIn")); } else { return(RedirectToAction("Index", new { id = uid })); } } }
public ActionResult Signup(UserViewModel uv) { tbluser tbl = db.tblusers.Where(u => u.Username == uv.Username).FirstOrDefault(); if (tbl != null) { return(Json(new { success = false, message = "User Already Register" }, JsonRequestBehavior.AllowGet)); } else { tbluser tb = new tbluser(); tb.Username = uv.Username; tb.Password = uv.Password; tb.FullName = uv.FullName; tb.Email = uv.Email; db.tblusers.Add(tb); db.SaveChanges(); tblUserRole ud = new tblUserRole(); ud.UserId = tb.UserId; ud.RoleId = 2; db.tblUserRoles.Add(ud); db.SaveChanges(); return(Json(new { success = true, message = "User Register Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(tbluser obj) { try { if (ModelState.IsValid) { var CustomerMasterlist = repo1.GetAllUsers(); if (CustomerMasterlist.Where(ite => ite.username.ToLower() == obj.username.ToLower()).FirstOrDefault() != null) { ViewBag.ErrorMsg = "User already exists"; return(View(obj)); } obj.passwordHash = vm.Encrypt(obj.passwordHash); repo1.Update(obj); ViewBag.SuccessMsg = "Record Updated Successfully"; } else { return(View(obj)); } } catch (Exception ex) { ViewBag.ErrorMsg = "Sorry Some Problem Occured"; } return(RedirectToAction("Listing")); }
public ActionResult Index(tbluser user) { if (user.c_username == null || user.c_password == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbluser tbluser = db.tblusers.Where(x => x.c_username == user.c_username && x.c_password == user.c_password).FirstOrDefault(); if (!ModelState.IsValid) { return(View(user)); } if (tbluser != null) { FormsAuthentication.SetAuthCookie(tbluser.c_userid.ToString(), false); var authTicket = new FormsAuthenticationTicket(1, tbluser.c_userid.ToString(), DateTime.Now, DateTime.Now.AddMinutes(20), false, tbluser.c_usertype.ToString()); string encryptedTicket = FormsAuthentication.Encrypt(authTicket); var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket); HttpContext.Response.Cookies.Add(authCookie); return(RedirectToAction("Index", "Users")); } else { ViewBag.message = "User name and password not match."; return(View()); } }
public ActionResult DeleteConfirmed(long id) { tbluser tbluser = db.tblusers.Find(id); db.tblusers.Remove(tbluser); db.SaveChanges(); return(RedirectToAction("Index")); }
public tbluser GetEmployee(int userId) { tbluser employeeDetails = (from p in svmContext.tbluser where p.UserId == userId && p.isDeleted == false select p).FirstOrDefault(); return(employeeDetails); }
public void DeleteUser(int userId) { tbluser employeeDetails = (from p in svmContext.tbluser where p.UserId == userId && p.isDeleted == false select p).FirstOrDefault(); employeeDetails.isDeleted = true; svmContext.SaveChanges(); }
public ActionResult Login() { tbluser u = new tbluser(); // tbluser objUserRegistrationVM = new tbluser(); UserRegistrationVM objUserRegistrationVM = new UserRegistrationVM(); return(View(objUserRegistrationVM)); }
public ActionResult Delete(int id) { using (KantipurDBEntities db = new KantipurDBEntities()) { tbluser sm = db.tblusers.Where(x => x.UserId == id).FirstOrDefault(); db.tblusers.Remove(sm); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit([Bind(Include = "c_userid,c_username,c_password,c_usertype")] tbluser tbluser) { if (ModelState.IsValid) { db.Entry(tbluser).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbluser)); }
public ActionResult AddStudent(tbluser t) { tbluser u = new tbluser(); u.name = t.name; u.pass = t.pass; db.tblusers.Add(u); db.SaveChanges(); return(Json(u, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(tbluser tbluser) { if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) { return(RedirectToAction("Login", "Login", null)); } ViewBag.Logout = Session["Username"]; ViewBag.roleid = Session["RoleID"]; String Username = Session["Username"].ToString(); int UserID = Convert.ToInt32(Session["UserID"]); int roleid = Convert.ToInt32(Session["RoleID"]); tbluser.ModifiedBy = UserID; tbluser.ModifiedOn = System.DateTime.Now; var dupUserData = db.tblusers.Where(m => m.IsDeleted == 0 && m.UserName == tbluser.UserName && m.UserID != tbluser.UserID).ToList(); if (dupUserData.Count == 0) { #region Active Log Code //tblUser OldData = db.tblUsers.Find(tbluser.UserID); //IEnumerable<string> FullData = ActiveLog.EnumeratePropertyDifferences<tblUser>(OldData, tbluser); //ICollection<tblUser> c = FullData as ICollection<tblUser>; //int Count = c.Count; //if (Count != 0) //{ // string CompleteModificationdetail = null; // for (int i = 0; i < Count; i++) // { // CompleteModificationdetail = CompleteModificationdetail + "-" + FullData.Take(i).ToArray(); // } // Action = "Edit"; // ActiveLogStorage Obj = new ActiveLogStorage(); // Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail); //} #endregion //End Active Log int primaryrole = Convert.ToInt32(tbluser.PrimaryRole); if (primaryrole != 3) { tbluser.MachineID = Convert.ToInt32(System.DBNull.Value); } db.Entry(tbluser).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else { Session["Error"] = "User Name Exists."; ViewBag.PrimaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0 && m.Role_ID >= roleid), "Role_ID", "RoleDesc", tbluser.PrimaryRole); ViewBag.SecondaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0 && m.Role_ID >= roleid), "Role_ID", "RoleDesc", tbluser.SecondaryRole); ViewBag.MachineID = new SelectList(db.tblmachinedetails.Where(m => m.IsDeleted == 0), "MachineID", "MachineDispName", tbluser.MachineID); return(View(tbluser)); } }
public ActionResult Create([Bind(Include = "c_userid,c_username,c_password,c_usertype")] tbluser tbluser) { if (ModelState.IsValid) { db.tblusers.Add(tbluser); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbluser)); }
public bool SaveUserDetails(tbluser user_add) // calling SaveStudentMethod for insert a new record { bool result = false; if (user_add != null) { db.tblusers.Add(user_add); db.SaveChanges(); result = true; } return(result); }
public UserIdentity() { long userid = Convert.ToInt64(HttpContext.Current.User.Identity.Name); tbluser tbluser = db.tblusers.Where(x => x.c_userid == userid).FirstOrDefault(); if (tbluser != null) { userid = tbluser.c_userid; userType = tbluser.c_usertype; userName = tbluser.c_username; } }
public bool UserInsert(tbluser user) { try { userService.Insert(user); return(true); } catch (System.Exception ex) { return(false); } }
// GET: Users/Edit/5 public ActionResult Edit(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbluser tbluser = db.tblusers.Find(id); if (tbluser == null) { return(HttpNotFound()); } return(View(tbluser)); }
public ActionResult ForgetPassword(UserViewModel uv) { if (ModelState.IsValid) { //https://www.google.com/settings/security/lesssecureapps //Make Access for less secure apps=true string from = "*****@*****.**"; using (MailMessage mail = new MailMessage(from, uv.Email)) { try { tbluser tb = db.tblusers.Where(u => u.Email == uv.Email).FirstOrDefault(); if (tb != null) { mail.Subject = "Password Recovery"; mail.Body = "Your Password is:" + tb.Password; mail.IsBodyHtml = false; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; smtp.EnableSsl = true; NetworkCredential networkCredential = new NetworkCredential(from, "basubinod"); smtp.UseDefaultCredentials = false; smtp.Credentials = networkCredential; smtp.Port = 587; smtp.Send(mail); ViewBag.Message = "Your Password Is Sent to your email"; } else { ViewBag.Message = "email Doesnot Exist in Database"; } } catch (Exception ex) { throw ex; } finally { } } } return(View()); //return RedirectToAction("Index", "Home"); }
public ActionResult logIn(tbluser u) { tbluser usr = res.tblusers.Where(t => t.UserName.Equals(u.UserName) && t.Password.Equals(u.Password)).SingleOrDefault(); if (usr != null) { Session["UserID"] = usr.UserID; Session["Username"] = usr.UserName; Session["Profile"] = usr.ProfilePic; return(RedirectToAction("Index", "Home")); } else { return(RedirectToAction("logIn")); } }
public tbluser GetuserDet3(int OperatorID) { tbluser ddldet = new tbluser(); Repository <tbluser> lista = new Repository <tbluser>(); try { string query = "SELECT IsNormalWC from [i_facility_TSAL].[dbo].tbluser WHERE UserID =" + OperatorID + ""; ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection); } catch (Exception ex) { // MessageBox.Show(ex.ToString()); } return(ddldet); }
public ActionResult Index(tbluser usr) { myshopDBEntities obj = new myshopDBEntities(); var a = obj.tblusers.Where(l => l.uname.Equals(usr.uname) && l.upass.Equals(usr.upass)).ToList(); if (a.Count > 0) { Session["uname"] = usr.uname.ToString(); return(RedirectToAction("Dashboard")); } else { ViewBag.msg = "Invalid Username or Password!"; } return(View()); }
public tbluser GetuserDet3(int OperatorID) { tbluser ddldet = new tbluser(); Repository <tbluser> lista = new Repository <tbluser>(); try { string query = "SELECT * from [" + ConnectionFactory.DB + "].[" + ConnectionFactory.Schema + "].tblusers WHERE UserID =" + OperatorID + ""; ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection); } catch (Exception ex) { // MessageBox.Show(ex.ToString()); } return(ddldet); }
public ActionResult ChangePassword(ChangePasswordViewModel ch) { string username = Session["Username"].ToString(); tbluser us = db.tblusers.Where(u => u.Username == username && u.Password == ch.OldPassword).FirstOrDefault(); if (us != null) { us.Password = ch.NewPassword; db.SaveChanges(); } else { return(Json(new { success = false, message = "You Enter Wrong Password" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = true, message = "Password Changed Successfully" }, JsonRequestBehavior.AllowGet)); }
public ActionResult Authorize(tbluser userModel) { using (ECommerceEntities2 db = new ECommerceEntities2()) { var userDetails = db.tblusers.Where(x => x.userid == userModel.userid && x.password == userModel.password).FirstOrDefault(); if (userDetails == null) { userModel.LoginErrorMessage = "Wrong User Id or Password"; return(View("Index", userModel)); } else { Session["userid"] = userDetails.userid; return(RedirectToAction("Index", "Home")); } } }
public ActionResult Create(tbluser tbluser) { if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) { return(RedirectToAction("Login", "Login", null)); } ViewBag.Logout = Session["Username"]; ViewBag.roleid = Session["RoleID"]; int roleid = Convert.ToInt32(Session["RoleID"]); String Username = Session["Username"].ToString(); //ViewBag.PrimaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0), "Role_ID", "RoleDesc"); //ViewBag.SecondaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0), "Role_ID", "RoleDesc"); tbluser.CreatedBy = roleid; tbluser.CreatedOn = System.DateTime.Now; tbluser.IsDeleted = 0; ////ActiveLog Code //int UserID = Convert.ToInt32(Session["UserId"]); //string CompleteModificationdetail = "New Creation"; //Action = "Create"; //ActiveLogStorage Obj = new ActiveLogStorage(); //Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail); ////End var dupUserData = db.tblusers.Where(m => m.IsDeleted == 0 && m.UserName == tbluser.UserName).ToList(); if (dupUserData.Count == 0) { int primaryrole = Convert.ToInt32(tbluser.PrimaryRole); if (primaryrole != 3) { // tbluser.MachineID = ; } db.tblusers.Add(tbluser); db.SaveChanges(); return(RedirectToAction("Index")); } else { Session["Error"] = "User Name Exists."; ViewBag.PrimaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0 && m.Role_ID >= roleid), "Role_ID", "RoleDesc", tbluser.PrimaryRole); ViewBag.SecondaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0 && m.Role_ID >= roleid), "Role_ID", "RoleDesc", tbluser.SecondaryRole); ViewBag.MachineID = new SelectList(db.tblmachinedetails.Where(m => m.IsDeleted == 0), "MachineID", "MachineDispName", tbluser.MachineID); return(View(tbluser)); } }
public ActionResult SaveUser(tbluser u, HttpPostedFileBase ProfilePic) { var fileName = Path.GetFileName(ProfilePic.FileName); var path = Path.Combine(Server.MapPath("~/Content/Images/User"), fileName); ProfilePic.SaveAs(path); u.ProfilePic = fileName; int cityid = Convert.ToInt32(Request["CityID"]); byte gen = Convert.ToByte(Request["Gender"]); u.CityID = cityid; u.Gender = gen; res.tblusers.Add(u); res.SaveChanges(); return(RedirectToAction("logIn")); }
public ActionResult CreateUser(string username, string password, string fullname) { tbluser usr = db.tblusers.Where(x => x.userName.Equals(username)).FirstOrDefault(); if (usr == null) { usr = new tbluser { userName = username, userPassword = password, userFullName = fullname }; db.tblusers.Add(usr); db.SaveChanges(); Session["isLoggedIn"] = usr; return RedirectToAction("PortfolioEdit"); } else { ViewBag.Message = "User already exist. Try another Username"; return View(); } //return View(); }
public ActionResult ChangePassword(int id) { if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) { return(RedirectToAction("Login", "Login", null)); } ViewBag.Logout = Session["Username"]; ViewBag.roleid = Session["RoleID"]; int roleid = Convert.ToInt32(Session["RoleID"]); String Username = Session["Username"].ToString(); tbluser tbluser = db.tblusers.Find(id); if (tbluser == null) { return(HttpNotFound()); } return(View(tbluser)); }
public ActionResult AddorEdit(tbluser user) { using (ECommerceEntities2 db = new ECommerceEntities2()) { if (db.tblusers.Any(x => x.userid == user.userid)) { ViewBag.DuplicateMessage = "User Name Already Exists."; return(View("AddorEdit", user)); } else { db.tblusers.Add(user); db.SaveChanges(); } } ModelState.Clear(); ViewBag.SuccessMessage = "Registration Successful."; return(View("AddorEdit", new tbluser())); }