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));
}
