private string getRFQSummarybyBOMDetailID(long bomDetailID) { RFQSummaryHeader rfqSummaryHeader = rfqSummaryHeader_CRUD.readByBOMDetailID(bomDetailID); if (rfqSummaryHeader == null) { rfqSummaryHeader = new RFQSummaryHeader(); } List <RFQSummary> rfqSummaryDetail = rfqSummaryDetil_CRUD.readByBOMDetailID(bomDetailID); rfqSummaryHeader.RfqSummaryList = rfqSummaryDetail; RFQSummary rfqSelected = rfqSummaryDetail.Find(item => item.Status == "SELECTED" || item.Status == "AWARDED"); if (rfqSelected != null) { SupplierCRUD supplier_CRUD = new SupplierCRUD(); Supplier supplierRecommended = supplier_CRUD.readById(rfqSelected.SupplierKey); rfqSummaryHeader.RecommendedSupplier = supplierRecommended.SupplierName; } return(JsonConvert.SerializeObject(rfqSummaryHeader)); }
private string getSuppliers() { SupplierCRUD supplier_CRUD = new SupplierCRUD(); List <Supplier> listSuppliers = (List <Supplier>)supplier_CRUD.readAll(); return(JsonConvert.SerializeObject(listSuppliers)); }
public string createSupplier() { Supplier resultSupplier = new Supplier(); GatewayResponse response = new GatewayResponse(); String s; try { s = new StreamReader(Request.InputStream).ReadToEnd(); resultSupplier = JsonConvert.DeserializeObject <Supplier>(s); } catch (Exception ex) { response.ErrorThrown = true; response.ResponseDescription = "ERROR: When trying to parse JSON in server. " + ex.Message; return(JsonConvert.SerializeObject(response)); } SupplierCRUD supplierCRUD = new SupplierCRUD(); string idGenerated = supplierCRUD.createAndReturnIdGenerated(resultSupplier); if (supplierCRUD.ErrorOccur) { response.ErrorThrown = true; response.ResponseDescription = "ERROR: " + supplierCRUD.ErrorMessage; return(JsonConvert.SerializeObject(response)); } resultSupplier.Id = long.Parse(idGenerated); response.ErrorThrown = false; response.ResponseDescription = "Supplier created successfully."; response.Result = resultSupplier; return(JsonConvert.SerializeObject(response)); }
public string resendRFQ() { GatewayResponse response = new GatewayResponse(); String s; RFQ rfqToResend; try { s = new StreamReader(Request.InputStream).ReadToEnd(); rfqToResend = JsonConvert.DeserializeObject <RFQ>(s); } catch (Exception ex) { response.ErrorThrown = true; response.ResponseDescription = "ERROR: When trying to parse JSON in server. " + ex.Message; return(JsonConvert.SerializeObject(response)); } UserCRUD user_CRUD = new UserCRUD(); string strAuthUser = HttpContext.Current.User.Identity.Name; User user = user_CRUD.readById(strAuthUser); SupplierCRUD supplier_CRUD = new SupplierCRUD(); Supplier supplier = supplier_CRUD.readById(rfqToResend.SupplierId); if (supplier != null) { if (supplier.ContactEmail.Trim() != rfqToResend.LastEmail.Trim()) { supplier.ContactEmail = rfqToResend.LastEmail.Trim(); if (!supplier_CRUD.update(supplier)) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + supplier_CRUD.ErrorMessage; return(JsonConvert.SerializeObject(response)); } } } TokenCRUD token_CRUD = new TokenCRUD(); Token token = token_CRUD.readByRFQ(rfqToResend); ConnectionManager CM = new ConnectionManager(); Data_Base_MNG.SQL DM = CM.getDataManager(); /*Begin Transaction*/ DM.Open_Connection("RFQ Re-send"); rfqToResend.SentToVendor = DateTime.Now; if (!rfq_CRUD.update(rfqToResend, ref DM)) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + rfq_CRUD.ErrorMessage; return(JsonConvert.SerializeObject(response)); } if (token == null) { token = new Token(); token.Subject = "RFQ"; token.SubjectKey = rfqToResend.Id; token.TokenNumber = MD5HashGenerator.GenerateKey(DateTime.Now); token_CRUD.create(token, ref DM); if (token_CRUD.ErrorOccur) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + token_CRUD.ErrorMessage; return(JsonConvert.SerializeObject(response)); } } Email NewMail = new Email(); MailMessage Message = new MailMessage(); try { Message.From = new MailAddress("*****@*****.**", "*****@*****.**"); Message.To.Add(new MailAddress(supplier.ContactEmail.ToString())); Message.Subject = "Request For Quote"; Message.IsBodyHtml = true; Message.BodyEncoding = System.Text.Encoding.UTF8; var url = ResolveUrl("~/Vendor/Email_RFQ_Request.htm"); var strEmailContent = HTMLContent(url); strEmailContent = strEmailContent.Replace("{BuyerName}", user.Name); strEmailContent = strEmailContent.Replace("{BuyerPhone}", user.Phone1); strEmailContent = strEmailContent.Replace("{BuyerEmail}", user.Email); strEmailContent = strEmailContent.Replace("{RFQ Number}", rfqToResend.RfqGenerated); strEmailContent = strEmailContent.Replace("{Part Number}", rfqToResend.PartNumber); strEmailContent = strEmailContent.Replace("{RFQLink}", "http://" + Request.Url.Authority + Request.ApplicationPath + "/Vendor/RFQHandler.ashx?token=" + token.TokenNumber); Message.Body = strEmailContent; NewMail.SendMail(Message); } catch (Exception ex) { DM.RollBack(); response.ErrorThrown = true; response.ResponseDescription = "ERROR: Could not send email to: " + supplier.ContactEmail.ToString(); return(JsonConvert.SerializeObject(response)); } DM.CommitTransaction(); DM.Close_Open_Connection(); if (DM.ErrorOccur) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + DM.Error_Mjs; return(JsonConvert.SerializeObject(response)); } response.ErrorThrown = false; response.ResponseDescription = "RFQ " + rfqToResend.RfqGenerated + " re-sent successfully."; response.Result = rfqToResend; return(JsonConvert.SerializeObject(response)); }
protected void btnSendSurvey_Click(object sender, EventArgs e) { if (supplier.ContactEmail.Trim() != txtEmail.Text.Trim()) { SupplierCRUD supplierCRUD = new SupplierCRUD(); supplier.ContactEmail = txtEmail.Text.Trim(); if (!supplierCRUD.update(supplier)) { Navigator.goToPage("~/Error.aspx", "ERROR:" + supplierCRUD.ErrorMessage); return; } } SupplierSurveyCRUD surveyCRUD = new SupplierSurveyCRUD(); SupplierSurvey survey = new SupplierSurvey(); survey.SupplierMasterKey = supplier.Id; survey.SentToVendor = DateTime.Now; supplier.SupplierSurvey = survey; ConnectionManager CM = new ConnectionManager(); Data_Base_MNG.SQL DM = CM.getDataManager(); /*Begin Transaction*/ DM.Open_Connection("Survey Save"); string idGenerated = surveyCRUD.createAndReturnIdGenerated(survey, ref DM); if (!surveyCRUD.ErrorOccur) { TokenCRUD token_CRUD = new TokenCRUD(); Token token = new Token(); token.Subject = "SURVEY"; token.SubjectKey = long.Parse(idGenerated); token.TokenNumber = MD5HashGenerator.GenerateKey(DateTime.Now); if (token_CRUD.create(token, ref DM)) { Email NewMail = new Email(); MailMessage Message = new MailMessage(); Message.From = new MailAddress("*****@*****.**", "*****@*****.**"); Message.To.Add(new MailAddress(supplier.ContactEmail.ToString())); Message.Subject = "Survey"; Message.IsBodyHtml = true; Message.BodyEncoding = System.Text.Encoding.UTF8; //Message.Body = "Aqui va el link con el token= " + " <a href:\"http://localhost:29724/APQM/Vendor/RFQ.aspx?token=" + token.TokenNumber + "\">Link</a>"; //Message.Body = "Aqui va el link con el token= " + " <a href:\"http://www.google.com\">Google</a>"; string strEmailContent = "Dear Potential Supplier," + Environment.NewLine + "Please click the following link to fill out our supplier survey form. Please fill out as completely as possible. Once we have received your completed survey, a representative will contact you to discuss the next steps." + Environment.NewLine + Environment.NewLine + "http://" + Request.Url.Authority + Request.ApplicationPath + "/Vendor/Survey.aspx?token=" + token.TokenNumber + Environment.NewLine + Environment.NewLine + "Thank you for your time. We look forward to hearing from you." + Environment.NewLine + Environment.NewLine + "Sincerely," + Environment.NewLine + Environment.NewLine + "The Capsonic Advanced Purchasing Team"; AlternateView htmlView = AlternateView.CreateAlternateViewFromString(strEmailContent); Message.AlternateViews.Add(htmlView); try { NewMail.SendMail(Message); } catch { DM.RollBack(); Navigator.goToPage("~/Error.aspx", "ERROR:Could not send email to: " + supplier.ContactEmail.ToString()); return; } } else { Navigator.goToPage("~/Error.aspx", "ERROR:" + token_CRUD.ErrorMessage); return; } } else { Navigator.goToPage("~/Error.aspx", "ERROR:" + surveyCRUD.ErrorMessage); return; } DM.CommitTransaction(); DM.Close_Open_Connection(); if (DM.ErrorOccur) { Navigator.goToPage("~/Error.aspx", "ERROR:" + DM.Error_Mjs); return; } supplier = null; Ok_Click(this, e); }