private static void SendEmailToSupplier(RMAResult filesAndSupp)
{
string cs = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
var subject = "RMA Request from Deltone Solutions ";
String bottomBanner = "<img src=\"cid:bottombanner\" height='105' width='550'>";
var bodytitle = "Hi , <br/> Please fill RMA for all attached orders and send back to Deltone Solutions.";
var creditEmailHandler = new CreditNoteRMAHandler(cs);
var typeEmail = 2; //RMA Request Email
// var suppEmails = new OrderSendEmailDAL(cs).GetSupplierEmails(suppName, typeEmail);
var body = CreateEmailTemplateForSupplier(bottomBanner, bodytitle);
var filePath = "C:\\inetpub\\wwwroot\\DeltoneCRM\\Uploads\\RMA\\";
var from = "*****@*****.**";
var fromName = "Deltonesolutions";
var sendEmail = new EmailSender();
if (filesAndSupp.FilesAndSuppNames != null)
{
foreach (var item in filesAndSupp.FilesAndSuppNames)
{
var suppEmails = new OrderSendEmailDAL(cs).GetSupplierEmails(item.Key, typeEmail);
var fileName = item.Value + ".csv";
foreach (var sEmail in suppEmails)
{
var fileAtta = new System.Collections.Generic.List <Attachment>();
var fileFullPAth = filePath + fileName;
if (File.Exists(fileFullPAth))
{
System.Net.Mail.Attachment attachment = new System.Net.Mail.Attachment(fileFullPAth);
attachment.Name = Path.GetFileName(fileFullPAth);
fileAtta.Add(attachment);
}
sendEmail.SendEmailAlternativeView(from, fromName, sEmail.SupplierEmailAddress,
"*****@*****.**", "", subject, body, true, fileAtta);
}
}
}
if (filesAndSupp.RMAIDS != null)
{
if (filesAndSupp.RMAIDS.Count() > 0)
{
foreach (var id in filesAndSupp.RMAIDS)
{
UpdateRMACreditXeroInfo(id);
}
}
}
}
private static RMAResult CreateCSVAndEmail(List <SuppNameDetail> objlist)
{
String StringBuilder = String.Empty;
var fileNames = new Dictionary <string, string>();
var rmaObjResult = new RMAResult();
rmaObjResult.FilesAndSuppNames = new Dictionary <string, string>();
rmaObjResult.RMAIDS = new List <int>();
var gropList = objlist.GroupBy(p => p.SuppName).ToList();
string nameFile = "";
// var filDirctory = System.Web.HttpContext.Current.Server.MapPath("~/Uploads/RMA/");
var filePath = "C:\\inetpub\\wwwroot\\DeltoneCRM\\Uploads\\RMA\\";
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
foreach (var grItem in gropList)
{
var keyGroupSuppName = grItem.Key;
nameFile = "RMARequest_Deltone_" + keyGroupSuppName + "_" + DateTime.Now.Ticks;
rmaObjResult.FilesAndSuppNames.Add(keyGroupSuppName, nameFile);
StreamWriter SW = File.CreateText(filePath + nameFile + ".csv");
SW.Write("Company Name,Order No,Credit No,Reason\r\n");
foreach (var item in grItem)
{
StringBuilder = String.Empty;
StringBuilder = item.CompanyName + "," + item.XeroInvoiceNumber + "," + item.XeroCreditNoteID + "," + item.Reason;
rmaObjResult.RMAIDS.Add(item.RMAID);
// int Length = StringBuilder.Length;
//StringBuilder = StringBuilder.Substring(0, (Length - 1));
StringBuilder = StringBuilder + "\r\n";
SW.Write(StringBuilder);
}
SW.Close();
}
return(rmaObjResult);
}
