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