public int CheckEmployee(IEmplBO obj)
{
string str = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(str);
sqlConnection.Open();
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "sp_checkUser";
com.Parameters.AddWithValue("@Username", obj.Username);
com.Parameters.AddWithValue("@Password", obj.Password);
com.Connection = sqlConnection;
int reader = Convert.ToInt32(com.ExecuteScalar());
if (reader > 0)
{
return(1);
}
else
{
return(0);
}
}
protected void btnSignin_Click(object sender, EventArgs e)
{
string username = txtUsername.Text;
string password = txtPassword.Text;
IEmplBO emplBO = EmplFacBO.CheckEmployee(username, password);
IEmplBLL emplBLL = EmplFacBLL.createnew();
int check = emplBLL.CheckEmp(emplBO);
if (check == 1)
{
Response.Redirect("~/successform.aspx");
}
else
{
Response.Redirect("~/Faliureform.aspx");
}
}
public int CheckEmp(IEmplBO emplBO)
{
IEmplDAL obj1 = EmplFacDAL.createDal();
return(obj1.CheckEmployee(emplBO));
}
