private void removeButton_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("UPDATE calendar SET employee_id = 0 WHERE day=@day AND shift=@shift", mydb.getConnection);
cmd.Parameters.Add("@day", SqlDbType.Int).Value = calendar.convertToInt(dayBox.Text);
cmd.Parameters.Add("@shift", SqlDbType.Int).Value = Convert.ToInt32(shiftBox.Text);
mydb.openConnection();
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Removed Shift");
if (salary.fined(400))
{
}
mydb.closeConnection();
}
else
{
mydb.closeConnection();
}
}
private void checkInButton_Click(object sender, EventArgs e)
{
int day = calendar.convertToInt(DateTime.Now.DayOfWeek.ToString());
DateTime checkin = DateTime.Now;
SqlCommand cmd = new SqlCommand("UPDATE calendar SET checkin=@checkin WHERE shift=@shift AND day=@day", mydb.getConnection);
cmd.Parameters.Add("@day", SqlDbType.Int).Value = day;
cmd.Parameters.Add("@checkin", SqlDbType.DateTime).Value = checkin;
TimeSpan shift1Lower = new TimeSpan(7, 0, 0);
TimeSpan shift1Upper = new TimeSpan(7, 5, 0);
TimeSpan shift2Lower = new TimeSpan(11, 0, 0);
TimeSpan shift2Upper = new TimeSpan(11, 5, 0);
TimeSpan shift3Lower = new TimeSpan(18, 0, 0);
TimeSpan shift3Upper = new TimeSpan(18, 5, 0);
TimeSpan shift1End = new TimeSpan(11, 0, 0);
TimeSpan shift2End = new TimeSpan(14, 0, 0);
TimeSpan shift3End = new TimeSpan(22, 0, 0);
int shift;
if (checkin.TimeOfDay < shift1Upper && checkin.TimeOfDay > shift1Lower)
{
shift = 1;
cmd.Parameters.Add("@shift", SqlDbType.Int).Value = shift;
mydb.openConnection();
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Checkin Completed");
mydb.closeConnection();
}
else
{
MessageBox.Show("You Don't Have Shift Today");
mydb.closeConnection();
}
}
else if (checkin.TimeOfDay < shift1End && checkin.TimeOfDay > shift1Lower)
{
shift = 1;
cmd.Parameters.Add("@shift", SqlDbType.Int).Value = shift;
mydb.openConnection();
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Checkin Completed");
MessageBox.Show("You are late !!!");
salary.fined(100);
mydb.closeConnection();
}
else
{
MessageBox.Show("You Don't Have Shift Today");
mydb.closeConnection();
}
}
else if (checkin.TimeOfDay < shift2Upper && checkin.TimeOfDay > shift2Lower)
{
shift = 2;
cmd.Parameters.Add("@shift", SqlDbType.Int).Value = shift;
mydb.openConnection();
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Checkin Completed");
mydb.closeConnection();
}
else
{
MessageBox.Show("You Don't Have Shift Today");
mydb.closeConnection();
}
}
else if (checkin.TimeOfDay < shift2End && checkin.TimeOfDay > shift2Lower)
{
shift = 2;
cmd.Parameters.Add("@shift", SqlDbType.Int).Value = shift;
mydb.openConnection();
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Checkin Completed");
MessageBox.Show("You are late !!!");
salary.fined(100);
mydb.closeConnection();
}
else
{
MessageBox.Show("You Don't Have Shift Today");
mydb.closeConnection();
}
}
else if (checkin.TimeOfDay < shift3Upper && checkin.TimeOfDay > shift3Lower)
{
shift = 3;
cmd.Parameters.Add("@shift", SqlDbType.Int).Value = shift;
mydb.openConnection();
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Checkin Completed");
mydb.closeConnection();
}
else
{
MessageBox.Show("You Don't Have Shift Today");
mydb.closeConnection();
}
}
else if (checkin.TimeOfDay < shift3End && checkin.TimeOfDay > shift3Lower)
{
shift = 3;
cmd.Parameters.Add("@shift", SqlDbType.Int).Value = shift;
mydb.openConnection();
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Checkin Completed");
MessageBox.Show("You are late !!!");
salary.fined(100);
mydb.closeConnection();
}
else
{
MessageBox.Show("You Don't Have Shift Today");
mydb.closeConnection();
}
}
else
{
MessageBox.Show("It's Not Time To Checkin");
}
}