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