private static void UpdateRMACreditXeroInfo(int rmaId) { String strConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; var creditEmailHandler = new CreditNoteRMAHandler(strConnectionString); creditEmailHandler.UpdateRMISentToSupplierByRAMID(rmaId); }
private void sentRMATOCustomer(string RmaId) { var ramIdC = Convert.ToInt32(RmaId); var rmaTrack = GetCreditNoteIdFromRAMTracking(ramIdC); String strConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; ContactDAL cdal = new ContactDAL(strConnectionString); var orderDal = new OrderDAL(strConnectionString); var creditNoteDal = new CreditNotesDAL(strConnectionString); var ordersendEmail = new OrderSendEmailDAL(strConnectionString); var creditNoteObj = creditNoteDal.getCreditNoteObj(rmaTrack.CreditNoteID); var creditEmailHandler = new CreditNoteRMAHandler(strConnectionString); if (creditNoteObj.IsAvail) { if (creditNoteObj.Reason == "CHANGED PRINTER") { var contactId = Convert.ToInt32(creditNoteObj.ContactId); var contact = cdal.GetContactByContactId(contactId); if (!string.IsNullOrEmpty(creditNoteObj.Reason)) { var orderID = Convert.ToInt32(creditNoteObj.OrderId); var xeroOrderDTSnumber = orderDal.getXeroDTSID(orderID); var subject = "RMA Request for " + creditNoteObj.Reason; var body = "Hi , <br/> RMA Request for this order number :" + xeroOrderDTSnumber; if (!string.IsNullOrEmpty(rmaTrack.SupplierRMANumber)) { body = body + "<br/> Supplier RMA number " + rmaTrack.SupplierRMANumber; } if (!string.IsNullOrEmpty(rmaTrack.TrackingNumber)) { body = body + " <br/> TrackingNumber " + rmaTrack.TrackingNumber; } var toEmail = contact.Email; var from = "*****@*****.**"; var fromName = "Deltonesolutions"; var res = creditEmailHandler.SendCreditNoteEmail(rmaTrack.CreditNoteID, "", "", from, fromName, toEmail, "", "", subject, body, true, null); if (res) { creditEmailHandler.UpdateRMISentToCustomer(rmaTrack.CreditNoteID); } } } } }
private string SetCreditNotesHistory(int rmaId, string recentNotes) { var comNotes = HttpContext.Current.Session["LoggedUser"] + "--<b><font color=\"red\">" + DateTime.Now.ToString("dd/MM/yyyy HH:mm") + "</font></b>--" + recentNotes; var CONNSTRING = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; var prevoiusNote = new CreditNoteRMAHandler(CONNSTRING).GetRMANotesById(rmaId); var combinecomNotes = comNotes + "<br/><br/>" + prevoiusNote; return(combinecomNotes); }
private void SetFaultyElemants(string creditId, string suppName) { string cs = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; var rma = new CreditNoteRMAFaultyGoods(); rma.CreditNoteId = creditId; rma.SupplierName = suppName; rma = new CreditNoteRMAHandler(cs).GetRMAFaultyGoods(rma); batchnumberfaulty.Value = rma.BatchNumber; modelnumberfaulty.Value = rma.ModelNumber; errormessagefaulty.Value = rma.ErrorMessage; faultyNotes.Value = rma.FaultyNotes; }
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); } } } }
protected void Page_Load(object sender, EventArgs e) { //Xero Model Create Contact Unit Test XeroIntergration xero = new XeroIntergration(); //Create Contact //Repository repos = xero.CreateRepository(); // XeroApi.Model.Contact DeltoneContact ; // XeroApi.Model.Item item; //DeltoneContact = xero.CreateContact(repos, "DeltoneTestCompan_5", "Shehan", "Peris", "4", "61", "2434684", String.Empty, String.Empty, String.Empty, "4", "61", "123456", "*****@*****.**", "12 Kauri Grove", "Spingwale", "Australia", "3150", "VIC", "26 Tamarisk Avenue", "Glen waverley", "Australia", "3150", "VIC"); //Response.Write(DeltoneContact.ContactID);//Fetch the Contact ID Created in Xero System .store it in the Dletone Contact Table //Fetch the Contact by Guid //DeltoneContact = xero.findContact(repos, "7B08CAB7-7157-4EFC-954C-59B3FC43F7C5"); //Response.Write(DeltoneContact.FirstName); //Deltone Test Create Item //xero.CreateItem(repos, "DeltoneItem", "DeltoneTestDescription", (Decimal)salesUnitPrice, (Decimal)purchaseunitPrice); //Deltone Update Item //Update an Invoice String strGuid = "adsfhajhsdfkjhajdshf"; //xero.UpdtateInvoice(repos, strGuid); //XeroIntergration xero = new XeroIntergration(); //Repository repos = xero.CreateRepository(); String Guid = "4dc4e979-11e5-4994-a6a9-912c102d3a13";// Expected value //String companyname = "REGIONAL SERVICES AUSTRALIA PTY LTD"; String companyname = "AUSJET"; // string ActualValue = xero.findContactByName(repos, companyname); //Actual Value QuoteDAL quote = new QuoteDAL(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString); // var sss = quote.GetAllQuotesByCompany(176); //360 // var testName = "Janine O'Connell"; // var ttt= testName.Insert(8, "\\"); var tttt = new CallNDataHandler(); // tttt.TestFileDownload(); var mmm = new RepDayOffDAL(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString); var obj = new StatsTargetConfig() { IsReached = false, TargetAmount = 7000, TargetDay = DateTime.Now.AddDays(2), TargetTitle = "Lunch Target" }; // mmm.InsertIntoTargetConfig(obj, 1); // var result = mmm.GetAllTargetItems(); //mmm.DeleteTargetConfig(2); // mmm.UpdateTargetConfig(5, true); var ddd = new CreditNoteRMAHandler(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString); // var nnn= ddd.GetRMANotesById(100); // SendMail(); SendCreditCardNotificationEmail(0); }
private static void UpdateRMANUmber(DeltoneCRM_DAL.CreditNoteRMAHandler.RMAUpdate obj) { var CONNSTRING = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; SqlConnection conn = new SqlConnection(); conn.ConnectionString = CONNSTRING; if (new CreditNoteRMAHandler(CONNSTRING).GetRMAByCreditNoteIdAndSuppName(Convert.ToInt32(obj.CreId), obj.SuppName) == 0) { new CreditNotesDAL(CONNSTRING).WriteSupplierIntoRMA(obj.CreId, obj.SuppName); } var rmaId = new CreditNoteRMAHandler(CONNSTRING).GetRMAByCreditNoteIdAndSuppName(Convert.ToInt32(obj.CreId), obj.SuppName); var RMAID = rmaId.ToString(); String SqlStmt = @"UPDATE dbo.RMATracking SET SentToSupplier=@SentToSupplier, SentToSupplierDateTime=@SentToSupplierDateTime, ApprovedRMA=@ApprovedRMA, ApprovedRMADateTime=@ApprovedRMADateTime, CreditInXero=@CreditInXero, CreditInXeroDateTime=@CreditInXeroDateTime, RMAToCustomer=@RMAToCustomer, RMAToCustomerDateTime=@RMAToCustomerDateTime, AdjustedNoteFromSupplier=@AdjustedNoteFromSupplier, AdjustedNoteFromSupplierDateTime=@AdjustedNoteFromSupplierDateTime, Status=@Status, SupplierRMANumber=@SupplierRMANumber, TrackingNumber=@TrackingNumber , InHouse=@inHouse WHERE CreditNoteID =@crId AND SupplierName=@suppName"; SqlCommand cmd = new SqlCommand(SqlStmt, conn); cmd.Parameters.Add("@suppName", SqlDbType.NVarChar).Value = obj.SuppName; cmd.Parameters.Add("@crId", SqlDbType.Int).Value = obj.CreId; String STS = obj.STS; String STSWrite = String.Empty; //DateTime STSDateTime = new DateTime(); if (STS == "True") { STSWrite = "1"; } else { STSWrite = "0"; } String inHouse = obj.INHouse; String inHouseWrite = String.Empty; //DateTime STSDateTime = new DateTime(); if (inHouse == "True") { inHouseWrite = "1"; } else { inHouseWrite = "0"; } cmd.Parameters.AddWithValue("@inHouse", inHouseWrite); String ARMA = obj.ARMA; String ARMAWrite = String.Empty; if (ARMA == "True") { ARMAWrite = "1"; } else { ARMAWrite = "0"; } String CIX = obj.CIX; String CIXWrite = String.Empty; if (CIX == "True") { CIXWrite = "1"; } else { CIXWrite = "0"; } String RTC = obj.RTC; String RTCWrite = String.Empty; if (RTC == "True") { RTCWrite = "1"; } else { RTCWrite = "0"; } String ANFS = obj.ANFS; String ANFSWrite = String.Empty; if (ANFS == "True") { ANFSWrite = "1"; } else { ANFSWrite = "0"; } String NewStatus = String.Empty; //if (STS == "True" && ARMA == "True" && CIX == "True" && RTC == "True" && ANFS == "True") //{ // NewStatus = "COMPLETED"; //} //else //{ //} NewStatus = new CreditNotesDAL(CONNSTRING).RMAStatusByCreditIdAndSuppllier(obj.CreId, obj.SuppName); if (inHouse == "True") { NewStatus = "COMPLETED"; } else if (CIX == "True") { NewStatus = "COMPLETED"; } cmd.Parameters.AddWithValue("@SentToSupplier", STSWrite); if (STS == "True") { if (checkIfSTSHasValue(RMAID) == "") { cmd.Parameters.AddWithValue("@SentToSupplierDateTime", DateTime.Today); } else { cmd.Parameters.AddWithValue("@SentToSupplierDateTime", DateTime.Parse(checkIfSTSHasValue(RMAID))); } } else { cmd.Parameters.AddWithValue("@SentToSupplierDateTime", DBNull.Value); } cmd.Parameters.AddWithValue("@ApprovedRMA", ARMAWrite); if (ARMA == "True") { if (checkIfARMAHasValue(RMAID) == "") { cmd.Parameters.AddWithValue("@ApprovedRMADateTime", DateTime.Today); // sentRMATOCustomer(RMAID); // sent email to customer once RMA Approved } else { cmd.Parameters.AddWithValue("@ApprovedRMADateTime", DateTime.Parse(checkIfARMAHasValue(RMAID))); } } else { cmd.Parameters.AddWithValue("@ApprovedRMADateTime", DBNull.Value); } cmd.Parameters.AddWithValue("@CreditInXero", CIXWrite); if (CIX == "True") { if (checkIfCIXHasValue(RMAID) == "") { cmd.Parameters.AddWithValue("@CreditInXeroDateTime", DateTime.Today); } else { cmd.Parameters.AddWithValue("@CreditInXeroDateTime", DateTime.Parse(checkIfCIXHasValue(RMAID))); } } else { cmd.Parameters.AddWithValue("@CreditInXeroDateTime", DBNull.Value); } cmd.Parameters.AddWithValue("@RMAToCustomer", RTCWrite); if (RTC == "True") { if (checkIfRTCHasValue(RMAID) == "") { cmd.Parameters.AddWithValue("@RMAToCustomerDateTime", DateTime.Today); } else { cmd.Parameters.AddWithValue("@RMAToCustomerDateTime", DateTime.Parse(checkIfRTCHasValue(RMAID))); } } else { cmd.Parameters.AddWithValue("@RMAToCustomerDateTime", DBNull.Value); } cmd.Parameters.AddWithValue("@AdjustedNoteFromSupplier", ANFSWrite); if (ANFS == "True") { if (checkIfANFSHasValue(RMAID) == "") { cmd.Parameters.AddWithValue("@AdjustedNoteFromSupplierDateTime", DateTime.Today); } else { cmd.Parameters.AddWithValue("@AdjustedNoteFromSupplierDateTime", DateTime.Parse(checkIfANFSHasValue(RMAID))); } } else { cmd.Parameters.AddWithValue("@AdjustedNoteFromSupplierDateTime", DBNull.Value); } cmd.Parameters.AddWithValue("@Status", NewStatus); cmd.Parameters.AddWithValue("@SupplierRMANumber", obj.SRMAN); cmd.Parameters.AddWithValue("@TrackingNumber", obj.TN); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }