private void btnConnect_Click(object sender, EventArgs e)
{
if (txtID.Text.Trim() == "")
{
MessageBox.Show("Please Enter User Name");
txtID.Focus();
return;
}
if (txtPass.Text.Trim() == "")
{
MessageBox.Show("Please Enter Password");
txtPass.Focus();
return;
}
if (DbAccess.recordExist("select * from Employee_Info where UserName='******' and Password='******'"))
{
VariableDecleration_Class.sLoginStatus = 1;
string connectionStr = DbAccess.connectionString;
SqlCommand cm = new SqlCommand();
SqlConnection cn = new SqlConnection(connectionStr);
try
{
cn.Open();
cm.Connection = cn;
cm.CommandText = "SELECT * FROM Employee_Info where UserName='******' and Password='******'";
SqlDataReader reader;
reader = cm.ExecuteReader();
while (reader.Read())
{
VariableDecleration_Class.sUserType = reader["UserType"].ToString();
VariableDecleration_Class.sUserName = reader["UserName"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cn.Close();
}
this.Close();
}
else
{
MessageBox.Show("Invalid User ID or Password");
txtID.Focus();
return;
}
}
public Boolean IsValid(int TypeKey, string TypeValue, int totalLeave)
{
string query = "SELECT * FROM Leave_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text);
int SickLeave = 0; int CasualLeave = 0; int MaternityLeave = 0; int EarnedLeave = 0;
SqlDataReader reader = DbAccess.GetFromDB(query);
if (reader.HasRows)
{
while (reader.Read())
{
SickLeave = Convert.ToInt32(reader["SickLeave"]);
CasualLeave = Convert.ToInt32(reader["CasualLeave"]);
MaternityLeave = Convert.ToInt32(reader["MaternityLeave"]);
EarnedLeave = Convert.ToInt32(reader["EarnedLeave"]);
}
}
DbAccess.connnection.Close();
if (TypeKey == 1)
{
if (DbAccess.recordExist("SELECT* FROM LeaveApply_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text) + " AND year(DateFrom) = '" + (int)DateTime.Now.Year + "' AND Type = '" + TypeValue + "'"))
{
query = "SELECT SUM(Total) AS UsedLeave FROM LeaveApply_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text) + " AND year(DateFrom) = '" + (int)DateTime.Now.Year + "' AND Type = '" + TypeValue + "'";
reader = DbAccess.GetFromDB(query);
if (reader.HasRows)
{
while (reader.Read())
{
if (totalLeave > (SickLeave - Convert.ToInt32(reader["UsedLeave"])))
{
DbAccess.connnection.Close();
return(false);
}
}
}
}
else
{
query = "SELECT SickLeave FROM Leave_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text);
reader = DbAccess.GetFromDB(query);
if (reader.HasRows)
{
while (reader.Read())
{
if (totalLeave > Convert.ToInt32(reader["SickLeave"]))
{
DbAccess.connnection.Close();
return(false);
}
}
}
}
}
if (TypeKey == 2)
{
if (DbAccess.recordExist("SELECT* FROM LeaveApply_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text) + " AND year(DateFrom) = '" + (int)DateTime.Now.Year + "' AND Type = '" + TypeValue + "'"))
{
query = "SELECT SUM(Total) AS UsedLeave FROM LeaveApply_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text) + " AND year(DateFrom) = '" + (int)DateTime.Now.Year + "' AND Type = '" + TypeValue + "'";
reader = DbAccess.GetFromDB(query);
if (reader.HasRows)
{
while (reader.Read())
{
if (totalLeave > (CasualLeave - Convert.ToInt32(reader["UsedLeave"])))
{
DbAccess.connnection.Close();
return(false);
}
}
}
}
else
{
query = "SELECT CasualLeave FROM Leave_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text);
reader = DbAccess.GetFromDB(query);
if (reader.HasRows)
{
while (reader.Read())
{
if (totalLeave > Convert.ToInt32(reader["CasualLeave"]))
{
DbAccess.connnection.Close();
return(false);
}
}
}
}
}
if (TypeKey == 3)
{
if (DbAccess.recordExist("SELECT* FROM LeaveApply_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text) + " AND year(DateFrom) = '" + (int)DateTime.Now.Year + "' AND Type = '" + TypeValue + "'"))
{
query = "SELECT SUM(Total) AS UsedLeave FROM LeaveApply_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text) + " AND year(DateFrom) = '" + (int)DateTime.Now.Year + "' AND Type = '" + TypeValue + "'";
reader = DbAccess.GetFromDB(query);
if (reader.HasRows)
{
while (reader.Read())
{
if (totalLeave > (MaternityLeave - Convert.ToInt32(reader["UsedLeave"])))
{
DbAccess.connnection.Close();
return(false);
}
}
}
}
else
{
query = "SELECT MaternityLeave FROM Leave_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text);
reader = DbAccess.GetFromDB(query);
if (reader.HasRows)
{
while (reader.Read())
{
if (totalLeave > Convert.ToInt32(reader["MaternityLeave"]))
{
DbAccess.connnection.Close();
return(false);
}
}
}
}
}
if (TypeKey == 4)
{
if (DbAccess.recordExist("SELECT* FROM LeaveApply_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text) + " AND year(DateFrom) = '" + (int)DateTime.Now.Year + "' AND Type = '" + TypeValue + "'"))
{
query = "SELECT SUM(Total) AS UsedLeave FROM LeaveApply_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text) + " AND year(DateFrom) = '" + (int)DateTime.Now.Year + "' AND Type = '" + TypeValue + "'";
reader = DbAccess.GetFromDB(query);
if (reader.HasRows)
{
while (reader.Read())
{
if (totalLeave > (EarnedLeave - Convert.ToInt32(reader["UsedLeave"])))
{
DbAccess.connnection.Close();
return(false);
}
}
}
}
else
{
query = "SELECT EarnedLeave FROM Leave_Info WHERE StaffID = " + Convert.ToInt32(StaffID.Text);
reader = DbAccess.GetFromDB(query);
if (reader.HasRows)
{
while (reader.Read())
{
if (totalLeave > Convert.ToInt32(reader["EarnedLeave"]))
{
DbAccess.connnection.Close();
return(false);
}
}
}
}
}
DbAccess.connnection.Close();
return(true);
}