private void btnEditRequest_Click(object sender, EventArgs e)
{
DataTable dt = this.Da.ExecuteQueryTable(@"select * from request_info where reqid = '" + this.txtReqID.Text + "';");
if (dt.Rows.Count == 1)
{
this.Sql = @"update request_info set status = '" + this.cmbStatusRequest.Text + "' where reqid = '" + this.txtReqID.Text + "';";
int count = this.Da.ExecuteUpdateQuery(this.Sql);
if (count == 1)
{
MessageBox.Show("Status updated successfully");
}
else
{
MessageBox.Show("Error while updating Status");
}
FormUserDashBoard f = new FormUserDashBoard();
Notifications n = new Notifications(f.Notify);
n("you have 1 new notifaction");
this.PopulateGridViewRequest();
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
CommonClass.UserID = this.txtLoginID.Text;
try
{
this.Sql = @"select * from user_info
where userid = '" + this.txtLoginID.Text + "' and password = '******';";
Dt = this.Da.ExecuteQueryTable(this.Sql);
string a = Dt.Rows[0][6].ToString();
if (a == "Admin" || a == "admin")
{
MessageBox.Show("Login Sccessfull Admin");
FormAdminDashBoard admin = new FormAdminDashBoard();
this.Hide();
admin.Show();
}
else if (a == "User" || a == "user")
{
MessageBox.Show("Login Sccessfull User");
FormUserDashBoard user = new FormUserDashBoard();
this.Hide();
user.Show();
}
}
catch (Exception exc)
{
if (String.IsNullOrEmpty(this.txtLoginID.Text) || String.IsNullOrEmpty(this.txtPassword.Text))
{
MessageBox.Show("Fill all the value");
}
else if (Dt.Rows.Count == 0)
{
MessageBox.Show("Invalid Username or Password");
}
}
}