public static CGeneralUser ForgotPassword(string Username, string Email)
{
CGeneralUser oResult = new CGeneralUser();
try
{
CShared oDBShared = new CShared();
DataSet dsLogin = oDBShared.GetDataSet("TForgotPassword", "uspForgotPassword '" + Username + "', '" + Email + "'");
using (DataTable dtForgot = dsLogin.Tables["TForgotPassword"])
{
if (dtForgot != null && dtForgot.Rows.Count > 0)
{
if (Convert.ToBoolean(dtForgot.Rows[0]["Success"]))
{
// SEND EMAIL INCULUDING PASSCODE ON USER'S EMAIL ADDRESS
string sUserEmail = dtForgot.Rows[0]["Email"].ToString();
string sPasscode = CShared.GetDecryptString(dtForgot.Rows[0]["Password"].ToString());
string sEmailBody = "<p>Greetings, <p>" +
"<p>This is your passcode: <b> " + sPasscode + "</b> for Ornament Application.<p>" +
"<p>Please use this passcode and login with Ornament app!<p>" +
"<p>Regards,</p>" +
"<p>Invisible Fiction.</p>";
//SEND EMAIL WITH NEW PASSWORD
oDBShared.SendEmail("Forgot Password|" + sUserEmail + "", "", "", "Your Passcode For Ornament App.", sEmailBody);
oResult.Success = Convert.ToBoolean(dtForgot.Rows[0]["Success"]);
oResult.WasSuccessful = Convert.ToInt32(dtForgot.Rows[0]["Success"]);
oResult.Exception = dtForgot.Rows[0]["ErrorSuccessMsg"].ToString();
}
else
{
oResult.Success = Convert.ToBoolean(dtForgot.Rows[0]["Success"]);
oResult.WasSuccessful = Convert.ToInt32(dtForgot.Rows[0]["Success"]);
oResult.Exception = dtForgot.Rows[0]["ErrorSuccessMsg"].ToString();
}
}
}
return(oResult);
}
catch (Exception ex)
{
throw ex;
}
}
public static CGeneralUser Login(string UserName, string PassWord)
{
CGeneralUser oResult = new CGeneralUser();
try
{
CShared oDBShared = new CShared();
string ePassword = CShared.GetEncryptString(PassWord);
DataSet dsLogin = oDBShared.GetDataSet("TLogin", "uspLogin '" + UserName + "', '" + ePassword + "'");
using (DataTable dtLogin = dsLogin.Tables["TLogin"])
{
if (dtLogin != null && dtLogin.Rows.Count > 0)
{
if (Convert.ToBoolean(dtLogin.Rows[0]["Success"]))
{
// TRUE FOR ORGANIZATION
oResult.DisplayName = dtLogin.Rows[0]["DisplayName"].ToString();
oResult.UserID = Convert.ToInt32(dtLogin.Rows[0]["UserID"]);
oResult.LoginTypeCode = Convert.ToInt32(dtLogin.Rows[0]["LoginTypeCode"]);
oResult.LastLogged = Convert.ToDateTime(dtLogin.Rows[0]["LastLogged"]).ToString("MM/dd/yyyy h:mm tt");
oResult.Success = Convert.ToBoolean(dtLogin.Rows[0]["Success"]);
oResult.WasSuccessful = Convert.ToInt32(dtLogin.Rows[0]["Success"]);
oResult.Exception = dtLogin.Rows[0]["ErrorSuccessMsg"].ToString();
}
// FAILED TO LOGIN
else
{
oResult.Success = Convert.ToBoolean(dtLogin.Rows[0]["Success"]);
oResult.WasSuccessful = Convert.ToInt32(dtLogin.Rows[0]["Success"]);
oResult.Exception = dtLogin.Rows[0]["ErrorSuccessMsg"].ToString();
}
}
}
}
catch (Exception ex)
{
//oResult.Success = false;
//oResult.WasSuccessful = 0;
//oResult.Exception = ex.Message;
throw ex;
}
return(oResult);
}
