public string GetCertifiedBy()
{
return(SQLTools.ExecuteSingleResult($@"
select concat(ln,', ',fn,' ',mn) as certby from period
left join attendance on attendance.pid=period.pid
left join dutydetails on dutydetails.DID= attendance.DID
left join certifier on period.certby = certifier.ccid where month='{period.month}' and period = '{period.period}' and year='{period.year}' and aid='{AID}'"));
}
public static string[] GetAttendanceTooltip(int aid, int period, int month, int year)
{
string hpblob =
SQLTools.ExecuteSingleResult(
$@"SELECT hp FROM msadbarchive.period where gid={aid} and period={period} and month = {
month
} and year={year};");
HourProcessor h = (HourProcessor)Payroll._DeserializeObject(hpblob);
string[] a = new string[24];
string[] b =
{
#region +Keys
"nsu_proper_day_normal",
"nsu_overtime_day_normal",
"sun_proper_day_normal",
"sun_overtime_day_normal",
"nsu_proper_night_normal",
"nsu_overtime_night_normal",
"sun_proper_night_normal",
"sun_overtime_night_normal",
"nsu_proper_day_regular",
"nsu_overtime_day_regular",
"sun_proper_day_regular",
"sun_overtime_day_regular",
"nsu_proper_day_special",
"nsu_overtime_day_special",
"sun_proper_day_special",
"sun_overtime_day_special",
"nsu_proper_night_regular",
"nsu_overtime_night_regular",
"sun_proper_night_regular",
"sun_overtime_night_regular",
"nsu_proper_night_special",
"nsu_overtime_night_special",
"sun_proper_night_special",
"sun_overtime_night_special"
#endregion
};
for (int c = 0; c < b.Length; c++)
{
TimeSpan ts = h.hp[b[c]];
a[c] = (b[c][4] == 'p' ? "Regular" : "Overtime") + ": " + (((int)(ts.TotalHours)).ToString("00") + ":" + ((int)ts.Minutes).ToString("00")).ToString() + " hrs.";
}
return(a);
}
public static int GetInt(String query)
{
return(int.Parse(SQLTools.ExecuteSingleResult(query)));
}
public static String GetNumberOfClientRequests(int RequestStatusEnumeration)
{
String q = "select count(*) from request where rstatus=" + RequestStatusEnumeration;
return(SQLTools.ExecuteSingleResult(q));
}
public static int GetNumberOfUnassignedGuards()
{
int ass = int.Parse(SQLTools.ExecuteSingleResult("select count(*) from guards"));
return(ass - GetNumberOfAssignedGuards());
}
public static int GetNumberOfAssignedGuards()
{
return(int.Parse(SQLTools.ExecuteSingleResult("select count(*) from sduty_assignment where astatus=1;")));
}
public static int GetNumberOfTotalClients()
{
return(int.Parse(SQLTools.ExecuteSingleResult("SELECT count(*) FROM client;")));
}
public static int GetNumberOfActiveClients()
{
return(int.Parse(SQLTools.ExecuteSingleResult($@"SELECT count(*) FROM client WHERE cstatus = {Enumeration.ClientStatus.Active};")));
}