public ForgotPassword FindUserByEmail(ForgotPasswordBo forgotpasswordBo)
{
var fogotpassword = BuiltForgotPasswordDomain(forgotpasswordBo);
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.proc_FindUser_byEmail", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", fogotpassword.Email);
cmd.Parameters.AddWithValue("@opReturnValue", SqlDbType.Int);
SqlDataReader reader = cmd.ExecuteReader();
ForgotPassword lst = new ForgotPassword();
if (reader.HasRows)
{
while (reader.Read())
{
lst.Email = reader["User_Name"].ToString();
lst.Id = Convert.ToInt32(reader["User_Id"]);
}
conn.Close();
}
return(lst);
}
private ForgotPassword BuiltForgotPasswordDomain(ForgotPasswordBo forgotpasswordBo)
{
return((ForgotPassword) new ForgotPassword().InjectFrom(forgotpasswordBo));
}