protected void btnLogin_Click(object sender, EventArgs e)
{
LoginBLL loginBLL = new LoginBLL();
//LoginDTO loginDTO = new LoginDTO();
//loginDTO.UserName = txtUserName.Text;
//loginDTO.PassWord = txtPassWord.Text;
LoginDTO loginDTO = new LoginDTO
{
UserName = txtUserName.Text,
PassWord = txtPassWord.Text
};
// bool ret_val = loginBLL.VerifyUser(loginDTO);
bool ret_val = loginBLL.VerifyUser(new LoginDTO
{
UserName = txtUserName.Text,
PassWord = txtPassWord.Text
});
if (ret_val == true)
{
Session["username"] = txtUserName.Text;
Response.Redirect("Default.aspx");
}
else
{
Response.Write("Login failed");
}
}
public bool VerifyUser(LoginDTO loginDTO)
{
//string val= File.ReadAllText("abc.txt");
loginDLL = new LoginDLL();
//bool ret_val = loginDLL.VerifyUser(loginDTO);
//return ret_val;
return loginDLL.VerifyUser(loginDTO);
}
public bool VerifyUser(LoginDTO loginDTO)
{
db = new DBAccess();
string sql = @"Select * from Users where
username='******' and password = '******'";
DataTable dtUsers = new DataTable();
dtUsers = db.ExecuteDataTable(sql);
if (dtUsers.Rows.Count == 1)
{
return true;
}
else
{
return false;
}
}
