public int ClientPasswordReminder(ClientForgetPasswordModel objModel)
{
try
{
_conString = SqlHelper.GetConnectionString();
int StratasBoardId = 0;
SqlParameter prmUserName = SqlHelper.CreateParameter("@EmailId", objModel.Email);
SqlParameter prmType = SqlHelper.CreateParameter("@Type", 2);
SqlParameter[] allParams = { prmUserName, prmType };
DataSet ds = SqlHelper.ExecuteDataset(_conString, CommandType.StoredProcedure, "Usp_GetClientUser", allParams);
if (ds != null && ds.Tables.Count > 0)
{
DataTable Dt = ds.Tables[0].Copy();
StratasBoardId = Convert.ToInt32(Dt.Rows[0]["StratasBoardId"]);
ds.Dispose();
return(StratasBoardId);
}
else
{
return(StratasBoardId);
}
}
catch
{
throw;
}
}
public ActionResult ForgotPassword(ClientForgetPasswordModel objClientForgetPasswordModel)
{
try
{
if (ModelState.IsValid)
{
string message = string.Empty;
objClientForgetPasswordModel.Flag = 4;
ClientLoginHelper ClientLoginHelper = new ClientLoginHelper();
int StratasBoardId = ClientLoginHelper.ClientPasswordReminder(objClientForgetPasswordModel);
if (StratasBoardId > 0)
{
string result = EmailSender.FncSend_StratasBoard_ForgotPassword_ToClient(StratasBoardId);
if (result == "success")
{
ViewBag.Style = "color:Green !important";
TempData["CommonMessage"] = AppLogic.setFrontendMessage(0, "Your password has been sent. Please check your inbox. It usually takes a few minutes but when we're busy.it may take longer.");
}
else
{
ViewBag.Message = "color:Red !important";
TempData["CommonMessage"] = AppLogic.setFrontendMessage(0, "Please try again.");
}
}
else
{
ViewBag.Message = "color:Red !important";
TempData["CommonMessage"] = AppLogic.setFrontendMessage(2, "Please enter correct email as Email does not exits in our database.");
}
}
return(View(objClientForgetPasswordModel));
}
catch
{
ViewBag.Message = "color:Red !important";
TempData["CommonMessage"] = "Email address does not exists. Please try again.";
return(View(objClientForgetPasswordModel));
}
}
