/// <summary> /// Get User Data /// </summary> /// <param name="userId"></param> /// <returns></returns> public SJSCUserMasterModels GetUserData(string userId) { var userdata = new SJSCUserMasterModels(); userdata = _context.SJSCUserMasterModel.Where(x => x.UserId == userId.Trim()).FirstOrDefault(); return(userdata); }
/// <summary> /// Register User /// </summary> /// <param name="UserData"></param> /// <returns></returns> public Int64 registerUser(SJSCUserMasterModels UserData) { SJSCUserMasterModels regData = new SJSCUserMasterModels(); regData.EmpCode = UserData.EmpCode.Trim(); regData.Title = UserData.Title.Trim(); regData.FirstName = UserData.FirstName.Trim(); regData.LastName = UserData.LastName.Trim(); regData.Designation = UserData.Designation.Trim(); regData.Department = UserData.Department.Trim(); regData.EmailID = UserData.EmailID.Trim(); regData.MobileNo = UserData.MobileNo.Trim(); regData.SJSCVerticalID = UserData.SJSCVerticalID; regData.Pwd = UserData.Pwd.Trim(); regData.HodTitle = UserData.HodTitle.Trim(); regData.HodName = UserData.HodName.Trim(); regData.HodEmailId = UserData.HodEmailId.Trim(); regData.HodMobileNo = UserData.HodMobileNo.Trim(); regData.UserId = UserData.EmailID; regData.IsApprover = UserData.EmailID.Trim().Equals(UserData.HodEmailId.Trim()) ? true : false; regData.IsActive = true; regData.CreateDate = DateTime.Now; regData.ModifiedDate = DateTime.Parse("01/01/1900"); _context.SJSCUserMasterModel.Add(regData); //manage sjsc role _context.SaveChanges(); return(regData.ID); }
public JsonResult UserRegister(SJSCUserMasterModels UserData) { if (UserData.EmpCode == null) { Random generator = new Random(); String r = generator.Next(0, 999999).ToString("D6"); UserData.EmpCode = r; } Int64 IsExist = _sJsisConcernRepository.checkUserIdWithEmpCode(UserData.EmailID, UserData.EmpCode); if (IsExist == 0) { Int64 s = _sJsisConcernRepository.registerUser(UserData); Session["SjsUserId"] = UserData.EmailID.Trim(); Session["SjsPwd"] = UserData.Pwd.Trim(); var emailSubject = "SpiceJet SOD-SJSC User Registration Confirmation Notification:" + System.DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt"); var emailTemplateName = "SJSCUserRegistrationConfirmation.html"; var emailCredentials = EmailCredentials(emailSubject, emailTemplateName, UserData); var SJSCRegistrationVerificationLink = ConfigurationManager.AppSettings["SJSCRegistrationVerification"].Trim(); var uri = SJSCRegistrationVerificationLink + "?str=" + CipherURL.Encrypt(UserData.EmailID.Trim()); var templateData = emailCredentials.TemplateFilePath; templateData = templateData.Replace("[hrefLink]", uri); emailCredentials.TemplateFilePath = templateData; TempData["emailData"] = emailCredentials; TempData["emailId"] = UserData.EmailID.Trim(); return(Json(s > 0 ? "Your registration process has been completed successfully. Please Activate your account via clicking on the link sent to your registered Email Id and login." : "Oops! something went wrong", JsonRequestBehavior.AllowGet)); } else { var msg = "This Employee Code :" + UserData.EmpCode + " or Employee Email ID : " + UserData.EmailID + " has already been registered."; return(Json(msg, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Reset Password /// </summary> /// <param name="UserData"></param> /// <param name="userID"></param> /// <returns></returns> public Int64 ResetPassword(PasswordModal UserData, string userID) { var s = 0; SJSCUserMasterModels getData = _context.SJSCUserMasterModel.Where(x => x.UserId == userID.Trim() && x.IsActive == true).FirstOrDefault(); if (getData.ResetPwd == false) { getData.Pwd = UserData.NewPwd.Trim(); getData.ResetPwd = true; getData.ModifiedDate = DateTime.Now; s = _context.SaveChanges(); } return(s); }
public JsonResult Loginregister(SJSCUserMasterModels UserData) { string IsExist = _sJsisConcernRepository.validateUserIdAndPwd(UserData.UserId, UserData.Pwd); try { if (IsExist == "Not varified") { return(Json("Not varified", JsonRequestBehavior.AllowGet)); } else if (IsExist == "Invalid") { return(Json("Invalid", JsonRequestBehavior.AllowGet)); } var regUserData = _sJsisConcernRepository.GetUserData(UserData.UserId); Session["SjsUserId"] = UserData.UserId.Trim(); Session["SjsPwd"] = UserData.Pwd.Trim(); Session["EmpCode"] = regUserData.EmpCode.Trim(); Session["EmpId"] = 0; Session["HodEmailId"] = regUserData.HodEmailId.Trim(); Session["FirstName"] = regUserData.FirstName; Session["LastName"] = regUserData.LastName; Session["Email"] = regUserData.EmailID; Session["Phone"] = regUserData.MobileNo; Session["Gender"] = regUserData.Title; Session["Designation"] = regUserData.Designation; Session["DeptIdCR"] = regUserData.Department; Session["Department"] = regUserData.Department; Session["Isapprover"] = regUserData.IsApprover; Session["HodName"] = regUserData.HodName.Trim(); Session["HodTitle"] = regUserData.HodTitle.Trim(); Session["HodMobileNo"] = regUserData.HodMobileNo == null ? "" : regUserData.HodMobileNo; Session["IsApprover"] = regUserData.IsApprover; if (regUserData.EmailID == regUserData.HodEmailId) { Session["Role"] = 11; Session["usertype"] = 1; } else { Session["Role"] = 10; } return(Json("Valid", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get Registered User Data /// </summary> /// <returns></returns> public ActionResult GetRegUserData() { var regUserData = new SJSCUserMasterModels(); if (Session["SjsUserId"] != null) { string userId = Session["SjsUserId"].ToString(); regUserData = _sJsisConcernRepository.GetUserData(userId); TempData["UserInfo"] = regUserData; return(Json(regUserData, JsonRequestBehavior.AllowGet)); } else { return(RedirectToAction("Login")); } }
/// <summary> /// Read File Method /// </summary> /// <param name="emailTemplateName"></param> /// <param name="UserData"></param> /// <returns></returns> private string ReadFile(string emailTemplateName, SJSCUserMasterModels UserData) { var strContent = new StringBuilder(); string line; var file = new System.IO.StreamReader(Server.MapPath("~/Template/SJSC/" + emailTemplateName)); while ((line = file.ReadLine()) != null) { strContent.Append(line); } file.Close(); var fullName = UserData.Title + " " + UserData.FirstName + " " + UserData.LastName; strContent = strContent.Replace("[userName]", fullName); strContent = strContent.Replace("[UserId]", UserData.EmailID); strContent = strContent.Replace("[PhNo]", UserData.MobileNo); return(strContent.ToString()); }
/// <summary> /// Update User info /// </summary> /// <param name="UserData"></param> /// <returns></returns> public Int64 UpdateUserInfo(SJSCUserMasterModels UserData) { var s = 0; var getData = _context.SJSCUserMasterModel.Where(x => x.UserId == UserData.EmailID.Trim()).FirstOrDefault(); getData.ModifiedDate = DateTime.Now; getData.Title = (UserData.Title == null) ? getData.Title.Trim() : UserData.Title.Trim(); getData.FirstName = (UserData.FirstName == null) ? getData.FirstName.Trim() : UserData.FirstName.Trim(); getData.LastName = (UserData.LastName == null) ? getData.LastName.Trim() : UserData.LastName.Trim(); getData.EmpCode = (UserData.EmpCode == null) ? getData.EmpCode.Trim() : UserData.EmpCode.Trim(); getData.SJSCVerticalID = (UserData.SJSCVerticalID == 0) ? getData.SJSCVerticalID : UserData.SJSCVerticalID; getData.Department = (UserData.Department == null) ? getData.Department.Trim() : UserData.Department.Trim(); getData.Designation = (UserData.Designation == null) ? getData.Designation.Trim() : UserData.Designation.Trim(); getData.MobileNo = (UserData.MobileNo == null) ? getData.MobileNo.Trim() : UserData.MobileNo.Trim(); getData.HodEmailId = (UserData.HodEmailId == null) ? getData.HodEmailId.Trim() : UserData.HodEmailId.Trim(); getData.HodName = (UserData.HodName == null) ? getData.HodName.Trim() : UserData.HodName.Trim(); getData.HodTitle = (UserData.HodTitle == null) ? getData.HodTitle.Trim() : UserData.HodTitle.Trim(); s = _context.SaveChanges(); return(s); }
public JsonResult validateUserIdforForgetPassword(SJSCUserMasterModels UserData) { Int64 IsExist = _sJsisConcernRepository.checkUserId(UserData); if (IsExist != 0) { try { var regUserData = _sJsisConcernRepository.GetUserData(UserData.EmailID); _sJsisConcernRepository.modifyPwd(UserData.EmailID); UserData.FirstName = regUserData.FirstName; UserData.LastName = regUserData.LastName; var ExpDate = DateTime.Now.AddMinutes(720); var emailSubject = "SOD-SJSC Account Recovery Notification:" + System.DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt"); var emailTemplateName = "SJSCUserForgotPassword.html"; var emailCredentials = EmailCredentials(emailSubject, emailTemplateName, UserData); var SJSCResetPasswordLink = ConfigurationManager.AppSettings["SJSCResetPassword"].Trim(); var uri = SJSCResetPasswordLink + "?str =" + CipherURL.Encrypt(UserData.EmailID.Trim()) + "&expdate=" + CipherURL.Encrypt(Convert.ToString(ExpDate)); var appLink = "<table><tr style='font-family:Arial;'><td style='padding:10px; height:25px; background-color:#04B431;text-align:center;border-radius:5px'><a style='color:#fff; text-decoration:none;' href='" + uri + "'>Reset Password</a></td></tr></table>"; var templateData = emailCredentials.TemplateFilePath; templateData = templateData.Replace("[hrefLink]", appLink); emailCredentials.TemplateFilePath = templateData; TempData["emailData"] = emailCredentials; TempData["emailId"] = UserData.EmailID.Trim(); } catch (Exception ex) { return(Json("Error", JsonRequestBehavior.AllowGet)); } return(Json("Success", JsonRequestBehavior.AllowGet)); } else { return(Json("Invalid", JsonRequestBehavior.AllowGet)); } }
/// <summary> /// check User Id /// </summary> /// <param name="UserData"></param> /// <returns></returns> public Int64 checkUserId(SJSCUserMasterModels UserData) { var datacheck = _context.SJSCUserMasterModel.Where(x => x.EmailID == UserData.EmailID.Trim()).FirstOrDefault(); return(datacheck != null ? datacheck.ID : 0); }
/// <summary> /// Initialized Email Credentials to Property /// </summary> /// <returns></returns> public EmailNotificationModel EmailCredentials(string subjectName, string emailTemplateName, SJSCUserMasterModels UserData) { var objEmailServices = new EmailNotificationModel { SmtpUser = ConfigurationManager.AppSettings["smtpUser"].Trim(), SmtpPass = ConfigurationManager.AppSettings["smtpPass"].Trim(), SmtpServer = ConfigurationManager.AppSettings["smtpServer"].Trim(), SmtpPort = ConfigurationManager.AppSettings["smtpPort"].Trim(), TemplateFilePath = ReadFile(emailTemplateName, UserData), EmailSubjectName = subjectName }; return(objEmailServices); }
public JsonResult UpdateUserInfo(SJSCUserMasterModels UserData) { Int64 s = _sJsisConcernRepository.UpdateUserInfo(UserData); return(Json(s > 0 ? "Your User Profile has been updated succesfully." : "Oops! something went wrong", JsonRequestBehavior.AllowGet)); }