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