protected void sendEmail(object sender, EventArgs e) { var conn = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; var Cdal = new ContactDAL(conn); foreach (GridViewRow row in GridViewProduct.Rows) { CheckBox chkSelect = (CheckBox)(row.Cells[0].FindControl("SelectCheckBox")); if (chkSelect.Checked) { string hiddenFieldValue = (row.Cells[0].FindControl("comId") as HiddenField).Value; var orderId = (row.Cells[0].FindControl("OrderID") as Label).Text; var producTCode = (row.Cells[0].FindControl("SupplierItemCode") as Label).Text; var AccountOwner = (row.Cells[0].FindControl("AccountOwner") as Label).Text; var contactName = (row.Cells[0].FindControl("contactName") as Label).Text; var conectID = Cdal.getContactByCompanyBasedOnLastOrder(Convert.ToInt32(hiddenFieldValue)); var conEmail = Cdal.GetContactByContactId(Convert.ToInt32(conectID)); contactName = conEmail.FirstName; if (!string.IsNullOrEmpty(conEmail.Email)) { SendMEmail(conEmail.Email, contactName, AccountOwner, hiddenFieldValue, orderId); } } } messagelable.Text = "Successfully sent"; }
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); } } } } }