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