public int CheckEmployees(IEMPLBO obj)
{
string str = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.CommandText = "spCheck";
comm.Parameters.AddWithValue("@username", obj.Username);
comm.Parameters.AddWithValue("@password", obj.Password);
comm.Connection = conn;
int reader = Convert.ToInt32(comm.ExecuteScalar());
if (reader > 0)
{
return(1);
}
else
{
return(0);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string username = txtUsername.Text;
string password = txtPassword.Text;
IEMPLBO objBO = EMPFACTORYBO.CheckEmployees(username, password);
IEMPLBLL objBLL = EMPFACTORYBLL.Createnew();
int check = objBLL.CheckEmp(objBO);
if (check == 1)
{
lblMessage.Text = "Welcome Back " + username;
}
else
{
lblMessage.Text = "Who the hell are you?";
}
}
public int CheckEmp(IEMPLBO obj)
{
IEMPLDAL obj1 = EMPFACTORYDAL.CreateDAL();
return(obj1.CheckEmployees(obj));
}
