public static void AddCertifier(int cid, string fn, string mn, string ln, string contactno)
{
var q =
$@"INSERT INTO `msadb`.`certifier` (`cid`, `fn`, `ln`, `mn`,`contactno`) VALUES ('{cid}', '{fn}', '{ln}', '{mn}', '{contactno}');";
SQLTools.ExecuteNonQuery(q);
}
public static DataTable GetAllAssignmentDetails(int AID)
{
SQLTools.ExecuteNonQuery("call msadb.init_checkdate_assignmentstatus();");
/*
* On Status: What status? Assignment status?
* NTS: Is status supposed to be active when guard has duty? Or when guard has assignment?
*/
//return Gid, Name sa Guard, CID, name sa client, status
String q = @"/* return Gid, Name sa Guard, CID, name sa client, status */
select
guards.gid as gid,
client.cid as cid,
concat(ln,', ',fn,' ',mn) as guardname,
client.name as clientname,
case astatus when 1 then 'Active' when 2 then 'Inactive' end as assignmentstatus
from sduty_assignment
left join request_assign on sduty_assignment.RAID=request_assign.RAID
left join request on request.RID = request_assign.RID
left join client on request.cid = client.cid
left join guards on guards.gid = sduty_assignment.GID
where sduty_assignment.AID = " + AID;
return(SQLTools.ExecuteQuery(q));
}
public static void UpdateDutyDetailDates(int did, DateTime de, DateTime dd)
{
var q = $@"UPDATE `msadb`.`dutydetails` SET `date_effective`='{de:yyyy-MM-dd}', `date_dismissal`='{dd:yyyy-MM-dd}' WHERE `DID`='{did}';";
SQLTools.ExecuteNonQuery(q);
SQLTools.ExecuteNonQuery("call init_checkdate_dutydetail();");
}
public static string AddDutyDetail(int aid, String TI_hr, String TI_min, String TI_ampm, String TO_hr, String TO_min, String TO_ampm, Days days, DateTime DateEffective, DateTime DateDismissed)
{
bool isOverlap = HasOverlap(aid, ($@"{TI_hr}:{TI_min}"), ($@"{TO_hr}:{TO_min}"), days, DateEffective, DateDismissed);
if (isOverlap)
{
return(">");
}
DateTime ti = DateTime.Parse($"3/1/0001 {TI_hr}:{TI_min} {TI_ampm}");
DateTime to = DateTime.Parse($"3/1/0001 {TO_hr}:{TO_min} {TO_ampm}");
HourProcessor hp = new HourProcessor(ti, to, ti, to);
DateTime to_props = ti.AddHours(8);
TimeSpan e = hp.GetTotalTS();
String q = $@"
INSERT INTO `msadb`.`dutydetails`
(`AID`,
`TI_hh`, `TI_mm`, `TI_period`,
`TO_hh`, `TO_mm`, `TO_period`,
`Mon`, `Tue`, `Wed`, `Thu`, `Fri`, `Sat`, `Sun`,
`DStatus`, `minutediff`,`to_actual_hh`,`to_actual_mm`,`to_actual_period`, `date_effective`, `date_dismissal`)
VALUES
('{aid}',
'{TI_hr}','{TI_min}','{TI_ampm}',
'{to_props:hh}','{to_props:mm}','{to_props:tt}',
'{ToInt32(days.Mon)}','{ToInt32(days.Tue)}','{ToInt32(days.Wed)}','{ToInt32(days.Thu)}','{ToInt32(days.Fri)}',
'{ToInt32(days.Sat)}','{ToInt32(days.Sun)}',
'{Enumeration.DutyDetailStatus.Pending}', {(int)e.TotalMinutes},
'{TO_hr}','{TO_min}','{TO_ampm}', '{DateEffective:yyyy-MM-dd}', '{DateDismissed:yyyy-MM-dd}');
";
//if (e.TotalHours > 8) { return "="; } else if (e.TotalHours < 8) { return "="; }
SQLTools.ExecuteNonQuery(q);
return("=");
}
public static void ApproveUnassignment(int RequestId)
{
DataTable de = SQLTools.ExecuteQuery($@"select * from request
left join request_unassign on request_unassign.RID = request.RID
where request.rid={RequestId};");
DateTime DateEffective = DateTime.Parse(de.Rows[0]["dateeffective"].ToString());
// 1.) Get all GIDs of guards in RID
DataTable GuardsToBeDismissed = SQLTools.ExecuteQuery(@"select guards.gid as gid, sduty_assignment.aid as aid from guards
left join sduty_assignment on sduty_assignment.GID = guards.gid
left join request_unassign on request_unassign.gid = guards.gid
where rid = " + RequestId + ";");
foreach (DataRow e in GuardsToBeDismissed.Rows)
{
// 1A) Set scheds to inactive
String q = @"UPDATE `msadb`.`dutydetails` SET `DStatus`='" + Enumeration.DutyDetailStatus.Inactive + "' WHERE `AID`='" + e["aid"] + "';";
SQLTools.ExecuteNonQuery(q);
// 2.) Set assignment to dismissed (IF they have schedules active)
q = $@"UPDATE `msadb`.`sduty_assignment` SET `AStatus`='{
Enumeration.AssignmentStatus.Inactive
}', UnassignedOn='{DateEffective:yyyy-MM-dd}' WHERE `gid`='{e["gid"]}';";
SQLTools.ExecuteNonQuery(q);
// 3.) Set guard to Inactive (BUT NOT DISMISSED)
q = $@"UPDATE `msadb`.`guards` SET `GStatus`='{Enumeration.GuardStatus.PendingPayroll}' WHERE `GID`='{e[0]}'";
SQLTools.ExecuteNonQuery(q);
SQLTools.ExecuteQuery($@"call init_checkdate_gstatus_onapprove({e[0]})");
}
// Step 4
UpdateRequestStatus(RequestId, Enumeration.RequestStatus.Approved, Login.LoggedInUser);
}
/// <summary>
/// Adds an unassignment request for the specified guards.
/// </summary>
/// <param name="cid">Client ID</param>
/// <param name="gid">An array of Guard ID's to be dismissed</param>
/// <param name="ReportType">Enumeration.ReportType (Incident)</param>
/// <param name="pcompleting">Idk unsa ni na field.</param>
/// <param name="EventDate">Date of event.</param>
/// <param name="location">Brief location description</param>
/// <param name="description">Brief description of incident.</param>
public static void AddUnassignmentRequest(int cid, int[] gid, int ReportType, String pcompleting, DateTime EventDate,
String location, String description, DateTime DateEffective)
{
// 1.) Add Incident Report
String q = String.Format(@"INSERT INTO `msadb`.`incidentreport`
(`ReportType`, `DateEntry`, `PCompleting`, `EventDate`, `EventLocation`, `Description`)
VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}');",
ReportType, SQLTools.getDateTime(), pcompleting, EventDate.ToString("yyyy-MM-dd"), location, description
);
SQLTools.ExecuteNonQuery(q);
// 2.) Insert a dismissal request.\
// 2a: Get last inserted Incident Report (link this)
int IncidentId = int.Parse(SQLTools.getLastInsertedId("IncidentReport", "iid"));
// 2b: Insert request
q = "INSERT INTO `msadb`.`request` (`RequestType`, `CID`, `DateEntry`,`rstatus`) VALUES ('{0}', '{1}', '{2}','{3}')";
q = string.Format(q, Enumeration.RequestType.Dismissal, cid, SQLTools.getDateTime(), Enumeration.RequestStatus.Pending);
SQLTools.ExecuteNonQuery(q);
String lid = SQLTools.getLastInsertedId("request", "rid");
for (int c = 0; c < gid.Length; c++)
{
q = $@"INSERT INTO `msadb`.`request_unassign` (`RID`, `gid`, `iid`, `DateEffective`) VALUES ('{lid.ToString()}', '{ gid[c]}', '{IncidentId}', '{DateEffective:yyyy-MM-dd}');";
SQLTools.ExecuteNonQuery(q);
}
}
public static void UpdateCertifier(int ccid, string fn, string mn, string ln, string contactno)
{
var q =
$@"UPDATE `msadb`.`certifier` SET `fn`='{fn}', `mn`='{mn}', `ln`='{ln}', `contactno`='{contactno}' WHERE `ccid`='{ccid}';";
SQLTools.ExecuteNonQuery(q);
}
public void SetCertifiedBy(int AID, int cert)
{
Period p = GetCurrentPayPeriod();
String q = @"UPDATE `msadb`.`period` SET `certby`='" + cert + "' WHERE `GID`='" + GID + "' AND month='" + p.month + "' AND period='" + p.period + "' AND year='" + p.year + "';";
SQLTools.ExecuteNonQuery(q);
}
public static void AddHoliday(SelectionRange r, string desc, int type, int trans)
{
var q = $@"
call msadb.proc_holiday_addholiday('{r.Start:yyyy-MM-dd}', '{r.End:yyyy-MM-dd}', '{desc}', {type}, {trans});
";
SQLTools.ExecuteNonQuery(q);
}
public static void AddClient(string name, string streetNo, string street, string brgy, string city, string contactPerson, string contactNo, string Manager, double OfficerRate)
{
String q = $@"INSERT INTO `msadb`.`Client`
(`Name`, `ClientStreetNo`, `ClientStreet`,`ClientBrgy`,`ClientCity`,`ContactPerson`,`ContactNo`,`Manager`,`CStatus` ,`ofcrate` )
VALUES ('{name}', '{streetNo}', '{street}', '{brgy}', '{city}', '{contactPerson}', '{contactNo}', '{Manager}', '{Enumeration.ClientStatus.Inactive}', '{OfficerRate}');";
SQLTools.ExecuteNonQuery(q);
}
public static void ChangeUsername(int accid, string NewUname)
{
var q = $@"
UPDATE `msadb`.`account` SET
`uname`='{NewUname}'
WHERE `accid`='{accid}';
";
SQLTools.ExecuteNonQuery(q);
}
public static void DismissDuty(int did, DateTime dismissal_date)
{
// Set duty detail to inactive.
// Previous duty na ni niya.
String q = $@"UPDATE `msadb`.`dutydetails`
SET `DStatus`={Enumeration.DutyDetailStatus.Inactive},
`Date_Dismissal`='{dismissal_date:yyyy-MM-dd}'
WHERE `DID`={did}";
SQLTools.ExecuteNonQuery(q);
Console.WriteLine(q);
}
public static void AddUnassignmentRequestNoIncident(int cid, int[] gid, DateTime DateEffective)
{
// 2b: Insert request
var q = "INSERT INTO `msadb`.`request` (`RequestType`, `CID`, `DateEntry`,`rstatus`) VALUES ('{0}', '{1}', '{2}','{3}')";
q = string.Format(q, Enumeration.RequestType.Dismissal, cid, SQLTools.getDateTime(), Enumeration.RequestStatus.Pending);
SQLTools.ExecuteNonQuery(q);
String lid = SQLTools.getLastInsertedId("request", "rid");
for (int c = 0; c < gid.Length; c++)
{
q = $@"INSERT INTO `msadb`.`request_unassign` (`RID`, `gid`, `DateEffective`) VALUES ('{lid.ToString()}', '{ gid[c]}', '{DateEffective:yyyy-MM-dd}');";
SQLTools.ExecuteNonQuery(q);
}
}
public void SetAttendance(int AtID, int ti_hh, int ti_mm, String ti_ampm, int to_hh, int to_mm, String to_ampm)
{
int did = SQLTools.GetInt("select did from attendance where AtID=" + AtID);
TimeSpan ts = GetTimeDiff(ti_hh, ti_mm, ti_ampm, to_hh, to_mm, to_ampm);
DateTime ti = GetDateTime(ti_hh, ti_mm, ti_ampm);
DateTime to = GetDateTime(to_hh, to_mm, to_ampm);
//compare with tama na sched for overtime
DataRow dt = SQLTools.ExecuteQuery("select * from dutydetails where DID=" + did).Rows[0];
DateTime start_night = GetDateTime(10, 00, "PM");
DateTime end_night = GetDateTime(6, 0, "AM").AddDays(1);
String q = @"UPDATE `msadb`.`attendance` SET `TimeIn`='{1}', `TimeOut`='{2}' WHERE `AtID`='{0}';";
q = Format(q, AtID, ti.ToString("hh:mm tt"), to.ToString("hh:mm tt"));
SQLTools.ExecuteNonQuery(q);
}
public static string UpdateDutyDetail(int did, String TI_hr, String TI_min, String TI_ampm, String TO_hr, String TO_min, String TO_ampm, Days days)
{
string wq = $@"SELECT * FROM msadb.dutydetails where did = '{did}';";
DataTable dt = SQLTools.ExecuteQuery(wq);
int aid;
if (dt.Rows.Count != 0)
{
aid = int.Parse(dt.Rows[0]["aid"].ToString());
}
else
{
MessageBox.Show("No duty details found.");
return("X");
}
DateTime deff = DateTime.Parse(dt.Rows[0]["date_effective"].ToString());
DateTime dend = DateTime.Parse(dt.Rows[0]["date_dismissal"].ToString());
bool isOverlap = HasOverlap(aid, did, ($@"{TI_hr}:{TI_min}"), ($@"{TO_hr}:{TO_min}"), days, deff, dend);
if (isOverlap)
{
return("olap");
}
DateTime ti = DateTime.Parse($"3/1/0001 {TI_hr}:{TI_min} {TI_ampm}");
DateTime to = DateTime.Parse($"3/1/0001 {TO_hr}:{TO_min} {TO_ampm}");
DateTime to_props = ti.AddHours(8);
HourProcessor hp = new HourProcessor(ti, to, ti, to);
TimeSpan e = hp.GetTotalTS();
//if (e.TotalHours > 8) { return ">"; } else if (e.TotalHours < 8) { return "<"; }
Console.Write(e.TotalMinutes);
String q = $@"
UPDATE `msadb`.`dutydetails` SET
`TI_hh`='{TI_hr}', `TI_mm`='{TI_min}', `TI_period`='{TI_ampm}',
`TO_actual_hh`='{TO_hr}', `TO_actual_mm`='{TO_min}', `TO_actual_period`='{TO_ampm}',
`TO_hh`='{to_props:hh}', `TO_mm`='{to_props:mm}', `TO_period`='{to_props:tt}',
`Mon`='{ToInt32(days.Mon)}', `Tue`='{ToInt32(days.Tue)}',
`Wed`='{ ToInt32(days.Wed)}', `Thu`='{ToInt32(days.Thu)}',
`Fri`='{ToInt32(days.Fri)}', `Sat`='{ToInt32(days.Sat)}',
`Sun`='{ToInt32(days.Sun)}', `minutediff`={(int)(e.TotalMinutes)}
WHERE `DID`='{did}';
";
SQLTools.ExecuteNonQuery(q);
return("=");
}
/// <summary>
/// Adds an assignment request. Note: This isn't an actual assignment yet.
/// </summary>
/// <param name="CID">Client ID (the requester)</param>
/// <param name="AssStreetNo"></param>
/// <param name="AssStreetName"></param>
/// <param name="AssBrgy"></param>
/// <param name="AssCity"></param>
/// <param name="ContractStart"></param>
/// <param name="ContractEnd">DateTime ang ipass diri</param>
/// <param name="NoGuards">Number of Guards</param>
public static void AddAssignmentRequest(int CID, string AssStreetNo, string AssStreetName, string AssBrgy, string AssCity, DateTime ContractStart, DateTime ContractEnd, int NoGuards)
{
String madeon = DateTime.Now.ToString("yyyy-MM-dd");
String q1 = String.Format("INSERT INTO `msadb`.`request` (`RequestType`, `CID`, `DateEntry`,`rstatus`) VALUES ('{0}', '{1}', '{2}','{3}');",
Enumeration.RequestType.Assignment, CID, madeon, Enumeration.RequestStatus.Pending);
SQLTools.ExecuteNonQuery(q1);
String rid = SQLTools.getLastInsertedId("request", "rid");
String query = String.Format("INSERT INTO `msadb`.`request_assign` " +
" ( `ContractStart`, `ContractEnd`, `streetno`, `streetname`, `brgy`, `city`,`noguards`,`rid`)" +
" VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}');",
ContractStart.ToString("yyyy-MM-dd"), ContractEnd.ToString("yyyy-MM-dd"),
AssStreetNo, AssStreetName, AssBrgy, AssCity, NoGuards, rid);
Console.WriteLine("AddAssignmentRequest: \n" + query);
SQLTools.ExecuteNonQuery(query);
}
public static void UpdateClient(string Cid, string name, string streetNo, string street, string brgy,
string city, string contactPerson, string contactNo, string Manager, double OfficerRate)
{
var q = $@"UPDATE `msadb`.`Client` SET
`Name` = '{name}',
`ClientStreetNo` = '{streetNo}',
`ClientStreet` = '{street}',
`ClientBrgy`= '{brgy}',
`ClientCity`= '{city}',
`ContactPerson`= '{contactPerson}',
`ContactNo`= '{contactNo}',
`Manager`= '{Manager}',
`OfcRate`={OfficerRate}
WHERE CID = '{Cid}';";
SQLTools.ExecuteNonQuery(q);
}
public static bool ChangePassword(int accid, string NewPassword, string OldPassword)
{
String x = @"select hash from account where accid='" + accid + "'";
DataTable dt = SQLTools.ExecuteQuery(x);
if (Crypt.Verify(OldPassword, dt.Rows[0]["hash"].ToString()))
{
var q = $@"
UPDATE `msadb`.`account` SET
`hash`='{Crypt.HashPassword(NewPassword)}'
WHERE `accid`='3';
";
SQLTools.ExecuteNonQuery(q);
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Returns a DataTable listing the Summary of Duty Details of a specific assignment.
/// </summary>
/// <param name="AID">Assignment ID</param>
/// <returns>Columns: ["did", "TimeIn", "TimeOut", "Days"]</returns>
public static DataTable GetDutyDetailsSummary(int AID)
{
SQLTools.ExecuteNonQuery("call init_checkdate_dutydetail();");
DataTable dt =
SQLTools.ExecuteQuery(@"
select did, concat (ti_hh,':',ti_mm,' ',ti_period) as TimeIn,
concat (to_actual_hh,':',to_actual_mm,' ',to_actual_period) as TimeOut,
'days_columnMTWThFSSu' as days,
DATE_FORMAT(date_effective, '%Y-%m-%d') AS DateEffective,
case DATE_FORMAT(date_dismissal, '%Y-%m-%d')
when '9999-12-31' then 'Not Set'
else DATE_FORMAT(date_dismissal, '%Y-%m-%d')
end AS DateDismissal
from
dutydetails where AID=" + AID);
foreach (DataRow e in dt.Rows)
{
e.SetField("days", GetDays(int.Parse(e["did"].ToString())).ToString());
}
return(dt);
}
public static void AddAssignment(int rid, int[] gid)
{
DataRow df = SQLTools.ExecuteQuery($@"select * from request where rid='{rid}'").Rows[0];
// First check if rid is type assignment.
if (df["requesttype"].ToString() == Enumeration.RequestType.Assignment.ToString())
{
// FUNCTION BODY
DataRow dtl = SQLTools.ExecuteQuery($@"
select * from request
left join request_assign on request_assign.RID = request.RID
left join sduty_assignment on sduty_assignment.RAID=request_assign.RAID where request_assign.rid={rid};
").Rows[0];
// Get RID of guard.
String raid = dtl["RAID"].ToString();
foreach (int g in gid)
{
DateTime consta = DateTime.Parse(dtl["contractstart"].ToString());
DateTime conend = DateTime.Parse(dtl["contractend"].ToString());
// Add assignment in assignment table
String q = $@"INSERT INTO `msadb`.`sduty_assignment` (`GID`, `RAID`, `AStatus`, `AssignedOn`, `cid`) VALUES ('{g}', '{raid}', '{Enumeration.Schedule.Pending}',
'{consta.ToString("yyyy-MM-dd")}', '{df["cid"].ToString()}');";
SQLTools.ExecuteNonQuery(q);
// SQLTools.ExecuteNonQuery(eventddl_cs); // contract start trigger
// SQLTools.ExecuteNonQuery(eventddl_ce); // contract end trigger
}
UpdateRequestStatus(rid, Enumeration.RequestStatus.Active, Login.LoggedInUser);
Data.InitGuardStatusAndDutyAssignments();
}
else
{
MessageBox.Show("Request is not an assignment.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
SQLTools.ExecuteQuery("call init_status_clientstatus()");
SQLTools.ExecuteNonQuery("call msadb.init_checkdate_assignmentstatus();");
}
public static bool Authenticate(string uname, string pword)
{
int uid;
try {
String q = @"select * from account where uname='" + uname + "'";
DataTable dt = SQLTools.ExecuteQuery_(q);
//Console.WriteLine(Crypt.HashPassword("clerk"));
string db_hash = dt.Rows[0]["hash"].ToString();
if (Crypt.Verify(pword, db_hash))
{
UserName = dt.Rows[0]["uname"].ToString();
AccountType = int.Parse(dt.Rows[0]["type"].ToString());
uid = int.Parse(dt.Rows[0]["accid"].ToString());
LoggedInUser = uid;
SQLTools.conn.Close();
SQLTools.ExecuteNonQuery($@"
INSERT INTO `msadb`.`loginhistory`
(`uid`, `session_start`)
VALUES ('{uid}', '{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}');
");
SessionId = SQLTools.GetInt("select last_insert_id()");
SQLTools.ExecuteNonQuery($@"SET @cuser={SessionId};");
SQLTools.ExecuteNonQuery($@"call init_checkdate_all");
return(true);
}
else
{
return(false);
}
}
catch (Exception) {
SQLTools.conn.Close();
return(false);
}
}
public static void DeleteBasicPay(int BasicPayId)
{
SQLTools.ExecuteNonQuery($@"delete FROM msadb.basicpay where bpid={BasicPayId};");
}
public static void DeleteContrib(int contrib_id)
{
SQLTools.ExecuteNonQuery($@"DELETE FROM contribdetails where contrib_id={contrib_id}");
}
/// <summary>
/// Use only for pending dates.
/// </summary>
public static void DeleteRate(int rates_id)
{
string deletequery = $@"delete FROM msadb.rates where rid = {rates_id};";
SQLTools.ExecuteNonQuery(deletequery);
}
public static void RemoveHoliday(int hid)
{
SQLTools.ExecuteNonQuery($@"call msadb.proc_holiday_remove({hid});");
}
public static void AddGuardsDependent(int Gid, int Rel, string First, string Middle, string Last)
{
SQLTools.ExecuteNonQuery("INSERT INTO Dependents(DRelationship, GID, FN, MN, LN) VALUES ('" + Rel + "','" + Gid + "','" + First + "','" + Middle + "','" + Last + "')");
}
public static void AddGuardBasicInfo(string FirstNameBX, string MiddleNameBX, string LastNameBX, DateTime BirthdateBX, int gender, string HeightBX, string WeightBX, string ReligionBX, int CVStatusBX, string CellNoBX, string TellNoBX, string LicenseNoBX, string SSSNoBX, string TINNoBX, string PhilHealthBX, string PrevAgencyBX, string PrevAssBX, int EdAttBX, string CourseBX, string MilTrainBX, string EmergBX, string EmergencyNoBX, int gtype)
{
SQLTools.ExecuteNonQuery(@"INSERT INTO Guards(FN, MN, LN, GStatus, BDate, Gender, Height, Weight, Religion, CivilStatus, CellNo, TelNo, LicenseNo, SSS, TIN, PhilHealth, PrevAgency, PrevAss, EdAtt, Course, MilitaryTrainings, EmergencyContact, EmergencyNo, gtype) VALUES ('" + FirstNameBX + "','" + MiddleNameBX + "','" + LastNameBX + "','" + Enumeration.GuardStatus.Inactive + "','" + BirthdateBX.Month + "/" + BirthdateBX.Day + "/" + BirthdateBX.Year + "','" + gender + "','" + HeightBX + "','" + WeightBX + "','" + ReligionBX + "','" + CVStatusBX + "','" + CellNoBX + "','" + TellNoBX + "','" + LicenseNoBX + "','" + SSSNoBX + "','" + TINNoBX + "','" + PhilHealthBX + "','" + PrevAgencyBX + "','" + PrevAssBX + "','" + EdAttBX + "','" + CourseBX + "','" + MilTrainBX + "','" + EmergBX + "','" + EmergencyNoBX + $"', '{gtype}')");
}
public static void RemoveDependent(int DependentId)
{
var _ = $@"delete from dependents where deid={DependentId}";
SQLTools.ExecuteNonQuery(_);
}
public static void UpdateGuardType(int gid, int gtype)
{
SQLTools.ExecuteNonQuery($@"UPDATE `msadb`.`guards` SET `gtype`='{gtype}' WHERE `GID`='{gid}';");
}
public static void UpdateGuardBasicInfo(int Gid, string FirstNameBX, string MiddleNameBX, string LastNameBX, DateTime BirthdateBX, int gender, string HeightBX, string WeightBX, string ReligionBX, int CVStatusBX, string CellNoBX, string TellNoBX, string LicenseNoBX, string SSSNoBX, string TINNoBX, string PhilHealthBX, string PrevAgencyBX, string PrevAssBX, int EdAttBX, string CourseBX, string MilTrainBX, string EmergBX, string EmergencyNoBX)
{
SQLTools.ExecuteNonQuery("UPDATE Guards SET FN = '" + FirstNameBX + "', MN = '" + MiddleNameBX + "', LN = '" + LastNameBX + "', BDate = '" + BirthdateBX.Month + "/" + BirthdateBX.Day + "/" + BirthdateBX.Year + "', Gender = '" + gender + "', Height = '" + HeightBX + "', Weight = '" + WeightBX + "', Religion = '" + ReligionBX + "', CivilStatus = '" + CVStatusBX + "', CellNo = '" + CellNoBX + "', TelNo = '" + TellNoBX + "', LicenseNo = '" + LicenseNoBX + "', SSS = '" + SSSNoBX + "', TIN = '" + TINNoBX + "', PhilHealth = '" + PhilHealthBX + "', PrevAgency = '" + PrevAgencyBX + "', PrevAss = '" + PrevAssBX + "', EdAtt = '" + EdAttBX + "', Course = '" + CourseBX + "', MilitaryTrainings = '" + MilTrainBX + "', EmergencyContact = '" + EmergBX + "', EmergencyNo = '" + EmergencyNoBX + "' WHERE GID=" + Gid);
}