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); }