public Userlogin checkLogincustomer(Userlogin_Class login)
{
Userlogin Userlogin1 = new Userlogin();
Userlogin1 = objModels.check_logincustomer(login);
return(Userlogin1);
}
public string checkLogin(Userlogin_Class login)
{
string Return = "";
DataTable dt = objModels.check_login(login);
if ((dt.Rows[0][0]).ToString() != "0")
{
Return = "login successfully";
}
else
{
Return = "not login";
}
return(Return);
}
public Userlogin check_logincustomer(Userlogin_Class obj)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(objCon.ConnectionReturn());
con.Open();
SqlCommand cmd = new SqlCommand("CheckLogincustomer", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", obj.Name);
cmd.Parameters.AddWithValue("@Password", obj.Password);
cmd.Parameters.Add("@Return", SqlDbType.NVarChar, 50).Value = "";
cmd.Parameters.Add("@ReturnName", SqlDbType.NVarChar, 50).Value = "";
cmd.Parameters["@Return"].Direction = ParameterDirection.Output;
cmd.Parameters["@Returnname"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
con.Close();
Userlogin Userlogin = new Userlogin();
Userlogin.Id = Convert.ToString(cmd.Parameters["@Return"].Value);
Userlogin.Name = Convert.ToString(cmd.Parameters["@Returnname"].Value);
return(Userlogin);
}
public DataTable check_login(Userlogin_Class obj)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(objCon.ConnectionReturn());
con.Open();
SqlCommand cmd = new SqlCommand("CheckLogin", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", obj.Name);
cmd.Parameters.AddWithValue("@Password", obj.Password);
try
{
dt.Load(cmd.ExecuteReader());
}
catch (Exception ex)
{
throw ex;
}
cmd.Dispose();
con.Close();
return(dt);
}
