public ActionResult Index(EmployeeViewModel model) { try { MvcTutorialEntities db = new MvcTutorialEntities(); List <tblDepartment> departments = db.tblDepartments.ToList(); ViewBag.DeparmentList = new SelectList(departments, "DepartmentId", "DepartmentName"); if (model.EmployeeID > 0) { //update tblEmployee emp = db.tblEmployees.SingleOrDefault(x => x.EmployeeID == model.EmployeeID && x.isDeleted == false); emp.DepartmentId = model.DepartmentId; emp.Name = model.Name; emp.Address = model.Address; db.SaveChanges(); } else { //insert tblEmployee emp = new tblEmployee(); emp.Address = model.Address; emp.Name = model.Name; emp.DepartmentId = model.DepartmentId; emp.isDeleted = false; db.tblEmployees.Add(emp); db.SaveChanges(); } return(View(model)); } catch (Exception) { throw; } }
public ActionResult ChangePassword(UserChangePasswordModelClass modelchangerPasswordData) { if (ModelState.IsValid) { using (var database = new MvcTutorialEntities()) { int UserID = Convert.ToInt32(Session["UserID"]); var verify = database.tblUser.FirstOrDefault(user => user.UserID == UserID && user.Password == modelchangerPasswordData.OldPassword && user.IsActive == true); if (verify != null) { verify.Password = modelchangerPasswordData.NewPassword; database.SaveChanges(); ViewBag.SuccessMessage = "Password Change Successfully. Please Re-Login With New Password."; Session.RemoveAll(); return(RedirectToAction("Login", "User")); } else { ViewBag.Message = "You have Enter Wrong Old Password."; } } } return(View()); }
public HttpResponseMessage ChangePassword(UserChangePasswordModelClass modelchangerPasswordData) { try { if (ModelState.IsValid) { using (var database = new MvcTutorialEntities()) { //int UserID = modelchangerPasswordData.UserID; var verify = database.tblUser.FirstOrDefault(user => user.UserID == modelchangerPasswordData.UserID && user.Password == modelchangerPasswordData.OldPassword && user.IsActive == true); if (verify != null) { verify.Password = modelchangerPasswordData.NewPassword; database.SaveChanges(); return(this.GenerateResponse(true, HttpStatusCode.OK, Constants.RESETPASSWORD)); //ViewBag.SuccessMessage = "Password Change Successfully. Please Re-Login With New Password."; } else { return(this.GenerateResponse(false, HttpStatusCode.NotFound, Constants.INVALIDPASSWORD)); //ViewBag.Message = "You have Enter Wrong Old Password."; } } } else { return(this.GenerateResponse(false, HttpStatusCode.NotFound, Constants.NODATA)); } } catch (Exception ex) { return(this.GenerateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult DeleteAccount() { if (Session["UserID"] != null) { using (var database = new MvcTutorialEntities()) { int UserID = Convert.ToInt32(Session["UserID"]); var databaseUserAccount = database.tblUser.Find(UserID); if (databaseUserAccount != null) { database.tblUser.Remove(databaseUserAccount); Session.RemoveAll(); database.SaveChanges(); ViewBag.SuccessMessage = "Your Account is Deleted Successfully."; return(RedirectToAction("Registration", "User")); } else { return(RedirectToAction("Index", "Home")); } } } else { return(RedirectToAction("Login", "User")); } }
public ActionResult ProfileInfo(UserProfileModelClass modelprofiledData) { if (ModelState.IsValid) { using (var database = new MvcTutorialEntities()) { int UserID = Convert.ToInt32(Session["UserID"]); var databaseData = database.tblUser.FirstOrDefault(user => user.UserID == UserID && user.IsActive == true); if (databaseData != null) { databaseData.MobileNo = modelprofiledData.MobileNo; databaseData.EmailAddress = modelprofiledData.EmailAddress; databaseData.Address = modelprofiledData.Address; database.SaveChanges(); ViewBag.SuccessMessage = "Profile Update Successfully."; return(View()); } else { ViewBag.Message = "Couldn't Find Your Profile."; } } } return(View()); }
public HttpResponseMessage DeactivateAccount(int id) { try { if (id != 0) { using (var database = new MvcTutorialEntities()) { var databaseUserAccount = database.tblUser.Find(id); if (databaseUserAccount != null) { databaseUserAccount.IsActive = false; database.SaveChanges(); return(this.GenerateResponse(true, HttpStatusCode.OK, Constants.ACCOUNTDEACTIVATEDSUCCESSFULLY)); } else { return(this.GenerateResponse(false, HttpStatusCode.NotFound, Constants.DATANOTFOUND)); } } } else { return(this.GenerateResponse(false, HttpStatusCode.NotFound, Constants.NODATA)); } } catch (Exception ex) { return(this.GenerateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage CreateNewPassword(UserNewPasswordModelClass modelnewpasswordData) { try { if (ModelState.IsValid) { using (var db = new MvcTutorialEntities()) { var verify = db.tblUser.Find(modelnewpasswordData.UserID); if (verify != null) { verify.Password = modelnewpasswordData.NewPassword; db.SaveChanges(); return(this.GenerateResponse(true, HttpStatusCode.OK, Constants.NEWPASSWORD)); } else { return(this.GenerateResponse(false, HttpStatusCode.Unauthorized, Constants.UNOTHORIZED)); } } } else { return(this.GenerateResponse(false, HttpStatusCode.NotFound, Constants.NODATA)); } } catch (Exception ex) { return(this.GenerateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public JsonResult ImageUpload(ProductViewModel model) { MvcTutorialEntities db = new MvcTutorialEntities(); int imageId = 0; var file = model.ImageFile; byte[] imagebyte = null; if (file != null) { file.SaveAs(Server.MapPath("/UploadedImage/" + file.FileName)); BinaryReader reader = new BinaryReader(file.InputStream); imagebyte = reader.ReadBytes(file.ContentLength); ImageStore img = new ImageStore(); img.ImageName = file.FileName; img.ImageByte = imagebyte; img.ImagePath = "/UploadedImage/" + file.FileName; img.IsDeleted = false; db.ImageStores.Add(img); db.SaveChanges(); imageId = img.ImageId; } if (model.ImageUrl != null) { imagebyte = DownloadImage(model.ImageUrl); ImageStore img = new ImageStore(); img.ImageName = "Abc"; img.ImageByte = imagebyte; img.ImagePath = model.ImageUrl; img.IsDeleted = false; db.ImageStores.Add(img); db.SaveChanges(); imageId = img.ImageId; } return(Json(imageId, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteEmployee(int employeId) { MvcTutorialEntities db = new MvcTutorialEntities(); Employee employee = db.Employee.Where(e => e.Id == employeId).FirstOrDefault(); db.Employee.Remove(employee); db.SaveChanges(); return(View()); }
public HttpResponseMessage ProfileInfo(UserProfileModelClass modelprofiledData) { try { if (ModelState.IsValid) { using (var database = new MvcTutorialEntities()) { // this validation is use when browser will disable javasript. if (database.tblUser.Any(email => email.EmailAddress == modelprofiledData.EmailAddress && email.EmailAddress != modelprofiledData.EmailAddress)) { return(this.GenerateResponse(false, HttpStatusCode.Found, Constants.EMAILALREADYEXISTS)); } else if (database.tblUser.Any(Mobileno => Mobileno.MobileNo == modelprofiledData.MobileNo && Mobileno.MobileNo != modelprofiledData.MobileNo)) { return(this.GenerateResponse(false, HttpStatusCode.Found, Constants.MOBILEALREADYEXISTS)); } else { var databaseData = database.tblUser.FirstOrDefault(user => user.UserID == modelprofiledData.UserID && user.IsActive == true); if (databaseData != null) { databaseData.MobileNo = modelprofiledData.MobileNo; databaseData.EmailAddress = modelprofiledData.EmailAddress; databaseData.Address = modelprofiledData.Address; database.Entry(databaseData).State = System.Data.Entity.EntityState.Modified; database.SaveChanges(); return(this.GenerateResponse(true, HttpStatusCode.OK, Constants.PROFILEUPDATE)); //ViewBag.SuccessMessage = "Profile Update Successfully."; //return View(); } else { return(this.GenerateResponse(false, HttpStatusCode.NotFound, Constants.DATANOTFOUND)); //ViewBag.Message = "Couldn't Find Your Profile."; } } } } else { return(this.GenerateResponse(false, HttpStatusCode.NotFound, Constants.NODATA)); } } catch (Exception ex) { return(this.GenerateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage ActivateAccount(UserActiveAccountClass modeluseractiveaccount) { try { using (var database = new MvcTutorialEntities()) { switch (modeluseractiveaccount.Action) { case "MobileVerify": var verifyMobile = database.tblUser.FirstOrDefault(user => user.MobileNo == modeluseractiveaccount.MobileNo); if (verifyMobile != null) { if (verifyMobile.IsActive == false) { return(this.GenerateResponse(true, HttpStatusCode.OK, verifyMobile.UserID)); } else { return(this.GenerateResponse(false, HttpStatusCode.Conflict, Constants.ACCOUNTDEALREADYACTIVE)); } } else { return(this.GenerateResponse(false, HttpStatusCode.Conflict, Constants.MOBILENOTEXISTS)); } case "PasswordVerify": var verifyPassword = database.tblUser.FirstOrDefault(user => user.UserID == modeluseractiveaccount.UserID && user.Password == modeluseractiveaccount.Password && user.IsActive == false); if (verifyPassword != null) { verifyPassword.IsActive = true; database.SaveChanges(); return(this.GenerateResponse(true, HttpStatusCode.OK, Constants.ACCOUNTACTIVATEDSUCCESSFULLY)); } else { return(this.GenerateResponse(false, HttpStatusCode.Conflict, Constants.INVALIDPASSWORD)); } default: return(this.GenerateResponse(false, HttpStatusCode.NotAcceptable, Constants.INVALID)); } } } catch (Exception ex) { return(this.GenerateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public JsonResult DeleteEmployee(int EmployeeId) { MvcTutorialEntities db = new MvcTutorialEntities(); bool result = false; tblEmployee emp = db.tblEmployees.SingleOrDefault(x => x.isDeleted == false && x.EmployeeID == EmployeeId); if (emp != null) { emp.isDeleted = true; db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult RegisterUser(RegistrationViewModel model) { MvcTutorialEntities db = new MvcTutorialEntities(); tblSiteUser siteUser = new tblSiteUser(); siteUser.UserName = model.UserName; siteUser.EmailId = model.EmailId; siteUser.Address = model.Address; siteUser.Password = model.Password; siteUser.RoleId = 3; db.tblSiteUsers.Add(siteUser); db.SaveChanges(); return(View()); }
public HttpResponseMessage Registration(UserRegistrationModelClass modelUserRegisterData) { try { if (ModelState.IsValid) { using (var database = new MvcTutorialEntities()) { // this validation is use when browser will disable javasript. if (database.tblUser.Any(email => email.EmailAddress == modelUserRegisterData.EmailAddress)) { return(this.GenerateResponse(false, HttpStatusCode.Found, Constants.EMAILALREADYEXISTS)); } else if (database.tblUser.Any(Mobileno => Mobileno.MobileNo == modelUserRegisterData.MobileNo)) { return(this.GenerateResponse(false, HttpStatusCode.Found, Constants.MOBILEALREADYEXISTS)); } else { tblUser dbobjectuser = new tblUser(); dbobjectuser.UserName = modelUserRegisterData.UserName; dbobjectuser.MobileNo = modelUserRegisterData.MobileNo; dbobjectuser.EmailAddress = modelUserRegisterData.EmailAddress; dbobjectuser.Password = modelUserRegisterData.Password; dbobjectuser.Address = modelUserRegisterData.Address; dbobjectuser.IsActive = true; dbobjectuser.AccountCreateDate = System.DateTime.Now; database.tblUser.Add(dbobjectuser); database.SaveChanges(); return(this.GenerateResponse(true, HttpStatusCode.OK, Constants.ACCOUNTCREATEDSUCCESSFULLY)); } } } else { return(this.GenerateResponse(false, HttpStatusCode.NotFound, Constants.INVALID)); } } catch (Exception ex) { return(this.GenerateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult CreateNewPassword(UserNewPasswordModelClass modelnewpasswordData) { if (ModelState.IsValid) { using (var db = new MvcTutorialEntities()) { var UserID = Convert.ToInt32(Session["ForgotPassword"]); var verify = db.tblUser.Find(UserID); if (verify != null) { verify.Password = modelnewpasswordData.NewPassword; db.SaveChanges(); ViewBag.SuccessMessage = "New Password Created Successfully. Please Re-Login with New Password."; Session.RemoveAll(); return(Json(new { msg = "success" }, JsonRequestBehavior.AllowGet)); //return RedirectToAction("Login", "User"); } } } return(View()); }
public ActionResult Registration(UserRegistrationModelClass modelUserRegister) { if (ModelState.IsValid) { using (var database = new MvcTutorialEntities()) { tblUser dbobjectuser = new tblUser(); dbobjectuser.UserName = modelUserRegister.UserName; dbobjectuser.MobileNo = modelUserRegister.MobileNo; dbobjectuser.EmailAddress = modelUserRegister.EmailAddress; dbobjectuser.Password = modelUserRegister.Password; dbobjectuser.Address = modelUserRegister.Address; dbobjectuser.IsActive = true; dbobjectuser.AccountCreateDate = System.DateTime.Now; database.tblUser.Add(dbobjectuser); database.SaveChanges(); ViewBag.SuccessMessage = "Account Created Successfully."; } } return(RedirectToAction("Login", "User")); }
public ActionResult DepartmentDropdown(EmployeeViewModel model) { //if (ModelState.IsValid == true) //{ MvcTutorialEntities db = new MvcTutorialEntities(); //dropdown List <department> departments = db.department.ToList(); ViewBag.departmentList = new SelectList(departments, "Id", "departmentname"); // Employee employee = new Employee(); employee.name = model.name; employee.adress = model.adress; employee.departmentId = model.departmentId; db.Employee.Add(employee); db.SaveChanges(); //} return(View()); }