/// <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));
}
