public void UpdateWholesalerQueriesSheet(WholesalersRequestModel request, List <StateTaxRegistrationInternal> internals, string feinfileurl) { SheetsService sheetsService = new SheetsService(new BaseClientService.Initializer { HttpClientInitializer = credential, ApplicationName = "Google-SheetsSample/0.1", }); var range = string.Empty; range = @"WholesalerEnquiriesOne!A:CZ"; var valueRange = new ValueRange(); var oblist = new List <object>(); oblist.Add(DateTime.Now.ToShortDateString()); oblist.Add(String.IsNullOrEmpty(request.BusinessName) ? "": request.BusinessName); oblist.Add(String.IsNullOrEmpty(request.ContactName) ? "": request.ContactName); oblist.Add(String.IsNullOrEmpty(request.AddressLine1) ? "": request.AddressLine1); oblist.Add(String.IsNullOrEmpty(request.AddressLine2) ? "": request.AddressLine2); oblist.Add(String.IsNullOrEmpty(request.City) ? "": request.City); oblist.Add(String.IsNullOrEmpty(request.State) ? "": request.State); oblist.Add(String.IsNullOrEmpty(request.ZipCode) ? "": request.ZipCode); oblist.Add(String.IsNullOrEmpty(request.BusinessPhoneNumber) ? "": request.BusinessPhoneNumber); oblist.Add(String.IsNullOrEmpty(request.EmailAddress) ? "": request.EmailAddress); oblist.Add(String.IsNullOrEmpty(request.ContactName) ? "": request.ContactName); oblist.Add(String.IsNullOrEmpty(request.Subject) ? "": request.Subject); oblist.Add(String.IsNullOrEmpty(request.Message) ? "": request.Message); oblist.Add(String.IsNullOrEmpty(request.FederalBusinessTaxId) ? "": request.FederalBusinessTaxId); oblist.Add(String.IsNullOrEmpty(feinfileurl) ? "": feinfileurl); foreach (var item in internals) { oblist.Add(String.IsNullOrEmpty(item.StateSalesTaxId) ? "": item.StateSalesTaxId); oblist.Add(String.IsNullOrEmpty(item.StateSelected) ? "": item.StateSelected); oblist.Add(String.IsNullOrEmpty(item.UploadedUrl) ? "": item.UploadedUrl); } valueRange.Values = new List <IList <object> > { oblist }; Google.Apis.Sheets.v4.Data.ValueRange requestBody = new Google.Apis.Sheets.v4.Data.ValueRange(); var appendRequest = sheetsService.Spreadsheets.Values.Append(valueRange, _registrationsheetid, range); appendRequest.ValueInputOption = SpreadsheetsResource.ValuesResource.AppendRequest.ValueInputOptionEnum.USERENTERED; // To execute asynchronously in an async method, replace `request.Execute()` as shown: Google.Apis.Sheets.v4.Data.AppendValuesResponse response = appendRequest.Execute(); }
private string ApplyEmailTemplate(string filename, WholesalersRequestModel model, List <StateTaxRegistrationInternal> internalregs) { /* * <p>Wholesaler Enquiry Request Received</p> * <p>Business Name: <NONE-BIZ-NAME></p> * <p>Contact Name: <NONE-NAME></p> * <p>EMAIL ADDRESS: <NONE-EMAIL-ADDRESS></p> * <p>CONTACT PHONE NUMBER: <NONE-PHONE-NUMBER></p> * <p>DATE Received:<NONE-DATE></p> * <p>ZIP CODE OF THE WHOLESALER:<NONE-ZIP-CODE></p> * <p>FEIN THE WHOLESALER:<NONE-FEIN></p> * <NONE-SALESTAX-DETAIL> * <p>SUBJECT:<NONE-SUBJECT></p> * <p>MESSAGE<NONE-MESSAGE></p> */ string retval = string.Empty; retval = System.IO.File.ReadAllText(filename); //retval = System.IO.File.ReadAllText(@"D:\home\site\wwwroot\" + filename); retval = retval.Replace("NONE-BIZ-NAME", model.BusinessName); retval = retval.Replace("NONE-NAME", model.ContactName); retval = retval.Replace("NONE-EMAIL-ADDRESS", model.EmailAddress); retval = retval.Replace("NONE-SUBJECT", model.Subject); retval = retval.Replace("NONE-DATE", DateTime.Now.ToShortDateString()); retval = retval.Replace("NONE-PHONE-NUMBER", model.BusinessPhoneNumber); retval = retval.Replace("NONE-ZIP-CODE", model.ZipCode); retval = retval.Replace("NONE-FEIN", model.FederalBusinessTaxId); retval = retval.Replace("NONE-MESSAGE", model.Message); string salesstring = string.Empty; foreach (StateTaxRegistrationInternal intregs in internalregs) { string templatestring = "<p>Sales Tax Id: NONE-SALES-TAX-ID, State: NONE-SALES-STATE, License: NONE-SALES-LICENSE-URL</p>"; templatestring = templatestring.Replace("NONE-SALES-TAX-ID", intregs.StateSalesTaxId); templatestring = templatestring.Replace("NONE-SALES-STATE", intregs.StateSelected); templatestring = templatestring.Replace("NONE-SALES-LICENSE-URL", intregs.UploadedUrl); salesstring += templatestring; } retval = retval.Replace("NONE-SALESTAX-DETAIL", salesstring); return(retval); }
public JsonResult CreateEntry([FromBody] WholesalersRequestModel data) { string retval = "ok"; DriveApiService service = new DriveApiService(); if (!ModelState.IsValid) { new JsonResult(new { result = "Bad Data" }); } List <StateTaxRegistrationInternal> internalregs = new List <StateTaxRegistrationInternal>(); // this.InternalFilename = // DateTime.Now.Ticks // + "-" // + fedtaxid // + "-" // + registration.StateSalesTaxId // + "-" // + registration.StateSelected // + "-" // + businessname // + "-" // + registration.FileName; string feinfilename = DateTime.Now.Ticks + "-" + data.FederalBusinessTaxId + "-" + data.BusinessName + "-" + data.FEINFileName; string feinfileurl = string.Empty; using (MemoryStream ms = ImageHelpers.ConvertFromBase64(data.FEINImageString)) { feinfileurl = service.UploadWholesalerDocument(ms, feinfilename); } foreach (StateTaxRegistration reg in data.StateRegistrations) { StateTaxRegistrationInternal internalreg = new StateTaxRegistrationInternal(reg, data.FederalBusinessTaxId, data.BusinessName); internalregs.Add(internalreg); } foreach (StateTaxRegistrationInternal inregs in internalregs) { inregs.UploadedUrl = service.UploadWholesalerDocument(inregs.InternalMemStream, inregs.InternalFilename); } service.UpdateWholesalerQueriesSheet(data, internalregs, feinfileurl); //"*****@*****.**" string OwnerContactEmailBodyString = GetOwnerContactEmailBodyString(data, internalregs); string CustomerContactEmailBodyString = GetCustomerContactEmailBodyString(data); List <string> owneremails = new List <string>(); owneremails.Add("*****@*****.**"); List <string> receipientemails = new List <string>(); receipientemails.Add(data.EmailAddress); List <AttachmentItem> attachments = PackageImages(internalregs); service.SendEmail(OwnerContactEmailBodyString, "Wholesaler Enquiry Received", owneremails, attachments); service.SendEmail(CustomerContactEmailBodyString, "Wholesaler Enquiry Received", receipientemails, new List <AttachmentItem>()); return(new JsonResult(new { result = retval })); }
private string GetOwnerContactEmailBodyString(WholesalersRequestModel model, List <StateTaxRegistrationInternal> intregs) { string result = ApplyEmailTemplate("OwnerWholesalerRequestTemplate.htm", model, intregs); return(result); }
private string GetCustomerContactEmailBodyString(WholesalersRequestModel model) { string result = ApplyEmailTemplate("WholesalerRequestTemplate.htm", model, new List <StateTaxRegistrationInternal>()); return(result); }