public bool Update(string id, Model.Fleet payload)
{
MySqlCommand mySqlCmd = null;
MySqlDataReader reader = null;
try
{
DateTime roadTaxExpiryDate = DateTime.Parse(payload.roadTaxExpiry);
DateTime serviceDueDateDate = DateTime.Parse(payload.serviceDueDate);
// add to job order status
Dictionary <string, string> updateParam = new Dictionary <string, string>();
updateParam.Add("registration_number", payload.registrationNumber);
updateParam.Add("fleet_types_id", payload.fleetTypeId);
updateParam.Add("road_tax_expired", roadTaxExpiryDate.ToString("yyyy-MM-dd HH:mm:ss"));
updateParam.Add("service_due_date", serviceDueDateDate.ToString("yyyy-MM-dd HH:mm:ss"));
updateParam.Add("service_due_mileage", payload.serviceDueMileage.ToString());
updateParam.Add("company_id", payload.companyId);
updateParam.Add("remarks", payload.remarks);
Dictionary <string, string> updateDesc = new Dictionary <string, string>();
updateDesc.Add("id", id);
mySqlCmd = GenerateEditCmd(TABLE_FLEETS, updateParam, updateDesc);
return(0 != PerformSqlNonQuery(mySqlCmd));
}
catch (Exception e)
{
DBLogger.GetInstance().Log(DBLogger.ESeverity.Info, e.Message);
DBLogger.GetInstance().Log(DBLogger.ESeverity.Info, e.StackTrace);
}
finally
{
CleanUp(reader, mySqlCmd);
}
return(false);
}
public string Add(Model.Fleet payload)
{
MySqlCommand mySqlCmd = null;
MySqlDataReader reader = null;
try
{
DateTime dateService = DateTime.Parse(payload.serviceDueDate);
DateTime dateRoadTax = DateTime.Parse(payload.roadTaxExpiry);
// add to job order status
Dictionary <string, string> insertParam = new Dictionary <string, string>();
insertParam.Add("registration_number", payload.registrationNumber);
insertParam.Add("fleet_types_id", payload.fleetTypeId);
insertParam.Add("road_tax_expired", dateRoadTax.ToString("yyyy-MM-dd HH:mm:ss"));
insertParam.Add("service_due_date", dateService.ToString("yyyy-MM-dd HH:mm:ss"));
insertParam.Add("service_due_mileage", payload.serviceDueMileage.ToString());
insertParam.Add("company_id", payload.companyId);
insertParam.Add("remarks", payload.remarks);
mySqlCmd = GenerateAddCmd(TABLE_FLEETS, insertParam);
PerformSqlNonQuery(mySqlCmd);
return(mySqlCmd.LastInsertedId.ToString());
}
catch (Exception e)
{
DBLogger.GetInstance().Log(DBLogger.ESeverity.Info, e.Message);
DBLogger.GetInstance().Log(DBLogger.ESeverity.Info, e.StackTrace);
}
finally
{
CleanUp(reader, mySqlCmd);
}
return(null);
}
public static void SendOrderConfirmed(string jobUniqueId, Model.User user,
Model.JobDetails jobDetails, Model.User driver, Model.Fleet fleet, Model.JobType jobType, Model.FleetType fleetType)
{
Task.Run(async() =>
{
String apiKey = ConfigurationManager.AppSettings.Get("SendGridApiKey");
dynamic sg = new SendGrid.SendGridAPIClient(apiKey);
Email from = new Email("*****@*****.**");
String subject = ConfigurationManager.AppSettings.Get("ConfirmSubject") + string.Format("(Order ID: {0})", jobUniqueId);
Email to = new Email(user.email);
Content content = new Content("text/html", subject);
Mail mail = new Mail(from, subject, to, content);
mail.TemplateId = ConfigurationManager.AppSettings.Get("ConfirmTemplateId");
mail.Personalization[0].AddSubstitution("{{orderId}}", jobUniqueId);
mail.Personalization[0].AddSubstitution("{{date}}", jobDetails.deliveryDate);
mail.Personalization[0].AddSubstitution("{{jobType}}", jobType.name);
mail.Personalization[0].AddSubstitution("{{fleetType}}", fleetType.name);
mail.Personalization[0].AddSubstitution("{{amount}}", jobDetails.amount.ToString());
mail.Personalization[0].AddSubstitution("{{driver}}", driver.displayName);
mail.Personalization[0].AddSubstitution("{{driverContact}}", driver.contactNumber);
mail.Personalization[0].AddSubstitution("{{driverIdentification}}", driver.identityCard);
mail.Personalization[0].AddSubstitution("{{fleetRegistration}}", fleet.registrationNumber);
var addressFrom = jobDetails.addressFrom[0];
mail.Personalization[0].AddSubstitution("{{from}}", addressFrom.address1 + ", " + addressFrom.address2 + ", " + addressFrom.address3);
try
{
var addressTo = jobDetails.addressTo[0];
if (addressTo != null)
{
mail.Personalization[0].AddSubstitution("{{to}}", addressTo.address1 + ", " + addressTo.address2 + ", " + addressTo.address3);
}
}
catch (Exception)
{
mail.Personalization[0].AddSubstitution("{{to}}", "");
}
dynamic response = await sg.client.mail.send.post(requestBody: mail.Get());
});
}
