private string createSIF() { GatewayResponse response = new GatewayResponse(); String s = new StreamReader(Request.InputStream).ReadToEnd(); SIF sif = JsonConvert.DeserializeObject <SIF>(s); String authUser = HttpContext.Current.User.Identity.Name; sif.AssignedTo = authUser; /*Begin Transaction*/ ConnectionManager CM = new ConnectionManager(); Data_Base_MNG.SQL DM = CM.getDataManager(); DM.Open_Connection("SIF Create"); string idGenerated = sif_CRUD.createAndReturnIdGenerated(sif, ref DM); if (sif_CRUD.ErrorOccur) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + sif_CRUD.ErrorMessage; return(JsonConvert.SerializeObject(response)); } else { sif.Id = long.Parse(idGenerated); foreach (SIFDetail sifVolume in sif.SifDetail) { sifVolume.SifHeaderKey = sif.Id; if (!sifDetail_CRUD.create(sifVolume, ref DM)) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + sifDetail_CRUD.ErrorMessage; 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 = "SIF created successfully."; response.Result = sif; return(JsonConvert.SerializeObject(response)); }
private string saveSIF() { GatewayResponse response = new GatewayResponse(); String s = new StreamReader(Request.InputStream).ReadToEnd(); SIF sif = JsonConvert.DeserializeObject <SIF>(s); /*Begin Transaction*/ ConnectionManager CM = new ConnectionManager(); Data_Base_MNG.SQL DM = CM.getDataManager(); DM.Open_Connection("SIF Update"); if (!sif_CRUD.update(sif, ref DM)) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + sif_CRUD.ErrorMessage; return(JsonConvert.SerializeObject(response)); } if (!sifDetail_CRUD.deleteByParentID(sif.Id, ref DM)) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + sifDetail_CRUD.ErrorMessage; return(JsonConvert.SerializeObject(response)); } foreach (SIFDetail sifVolume in sif.SifDetail) { sifVolume.SifHeaderKey = sif.Id; if (!sifDetail_CRUD.create(sifVolume, ref DM)) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + sifDetail_CRUD.ErrorMessage; 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 = "SIF updated successfully."; response.Result = getSIFbyID(sif.Id); return(JsonConvert.SerializeObject(response)); }
public string sendRFQ() { List <RFQ> resultRFQs = new List <RFQ>(); GatewayResponse response = new GatewayResponse(); String s; NewRFQScreen newRFQScreen; try { s = new StreamReader(Request.InputStream).ReadToEnd(); newRFQScreen = JsonConvert.DeserializeObject <NewRFQScreen>(s); } catch (Exception ex) { response.ErrorThrown = true; response.ResponseDescription = "ERROR: When trying to parse JSON in server. " + ex.Message; return(JsonConvert.SerializeObject(response)); } RFQNumberCRUD rfqNumberCRUD = new RFQNumberCRUD(); bomDetailCRUD bomDetail_CRUD = new bomDetailCRUD(); UserCRUD user_CRUD = new UserCRUD(); string baseBOMAttachmentsPath = ConfigurationManager.AppSettings["BOMLineAttachments"]; string baseRFQAttachmentsPath = ConfigurationManager.AppSettings["RFQAttachmentsSent"]; string strAuthUser = HttpContext.Current.User.Identity.Name; User user = user_CRUD.readById(strAuthUser); List <SIFDetail> EAUsList = newRFQScreen.SIFVolumesList; if (EAUsList.Count == 0) { response.ErrorThrown = true; response.ResponseDescription = "ERROR: Cannot create RFQ without EAU specified."; return(JsonConvert.SerializeObject(response)); } List <RFQEAV> newEAUList = new List <RFQEAV>(); foreach (SIFDetail eau in EAUsList) { RFQEAV eauParsed = new RFQEAV(); eauParsed.Volume = eau.ProjectedAnnualVolume; eauParsed.Year = eau.ProgramYear; RFQEAV alreadyExists = newEAUList.Find(eauInternal => eauInternal.Volume == eauParsed.Volume); if (alreadyExists == null) { newEAUList.Add(eauParsed); } else { alreadyExists.Year = alreadyExists.Year.Trim() + ", " + eauParsed.Year.Trim(); } } List <BOMDetail> bomDetailList = newRFQScreen.BomDetailList; ConnectionManager CM = new ConnectionManager(); Data_Base_MNG.SQL DM = CM.getDataManager(); if (newRFQScreen.SupplierList.Count > 0) { foreach (Supplier supplier in newRFQScreen.SupplierList) { foreach (BOMDetail component in bomDetailList) { RFQNumberEntity rfqNumber = new RFQNumberEntity(); rfqNumber.BOMDetailKey = component.Id; rfqNumber.SifHeaderKey = newRFQScreen.SIFHeaderID; rfqNumber.RFQNumber = rfqNumberCRUD.generateNewRFQNumber(rfqNumber.SifHeaderKey); if (rfqNumber.RFQNumber == -1) { response.ErrorThrown = true; response.ResponseDescription = "ERROR: There was an error generating a new RFQ number."; return(JsonConvert.SerializeObject(response)); } CM = new ConnectionManager(); DM = CM.getDataManager(); /*Begin Transaction*/ DM.Open_Connection("Send New RFQ"); RFQ rfq = new RFQ(); RFQNumberEntity rfqNumberGenereated = rfqNumberCRUD.create_return_object(rfqNumber, ref DM); if (rfqNumberCRUD.ErrorOccur) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + rfqNumberCRUD.ErrorMessage; return(JsonConvert.SerializeObject(response)); } else { //rfq.SentAttachmentsFolder = newRFQScreen.FolderAttachments; newRFQScreen.FolderAttachments = newRFQScreen.FolderAttachments.Trim(); if (newRFQScreen.FolderAttachments != "") { if (System.IO.Directory.Exists((baseRFQAttachmentsPath + newRFQScreen.FolderAttachments))) { DirectoryInfo directory = new DirectoryInfo((baseRFQAttachmentsPath + newRFQScreen.FolderAttachments)); if (directory.GetFiles().Length > 0) { string folderName = ""; do { DateTime date = DateTime.Now; folderName = date.Year.ToString() + date.Month.ToString() + date.Day.ToString() + "_" + MD5HashGenerator.GenerateKey(date); } while (Directory.Exists((baseRFQAttachmentsPath + folderName))); Directory.CreateDirectory((baseRFQAttachmentsPath + folderName)); rfq.SentAttachmentsFolder = folderName; foreach (FileInfo file in directory.GetFiles()) { try { File.Copy(file.FullName, (baseRFQAttachmentsPath + rfq.SentAttachmentsFolder + @"\" + file.Name), true); } catch (Exception ex) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + ex.Message; return(JsonConvert.SerializeObject(response)); } } } } } foreach (Attachment bomAttachment in component.AttachmentsList) { if (rfq.SentAttachmentsFolder.Trim() == "") { string folderName = ""; do { DateTime date = DateTime.Now; folderName = date.Year.ToString() + date.Month.ToString() + date.Day.ToString() + "_" + MD5HashGenerator.GenerateKey(date); } while (Directory.Exists((baseRFQAttachmentsPath + folderName))); Directory.CreateDirectory((baseRFQAttachmentsPath + folderName)); rfq.SentAttachmentsFolder = folderName; } string currentPathAttachmentSource = baseBOMAttachmentsPath + bomAttachment.Directory + @"\" + bomAttachment.FileName; string currentPathAttachmentTarget = baseRFQAttachmentsPath + rfq.SentAttachmentsFolder + @"\" + bomAttachment.FileName; try { File.Copy(currentPathAttachmentSource, currentPathAttachmentTarget, true); } catch (Exception e) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + e.Message; return(JsonConvert.SerializeObject(response)); } } RfqCRUD rfqCRUD = new RfqCRUD(); rfq.SupplierId = supplier.Id; rfq.SupplierName = supplier.SupplierName; rfq.SentToVendor = DateTime.Now; rfq.LastEmail = supplier.ContactEmail; rfq.Status = "PENDING"; rfq.BomDetailId = component.Id; rfq.Um = component.Um; rfq.RfqNumberKey = rfqNumberGenereated.Id; rfq.RfqGenerated = rfqNumberGenereated.RfqGenerated; rfq.DueDate = newRFQScreen.DueDate; rfq.MarketSectorID = newRFQScreen.MarketSectorID; rfq.DrawingLevel = newRFQScreen.DrawingLevel; rfq.TargetPrice = newRFQScreen.TargetPrice; rfq.CommentsToVendor = newRFQScreen.CommentsToVendor; rfq.CreatedBy = strAuthUser; string idGenerated = rfqCRUD.createAndReturnIdGenerated(rfq, component, ref DM); if (!rfqCRUD.ErrorOccur) { rfq.Id = long.Parse(idGenerated); foreach (RFQEAV eau in newEAUList) { RFQEAVCRUD rfqEAV_CRUD = new RFQEAVCRUD(); RFQEAV rfqEAV_toPersist = new RFQEAV(); rfqEAV_toPersist.RfqHeaderKey = long.Parse(idGenerated); rfqEAV_toPersist.Volume = eau.Volume * component.Qty; rfqEAV_toPersist.Year = eau.Year; rfqEAV_toPersist.Status = "CREATED"; rfqEAV_CRUD.createAndReturnIdGenerated(rfqEAV_toPersist, ref DM); if (rfqEAV_CRUD.ErrorOccur) { response.ErrorThrown = true; response.ResponseDescription = "ERROR:" + rfqEAV_CRUD.ErrorMessage; return(JsonConvert.SerializeObject(response)); } } TokenCRUD token_CRUD = new TokenCRUD(); Token token = new Token(); token.Subject = "RFQ"; 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(); 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}", rfqNumber.RfqGenerated); strEmailContent = strEmailContent.Replace("{Part Number}", component.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() + "; " + ex.Message; return(JsonConvert.SerializeObject(response)); } } else { response.ErrorThrown = true; response.ResponseDescription = "ERROR: " + token_CRUD.ErrorMessage; return(JsonConvert.SerializeObject(response)); } } else { response.ErrorThrown = true; response.ResponseDescription = "ERROR: " + rfqCRUD.ErrorMessage; 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)); } resultRFQs.Add(rfq); } } } response.ErrorThrown = false; response.ResponseDescription = "RFQs created successfully."; response.Result = resultRFQs; 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)); }
private string updateRFQ() { String s = new StreamReader(Request.InputStream).ReadToEnd(); RFQ rfq = JsonConvert.DeserializeObject <RFQ>(s); if (rfq.Status == "COMPLETED") { if (rfq.NoQuote) { rfq.Status = "NO QUOTE"; } } /*Begin Transaction*/ ConnectionManager CM = new ConnectionManager(); Data_Base_MNG.SQL DM = CM.getDataManager(); DM.Open_Connection("RFQ Update"); if (!rfq_CRUD.update(rfq, ref DM)) { return("ERROR:" + rfq_CRUD.ErrorMessage); } foreach (RFQEAV rfqEAVLocal in rfq.RfqEAV) { if (!rfqEAV_CRUD.update(rfqEAVLocal, ref DM)) { return("ERROR:" + rfqEAV_CRUD.ErrorMessage); } if (!rfqDetail_CRUD.deleteByParentID(rfqEAVLocal.Id, ref DM)) { return("ERROR:" + rfqDetail_CRUD.ErrorMessage); } foreach (RFQDetail rfqDetailCurrent in rfqEAVLocal.RfqDetail) { rfqDetailCurrent.RfqEAVKey = rfqEAVLocal.Id; if (!rfqDetail_CRUD.create(rfqDetailCurrent, ref DM)) { return("ERROR:" + rfqDetail_CRUD.ErrorMessage); } } } if (!rfqACR_CRUD.deleteByParentID(rfq.Id, ref DM)) { return("ERROR:" + rfqACR_CRUD.ErrorMessage); } foreach (RFQACR currentACR in rfq.RfqAcr) { currentACR.RfqHeaderKey = rfq.Id; if (!rfqACR_CRUD.create(currentACR, ref DM)) { return("ERROR:" + rfqACR_CRUD.ErrorMessage); } } DM.CommitTransaction(); DM.Close_Open_Connection(); if (DM.ErrorOccur) { return("ERROR:" + DM.Error_Mjs); } return(getRFQbyID(rfq.Id)); }
public string selectRFQ(long rfqHeaderKey, long eavKey, float newBomCost) { saveRFQSummary(); RfqCRUD rfqCRUD = new RfqCRUD(); RfqSummaryCRUD rfqSummaryCRUD = new RfqSummaryCRUD(); RFQ rfq = rfqCRUD.readById(rfqHeaderKey); //List<RFQSummary> rfqSummaryList = rfqSummaryCRUD.readByBOMDetailIDAndEAU(rfq.BomDetailId, rfqSummary.EstimatedAnnualVolume); List <RFQ> rfqList = rfqCRUD.readByBOMDetailKey(rfq.BomDetailId); RFQEAVCRUD rfqEAV_CRUD = new RFQEAVCRUD(); RFQEAV eavSelected = rfqEAV_CRUD.readById(eavKey); bomDetailCRUD bomDetailCRUD = new bomDetailCRUD(); BOMDetail bomDetail = bomDetailCRUD.readById(rfq.BomDetailId); ConnectionManager CM = new ConnectionManager(); Data_Base_MNG.SQL DM = CM.getDataManager(); List <RFQEAV> eavList = new List <RFQEAV>(); foreach (RFQ rfqObj in rfqList) { eavList.AddRange(rfqEAV_CRUD.readByParentID(rfqObj.Id)); } /*Begin Transaction*/ DM.Open_Connection("RFQ Selection"); foreach (RFQ rfqObj in rfqList) { foreach (RFQEAV eavCurrent in eavList) { if (eavCurrent.Id != eavKey && eavCurrent.RfqHeaderKey == rfqObj.Id) { eavCurrent.Status = "DISMISSED"; if (rfqObj.NoQuote == true) { eavCurrent.Status = "NO QUOTE"; } if (!rfqEAV_CRUD.update(eavCurrent, ref DM)) { return("ERROR:" + rfqEAV_CRUD.ErrorMessage); } } } if (rfqObj.Id != rfq.Id) { rfqObj.Status = "DISMISSED"; if (rfqObj.NoQuote == true) { rfqObj.Status = "NO QUOTE"; } if (!rfqCRUD.update(rfqObj, ref DM)) { return("ERROR:" + rfqCRUD.ErrorMessage); } } } if (rfq != null) { rfq.Status = "SELECTED"; if (!rfqCRUD.update(rfq, ref DM)) { return("ERROR:" + rfqCRUD.ErrorMessage); } if (eavSelected != null) { eavSelected.Status = "SELECTED"; if (!rfqEAV_CRUD.update(eavSelected, ref DM)) { return("ERROR:" + rfqEAV_CRUD.ErrorMessage); } if (bomDetail != null) { if (newBomCost > -1) { bomDetail.Cost = newBomCost; } bomDetail.Status = "Processed"; if (!bomDetailCRUD.update(bomDetail, ref DM)) { return("ERROR:" + bomDetailCRUD.ErrorMessage); } } else { DM.RollBack(); return("ERROR:There was an error retrieving BOM Detail for BomDetailKey = " + rfq.BomDetailId); } } else { DM.RollBack(); return("ERROR:There was an error retrieving EAV entity for eavKey = " + eavKey); } } else { DM.RollBack(); return("ERROR:Could not retrieve RFQ for ID = " + rfqHeaderKey); } DM.CommitTransaction(); DM.Close_Open_Connection(); if (DM.ErrorOccur) { return("ERROR:" + DM.Error_Mjs); } return(getRFQSummarybyBOMDetailID(rfq.BomDetailId)); }
public bool saveRFQ() { RFQ rfq = new RFQ(); //lblPartNumber.Text //if(rfq.NoQuote) // rfq.ReasonNoQuote = txtReasonNoQuote.Text; // else // rfq.ReasonNoQuote = ""; //rfq.BomDetailId = long.Parse(lblBOMDetailID.Text); //rfq.SupplierId = long.Parse(hiddenSupplierID.Value); //rfq.RfqNumber = lblRFQNumber.Text; //rfq.MarketSectorID = (long)ViewState["MarketSectoryID"]; //rfq.CreatedBy = hiddenCreatedBy.Value; //rfq.SentAttachmentsFolder = hiddenSentAttachmentsFolder.Value; //rfq.SentToVendor = (DateTime)ViewState["SentToVendor"]; string folderVendorAttachments = (string)Session["RFQATTACHMENTSFOLDERINBOX"]; if (folderVendorAttachments != null) { rfq.InboxAttachmentsFolder = folderVendorAttachments; } else { rfq.InboxAttachmentsFolder = hiddenInboxAttachments.Value; } Session.Remove("RFQATTACHMENTSFOLDERINBOX"); //List<RFQACR> rfqACRList = uscRfqACR.getEntity(); ConnectionManager CM = new ConnectionManager(); Data_Base_MNG.SQL DM = CM.getDataManager(); /*Begin Transaction*/ DM.Open_Connection("RFQ Save"); rfq.Status = "IN PROGRESS"; rfq.Id = this.rfq.Id; if (!rfqCRUD.update(rfq, ref DM)) { Navigator.goToPage("~/Error.aspx", "ERROR:" + rfqCRUD.ErrorMessage); return(false); } foreach (RFQEAV rfqEAVLocal in rfq.RfqEAV) { if (rfqEAV_CRUD.update(rfqEAVLocal, ref DM)) { Navigator.goToPage("~/Error.aspx", "ERROR:" + rfqDetailCRUD.ErrorMessage); return(false); } //if (txtSGAProfit.Text.Trim() != "") rfq.SgAProfit = float.Parse(txtSGAProfit.Text); //if (txtPackingCostUnit.Text.Trim() != "") rfq.PackingPerUnit = float.Parse(txtPackingCostUnit.Text); //if (txtAssemblyCostUnit.Text.Trim() != "") rfq.AssemblyCostPerUnit = float.Parse(txtAssemblyCostUnit.Text); if (!rfqDetailCRUD.deleteByParentID(rfqEAVLocal.Id, ref DM)) { Navigator.goToPage("~/Error.aspx", "ERROR:" + rfqDetailCRUD.ErrorMessage); return(false); } } if (!rfqACRCRUD.deleteByParentID(rfq.Id, ref DM)) { Navigator.goToPage("~/Error.aspx", "ERROR:" + rfqACRCRUD.ErrorMessage); return(false); } foreach (RFQEAV rfqEAVLocal in rfq.RfqEAV) { foreach (RFQDetail detail in rfqEAVLocal.RfqDetail) { detail.RfqEAVKey = rfqEAVLocal.Id; if (!rfqDetailCRUD.create(detail, ref DM)) { Navigator.goToPage("~/Error.aspx", "ERROR:" + rfqDetailCRUD.ErrorMessage); return(false); } } } //foreach (RFQACR detail in rfqACRList) //{ // detail.RfqHeaderKey = this.rfq.Id; // if (!rfqACRCRUD.create(detail, ref DM)) // { // Navigator.goToPage("~/Error.aspx", "ERROR:" + rfqACRCRUD.ErrorMessage); // return false; // } //} DM.CommitTransaction(); DM.Close_Open_Connection(); if (DM.ErrorOccur) { Navigator.goToPage("~/Error.aspx", "ERROR:" + DM.Error_Mjs); return(false); } return(true); }
public bool save() { SupplierSurvey survey = new SupplierSurvey(); survey.SupplierMasterKey = supplier.Id; survey.StreetAddress = txtAddress.Text; survey.City = txtCity.Text; survey.State = txtState.Text; survey.ZipCode = txtZip.Text; survey.Website = txtWebsite.Text; survey.LastSurvey = DateTime.Now; if (lblNDARec.Text.Trim() != "") { survey.NDARec = DateTime.Parse(lblNDARec.Text); } survey.PrimaryBusiness = txtPrimaryBusiness.Text; survey.SecundaryBusiness = txtSecundaryBusiness.Text; survey.UnionYN = radUnion.Checked; survey.Local = txtLocal.Text; survey.ContractExpiration = txtContractExpiration.Text; survey.CurrentCapacity = txtCurrentCapacity.Text; survey.ManufacturingMetod = txtManufacturingMethod.Text; survey.ToolingNewInHouseYN = chkNewInHouseManufacture.Checked; survey.ToolingNewOutsourcedYN = chkNewOutsourced.Checked; survey.ToolingInHouseYN = chkRepairInHouse.Checked; survey.ToolingOutsourcedYN = chkRepairOutsource.Checked; survey.Notes = txtNotes.Text; ConnectionManager CM = new ConnectionManager(); Data_Base_MNG.SQL DM = CM.getDataManager(); /*Begin Transaction*/ DM.Open_Connection("Survey Save"); certification_CRUD.deleteByParentId(supplier.SupplierSurvey.Id, ref DM); foreach (SupplierSurveyCertification certification in supplier.SupplierSurvey.Certifications) { certification.SupplierSurveyKey = supplier.SupplierSurvey.Id; certification_CRUD.create(certification, ref DM); } industries_CRUD.deleteByParentId(supplier.SupplierSurvey.Id, ref DM); foreach (SupplierSurveyIndustriesSupplied industrie in supplier.SupplierSurvey.IndustriesSupplied) { industrie.SupplierSurveyKey = supplier.SupplierSurvey.Id; industries_CRUD.create(industrie, ref DM); } forecast_CRUD.deleteByParentId(supplier.SupplierSurvey.Id, ref DM); foreach (SupplierSurveyForecastSales forecastSale in supplier.SupplierSurvey.ForecastSales) { forecast_CRUD.create(forecastSale, ref DM); } SupplierSurveyContacts executive = uscContactExecutive.getEntity(); executive.SupplierSurveyKey = supplier.SupplierSurvey.Id; if (supplier.SupplierSurvey.ContactExecutive != null) { contacts_CRUD.update(executive, ref DM); } else { contacts_CRUD.create(executive, ref DM); } SupplierSurveyContacts sales = uscContactSales.getEntity(); sales.SupplierSurveyKey = supplier.SupplierSurvey.Id; if (supplier.SupplierSurvey.ContactSales != null) { contacts_CRUD.update(sales, ref DM); } else { contacts_CRUD.create(sales, ref DM); } SupplierSurveyContacts quality = uscContactQuality.getEntity(); quality.SupplierSurveyKey = supplier.SupplierSurvey.Id; if (supplier.SupplierSurvey.ContactQuality != null) { contacts_CRUD.update(quality, ref DM); } else { contacts_CRUD.create(quality, ref DM); } SupplierSurveyContacts support = uscContactCustomerSupport.getEntity(); support.SupplierSurveyKey = supplier.SupplierSurvey.Id; if (supplier.SupplierSurvey.ContactCustomerSupport != null) { contacts_CRUD.update(support, ref DM); } else { contacts_CRUD.create(support, ref DM); } SupplierSurveyContacts afterHours = uscContactAfterHours.getEntity(); afterHours.SupplierSurveyKey = supplier.SupplierSurvey.Id; if (supplier.SupplierSurvey.ContactAfterHoursContact != null) { contacts_CRUD.update(afterHours, ref DM); } else { contacts_CRUD.create(afterHours, ref DM); } if (lblMode.Text == "New") { if (!survey_CRUD.create(survey, ref DM)) { Navigator.goToPage("~/Error.aspx", "ERROR:" + survey_CRUD.ErrorMessage); return(false); } //else //{ // BOM bom = new BOM(); // bom.SifId = 21; // bomCRUD bomCrud = new bomCRUD(); // if (!bomCrud.create(bom)) // { // Navigator.goToPage("~/Error.aspx",""); // } //} } else if (lblMode.Text == "Update") { survey.Id = long.Parse(lblID.Text); if (!survey_CRUD.update(survey, ref DM)) { Navigator.goToPage("~/Error.aspx", "ERROR:" + survey_CRUD.ErrorMessage); return(false); } } DM.CommitTransaction(); DM.Close_Open_Connection(); if (DM.ErrorOccur) { Navigator.goToPage("~/Error.aspx", "ERROR:" + DM.Error_Mjs); return(false); } return(true); }
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); }
private string saveBOM() { String s = new StreamReader(Request.InputStream).ReadToEnd(); BOM bomHeader = JsonConvert.DeserializeObject <BOM>(s); List <Item> itemList = (List <Item>)item_CRUD.readAll(); /*Begin Transaction*/ ConnectionManager CM = new ConnectionManager(); Data_Base_MNG.SQL DM = CM.getDataManager(); DM.Open_Connection("BOM Update"); if (!bom_CRUD.update(bomHeader, ref DM)) { return("ERROR:" + bom_CRUD.ErrorMessage); } foreach (BOMDetail bomLine in bomHeader.BomDetail) { Item item = readByPartNumberInList(bomLine, itemList); if (item == null) { item = new Item(); item.PartNumber = bomLine.PartNumber.Trim(); item.Cost = bomLine.Cost; item.Um = bomLine.Um; item.Material = bomLine.Material; item.CommCode = bomLine.CommCode; string itemIDGenerated = item_CRUD.createAndReturnIdGenerated(item, ref DM); if (itemIDGenerated == "") { return("ERROR: Could not export Item: " + item + "\n" + "Error Description: " + DM.Error_Mjs); } else { item.Id = long.Parse(itemIDGenerated); itemList.Add(item); } } else { item.PartNumber = bomLine.PartNumber.Trim(); item.Cost = bomLine.Cost; item.Um = bomLine.Um; item.Material = bomLine.Material; item.CommCode = bomLine.CommCode; if (!item_CRUD.update(item, ref DM)) { return("ERROR:" + item_CRUD.ErrorMessage); } } if (bomLine.Id > 0) { bomLine.ItemMasterkey = item.Id; if (!bomDetail_CRUD.update(bomLine, ref DM)) { return("ERROR:" + bomDetail_CRUD.ErrorMessage); } } else { bomLine.BomHeaderKey = bomHeader.Id; bomLine.ItemMasterkey = item.Id; bomLine.Status = "Created"; if (!bomDetail_CRUD.create(bomLine, ref DM)) { return("ERROR:" + bomDetail_CRUD.ErrorMessage); } } } DM.CommitTransaction(); DM.Close_Open_Connection(); if (DM.ErrorOccur) { return("ERROR:" + DM.Error_Mjs); } return(getBOMbyID(bomHeader.Id)); }