public static string InsertEmployeeQuery(Employee employee)
{
string query = @"INSERT INTO [dbo].[TPT_Trucking_Employee_Tbl]
([Code]
,[FirstName]
,[MiddleName]
,[LastName]
,[NRIC]
,[Nationality]
,[Driving_Licence_No]
,[Driving_Class]
,[Licence_Expiry_Date]
,[Is_Available]
,[Employ_Status]
,[Phone_No]
,[Mobile_No]
,[Email]
,[Address]
,[Address2]
,[Address3]
,[Address4]
,[City]
,[SSS_ID]
,[TAX_ID]
,[Philhealth_ID]
,[Role])
VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}',
'{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}')";
query = string.Format(query, CommonUtilities.FormatString(employee.Code)
, CommonUtilities.FormatString(employee.FirstName)
, CommonUtilities.FormatString(employee.MiddleName)
, CommonUtilities.FormatString(employee.LastName)
, CommonUtilities.FormatString(employee.Nirc)
, CommonUtilities.FormatString(employee.Nationality)
, CommonUtilities.FormatString(employee.DrivingLicence)
, CommonUtilities.FormatString(employee.DrivingClass)
, CommonUtilities.ConvertDateForSQLPurpose(employee.LicenceExpiryDate)
, employee.IsAvailable ? "T" : "F"
, employee.EmployeeStatus == Employee_Status.Available ? "A" : "R"
, CommonUtilities.FormatString(employee.Phone_no)
, CommonUtilities.FormatString(employee.Mobile_no)
, CommonUtilities.FormatString(employee.Email_add)
, CommonUtilities.FormatString(employee.Address1)
, CommonUtilities.FormatString(employee.Address2)
, CommonUtilities.FormatString(employee.Address3)
, CommonUtilities.FormatString(employee.Address4)
, CommonUtilities.FormatString(employee.City)
, CommonUtilities.FormatString(employee.SSS_ID)
, CommonUtilities.FormatString(employee.Tax_ID)
, CommonUtilities.FormatString(employee.Philhealth_ID)
, employee.Role.GetHashCode());
return(query);
}
