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