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