private void GetWorkingorprDays()
{
int NumberOfDays = Calculate.GetTotalDaysOfMonth(MonthYear.Value);
int TotalSunday = Calculate.GetSunday(MonthYear.Value);
GetHollyday();
Official_Working_Days = (NumberOfDays - (Hollydays + TotalSunday)).ToString();
Total_Hours = (int.Parse(MyConnectionMethods.GetTotalHr()) * int.Parse(Official_Working_Days)).ToString();
}
public void GetOvertimeHours()
{
String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString;
SqlConnection conn = new SqlConnection(ConnString);
SqlDataReader reader;
String sql;
try
{
using (conn)
{
//Statuslabel
sql = "GetOvertimeHours";
SqlCommand cmd1 = new SqlCommand(sql, conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@ID", IDTB.Text);
cmd1.Parameters.AddWithValue("@Month", MonthSelected);
cmd1.Parameters.AddWithValue("@Year", YearSelected);
cmd1.Parameters.AddWithValue("@OnTime", MyConnectionMethods.GetTotalHr());
conn.Open();
reader = cmd1.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
// MessageBox.Show(reader[0].ToString());
if (reader[0].ToString() != "")
{
OverTimeHrtextBox.Text = reader[0].ToString();
OvertimeHours = int.Parse(OverTimeHrtextBox.Text);
}
// OvertimeHours = int.Parse(OverTimeHrtextBox.Text);
}
else
{
OverTimeHrtextBox.Text = "No OverTime";
}
}
}
catch (Exception)
{
}
}
