/// <summary>
/// Checking if super admin exist by email
/// and password
/// </summary>
/// <param name="email"></param>
/// <param name="isDelete"></param>
/// <returns></returns>
public FinocartMaster CheckSuperAdmin(string email, string password)
{
RepositoryService <FinocartMaster> objFinocartMaster = new RepositoryService <FinocartMaster>(_vContext);
FinocartMaster finocartMaster = objFinocartMaster.SelectAll().Where(x => x.EmailId == email && x.Password == password).FirstOrDefault();
return(finocartMaster);
}
/// <summary>
/// Checking if super admin exist by email
/// </summary>
/// <param name="email"></param>
/// <param name="isDelete"></param>
/// <returns></returns>
public FinocartMaster CheckSuperAdminByEmail(string email, bool isDelete)
{
RepositoryService <FinocartMaster> objFinocartMaster = new RepositoryService <FinocartMaster>(_vContext);
FinocartMaster finocartMaster = objFinocartMaster.SelectAll().Where(x => x.EmailId == email && x.IsDelete == isDelete).FirstOrDefault();
return(finocartMaster);
}
/// <summary>
/// Validate login
/// </summary>
/// <param name="EmailId"></param>
/// <param name="Password"></param>
/// <returns></returns>
public FinocartMaster ValidateLogin(string EmailId, string Password)
{
RepositoryService <FinocartMaster> objFinocartMaster = new RepositoryService <FinocartMaster>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@EmailId", EmailId, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Password", Password, System.Data.SqlDbType.VarChar));
var data = objFinocartMaster.ExecWithStoreProcedure("proc_CheckSuperAdminLogin @EmailId, @Password", parameters.ToArray());
FinocartMaster SuperAdmin = data.SingleOrDefault();
return(SuperAdmin);
}
public ActionResult SendForgetPasswordMail(ForgetPasswordModel objForgetPassword)
{
string ActionName = this.ControllerContext.RouteData.Values["action"].ToString();
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
Int32? UserID = HttpContext.Session.GetInt32("UserID");
string ErrorMessage = string.Empty;
var RoleName = "";
FinocartMaster objDatawithSP1 = null;
Company objDatawithSP2 = null;
User objDatawithSP3 = null;
IEnumerable <User> objDatawithSP = _CommonRepository.CheckUserPassword();
IEnumerable <User> objDatawithSP4 = _CommonRepository.CheckUserPassword();
try
{
var Name = "";
string ID = "";
string randomPassword = _CommonRepository.GeneratePassword();
// string EncryptToken = SecurityHelperService.Encrypt(Token);
string EmailID = objForgetPassword.EmailID.Trim();
var data = Encoding.UTF8.GetBytes(objForgetPassword.RoleName);
RoleName = Convert.ToBase64String(data);
if (objForgetPassword.RoleName == "MasterAdmin")
{
//IEnumerable<Company> objDatawithSP = _CommonRepository.CheckAdminPassword();
//objDatawithSP = objDatawithSP.Where(x => x.Contact_email == EmailID && x.IsDelete == false);
objDatawithSP2 = _CommonRepository.CheckAdminByEmailExists(EmailID);
if (objDatawithSP2 != null && (!objDatawithSP2.IsDelete || objDatawithSP2.LoginAttempt == 3))
{
Name = objDatawithSP2.Company_name;
ID = Convert.ToString(objDatawithSP2.CompanyID);
}
}
if (objForgetPassword.RoleName == "InternalUser")
{
//IEnumerable<User> objDatawithSP = _CommonRepository.CheckUserPassword();
//objDatawithSP = objDatawithSP.Where(x => x.Email == EmailID && x.IsDelete == true);
objDatawithSP3 = _CommonRepository.CheckUserByEmail(EmailID, true);
if (objDatawithSP3 != null)
{
Name = objDatawithSP3.Name;
ID = Convert.ToString(objDatawithSP3.UserID);
}
}
if (objForgetPassword.RoleName == "Vendor")
{
objDatawithSP = objDatawithSP.Where(x => x.Email == EmailID);
if (objDatawithSP.Any())
{
Name = objDatawithSP.ElementAt(0).Name;
ID = Convert.ToString(objDatawithSP.ElementAt(0).UserID);
}
}
if (objForgetPassword.RoleName == "Anchor Company")
{
objDatawithSP4 = objDatawithSP.Where(x => x.Email == EmailID && x.IsDelete == false);
if (objDatawithSP4.Any())
{
Name = objDatawithSP4.ElementAt(0).Name;
ID = Convert.ToString(objDatawithSP4.ElementAt(0).UserID);
}
}
if (objForgetPassword.RoleName == "SuperAdmin")
{
objDatawithSP1 = _CommonRepository.CheckSuperAdminByEmail(EmailID, false);
if (objDatawithSP1 != null)
{
Name = objDatawithSP1.Name;
ID = Convert.ToString(objDatawithSP1.ID);
}
}
if (Name != "")
{
string Token = ID + "~" + objForgetPassword.RoleName + "~" + DateTime.Now;
string EncryptToken = SecurityHelperService.Encrypt(Token);
// var Result = _CommonRepository.UpdatePassword(Password, EmailID, objForgetPassword.RoleName);
// if (Result > 0)
//{
IEnumerable <GetForgetPasswordMailTemplate> lstAwaitedInvVendorsView = _lookUpRepository.getForgetPasswordMailTemplate();
string path = lstAwaitedInvVendorsView.ElementAt(0).Template;
string EMAIL_TOKEN_PAYMENT_LINK = "##$$LOGIN_LINK$$##";
//string paymentLink ="http://*****:*****@@User@@", Name);
body = body.Replace("@@ProjectName@@", "Finocart");
body = body.Replace(EMAIL_TOKEN_PAYMENT_LINK, paymentLink);
body = body.Replace("http://dotnet.brainvire.com/Finocart/Account/AdminLogin", paymentLink);
body = body.Replace("@@Password@@", randomPassword);
IEnumerable <LookupDetails> lookupDetails = _lookUpRepository.getLookupDetailByKey("SMTPInfo");
_CommonRepository.SendEmail(lookupDetails, emailToAddress, subject, body, true);
TempData["MailSuccess"] = "Mail sent successfully";
// }
}
else
{
TempData["WrongMail"] = "Email ID is not valid";
}
}
catch (Exception ex)
{
TempData["FailureMessage"] = "We are sorry, something went wrong. Please try again later";
var st = new StackTrace(ex, true);
var frame = st.GetFrame(0);
int ErrorLine = frame.GetFileLineNumber();
var Result = _CommonRepository.LogManagement(ControllerName, ActionName, ex.Message, ErrorLine, UserID);
return(RedirectToAction("ErrorPage", "Common"));
}
return(RedirectToAction("ForgetPassword", "Account", new { Role = RoleName }));
}
public IActionResult ValidateSuperAdminLogOn(string EmailID, string Password, string IsRemember)
{
//EmailID = "*****@*****.**";
if (!ReCaptchaPassed(
Request.Form["g-recaptcha-response"], // that's how you get it from the Request object
_configuration.GetSection("GoogleReCaptcha:SecretKey").Value
))
{
TempData["InvalidCredential"] = "Captcha verification failed.";
return(RedirectToAction("SuperAdminLogin", "Account"));
}
string ActionName = this.ControllerContext.RouteData.Values["action"].ToString();
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
Int32? UserLoginID = HttpContext.Session.GetInt32("UserID");
string ErrorMessage = string.Empty;
try
{
Password = SecurityHelperService.Encrypt(Password);
FinocartMaster objDatawithSP = _SuperAdminRepository.ValidateLogin(EmailID, Password);
HttpContext.Session.SetString("Role", "SuperAdmin");
CookieOptions option = new CookieOptions();
option.Expires = DateTime.Now.AddDays(2);
Response.Cookies.Append("RoleAccess", "SuperAdmin", option);
if (objDatawithSP == null)
{
TempData["InvalidCredential"] = "Enter valid credential";
return(RedirectToAction("SuperAdminLogin", "Account"));
}
else
{
var UserID = objDatawithSP.ID;
var UserName = objDatawithSP.Name;
HttpContext.Session.SetInt32("UserID", UserID);
HttpContext.Session.SetString("LoginName", UserName);
HttpContext.Session.SetString("JWToken", GenerateJWTToken(UserName));
if (IsRemember == "1")
{
SetCookie(UserID.ToString(), UserName, "SuperAdmin");
Response.Cookies.Append("EmailID", EmailID, option);
}
var Res = _CommonRepository.AuditTrailLog("Login", "Super Admin Login", UserID, 0);
if (objDatawithSP.IsTemporaryPassword == false)
{
TempData["Role"] = "SuperAdmin";
return(RedirectToAction("SuperAdminDashBoard", "AnchorCompany"));
}
else
{
var data = Encoding.UTF8.GetBytes("SuperAdmin");
var Role = Convert.ToBase64String(data);
HttpContext.Session.SetString("Email", objDatawithSP.EmailId);
return(RedirectToAction("ChangePassword", "Common", new { RoleName = Role }));
}
}
}
catch (Exception ex)
{
var st = new StackTrace(ex, true);
var frame = st.GetFrame(0);
int ErrorLine = frame.GetFileLineNumber();
var Result = _CommonRepository.LogManagement(ControllerName, ActionName, ex.Message, ErrorLine, UserLoginID);
return(RedirectToAction("ErrorPage", "Common"));
}
}
public IActionResult updateNewPassword(ChangePasswordModel changePassword)
{
string ActionName = this.ControllerContext.RouteData.Values["action"].ToString();
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
Int32? UserID = HttpContext.Session.GetInt32("UserID");
string ErrorMessage = string.Empty;
var lstEmailIDofBank = _companyRepository.GetAnchorEmail(Convert.ToString(changePassword.UserId));
changePassword.Email = lstEmailIDofBank.ElementAt(0).Contact_email;
try
{
var Result = "";
var Actions = "";
changePassword.NewPassword = SecurityHelperService.Encrypt(changePassword.NewPassword);
changePassword.OldPassword = SecurityHelperService.Encrypt(changePassword.OldPassword);
var data = Encoding.UTF8.GetBytes(changePassword.Role);
var Role = Convert.ToBase64String(data);
if (HttpContext.Session.GetInt32("UserID") != null)
{
if (changePassword.Role == "InternalUser")
{
Actions = "UserLogin";
User objDatawithSP = _empRepository.CheckUser(changePassword.Email, changePassword.OldPassword);
if (objDatawithSP != null)
{
Result = objDatawithSP.Password;
}
}
if (changePassword.Role == "MasterAdmin")
{
Actions = "AdminLogin";
Company objDatawithSP = _empRepository.CheckAdmin(changePassword.Email, changePassword.OldPassword);
if (objDatawithSP != null)
{
Result = objDatawithSP.Password;
}
}
if (changePassword.Role == "SuperAdmin")
{
Actions = "SuperAdminLogin";
FinocartMaster objDatawithSP = _empRepository.CheckSuperAdmin(changePassword.Email, changePassword.OldPassword);
if (objDatawithSP != null)
{
Result = objDatawithSP.Password;
}
}
if (Result != "")
{
var Data = _empRepository.UpdateNewPassword(changePassword);
}
else
{
TempData["WrongPassword"] = "******";
return(RedirectToAction("ChangePassword", "Common", new { RoleName = Role }));
}
if (Result != "")
{
string emailToAddress = lstEmailIDofBank.ElementAt(0).Contact_email;
string AnchorName = lstEmailIDofBank.ElementAt(0).Contact_Name;
string BankName = HttpContext.Session.GetString("LoginName");
string Template = string.Empty;
int Id = 1;
IEnumerable <GetChangePasswordMailTemplate> lstAwaitedInvVendorsView = _companyRepository.GetChangePasswordMailTemplate(Template);
string path = lstAwaitedInvVendorsView.ElementAt(0).Template;
//string path = "";
string subject = "Change Password";
string body = path;
body = body.Replace("@@User@@", AnchorName);
body = body.Replace("@@BankName@@", BankName);
body = body.Replace("@@mentiondateandtime", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"));
IEnumerable <LookupDetails> lookupDetails = _lookUpRepository.getLookupDetailByKey("SMTPInfo");
_CommonRepository.SendEmail(lookupDetails, emailToAddress, subject, body, true);
}
return(RedirectToAction(Actions, "Account"));
}
else
{
return(RedirectToAction("ChangePassword", "Common", new { RoleName = Role }));
}
}
catch (Exception ex)
{
var st = new StackTrace(ex, true);
var frame = st.GetFrame(0);
int ErrorLine = frame.GetFileLineNumber();
var Result = _CommonRepository.LogManagement(ControllerName, ActionName, ex.Message, ErrorLine, UserID);
return(RedirectToAction("ErrorPage", "Common"));
}
}
public IActionResult setChangePassword(ChangePasswordModel objChangePassword)
{
string ActionName = this.ControllerContext.RouteData.Values["action"].ToString();
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
Int32? UserID = HttpContext.Session.GetInt32("UserID");
string ErrorMessage = string.Empty;
try
{
//string pw = SecurityHelperService.Decrypt("ueNl4Gl98pKy3m0G6CaqBsi6jSC58DX8");
var Result = "";
var Actions = "";
objChangePassword.NewPassword = SecurityHelperService.Encrypt(objChangePassword.NewPassword);
objChangePassword.OldPassword = SecurityHelperService.Encrypt(objChangePassword.OldPassword);
var data = Encoding.UTF8.GetBytes(objChangePassword.Role);
var Role = Convert.ToBase64String(data);
if (HttpContext.Session.GetInt32("UserID") != null)
{
if (objChangePassword.Role == "InternalUser")
{
Actions = "UserLogin";
//IEnumerable<User> objDatawithSP = _empRepository.CheckUserPassword();
//objDatawithSP = objDatawithSP.Where(x => x.Password == objChangePassword.OldPassword && x.Email == objChangePassword.Email);
User objDatawithSP = _empRepository.CheckUser(objChangePassword.Email, objChangePassword.OldPassword);
if (objDatawithSP != null)
{
Result = objDatawithSP.Password;
}
}
if (objChangePassword.Role == "MasterAdmin")
{
Actions = "AdminLogin";
//IEnumerable<Company> objDatawithSP = _empRepository.CheckAdminPassword();
////objDatawithSP = objDatawithSP.Where(x => x.Password == objChangePassword.OldPassword && (x.Email == objChangePassword.Email || x.PANNumber == objChangePassword.Email));
//objDatawithSP = objDatawithSP.Where(x => x.Password == objChangePassword.OldPassword && x.Pan_number == objChangePassword.Email);
Company objDatawithSP = _empRepository.CheckAdmin(objChangePassword.Email, objChangePassword.OldPassword);
if (objDatawithSP != null)
{
Result = objDatawithSP.Password;
}
}
if (objChangePassword.Role == "SuperAdmin")
{
Actions = "SuperAdminLogin";
//IEnumerable<FinocartMaster> objDatawithSP = _empRepository.CheckSuperAdminPassword();
//objDatawithSP = objDatawithSP.Where(x => x.Password == objChangePassword.OldPassword && x.EmailId == objChangePassword.Email);
FinocartMaster objDatawithSP = _empRepository.CheckSuperAdmin(objChangePassword.Email, objChangePassword.OldPassword);
if (objDatawithSP != null)
{
Result = objDatawithSP.Password;
}
}
if (Result != "")
{
var Data = _empRepository.UpdateNewPassword(objChangePassword);
return(RedirectToAction(Actions, "Account"));
}
else
{
TempData["WrongPassword"] = "******";
return(RedirectToAction("ChangePassword", "Common", new { RoleName = Role }));
}
}
else
{
return(RedirectToAction("ChangePassword", "Common", new { RoleName = Role }));
}
}
catch (Exception ex)
{
var st = new StackTrace(ex, true);
var frame = st.GetFrame(0);
int ErrorLine = frame.GetFileLineNumber();
var Result = _CommonRepository.LogManagement(ControllerName, ActionName, ex.Message, ErrorLine, UserID);
return(RedirectToAction("ErrorPage", "Common"));
}
}
