public ActionResult SignUp(JobSeekerViewModel jsm) { List <tblUser> lst = _db.tblUsers.Where(u => u.Username == jsm.Username).ToList(); if (lst.Count == 0) { if (jsm.Password != jsm.RetypePassword) { ViewBag.Message = "Password Mismatch"; } else { string password = encryptpass(jsm.Password); tblUser tbu = new tblUser(); tbu.Username = jsm.Username; tbu.Password = password; _db.tblUsers.Add(tbu); _db.SaveChanges(); tblUserRole tbur = new tblUserRole(); tbur.UserId = tbu.UserId; tbur.RoleId = 3; _db.tblUserRoles.Add(tbur); _db.SaveChanges(); tblJobSeeker tbj = new tblJobSeeker(); tbj.FullName = jsm.FullName; tbj.Gender = jsm.Gender; tbj.Email = jsm.Email; tbj.Address = jsm.Address; tbj.Skills = jsm.Skills; tbj.JobType = jsm.JobType; tbj.CurrentPosition = jsm.CurrentPosition; tbj.HighestDegree = jsm.HighestDegree; tbj.ExpectedSalary = jsm.ExpectedSalary; tbj.Experience = jsm.Experience; tbj.UserId = tbu.UserId; HttpPostedFileBase fup = Request.Files["Resume"]; if (fup != null) { if (fup.FileName != "") { tbj.Resume = fup.FileName; fup.SaveAs(Server.MapPath("~/ResumeUpload/" + fup.FileName)); } } _db.tblJobSeekers.Add(tbj); _db.SaveChanges(); ViewBag.Message = "Your Account was created successfully"; RefreshPageControl(); } } else { ViewBag.Message = "Username already exists!!!"; } return(View()); }
public ActionResult AddOrEdit(UserViewModel uv) { using (OnlineVotingSystemEntities db = new OnlineVotingSystemEntities()) { tblUser tb = new tblUser(); tb.UserName = uv.UserName; tb.Password = OnlineVotingSystemForCollege.Models.EncryptPassword.textToEncrypt(uv.Password); tb.Fullname = uv.FullName; tb.Email = uv.Email; tb.EmailVerification = true; db.tblUsers.Add(tb); db.SaveChanges(); tblUserRole ud = new tblUserRole(); ud.UserId = tb.UserId; ud.RoleId = 1; db.tblUserRoles.Add(ud); db.SaveChanges(); ViewBag.Message = "User Created Successfully"; return(RedirectToAction("ManageUser")); } }
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 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 AddOrEdit(UserViewModel sm) { using (ELaundryDBEntities db = new ELaundryDBEntities()) { tblUser tb = new tblUser(); string password = Utilities.Base64Encode(sm.Password); tb.Username = sm.Username; tb.Password = password; tb.Fullname = sm.Fullname; db.tblUsers.Add(tb); db.SaveChanges(); tblUserRole tu = new tblUserRole(); tu.RoleId = sm.RoleId; tu.UserId = tb.UserId; db.tblUserRoles.Add(tu); db.SaveChanges(); tblUserBranch br = new tblUserBranch(); br.UserId = tb.UserId; br.BranchId = sm.BranchId; db.tblUserBranches.Add(br); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } }
public long UpdateRoleUser(long UserID, int RoleID) { long result = 0; try { tblUserRole userRole = new tblUserRole { UserId = UserID, RoleId = RoleID }; using (var db = ContextFactory.UsTransportEntities()) { var updaterole = db.tblUserRoles.FirstOrDefault(u => u.UserId == UserID); if (updaterole != null) { updaterole.RoleId = RoleID; if (db.SaveChanges() > 0) { result = updaterole.Id; } } else { db.tblUserRoles.Add(userRole); db.SaveChanges(); result = userRole.Id; } } } catch (Exception) { } return(result); }
public DataModel.UserRoles UpdateUserRole(DataModel.UserRoles obj) { tblUserRole userrole = new tblUserRole(); userrole.RoleID = obj.RoleID; userrole.RoleName = obj.RoleName; userrole.RoleAbbrivation = obj.RoleAbbrivation; userrole.CreatedBy = obj.CreatedBy; userrole.CreatedAt = obj.CreatedAt; userrole.UpdatedBy = obj.UpdatedBy; userrole.UpdatedAt = obj.UpdatedAt; userrole.IsActive = obj.IsActive; context.Entry(userrole).State = EntityState.Modified; context.SaveChanges(); return(obj); }
public tblUserRole Select(string UserName) { tblUserRole result = new tblUserRole(); try { using (var db = ContextFactory.UsTransportEntities()) { long userID = db.tblUsers.Where(x => x.Username.Contains(UserName)).Select(x => x.Id).FirstOrDefault(); result = db.tblUserRoles.Where(x => x.UserId == userID).SingleOrDefault(); } } catch (Exception) { } return(result); }
public tblUserRole Select(string UserName) { tblUserRole result = new tblUserRole(); try { using (var db = ContextFactory.UsTransportEntities()) { long userID = db.tblUsers.FirstOrDefault(x => x.Username.Contains(UserName))?.Id ?? -1; result = db.tblUserRoles.SingleOrDefault(x => x.UserId == userID); } } catch (Exception ex) { SELog.WriteLog("RoleService => Select", ex); } return(result); }
public DataModel.UserRoles AddUserRole(DataModel.UserRoles obj) { try { //CustomResponse response = new CustomResponse(); var existing = context.tblUserRoles.Where(u => u.RoleID == obj.RoleID).FirstOrDefault(); if (obj.RoleID != 0) { return(UpdateUserRole(obj)); } tblUserRole userrole = new tblUserRole(); userrole.RoleName = obj.RoleName; userrole.RoleAbbrivation = obj.RoleAbbrivation; userrole.CreatedBy = obj.CreatedBy; userrole.CreatedAt = DateTime.Now; userrole.UpdatedBy = obj.UpdatedBy; userrole.UpdatedAt = DateTime.Now; userrole.IsActive = obj.IsActive; if (existing != null) { obj.ErrorMessage = "User Role with same name already exists"; obj.Success = false; obj.CreatedAt = existing.CreatedAt.Value; obj.UpdatedAt = existing.UpdatedAt.Value; return(obj); } context.tblUserRoles.Add(userrole); context.SaveChanges(); //Assuming the database is generating your Id's for you obj.RoleID = userrole.RoleID; obj.Success = true; obj.CreatedAt = DateTime.Now; obj.UpdatedAt = DateTime.Now; obj.ErrorMessage = "User role saved successfully"; } catch (Exception ex) { obj.ErrorMessage = ex.Message; obj.Success = false; } return(obj); }
public ActionResult Create(UserViewModel uvm) { tblUser tb = new tblUser(); tb.RoleId = uvm.RoleId; tb.UserName = uvm.UserName; tb.Password = uvm.Password; tb.FullName = uvm.FullName; tb.Email = uvm.Email; tb.CitizenshipNumber = uvm.CitizenshipNumber; _db.tblUsers.Add(tb); _db.SaveChanges(); int latestUserId = tb.UserId; tblUserRole userRole = new tblUserRole(); userRole.UserId = latestUserId; userRole.RoleId = tb.RoleId; _db.tblUserRoles.Add(userRole); _db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Registration(RegistrationViewModel uv) { using (OnlineVotingSystemEntities db = new OnlineVotingSystemEntities()) { tblUser tbl = db.tblUsers.Where(u => u.UserName == uv.UserName || u.Email == uv.Email).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 = OnlineVotingSystemForCollege.Models.EncryptPassword.textToEncrypt(uv.Password); tb.Fullname = uv.FullName; tb.Email = uv.Email; tb.EmailVerification = false; tb.ActivationCode = Guid.NewGuid(); db.tblUsers.Add(tb); db.SaveChanges(); tblUserRole ud = new tblUserRole(); ud.UserId = tb.UserId; ud.RoleId = 2; db.tblUserRoles.Add(ud); db.SaveChanges(); tblIdRequest tbid = new tblIdRequest(); tbid.UserEmail = tb.Email; tbid.FullName = tb.Fullname; tbid.UserId = tb.UserId; db.tblIdRequests.Add(tbid); db.SaveChanges(); return(Json(new { success = true, message = "Registration Completed . A Email would be send to your email" + tb.Email + "If You are a Valid User" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult AddOrEdit(UserViewModel uv) { using (E_CommerceWebsiteEntities db = new E_CommerceWebsiteEntities()) { 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 = 1; db.tblUserRoles.Add(ud); db.SaveChanges(); ViewBag.Message = "User Created Successfully"; return(RedirectToAction("ManageUser")); } }
public LoginModel loginUser(LoginModel model) { LoginModel _LoginModel = new LoginModel(); try { List <tblUserRole> _tblUserRole = new List <tblUserRole>(); bool FirstLog = false; tblUser _tblUser = new tblUser(); tblUserLog _tblUserLog = new tblUserLog(); model.Username = model.Username.Trim(); model.Password = model.Password.Trim(); model.Password = EncryptUtil.EncryptString(model.Password); model.Username = model.Username.ToLower(); _tblUser = _ItblUserRepository.Get(x => x.Email.ToLower() == model.Username && x.Password == model.Password && x.IsActive == true && x.IsBlocked == false).FirstOrDefault(); if (_tblUser != null) { _tblUser.tblUserRole = null; _tblUser.InvalidAttempt = 0; _ItblUserRepository.Update(_tblUser); List <tblRole> _tblUserRole2 = _ItblUserRoleRepository.Get(x => x.FKUser == _tblUser.PKUser && x.IsActive == true).Select(s => s.tblRole ).ToList(); foreach (var data in _tblUserRole2) { tblUserRole temp = new tblUserRole(); temp.tblRole = data; temp.FKRole = data.PKRole; _tblUserRole.Add(temp); } _tblUserLog.LoginSuccess = true; _tblUserLog.FKUser = _tblUser.PKUser; lastLogin = _ItblUserLogRepository.Get(x => x.UserName == _tblUser.Email && x.LoginSuccess == true).ToList(); if (lastLogin != null && lastLogin.Count > 0 && _tblUser.IsChangePassword == true) { FirstLog = true; } else { FirstLog = false; } } else { _tblUser = _ItblUserRepository.Get(x => x.Email.ToLower() == model.Username && x.Password == model.Password && x.IsActive == true && x.IsBlocked == true).FirstOrDefault(); if (_tblUser != null) { _LoginModel.ErrorMessage = "Your account has been blocked. Please contact to the administrator!"; } else { _tblUser = _ItblUserRepository.Get(x => x.Email.ToLower() == model.Username).FirstOrDefault(); if (_tblUser != null) { _tblUser.tblUserRole = null; _tblUserLog.FKUser = _tblUser.PKUser; _tblUser.InvalidAttempt = _tblUser.InvalidAttempt + 1; _ItblUserRepository.Update(_tblUser); } _tblUserLog.LoginSuccess = false; _LoginModel.ErrorMessage = "Invalid Username Or Password"; } } _tblUserLog.UserName = model.Username; _tblUserLog.Password = model.Password; _tblUserLog.LoginTime = DateTime.Now; _tblUserLog.IPAddress = context.HttpContext.Connection.RemoteIpAddress.ToString(); _tblUserLog.Origin = model.Origin; _tblUserLog.IsActive = true; _ItblUserLogRepository.Add(_tblUserLog); if (_tblUser != null && _tblUser.InvalidAttempt > 3) { tblUser _tblUser1 = new tblUser(); _tblUser1 = _ItblUserRepository.Get(x => x.Email.ToLower() == model.Username).FirstOrDefault(); if (_tblUser1 != null) { _tblUser1.IsBlocked = true; _tblUser.IsBlocked = true; _tblUser.tblUserRole = null; _ItblUserRepository.Update(_tblUser1); } } if (_tblUser != null) { _tblUser.IsActive = FirstLog; _tblUser.tblUserRole = _tblUserRole; if (_tblUserLog.LoginSuccess == false) { _tblUser = null; } else { _tblUser.Password = null; } } _LoginModel.Users = _tblUser; if (_LoginModel.ErrorMessage != null && _LoginModel.ErrorMessage.Length > 0) { _LoginModel.Users = null; } return(_LoginModel); } catch (Exception ex) { _LoginModel.ErrorMessage = ex.Message; log.Fatal("login:", ex); throw ex; } }
public ActionResult Registration(StudentRegistrationViewModel ts = null, WardenRegistrationViewModel tw = null) { tbluser us = new tbluser(); if (ts.StudentUserName != null) { if (ts.StudentId == 0) { tblStudent student = new tblStudent(); HttpPostedFileBase pic = Request.Files["StudentPhoto"]; HttpPostedFileBase avt = Request.Files["AvatarPhoto"]; student.UserName = ts.StudentUserName; student.StudentName = ts.StudentName; student.PermanentAddress = ts.PermanentAddress; student.TemporaryAddress = ts.TemporaryAddress; student.Phone = ts.StudentPhone; student.Email = ts.StudentEmail; student.Education = ts.Education; student.DOB = ts.DOB; student.Age = Convert.ToInt32(DateTime.Now.Year) - Convert.ToInt32(student.DOB.Value.Year); student.Photo = pic.FileName; student.AvatarPhoto = avt.FileName; student.UserName = ts.StudentUserName; student.Password = ts.StudentPassword; us.UserName = ts.StudentUserName; us.Password = ts.StudentPassword; us.Email = ts.StudentEmail; if (pic.ContentLength > 0) { pic.SaveAs(Path.Combine(Server.MapPath("~/Images/Student"), pic.FileName)); } if (avt.ContentLength > 0) { avt.SaveAs(Path.Combine(Server.MapPath("~/Images/Student"), avt.FileName)); } db.tblusers.Add(us); db.tblStudents.Add(student); db.SaveChanges(); tbluser tb = db.tblusers.Where(x => x.UserName == student.UserName).FirstOrDefault(); tblUserRole tr = new tblUserRole(); tr.UserId = tb.UserId; tr.RoleId = 2; db.tblUserRoles.Add(tr); db.SaveChanges(); } else { StudentRegistrationViewModel sm = ts; tblStudent student = db.tblStudents.Where(x => x.StudentId == sm.StudentId).FirstOrDefault(); HttpPostedFileBase pic = Request.Files["StudentPhoto"]; HttpPostedFileBase avt = Request.Files["AvatarPhoto"]; student.UserName = sm.StudentUserName; student.StudentName = sm.StudentName + " " + sm.StudentSurName; student.PermanentAddress = sm.PermanentAddress; student.TemporaryAddress = sm.TemporaryAddress; student.Phone = sm.StudentPhone; student.Email = sm.StudentEmail; student.Education = sm.Education; student.DOB = sm.DOB; student.Testomonial = sm.Testomonial; student.Age = Convert.ToInt32(DateTime.Now.Year) - Convert.ToInt32(student.DOB.Value.Year); if (pic.ContentLength > 0) { System.IO.File.Delete(Path.Combine(Server.MapPath("~/Images/Student/"), sm.StudentPhoto)); student.Photo = pic.FileName; avt.SaveAs(Path.Combine(Server.MapPath("~/Images/Student/"), pic.FileName)); } if (avt.ContentLength > 0) { System.IO.File.Delete(Path.Combine(Server.MapPath("~/Images/Student/"), sm.AvatarPhoto)); student.AvatarPhoto = avt.FileName; avt.SaveAs(Path.Combine(Server.MapPath("~/Images/Student/"), avt.FileName)); } student.UserName = sm.StudentUserName; student.Password = sm.StudentPassword; foreach (var item in db.tblusers.ToList()) { if (item.UserName == User.Identity.Name) { item.UserName = sm.StudentUserName; item.Email = sm.StudentEmail; item.Password = sm.StudentPassword; } } db.SaveChanges(); return(RedirectToAction("Index", "Opening")); } } if (tw.UserName != null) { if (tw.WardenId == 0) { tblWarden warden = new tblWarden(); HttpPostedFileBase fup = Request.Files["Photo"]; var filename = fup.FileName; warden.WardenName = tw.WardenName + " " + tw.WardenSurName; warden.WardenAddress = tw.WardenAddress; warden.WardenPhone = tw.WardenPhone; warden.Email = tw.Email; warden.Photo = filename; warden.UserName = tw.UserName; warden.Password = tw.Password; us.UserName = tw.UserName; us.Password = tw.Password; us.Email = tw.Email; if (fup.ContentLength > 0) { fup.SaveAs(Path.Combine(Server.MapPath("~/Images/Warden/"), fup.FileName)); } db.tblusers.Add(us); db.tblWardens.Add(warden); db.SaveChanges(); tbluser tb = db.tblusers.Where(x => x.UserName == warden.UserName).FirstOrDefault(); tblUserRole tr = new tblUserRole(); tr.UserId = tb.UserId; tr.RoleId = 3; db.tblUserRoles.Add(tr); db.SaveChanges(); } else { tblWarden warden = db.tblWardens.Where(x => x.WardenId == tw.WardenId).FirstOrDefault(); HttpPostedFileBase fup = Request.Files["Photo"]; warden.WardenName = tw.WardenName + " " + tw.WardenSurName; warden.WardenAddress = tw.WardenAddress; warden.WardenPhone = tw.WardenPhone; warden.Email = tw.Email; warden.Password = tw.Password; if (fup.ContentLength > 0) { System.IO.File.Delete(Path.Combine(Server.MapPath("~/Images/Warden/"), tw.Photo)); warden.Photo = fup.FileName; fup.SaveAs(Path.Combine(Server.MapPath("~/Images/Warden/"), fup.FileName)); } warden.UserName = tw.UserName; foreach (var item in db.tblusers.ToList()) { if (item.UserName == User.Identity.Name) { item.Password = tw.Password; item.UserName = tw.UserName; item.Email = tw.Email; } } db.SaveChanges(); return(RedirectToAction("Index", "Opening")); } } return(RedirectToAction("Login", "Account")); }
/// <summary> public static int UserRegistration(RegisterModel model) { try { using (var context = new IOASDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { tblUserRole objuserrole = new tblUserRole(); if (model.UserId == 0) { try { tblUser reg = new tblUser(); var chkuser = context.tblUser.FirstOrDefault(dup => dup.UserName == model.Username && dup.Status == "Active"); if (chkuser != null) { return(2); } reg.FirstName = model.Firstname; reg.LastName = model.Lastname; reg.RoleId = model.RoleId; reg.UserName = model.Username; reg.Password = Cryptography.Encrypt(model.Password, "LFPassW0rd"); reg.Dateofbirth = model.Dateofbirth; reg.DepartmentId = model.Department; reg.Gender = model.Gender; reg.CRTDDateTS = DateTime.Now; reg.UPDTDateTS = DateTime.Now; string Username = model.Createuser; reg.CreatedUserId = Common.GetUserid(Username); reg.Email = model.Username; reg.Status = "Active"; reg.UserImage = model.Image; context.tblUser.Add(reg); context.SaveChanges(); if (model.SelectedRoles != null) { var userid = (from U in context.tblUser where (U.UserName == model.Username) select U.UserId).FirstOrDefault(); model.UserId = userid; for (int i = 0; i < model.SelectedRoles.Length; i++) { objuserrole.UserId = model.UserId; objuserrole.RoleId = model.SelectedRoles[i]; objuserrole.Delegated_f = false; context.tblUserRole.Add(objuserrole); context.SaveChanges(); } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); return(-1); } return(1); } else { var objupdateuser = context.tblUser.Where(U => U.UserId == model.UserId).FirstOrDefault(); if (objupdateuser != null) { try { objupdateuser.UserId = model.UserId; objupdateuser.FirstName = model.Firstname; objupdateuser.LastName = model.Lastname; objupdateuser.RoleId = model.RoleId; //bjupdateuser.UserName = model.Username; //reg.Password = Cryptography.Encrypt(model.Password, "LFPassW0rd"); objupdateuser.Dateofbirth = model.Dateofbirth; objupdateuser.DepartmentId = model.Department; objupdateuser.Gender = model.Gender; objupdateuser.UPDTDateTS = DateTime.Now; string Username = model.Createuser; objupdateuser.LastUpdateUserId = Common.GetUserid(Username); //objupdateuser.Email = model.Username; if (model.Image != null) { objupdateuser.UserImage = model.Image; } context.SaveChanges(); var username = (from U in context.tblUser where (U.UserId == model.UserId) select U.UserName).FirstOrDefault(); model.Username = username; var query = (from R in context.tblUserRole where (R.UserId == model.UserId) select R).ToList(); if (query.Count > 0) { context.tblUserRole.RemoveRange(query); context.SaveChanges(); } if (model.SelectedRoles != null) { for (int i = 0; i < model.SelectedRoles.Length; i++) { objuserrole.UserId = model.UserId; objuserrole.RoleId = model.SelectedRoles[i]; objuserrole.Delegated_f = false; context.tblUserRole.Add(objuserrole); context.SaveChanges(); } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); return(-1); } } return(3); } } } } catch (Exception ex) { return(-1); } }
public ActionResult EmployerSignUp(EmployerViewModel em) { if (ModelState.IsValid) { List <tblUser> lst = _db.tblUsers.Where(u => u.Username == em.Username).ToList(); if (lst.Count == 0) { if (em.Password != null) { if (em.Password != em.RetypePassword) { ViewBag.Message = "Password Mismatch"; } else { string password = encryptpass(em.Password); tblUser tbu = new tblUser(); tbu.Username = em.Username; tbu.Password = password; _db.tblUsers.Add(tbu); _db.SaveChanges(); tblUserRole tbur = new tblUserRole(); tbur.UserId = tbu.UserId; tbur.RoleId = 2; _db.tblUserRoles.Add(tbur); _db.SaveChanges(); tblEmployer tbe = new tblEmployer(); tbe.CompanyName = em.CompanyName; tbe.ContactPerson = em.ContactPerson; tbe.Phone = em.Phone; tbe.Email = em.Email; tbe.CompanyWebsite = em.CompanyWebsite; tbe.Location = em.Location; tbe.CompanyDetails = em.CompanyDetails; tbe.UserId = tbu.UserId; HttpPostedFileBase fup = Request.Files["Logo"]; if (fup != null) { if (fup.FileName != "") { tbe.Logo = fup.FileName; fup.SaveAs(Server.MapPath("~/CompanyLogo/" + fup.FileName)); } } _db.tblEmployers.Add(tbe); _db.SaveChanges(); ViewBag.Message = "Your Account was created successfully"; } } else { ViewBag.Message = "Password Field is empty"; } } else { ViewBag.Message = "Username already exists!!!"; } } return(View()); }