private string CreateInvitationBody(int userid)
{
StringBuilder sb = new StringBuilder();
sb.Append("<tr>");
sb.Append("<td valign='top'>");
sb.Append("<p>");
sb.Append("<br /><b>" + DateTime.Now.ToLongDateString() + "</b><br />");
sb.Append("<b>TO  :  <u>" + tbFirstName.Text.Trim() + " " + tbLastName.Text.Trim() + "</u></b>");
sb.Append("<br /><br /><br />");
sb.Append("Good Day!");
sb.Append("<br /><br />");
sb.Append("Your new profile has been successfully created.");
sb.Append("<br /> Username: "******"<br /> Password: "******"<br /><br /><br />");
sb.Append("Sincerely Yours,");
sb.Append("<br /><br />");
sb.Append(ConfigurationManager.AppSettings["AdminEmailName"]);
sb.Append("<br /><br />");
sb.Append("</p>");
sb.Append("</td>");
sb.Append("</tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateBody()
{
StringBuilder sb = new StringBuilder();
sb.Append("<tr>");
sb.Append("<td valign='top'>");
sb.Append("<p>");
sb.Append("<br /><b>" + DateTime.Now.ToLongDateString() + "</b><br />");
sb.Append("<b>TO : <u>" + txtVendorName.Text.Trim() + "</u></b>");
sb.Append("<br /><br /><br />");
sb.Append("Good Day!");
sb.Append("<br /><br />");
sb.Append("Your profile has been successfully created.");
sb.Append("<br /> Username: "******"<br /> Password: "******"sUserID"].ToString().Trim())))));
sb.Append("<br /><br />");
sb.Append("You can access the site using <a href='" + ConfigurationManager.AppSettings["ServerUrl"] + "' target='_blank'>https://e-sourcing.Trans-Asia.com.ph</a>");
sb.Append("<br /><br /><br />");
sb.Append("Sincerely Yours,");
sb.Append("<br /><br />");
sb.Append("</p>");
sb.Append("</td>");
sb.Append("</tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody()
{
StringBuilder sb = new StringBuilder();
sb.Append("<tr><td align='right'><h5>" + DateTime.Now.ToLongDateString() + "</h5></td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody()
{
StringBuilder sb = new StringBuilder();
//sb.Append("<tr><td align='right'><h5>" + DateTime.Now.ToLongDateString() + "</h5></td></tr>");
sb.Append("<tr><td><p><strong>BAC for Approval</strong> <br> Sent: " + DateTime.Now.ToLongDateString() + "</p> <p>From: From TestName<br><br> To: To Testname<br><br> Subject: Test eMail<br><br> Dear Bid Award Approvers, <br><br> Re: Request for Bid Award Approval – <strong>Test email only.</strong><br><br> This is to request for your Bid Award Approval of the ff:<br><br> <b>Bid Reference Number:</b> 999999<br> <b>Bid Event Name:</b> Just a test email<br></p> <p>Very truly yours,<br><br><br> <strong>e-Sourcing Procurement</strong></p><p> </p> <p><strong>Instructions:</strong></p> <ol> <li>Go to <a href='https://e-sourcing.Trans-Asia.com.ph/'>https://e-sourcing.Trans-Asia.com.ph</a></li> <li>Enter your Username and Password then click Login</li> <li>Click Received Bid Events for Awarding</li> <li>Click Bid Events Name</li> <li>Review / Endorse / Approve Bid event for Awarding</li> <li>Click Clarify if you have clarification or click Approved to award Bid Events</li> </ol> Please do not reply to this auto-generated message. </td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBodyReject()
{
StringBuilder sb = new StringBuilder();
string sCommand;
string BuyersName1 = "";
string connstring = HttpContext.Current.Session["ConnectionString"].ToString();
SqlDataReader oReader;
sCommand = "SELECT t1.BuyerFirstName + ' ' + t1.BuyerMidName + ' ' + t1.BuyerLastName AS Name1 FROM tblBuyers t1, tblBacBidItems t2 ";
sCommand = sCommand + "WHERE t1.BuyerID=t2.BuyerId AND t2.BidRefNo=" + Session["BuyerBidForBac"];
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
BuyersName1 = oReader["Name1"].ToString();
}
oReader.Close();
// Approvers
string oApprovers = "";
sCommand = "select BACId, NAME1, ApprovingLimit, ApprovedDt from ( SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_1 ApprovedDt, 1 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_1 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_2 ApprovedDt, 2 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_2 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_3 ApprovedDt, 3 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_3 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_4 ApprovedDt, 4 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_4 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_5 ApprovedDt, 5 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_5 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_6 ApprovedDt, 6 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_6 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_7 ApprovedDt, 7 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_7 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_8 ApprovedDt, 8 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_8 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_9 ApprovedDt, 9 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_9 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_10 ApprovedDt, 10 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_10 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.PurchasingID BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_0 ApprovedDt, 0 AS ApprovingLimit FROM tblPurchasing t1, tblBacBidItems t2 WHERE t1.PurchasingID=t2.Approver_0 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + ") as table_1 order by ApprovingLimit";
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
while (oReader.Read())
{
if (oReader["ApprovingLimit"].ToString() == "0")
{
oApprovers = oApprovers + "Purchasing: " + oReader["Name1"].ToString() + "<br>";
}
else
{
oApprovers = oApprovers + "Approver " + oReader["ApprovingLimit"].ToString() + ": " + oReader["Name1"].ToString() + "<br>";
}
}
}
oReader.Close();
string ItemDesc = "";
sCommand = "SELECT ItemDesc FROM tblBacBidItems WHERE BidRefNo=" + Session["BuyerBidForBac"];
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
ItemDesc = oReader["ItemDesc"].ToString();
}
oReader.Close();
sb.Append("<tr><td><p><strong>BAC Rejected</strong> <br> Sent: " + DateTime.Now.ToLongDateString() + "</p> <p>From: Reviewers<br><br> Dear " + BuyersName1 + ", <br><br> Re: Notice of Rejected BAC – " + ItemDesc + "<br><br> This is to inform all Bid Award reviewers and approvers that the following Bid was rejected:<br><br> <b>Bid Reference Number:</b> " + Session["BuyerBidForBac"] + "<br> <b>Bid Event Name:</b> " + ItemDesc + "<br><br> Very truly yours,<br><br><br> <strong>" + oApprovers + "</strong></p><p> </p> Please do not reply to this auto-generated message. </td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
protected void btnSend_Click(object sender, EventArgs e)
{
SqlParameter[] sqlparams = new SqlParameter[1];
sqlparams[0] = new SqlParameter("@UserName", SqlDbType.NVarChar, 100);
sqlparams[0].Value = txtUserName2.Text.Trim();
DataTable dt;
try
{
dt = SqlHelper.ExecuteDataset(connstring, "sp_GetUserPasswordAndEmail", sqlparams).Tables[0];
string ePwd = dt.Rows[0]["Password"].ToString();
string eAdd = dt.Rows[0]["EmailAddress"].ToString();
if (ePwd.Equals("NONE") || eAdd.Equals("NONE"))
{
txtNote2.Text = "Username not found.";
}
else
{
string from = System.Configuration.ConfigurationManager.AppSettings["AdminEmailAddress"];
string to = eAdd;
string subject = "Trans - Asia : Password Request";
try
{
if (MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), from, to, subject,
MailTemplate.IntegrateBodyIntoTemplate(CreateRequestPasswordBody(ePwd)),
MailTemplate.GetTemplateLinkedResources(this)))
{
Session["msg"] = "Password was sent to your email!";
LogHelper.TextLogHelper.Log("User Login > Send Password : Email Sent to " + to, LogHelper.TextLogHelper.LogType.Information);
}
else
{
Session["msg"] = "Password not sent this time.";
LogHelper.TextLogHelper.Log("User Login > Send Password : Sending Failed to " + to, LogHelper.TextLogHelper.LogType.Error);
}
}
catch (Exception ex)
{
Session["msg"] = "Password not sent this time.";
LogHelper.TextLogHelper.Log("User Login > Send Password : "******"login.aspx?t=1");
}
}
catch (Exception ex)
{
LogHelper.TextLogHelper.Log("User Login : " + ex.Message, LogHelper.TextLogHelper.LogType.Error);
}
}
private string CreateNotificationBody(string cfromName, string ctoName, string cVendorEmail, string cVendorName, string cUserName, string cPassword)
{
StringBuilder sb = new StringBuilder();
string sTxt = "";
//sTxt = sTxt + "<table border='0' style='font-size:12px' cellpadding='5'>";
//sTxt = sTxt + "<tr>";
//sTxt = sTxt + "<td><strong> Company Name</strong></td>";
//sTxt = sTxt + "<td> " + cVendorName + " </td>";
//sTxt = sTxt + "</tr>";
//sTxt = sTxt + "<tr>";
//sTxt = sTxt + "<td><strong> Vendor Email</strong></td>";
//sTxt = sTxt + "<td> " + cVendorEmail + " </td>";
//sTxt = sTxt + "</tr>";
//sTxt = sTxt + "</table>";
sTxt = sTxt + "<table border='0' cellpadding='5' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Login</strong></td>";
sTxt = sTxt + "<td> <a href='" + System.Configuration.ConfigurationManager.AppSettings["ServerUrl"] + "' target='_blank'>" + System.Configuration.ConfigurationManager.AppSettings["ServerUrl"] + "</a> </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> User Name</strong></td>";
sTxt = sTxt + "<td> " + cUserName + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> User Password</strong></td>";
sTxt = sTxt + "<td> " + cPassword + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br>");
sb.Append("To: " + ctoName + " <" + cVendorEmail + "><br><br>");
sb.Append("</p>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Dear " + ctoName + ":<br><br>");
sb.Append("This email is to inform you that we have received your letter of intent for accreditation. Your request has been approved.<br><br>");
sb.Append("Please access the link below using your username and password to start your application for Trans-Asia accreditation. <br><br>");
//sb.Append("<a href='http://'<br><br>");
sb.Append(sTxt);
sb.Append("</p>");
sb.Append("We are happy to be doing business with you. Thank you and God bless your dealings.<br><br><br>");
sb.Append("Sincerely,<br><br>");
sb.Append("Trans-Asia<br><br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p><span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span>");
sb.Append("</td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody(string oVSFId, string oProjectName, string fromName, string toName)
{
StringBuilder sb = new StringBuilder();
string BuyersName1 = fromName;
string PurchasingName1 = toName;
sb.Append("<tr><td><p><strong>VSF Approved</strong> <br> Sent: " + DateTime.Now.ToLongDateString() + "</p> <p>From: " + BuyersName1 + "<br><br> To: " + PurchasingName1 + "<br><br> Subject: " + oProjectName + "<br><br> Dear Buyer, <br><br> Re: Vendor Shortlisting Form Approved – <strong>" + oProjectName + "</strong><br><br> This is to inform you that Vendor Shortlisting Form has been approved with the ff:<br><br> <b>VSF Reference Number:</b> " + oVSFId + "<br> <b>Project Name:</b> " + oProjectName + "<br></p> <p>Very truly yours,<br><br><br> <strong>e-Sourcing Procurement</strong></p><p> </p> <p><strong>Instructions:</strong></p> <ol> <li>Go to <a href='https://e-sourcing.Trans-Asia.com.ph/'>https://e-sourcing.Trans-Asia.com.ph</a></li> <li>Enter your Username and Password then click Login</li> <li>Under Vendor Shortlisting Form, click View Endorsed</li> <li>Click VSF Reference No: " + oVSFId + "</li> <li>Review / Endorse / VSF for Awarding</li> <li>Click Clarify if you have clarification or click Approved to award VSF</li> </ol> Please do not reply to this auto-generated message. </td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody(BidDetails biddetails, BidParticipant participant)
{
StringBuilder sb = new StringBuilder();
sb.Append("<table style='width: 100%'><tr><td style='width: 1px'></td><td style='width: auto' colspan=''></td><td style='width: 1px'></td></tr>");
sb.Append("<tr><td style='width: auto; height: 635px'></td>");
sb.Append("<td style='width: 100%; height: auto; text-align: justify;'>");
sb.Append("<br />");
sb.Append("<br />");
sb.Append(DateTime.Now.ToLongDateString());
sb.Append("<br /><br /><br /><strong>");
sb.Append(participant.Name);
sb.Append("<br /></strong>");
sb.Append("<br />");
sb.Append("<table style='width: 745px'>");
sb.Append("<tr>");
sb.Append("<td style='width: 50px'>");
sb.Append("Attention :</td>");
sb.Append("<td style='width: 225px'>");
sb.Append("<strong>");
sb.Append(participant.Username);
sb.Append("</strong></td></tr>");
sb.Append("<tr>");
sb.Append("<td style='width: 26px'>");
sb.Append("</td>");
sb.Append("<td style='width: 225px'>");
sb.Append("</td></tr>");
sb.Append("<tr>");
sb.Append("<td style='width: 26px'>");
sb.Append("</td>");
sb.Append("<td style='width: 225px'>");
sb.Append("</td></tr>");
sb.Append("</table>");
sb.Append("<br />");
sb.Append("Re: ");
sb.Append(" ");
sb.Append(String.Format("Changed Submission Deadline Notification : {0}", biddetails.Description));
sb.Append("<br /><br />");
sb.Append("Dear Sir/Madame: <br /><br />");
sb.Append("We would like to inform you that the Submission Deadline for ");
sb.Append(String.Format("{2} has been moved from {0:D} {0:T} to {1:D} {1:T}.<br />", _currentDeadline, _newDeadline, biddetails.Description));
sb.Append("<br /><br /><br />");
sb.Append("");
sb.Append("Sincerely,");
sb.Append("<br /><br />");
sb.Append(Session[Constant.SESSION_USERFULLNAME].ToString());
sb.Append("<br /><br /><br /><br /></td><td style='width: auto; height: auto'></td></tr><tr><td style='width: auto'></td><td style='width: auto'></td><td style='width: auto'></td></tr></table>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody(string cfromName, string ctoName, string cAuthenticationNumber, string cVendorName)
{
StringBuilder sb = new StringBuilder();
string sTxt = "<table border='0' cellpadding='5' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Vendor ID</strong></td>";
sTxt = sTxt + "<td> " + Request.Form["__EVENTARGUMENT"] + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Company Name</strong></td>";
sTxt = sTxt + "<td> " + cVendorName + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Authentication Ticket</strong></td>";
sTxt = sTxt + "<td> " + cAuthenticationNumber + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
//sb.Append("<tr><td><p>Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br> To: " + ctoName + "<br><br> Good day!<br><br> This is to inform you that application for vendor accreditation has been posted for your approval.<br></p><br>" + sTxt + "<p>Very truly yours,<br><br><br> <strong>" + cfromName + "</strong></p><p> </p> <span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span></td></tr>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br>");
sb.Append("To: " + ctoName + "<br><br>");
sb.Append("</p>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Dear " + ctoName + ":<br><br>");
sb.Append("Re: Vendor information for clarification -- " + cVendorName + "<br><br>");
sb.Append("This is to request for your clarification of the ff: <br><br>");
//sb.Append("<a href='http://'<br><br>");
sb.Append(sTxt);
sb.Append("</p><br><br>");
//sb.Append("We are happy to be doing business with you. Thank you and God bless your dealings.<br><br><br>");
sb.Append("Very truly yours,<br><br>");
sb.Append("Trans-Asia<br><br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p>");
//sb.Append("<b>Instructions:</b><br>");
//sb.Append(" 1. Go to <a href='" + System.Configuration.ConfigurationManager.AppSettings["ServerUrl"] + "' target='_blank'>" + System.Configuration.ConfigurationManager.AppSettings["ServerUrl"] + "</a><br>");
//sb.Append(" 2. Enter your Username and Password then click Login<br>");
//sb.Append(" 3. Click Vendors for Authentication<br>");
//sb.Append(" 4. Click Authenticate<br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p><span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span>");
sb.Append("</td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBodyClarify()
{
StringBuilder sb = new StringBuilder();
string sCommand;
string WhoClarifyName1 = "";
string ClarifyToName1 = "";
string connstring = HttpContext.Current.Session["ConnectionString"].ToString();
SqlDataReader oReader;
sCommand = "SELECT t1.BuyerFirstName + ' ' + t1.BuyerMidName + ' ' + t1.BuyerLastName AS Name1 FROM tblBuyers t1, tblBacBidItems t2 ";
sCommand = sCommand + "WHERE t1.BuyerID=t2.BuyerId AND t2.BidRefNo=" + Session["BuyerBidForBac"];
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
WhoClarifyName1 = oReader["Name1"].ToString();
}
oReader.Close();
sCommand = "SELECT t1.PurchasingID, t2.LastName + ', ' + t2.FirstName + ' ' + t2.MiddleName AS Name1, CONVERT(VARCHAR(17), t3.ApprovedDt_0, 113) ApprovedDt ";
sCommand = sCommand + "FROM tblSupervisor t1, tblPurchasing t2, tblBacBidItems t3 WHERE ";
sCommand = sCommand + "t1.PurchasingID=t2.PurchasingID and t1.BuyerId = t3.buyerId AND t2.PurchasingID=t3.Approver_0 and t3.BidRefNo=" + Session["BuyerBidForBac"];
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
ClarifyToName1 = oReader["Name1"].ToString();
}
oReader.Close();
string ItemDesc = "";
sCommand = "SELECT ItemDesc FROM tblBacBidItems WHERE BidRefNo=" + Session["BuyerBidForBac"];
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
ItemDesc = oReader["ItemDesc"].ToString();
}
oReader.Close();
//sb.Append("<tr><td align='right'><h5>" + DateTime.Now.ToLongDateString() + "</h5></td></tr>");
sb.Append("<tr><td><p><strong>BAC for Clarification</strong> <br> Sent: " + DateTime.Now.ToLongDateString() + "</p> <p>From: " + WhoClarifyName1 + "<br><br> To: " + ClarifyToName1 + "<br><br> Attention:<br> Re: Request for Clarification: " + ItemDesc + "<br><br> Dear " + ClarifyToName1 + ", <br><br> There is a request for clarification on Bid for Award as follows:<br><br> <b>Bid Reference Number:</b> " + Session["BuyerBidForBac"] + "<br> <b>Bid Event Name:</b> " + ItemDesc + "<br><br></p> <p>Very truly yours,<br><br><br> <strong>e-Sourcing Procurement</strong></p><p> </p> <p><strong>Instructions:</strong></p> <ol> <li>Go to <a href='https://e-sourcing.Trans-Asia.com.ph/'>https://e-sourcing.Trans-Asia.com.ph</a></li> <li>Enter your Username and Password then click Login</li> <li>Click Bid Award for clarification</li> <li>Click Bid Events Name</li> <li>See Remarks / Comments box for items to clarify</li> <li>Click Clarify & provide response to Clarification</li> </ol> Please do not reply to this auto-generated message. </td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBodyReject(string cfromName, string ctoName, string cAuthenticationNumber, string cVendorName, string VendorIdx)
{
StringBuilder sb = new StringBuilder();
string sTxt = "<table border='0' cellpadding='5' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Vendor ID</strong></td>";
sTxt = sTxt + "<td> " + VendorIdx + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Company Name</strong></td>";
sTxt = sTxt + "<td> " + cVendorName + " </td>";
sTxt = sTxt + "</tr>";
//sTxt = sTxt + "<tr>";
//sTxt = sTxt + "<td><strong> Authentication Ticket</strong></td>";
//sTxt = sTxt + "<td> " + cAuthenticationNumber + " </td>";
//sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br>");
sb.Append("To: " + cVendorName + "<br><br>");
sb.Append("</p>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Dear " + cVendorName + ":<br><br>");
sb.Append("Be advised that your application to be an Accredited Trans-Asia Vendor was evaluated and found to have not met the requirements, we regret that you will not be accredited at this time.<br><br>");
sb.Append("If you so wish, we encourage you to schedule a meeting with us to discuss the result of your application for accreditation.<br><br>");
sb.Append("We would like to thank you for the time afforded in completing and submitting your application. We will keep your details on record for consideration of future business opportunities.<br><br>");
//sb.Append("Please access the link below using your username and password to start your application for Trans-Asia accreditation. <br><br>");
//sb.Append("<a href='http://'<br><br>");
sb.Append(sTxt);
sb.Append("</p>");
sb.Append("<br><br><br>");
sb.Append("Sincerely,<br><br>");
sb.Append("Trans-Asia<br><br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p><span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span>");
sb.Append("</td></tr>");
//sb.Append("<tr><td><p>Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br> To: " + ctoName + "<br><br> Good day!<br><br> This is to inform you that application for vendor accreditation has been rejected.<br></p><br>" + sTxt + "<p>Very truly yours,<br><br><br> <strong>" + cfromName + "</strong></p><p> </p> <span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span></td></tr>");
//Response.Write(sb.ToString());
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBodyReject(string cfromName, string ctoName, string cAuthenticationNumber, string cVendorName)
{
StringBuilder sb = new StringBuilder();
string sTxt = "<table border='0' cellpadding='5' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Vendor ID</strong></td>";
sTxt = sTxt + "<td> " + Session["VendorId"] + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Company Name</strong></td>";
sTxt = sTxt + "<td> " + cVendorName + " </td>";
sTxt = sTxt + "</tr>";
//sTxt = sTxt + "<tr>";
//sTxt = sTxt + "<td><strong> Authentication Ticket</strong></td>";
//sTxt = sTxt + "<td> " + cAuthenticationNumber + " </td>";
//sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br>");
sb.Append("To: " + cVendorName + "<br><br>");
sb.Append("</p>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Dear " + cVendorName + ":<br><br>");
sb.Append("This is to inform you that your application for vendor accreditation has been disapproved.<br><br>");
//sb.Append("Please access the link below using your username and password to start your application for Trans-Asia accreditation. <br><br>");
//sb.Append("<a href='http://'<br><br>");
sb.Append(sTxt);
sb.Append("</p>");
sb.Append("<br><br><br>");
sb.Append("Sincerely,<br><br>");
sb.Append("Trans-Asia<br><br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p><span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span>");
sb.Append("</td></tr>");
//sb.Append("<tr><td><p>Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br> To: " + ctoName + "<br><br> Good day!<br><br> This is to inform you that application for vendor accreditation has been rejected.<br></p><br>" + sTxt + "<p>Very truly yours,<br><br><br> <strong>" + cfromName + "</strong></p><p> </p> <span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span></td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody(string cfromName, string ctoName, string cVendorEmail, string cVendorName)
{
StringBuilder sb = new StringBuilder();
string sTxt = "<table border='0' cellpadding='5' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Company Name</strong></td>";
sTxt = sTxt + "<td> " + cVendorName + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Vendor Email</strong></td>";
sTxt = sTxt + "<td> " + cVendorEmail + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br>");
sb.Append("To: " + ctoName + "<br><br>");
sb.Append("</p>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Dear " + ctoName + ":<br><br>");
sb.Append("This email is to inform you that we have received a new letter of intent for accreditation.<br><br>");
//sb.Append("Please access the link below using your username and password to start your application for Trans-Asia accreditation. <br><br>");
//sb.Append("<a href='http://'<br><br>");
sb.Append(sTxt);
sb.Append("</p>");
sb.Append("<br><br><br>");
sb.Append("Sincerely,<br><br>");
sb.Append("Trans-Asia<br><br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p><span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span>");
sb.Append("</td></tr>");
//StringBuilder sb = new StringBuilder();
//string AdminName1 = fromName;
//string VendorName1 = toName;
//sb.Append("<tr><td><p>Sent: " + DateTime.Now.ToLongDateString() + "<br> To: " + VendorName1 + "<br><br> Good day!<br><br> This is to inform you that your application for accreditation is being processed.<br></p> <p>Very truly yours,<br><br><br> <strong>e-Sourcing Procurement</strong></p><p> </p> <span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span></td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBodyReject(string cfromName, string ctoName, string cVendorEmail, string cVendorName)
{
StringBuilder sb = new StringBuilder();
string sTxt = "<table border='0' cellpadding='5' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Company Name</strong></td>";
sTxt = sTxt + "<td> " + cVendorName + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Vendor Email</strong></td>";
sTxt = sTxt + "<td> " + cVendorEmail + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br>");
sb.Append("To: " + ctoName + " <" + cVendorEmail + "><br><br>");
sb.Append("</p>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Dear " + ctoName + ":<br><br>");
sb.Append("This email is to acknowledge receipt of your Letter of Intent for accreditation.<br><br>We regret to inform you that your application did not pass Trans-Asia's pre-screening conditions at this time.<br><br>Thank you.<br><br>");
//sb.Append("This email is to inform you that we have received your letter of intent for accreditation. We regret to inform you that your application for accreditation has been denied.<br><br>Thank you.<br><br>");
//sb.Append("Please access the link below using your username and password to start your application for Trans-Asia accreditation. <br><br>");
//sb.Append("<a href='http://'<br><br>");
sb.Append(sTxt);
sb.Append("</p>");
sb.Append("<br><br><br>");
sb.Append("Sincerely,<br><br>");
sb.Append("Trans-Asia<br><br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p><span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span>");
sb.Append("</td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateThanksEmailBody(DataRow drVendor)
{
StringBuilder sb = new StringBuilder();
string vendorName = drVendor["VendorName"].ToString();
string officialRep = drVendor["KeyPersonnel"].ToString();
string orDesignation = drVendor["KpPosition"].ToString();
string bidEvent = drVendor["ItemDesc"].ToString();
string buyerName = drVendor["BuyerName"].ToString();
sb.Append("<tr><td style='width: 5%; height: 13px;'></td><td style='width: 90%; height: 13px;' colspan=''></td><td style='width: 5%; height: 13px;'></td></tr><tr><td style='width: 5%; height: 635px'></td><td style='width: 90%'><br />");
sb.Append(DateTime.Now.ToLongDateString());
sb.Append("<br /><br />");
sb.Append(officialRep);
sb.Append("<br />");
sb.Append(orDesignation);
sb.Append("<br /><strong>");
sb.Append(vendorName);
sb.Append("</strong><br />");
sb.Append("<br /><br />");
sb.Append("Dear Mr/Madame,");
sb.Append("<br /><br />");
sb.Append("Re: Notice of Unsuccessful Bid - " + bidEvent);
sb.Append("<br /><br />");
sb.Append("We sincerely appreciate the time and effort you have dedicated to conform with our requirements.");
sb.Append("<br /><br />");
sb.Append("Trans-Asia / Commnunications will be looking forward to working with you on future bid events or projects.");
sb.Append("<br /><br />");
sb.Append("Please do not reply.");
sb.Append("<br /><br />");
sb.Append("Very truly yours,");
sb.Append("<br /><br />");
sb.Append("T. Jefferson M. de Leon");
sb.Append("<br />");
sb.Append("<i>Head-Logistics</i>");
sb.Append("<br /><br />");
sb.Append("Cc: EC Santiago");
sb.Append("</td><td style='width: 5%; height: auto'></td></tr><tr><td style='width: 5%'></td><td style='width: 90%'></td><td style='width: 5%'></td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody(string cfromName, string ctoName, string cAuthenticationNumber, string cVendorName)
{
StringBuilder sb = new StringBuilder();
string sTxt = "<table border='1' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Vendor ID</strong></td>";
sTxt = sTxt + "<td> " + Session["VendorId"] + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Company Name</strong></td>";
sTxt = sTxt + "<td> " + cVendorName + " </td>";
sTxt = sTxt + "</tr>";
//sTxt = sTxt + "<tr>";
//sTxt = sTxt + "<td><strong> Authentication Ticket</strong></td>";
//sTxt = sTxt + "<td> " + cAuthenticationNumber + " </td>";
//sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
sb.Append("<tr><td><p>Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br> To: " + ctoName + "<br><br> Good day!<br><br> This is to inform you that application for vendor accreditation has been reviewed for your approval.<br></p><br>" + sTxt + "<p>Very truly yours,<br><br><br> <strong>" + cfromName + "</strong></p><p> </p> <span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span></td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBodyforVendor(string cfromName, string ctoName, string cAuthenticationNumber, string cVendorName)
{
StringBuilder sb = new StringBuilder();
string sTxt = "<table border='1' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Vendor ID</strong></td>";
sTxt = sTxt + "<td> " + Session["VendorId"] + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Company Name</strong></td>";
sTxt = sTxt + "<td> " + cVendorName + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Authentication Ticket</strong></td>";
sTxt = sTxt + "<td> " + cAuthenticationNumber + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
sb.Append("<tr><td><p>Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br> To: " + ctoName + "<br><br> Good day!<br><br> Your application for accreditation will now undergo approval processes. You will be notified once approved or rejected.<br></p><br>" + sTxt + "<p>Very truly yours,<br><br><br> <strong>e-Sourcing Procurement</strong></p><p> </p> <span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span></td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody(string oVSFId, string oProjectName, string fromName, string toName)
{
StringBuilder sb = new StringBuilder();
string BuyersName1 = fromName;
string PurchasingName1 = toName;
//// Awarded To
//string sTxt = "<table border='1' style='font-size:12px'><tr>";
//sTxt = sTxt + "<td><strong> VSF Project Name</strong></td>";
//sTxt = sTxt + "</tr>";
//sTxt = sTxt + "<tr>";
//sTxt = sTxt + "<td>";
//sTxt = sTxt + " " + oProjectName + " ";
//sTxt = sTxt + "</td>";
//sTxt = sTxt + "<tr></table>";
////contents = contents.Replace("[BidAwardedTo]", sTxt);
//sb.Append("<tr><td align='right'><h5>" + DateTime.Now.ToLongDateString() + "</h5></td></tr>");
sb.Append("<tr><td><p><strong>VSF Clarified</strong> <br> Sent: " + DateTime.Now.ToLongDateString() + "</p> <p>From: " + BuyersName1 + "<br><br> To: " + PurchasingName1 + "<br><br> Subject: " + oProjectName + "<br><br> Dear VSF Approvers, <br><br> Re: Request for Vendor Shortlisting Form Approval – <strong>" + oProjectName + "</strong><br><br> This is to request for your Vendor Shortlisting Form Approval of the ff:<br><br> <b>VSF Reference Number:</b> " + oVSFId + "<br> <b>Project Name:</b> " + oProjectName + "<br></p> <p>Very truly yours,<br><br><br> <strong>e-Sourcing Procurement</strong></p><p> </p> <p><strong>Instructions:</strong></p> <ol> <li>Go to <a href='https://e-sourcing.Trans-Asia.com.ph/'>https://e-sourcing.Trans-Asia.com.ph</a></li> <li>Enter your Username and Password then click Login</li> <li>Unser Vendor Shortlisting Form, click View Endorsed</li> <li>Click VSF Reference No: " + oVSFId + "</li> <li>Review / Endorse / VSF for Awarding</li> <li>Click Clarify if you have clarification or click Approved to award VSF</li> </ol> Please do not reply to this auto-generated message. </td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
//private string CreateSMSInvitationBody(AuctionDetails auctiondetails, AuctionParticipant participant)
//{
// return String.Format("You are invited to participate in an auction event;Ref. No.:{0}, initiated by Trans-Asia . Start Date: {1}", auctiondetails.ID, auctiondetails.StartDateTime.ToString("MM/dd/yyyy hh:mm:ss tt"));
//}
private string CreateCancelAuctionBody(AuctionDetails auctiondetails, AuctionParticipant participant)
{
StringBuilder sb = new StringBuilder();
sb.Append("<tr><td style='width: 1px'></td><td style='width: auto' colspan=''></td><td style='width: 1px'></td></tr>");
sb.Append("<tr><td style='width: auto; height: 635px'></td>");
sb.Append("<td style='width: 100%; height: auto; text-align: justify;'>");
sb.Append("<br /><br /><br />");
sb.Append("" + DateTime.Now.ToLongDateString() + "");
sb.Append("<br /><br /><br /><strong>");
sb.Append(participant.Name);
sb.Append("<br /></strong>");
sb.Append("<br /><br />");
sb.Append("<table style='width: 100%'><tr><td style='width: 12px'>");
sb.Append("Auction Event:");
sb.Append("</td><td style='width: auto'>");
sb.Append(auctiondetails.Description);
sb.Append("</td></tr></table>");
sb.Append("<br /><br />");
sb.Append("Dear Sir/Madame:");
sb.Append("<br /><br />");
sb.Append("Thank you for confirming your participation on Trans-Asia / Commnunications Auction Invitation for ");
sb.Append("" + auctiondetails.Description + ", that is scheduled to start on ");
sb.Append("" + Convert.ToDateTime(auctiondetails.StartDateTime).ToLongDateString() + " " + Convert.ToDateTime(auctiondetails.StartDateTime).ToShortTimeString() + ", We regret to inform you, ");
sb.Append("however, that the subject Auction event has been cancelled.");
sb.Append("We will keep in mind your cooperation and commitment in helping us on this endeavor.");
sb.Append("<br /><br />");
sb.Append("We sincerely appreciate the time and effort you dedicated for the completion ");
sb.Append("of your response and we look forward to working with you again in the future.");
sb.Append("<br /><br /><br />");
sb.Append("Sincerely,");
sb.Append("<br /><br /><br /><br />");
sb.Append(auctiondetails.Sender);
sb.Append("<br /><br /><br /><br /></td><td style='width: auto; height: auto'></td></tr><tr><td style='width: auto'></td><td style='width: auto'></td><td style='width: auto'></td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
protected void btnSend_Click(object sender, EventArgs e)
{
SqlParameter[] sqlparams = new SqlParameter[1];
sqlparams[0] = new SqlParameter("@UserName", SqlDbType.NVarChar, 100);
sqlparams[0].Value = txtUserName2.Text.Trim();
DataTable dt;
try
{
SqlDataReader oReader;
string query;
string userPP = "", userEE = "";
SqlCommand cmd;
SqlConnection conn;
query = "sp_GetUserPasswordAndEmail";
using (conn = new SqlConnection(ConfigurationManager.ConnectionStrings["EBidConnectionString"].ConnectionString))
{
using (cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Username", txtUserName2.Text.Trim());
conn.Open();
oReader = cmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
userPP = oReader["Password"].ToString();
userEE = oReader["EmailAddress"].ToString();
}
}
}
}
//dt = SqlHelper.ExecuteDataset(connstring, "sp_GetUserPasswordAndEmail", sqlparams).Tables[0];
//string ePwd = dt.Rows[0]["Password"].ToString();
//string eAdd = dt.Rows[0]["EmailAddress"].ToString();
string ePwd = userPP;
string eAdd = userEE;
if (userPP == "" || userEE == "")
{
txtNote2.Text = "Username not found.";
}
else
{
string from = MailHelper.ChangeToFriendlyName(ConfigurationManager.AppSettings["AdminEmailName"], ConfigurationManager.AppSettings["AdminEmailAddress"]);
string to = eAdd;
string subject = "Trans-Asia : Password Request";
try
{
if (MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), from, to, subject,
MailTemplate.IntegrateBodyIntoTemplate(CreateRequestPasswordBody(ePwd)),
MailTemplate.GetTemplateLinkedResources(this)))
{
Session["msg"] = "Password sent!";
LogHelper.EventLogHelper.Log("User Login > Send Password : Email Sent to " + to, EventLogEntryType.Information);
}
else
{
Session["msg"] = "Password not sent this time.";
LogHelper.EventLogHelper.Log("User Login > Send Password : Sending Failed to " + to, EventLogEntryType.Error);
}
}
catch (Exception ex)
{
Session["msg"] = "Password not sent this time.";
LogHelper.EventLogHelper.Log("User Login > Send Password : "******"";
if (Session["msg"] != null)
{
txtNote2.Text = Session["msg"].ToString();
Session["msg"] = null;
}
}
}
catch (Exception ex)
{
LogHelper.EventLogHelper.Log("User Login : " + ex.Message, EventLogEntryType.Error);
}
}
private string CreateInvitationBody(AuctionDetails auctiondetails, AuctionParticipant participant)
{
StringBuilder sb = new StringBuilder();
sb.Append("<tr><td align='right'><h5>" + DateTime.Now.ToLongDateString() + "</h5></td></tr>");
sb.Append("<tr><td align='center'><h3>INVITATION TO AUCTION</h3></td></tr>");
sb.Append("<tr>");
sb.Append("<td valign='top'>");
sb.Append("<p>");
sb.Append("<b>TO  :  <u>" + participant.Name + "</u></b>");
sb.Append("<br /><br />");
sb.Append("Good Day!");
sb.Append("<br /><br />");
sb.Append("We are glad to inform you that you have been invited to participate in an online auction event which was initiated by Trans-Asia Incorporated.");
sb.Append("</p>");
sb.Append("<table style='font-size: 12px;width:100%;'>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>1.</td>");
sb.Append("<td style='font-weight:bold;'>Auction Description</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>" + auctiondetails.Description + "</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>2.</td>");
sb.Append("<td style='font-weight:bold;'>Schedule of Auction Event</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("Confirmation Deadline : " + FormattingHelper.FormatDateToString(auctiondetails.ConfirmationDeadline) + "<br />");
sb.Append("Start Date & Time : " + FormattingHelper.FormatDateToLongString(auctiondetails.StartDateTime) + "<br />");
sb.Append("End Date & Time : " + FormattingHelper.FormatDateToLongString(auctiondetails.EndDateTime) + "<br />");
sb.Append("Duration : " + auctiondetails.Duration + "<br />");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>3.</td>");
sb.Append("<td style='font-weight:bold;'>Payment Details</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("<ul>");
sb.Append("<li>Payment Terms</li>");
sb.Append("<ul><li>Trans-Asia shall pay supplier 10% Down Payment, Progress Billing.</li></ul>");
sb.Append("<br />");
sb.Append("<li>Billing Details</li>");
sb.Append("<ul>");
sb.Append("<li>Contact Person: Rose Soteco T# 730 2413</li>");
sb.Append("<li>Contact Details: 2F GT Plaza Tower 1, Pioneer cor Madison Sts., Mandaluyong City</li>");
sb.Append("</ul>");
sb.Append("</ul>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>4.</td>");
sb.Append("<td style='font-weight:bold;'>Bid Price Details</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>The bid price submitted by the supplier shall be exclusive of VAT.</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>5.</td>");
sb.Append("<td style='font-weight:bold;'>Price Validity</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("The price quoted must be valid and firm for a period of 30 days.");
sb.Append("No change in price quoted shall be allowed after bid submission unless negotiated by Trans-Asia .");
sb.Append("</td.");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>6.</td>");
sb.Append("<td style='font-weight:bold;'>Price Confirmation</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("All participants must submit the price breakdown according to the final bid price submitted during the e-BID event not later than 24 hours after the e-BIDding event has ended.");
sb.Append("The sum of the breakdown must be equal to the supplier's final bid price submitted during the e-BIDding event.");
sb.Append("Any attempt to submit a breakdown which totals significantlly higher or lower than the final bid price submitted during the event may be subject to sanctions from Trans-Asia .");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>7.</td>");
sb.Append("<td style='font-weight:bold;'>Grounds for Invalidating Bids</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("A supplier's bid may be invalidated under any of the following circumstances:");
sb.Append("<ul>");
sb.Append("<li>Incomplete bid documents</li>");
sb.Append("<li>Bid documents without bidder's signature</li>");
sb.Append("<li>Late submission of hard copy of bid price breakdown</li>");
sb.Append("</ul>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>8.</td>");
sb.Append("<td style='font-weight:bold;'>Awarding of Bid</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("The lowest/highest bidder is not necessarily the winning bidder. Trans-Asia shall not be bound to assign any reason for not accepting any bid or accepting it in part.");
sb.Append("Bids are still subject to further ecaluation. Trans-Asia shall award the winning supplier through a Purchase Order/Sales Order.");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>9.</td>");
sb.Append("<td style='font-weight:bold;'>Penalties (depends on the items to be purchased)</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("<ul>");
sb.Append("<li>10K - 49.99K</li>");
sb.Append("<li>50K - 99.99K</li>");
sb.Append("<li>100K - 199.99K</li>");
sb.Append("<li>200K - 299.99K</li>");
sb.Append("<li>300K - 499.99K</li>");
sb.Append("<li>500K - 999.99K</li>");
sb.Append("<li>1M - 1.999M</li>");
sb.Append("<li>2M - 19.999M</li>");
sb.Append("<li>20M and above</li>");
sb.Append("</ul>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("</table>");
sb.Append("<p>");
sb.Append("To know more about this auction, click <a href='" + ConfigurationManager.AppSettings["ServerUrl"] + "web/auctions/auctiondetails.aspx?aid=" + HttpUtility.UrlEncode(EncryptionHelper.Encrypt(auctiondetails.ID.ToString())) + "' target='_blank'>here</a>. ");
sb.Append("<br />");
sb.Append("To confirm/decline your invitation, click <a href='" + ConfigurationManager.AppSettings["ServerUrl"] + "web/auctions/confirmauctionevent.aspx?aid=" + HttpUtility.UrlEncode(EncryptionHelper.Encrypt(auctiondetails.ID.ToString())) + "' target='_blank'>here</a>.");
sb.Append("<br />");
sb.Append("<a href='" + ConfigurationManager.AppSettings["ServerUrl"] + "rules.htm' target='_blank' title='Click here or copy the link'>Rules and Regulations</a> : " + ConfigurationManager.AppSettings["ServerUrl"] + "rules.htm");
sb.Append("<br /><br />");
sb.Append("######################################################################################<br />");
sb.Append(" Credentials:<br />");
sb.Append(" Username: "******"<br />");
sb.Append(" Ticket: " + EncryptionHelper.Decrypt(participant.EncryptedTicket) + "<br /><br />");
sb.Append(" Notes:<br />");
sb.Append(" Ticket and password are CASE SENSITIVE.<br />");
sb.Append(" Ticket is for confirming/declining/participating an auction.<br />");
sb.Append(" Ticket is different for each supplier for each auction event.<br />");
sb.Append(" Password is for login.<br />");
sb.Append(" Username is NOT CASE SENSITIVE.<br />");
sb.Append(" If you don't know or forgot your password, go to eBid login page and click forgot password.<br />");
sb.Append(" Use the username provided. Click Send. Your password will be sent to this email address.<br />");
sb.Append("######################################################################################<br />");
sb.Append("<br /><br /><br />");
sb.Append("Sincerely Yours,");
sb.Append("<br /><br />");
sb.Append(auctiondetails.Creator);
sb.Append("<br /><br />");
sb.Append("</p>");
sb.Append("</td>");
sb.Append("</tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody(string cfromName, string ctoName, string cAuthenticationNumber, string cVendorName, string VendorIdx)
{
SqlDataReader oReader;
string connstring = ConfigurationManager.ConnectionStrings["AVAConnectionString"].ConnectionString;
string cCeo = "", cCeoEmail = "", cAddress = "", cServices = "", cAccreDuration = "";
query = "SELECT * FROM tblVendorInformation WHERE VendorId = @VendorId";
using (conn = new SqlConnection(connstring))
{
using (cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@VendorId", Convert.ToInt32(VendorIdx));
conn.Open();
//Process results
oReader = cmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
cCeo = oReader["conBidName"].ToString();
cCeoEmail = oReader["conBidEmail"].ToString();
cAddress = oReader["regBldgCode"].ToString() != "" ? cAddress + "Bldg. " + oReader["regBldgCode"].ToString() + ", " : cAddress + "";
cAddress = oReader["regBldgRoom"].ToString() != "" ? cAddress + "Rm. " + oReader["regBldgRoom"].ToString() + ", " : cAddress + "";
cAddress = oReader["regBldgFloor"].ToString() != "" ? cAddress + oReader["regBldgFloor"].ToString() + " Fr, " : cAddress + "";
cAddress = oReader["regBldgHouseNo"].ToString() != "" ? cAddress + "No. " + oReader["regBldgHouseNo"].ToString() + " " : cAddress + "";
cAddress = oReader["regStreetName"].ToString() != "" ? cAddress + oReader["regStreetName"].ToString() + ", " : cAddress + "";
cAddress = cAddress + "<br>";
cAddress = oReader["regCity"].ToString() != "" ? cAddress + oReader["regCity"].ToString() + ", " : cAddress + "";
cAddress = oReader["regProvince"].ToString() != "" ? cAddress + oReader["regProvince"].ToString() + ", " : cAddress + "";
cAddress = cAddress + "<br>";
cAddress = oReader["regCountry"].ToString() != "" ? cAddress + oReader["regCountry"].ToString() + ", " : cAddress + "";
cAddress = oReader["regPostal"].ToString() != "" ? cAddress + oReader["regPostal"].ToString() + " " : cAddress + "";
}
}
}
}
query = "SELECT t1.*, t2.CategoryName, t3.SubCategoryName FROM tblVendorProductsAndServices t1, rfcProductCategory t2, rfcProductSubcategory t3 WHERE t2.CategoryId = t1.CategoryId AND t3.SubCategoryId = t1.SubCategoryId AND t1.VendorId = @VendorId";
using (conn = new SqlConnection(connstring))
{
using (cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@VendorId", Convert.ToInt32(VendorIdx));
conn.Open();
//Process results
oReader = cmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
cServices = cServices + "• " + oReader["CategoryName"].ToString() + " - " + oReader["SubCategoryName"].ToString() + "<br>";
}
}
}
}
query = "SELECT * FROM tblVendorApprovalbyVmReco WHERE VendorId = @VendorId";
using (conn = new SqlConnection(connstring))
{
using (cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@VendorId", Convert.ToInt32(VendorIdx));
conn.Open();
//Process results
oReader = cmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
cAccreDuration = oReader["AccreDuration"].ToString();
}
}
}
}
StringBuilder sb = new StringBuilder();
string sTxt = "<table border='1' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Vendor ID</strong></td>";
sTxt = sTxt + "<td> " + VendorIdx + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Company Name</strong></td>";
sTxt = sTxt + "<td> " + cVendorName + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Date: " + DateTime.Now.ToLongDateString() + "<br><br>");
sb.Append(cCeo + "<br>");
sb.Append("<b>" + cVendorName + "</b><br>");
sb.Append(cAddress + "<br><br>");
sb.Append("</p>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Dear " + cCeo + ":<br><br>");
sb.Append("Please consider this email as reminders to renew/update your accreditation status with Trans-Asia.<br><br>");
sb.Append("Looking forward for your compliance on this request before your accreditation expired. Failure to comply will temporarily suspend your company to participate on any upcoming bid events.<br><br>");
sb.Append("We encourage you to renew your accreditation and continue to be a business partner of Trans-Asia.<br><br>");
sb.Append("Hope to receive positive response from your end.<br><br>");
sb.Append("Please get in touch with Marife Pablo of Vendor Management for any clarifications.<br><br>");
sb.Append(sTxt);
sb.Append("</p>");
sb.Append("<br><br><br>");
sb.Append("Sincerely,<br><br>");
sb.Append("Trans-Asia<br><br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p><span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span>");
sb.Append("</td></tr>");
//Response.Write(sb.ToString());
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody(string cfromName, string ctoName, string cAuthenticationNumber, string cVendorName, string VendorIdx, string Username, string Password)
{
SqlDataReader oReader;
string connstring = ConfigurationManager.ConnectionStrings["AVAConnectionString"].ConnectionString;
string cCeo = "", cCeoEmail = "", cAddress = "", cServices = "", cAccreDuration = "";
query = "SELECT * FROM tblVendorInformation WHERE VendorId = @VendorId";
//query = "sp_GetVendorInformation"; //##storedProcedure
using (conn = new SqlConnection(connstring))
{
using (cmd = new SqlCommand(query, conn))
{
//cmd.CommandType = CommandType.StoredProcedure; //##storedProcedure
cmd.Parameters.AddWithValue("@VendorId", Convert.ToInt32(VendorIdx));
conn.Open();
//Process results
oReader = cmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
cCeo = oReader["conBidName"].ToString();
cCeoEmail = oReader["conBidEmail"].ToString();
cAddress = oReader["regBldgBldg"].ToString() != "" ? cAddress + "Bldg. " + oReader["regBldgBldg"].ToString() + ", " : cAddress + "";
cAddress = oReader["regBldgUnit"].ToString() != "" ? cAddress + "Rm. " + oReader["regBldgUnit"].ToString() + ", " : cAddress + "";
cAddress = oReader["regBldgLotNo"].ToString() != "" ? cAddress + oReader["regBldgLotNo"].ToString() + ", " : cAddress + "";
cAddress = oReader["regBldgBlock"].ToString() != "" ? cAddress + oReader["regBldgBlock"].ToString() + ", " : cAddress + "";
cAddress = oReader["regBldgPhase"].ToString() != "" ? cAddress + oReader["regBldgPhase"].ToString() + ", " : cAddress + "";
cAddress = oReader["regBldgHouseNo"].ToString() != "" ? cAddress + "No. " + oReader["regBldgHouseNo"].ToString() + ", " : cAddress + "";
cAddress = oReader["regBldgStreet"].ToString() != "" ? cAddress + oReader["regBldgStreet"].ToString() + ", " : cAddress + "";
cAddress = oReader["regBldgSubd"].ToString() != "" ? cAddress + oReader["regBldgSubd"].ToString() + ", " : cAddress + "";
cAddress = oReader["regBrgy"].ToString() != "" ? cAddress + oReader["regBrgy"].ToString() + ", " : cAddress + "";
cAddress = cAddress + "<br>";
cAddress = oReader["regCity"].ToString() != "" ? cAddress + oReader["regCity"].ToString() + ", " : cAddress + "";
cAddress = oReader["regProvince"].ToString() != "" ? cAddress + oReader["regProvince"].ToString() + ", " : cAddress + "";
cAddress = cAddress + "<br>";
cAddress = oReader["regCountry"].ToString() != "" ? cAddress + oReader["regCountry"].ToString() + ", " : cAddress + "";
cAddress = oReader["regPostal"].ToString() != "" ? cAddress + oReader["regPostal"].ToString() + " " : cAddress + "";
}
}
}
}
conn.Close();
//Response.Write(VendorIdx);
//query = "SELECT t1.*, t2.CategoryName FROM tblVendorProductsAndServices t1, rfcProductCategory t2 WHERE t2.CategoryId = t1.CategoryId AND t1.VendorId = @VendorId";
query = "SELECT t1.*, t2.CategoryName, t3.SubCategoryName FROM tblVendorProductsAndServices t1, rfcProductCategory t2, rfcProductSubcategory t3 WHERE t2.CategoryId = t1.CategoryId AND t3.SubCategoryId = t1.SubCategoryId AND t1.VendorId = @VendorId";
//query = "sp_GetVendorInformation"; //##storedProcedure
using (conn = new SqlConnection(connstring))
{
using (cmd = new SqlCommand(query, conn))
{
//cmd.CommandType = CommandType.StoredProcedure; //##storedProcedure
cmd.Parameters.AddWithValue("@VendorId", Convert.ToInt32(VendorIdx));
conn.Open();
//Process results
oReader = cmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
//cServices = cServices + "• " + oReader["CategoryName"].ToString() + "<br>";
cServices = cServices + "• " + oReader["CategoryName"].ToString() + " - " + oReader["SubCategoryName"].ToString() + "<br>";
}
}
}
}
conn.Close();
query = "SELECT * FROM tblVendorApprovalbyVmReco WHERE VendorId = @VendorId";
//query = "sp_GetVendorInformation"; //##storedProcedure
using (conn = new SqlConnection(connstring))
{
using (cmd = new SqlCommand(query, conn))
{
//cmd.CommandType = CommandType.StoredProcedure; //##storedProcedure
cmd.Parameters.AddWithValue("@VendorId", Convert.ToInt32(VendorIdx));
conn.Open();
//Process results
oReader = cmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
cAccreDuration = oReader["AccreDuration"].ToString();
//Response.Write(cAccreDuration);
}
}
}
}
conn.Close();
StringBuilder sb = new StringBuilder();
string sTxt = "<table border='1' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> UserName</strong></td>";
sTxt = sTxt + "<td> " + Username + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Temporary Password</strong></td>";
sTxt = sTxt + "<td> " + Password + " </td>";
sTxt = sTxt + "</tr>";
//sTxt = sTxt + "<tr>";
//sTxt = sTxt + "<td><strong> Authentication Ticket</strong></td>";
//sTxt = sTxt + "<td> " + cAuthenticationNumber + " </td>";
//sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
//sb.Append("<tr><td><p>Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br> To: " + ctoName + "<br><br> Congratulations!<br><br> This is to inform you that application for vendor accreditation has been approved.<br></p><br>" + sTxt + "<p>Very truly yours,<br><br><br> <strong>" + cfromName + "</strong></p><p> </p> <span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span></td></tr>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Date: " + DateTime.Now.ToLongDateString() + "<br><br>");
sb.Append(cCeo + "<br>");
sb.Append("<b>" + cVendorName + "</b><br>");
sb.Append(cAddress + "<br><br>");
sb.Append("</p>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Dear " + cCeo + ":<br><br>");
sb.Append("We are pleased to inform you that Trans-Asia Vendor Management has approved your accreditation.<br><br>");
//sb.Append("We are pleased to inform you that Trans-Asia Vendor Management has approved your accreditation for the following:<br><br>");
//sb.Append("<b>PRODUCTS/SERVICES OFFERED : </b><br>");
//sb.Append(cServices + "<br><br><br>");
sb.Append("Please inform us immediately should there be any change in your products and services, organization, management, ownership, contact numbers, address and other material information which will affect our business relationship.<br><br>");
sb.Append("This certification is valid for " + cAccreDuration + " from date of issuance. Trans-Asia reserves the right to invite and select suppliers, determine allocation and volume of orders in accordance with the company's procurement policies and objectives. Trans-Asia is also not committed to place an order upon accreditation. <br><br>");
sb.Append("Your continuing status as an accredited supplier of Trans-Asia depends on your performance as a vendor/service provider subject to regular review and your compliance to company requirements. Consequently, Trans-Asia reserves the right to invite and require you to undergo an accreditation renewal process 60 days prior to the lapse of the " + cAccreDuration + " period.<br><br>");
sb.Append("As part of Trans-Asia's program for good governance, we would like to take this opportunity to remind you, our business partner, of Trans-Asia's Gifts and Inducement Policy. Our policy strongly prohibits Trans-Asia employees from soliciting gifts from business partners; and conversely prohibits business partners from giving Trans-Asia employees gifts of any kind in consideration of business, or as an inducement for the award of business. <br><br>");
sb.Append("We congratulate you and we look forward to a mutually beneficial and long-lasting business relationship with you. <br><br>");
sb.Append("Please click the link below and login using the provided username and password for Trans-Asia e-Sourcing System. <br><br>");
sb.Append("<a href='http://vm2008:300/'>http://vm2008:300/</a><br><br>");
sb.Append(sTxt);
sb.Append("</p>");
sb.Append("<br><br><br><br>");
sb.Append("Very truly yours,<br><br>");
sb.Append("<b>Honesto P. Oliva</b><br>");
sb.Append("Head - Vendor Management<br><br>");
//sb.Append("<b>Trans-Asia Admin<br><br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p><span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span>");
sb.Append("</td></tr>");
//Response.Write(sb.ToString());
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBody(string cfromName, string ctoName, string cAuthenticationNumber, string cVendorName)
{
SqlDataReader oReader;
string cServices = "";
query = "SELECT t1.*, t2.CategoryName FROM tblVendorProductsAndServices t1, rfcProductCategory t2 WHERE t2.CategoryId = t1.CategoryId AND t1.VendorId = @VendorId";
//query = "sp_GetVendorInformation"; //##storedProcedure
using (conn = new SqlConnection(connstring))
{
using (cmd = new SqlCommand(query, conn))
{
//cmd.CommandType = CommandType.StoredProcedure; //##storedProcedure
cmd.Parameters.AddWithValue("@VendorId", Convert.ToInt32(Session["VendorId"]));
conn.Open();
//Process results
oReader = cmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
cServices = cServices + "• " + oReader["CategoryName"].ToString() + "<br>";
}
}
}
}
conn.Close();
StringBuilder sb = new StringBuilder();
string sTxt = "<table border='1' style='font-size:12px'>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Vendor ID</strong></td>";
sTxt = sTxt + "<td> " + Session["VendorId"] + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Company Name</strong></td>";
sTxt = sTxt + "<td> " + cVendorName + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td><strong> Category</strong></td>";
sTxt = sTxt + "<td> " + cServices + " </td>";
sTxt = sTxt + "</tr>";
sTxt = sTxt + "</table>";
//sb.Append("<tr><td><p>Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br> To: " + ctoName + "<br><br> Good day!<br><br> This is to inform you that application for vendor accreditation has been reviewed for your approval.<br></p><br>" + sTxt + "<p>Very truly yours,<br><br><br> <strong>" + cfromName + "</strong></p><p> </p> <span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span></td></tr>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Sent: " + DateTime.Now.ToLongDateString() + "<br>From: " + cfromName + "<br>");
sb.Append("To: " + ctoName + "<br><br>");
sb.Append("</p>");
sb.Append("<tr><td>");
sb.Append("<p>");
sb.Append("Dear " + ctoName + ":<br><br>");
sb.Append("Re: Request for Vendor Accreditation Approval -- " + cVendorName + "<br><br>");
sb.Append("This is to request for your Approval of the ff: <br><br>");
//sb.Append("<a href='http://'<br><br>");
sb.Append(sTxt);
sb.Append("</p><br><br>");
//sb.Append("We are happy to be doing business with you. Thank you and God bless your dealings.<br><br><br>");
sb.Append("Very truly yours,<br><br>");
sb.Append("Trans-Asia<br><br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p>");
sb.Append("<b>Instructions:</b><br>");
sb.Append(" 1. Go to <a href='" + System.Configuration.ConfigurationManager.AppSettings["ServerUrl"] + "' target='_blank'>" + System.Configuration.ConfigurationManager.AppSettings["ServerUrl"] + "</a><br>");
sb.Append(" 2. Enter your Username and Password then click Login<br>");
sb.Append(" 3. Click Vendors for Approval<br>");
sb.Append(" 4. Click View<br>");
sb.Append("</td></tr>");
sb.Append("<tr><td>");
sb.Append("<p> </p><span style='font-size:10px; font-style:italic;'>Please do not reply to this auto-generated message. </span>");
sb.Append("</td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBodyAwarded()
{
StringBuilder sb = new StringBuilder();
string sCommand;
string BuyersName1 = "";
string ApproverName1 = "";
string connstring = HttpContext.Current.Session["ConnectionString"].ToString();
SqlDataReader oReader;
sCommand = "SELECT t1.BuyerFirstName + ' ' + t1.BuyerMidName + ' ' + t1.BuyerLastName AS Name1 FROM tblBuyers t1, tblBacBidItems t2 WHERE t1.BuyerID=t2.BuyerId AND t2.BidRefNo=" + Session["BuyerBidForBac"];
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
BuyersName1 = oReader["Name1"].ToString();
}
oReader.Close();
sCommand = "SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t1.EmailAdd FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_1 AND t2.BidRefNo = " + Session["BuyerBidForBac"];
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
ApproverName1 = oReader["Name1"].ToString();
}
oReader.Close();
// Awarded To
string sTxt = "<table border='1' style='font-size:12px'><tr>";
sTxt = sTxt + "<td><strong> Item #</strong></td>";
sTxt = sTxt + "<td><strong> Item Details</strong></td>";
sTxt = sTxt + "<td><strong> Vendor Name</strong></td>";
sTxt = sTxt + "<td><strong> Qty</strong></td>";
sTxt = sTxt + "<td><strong> Total</strong></td>";
sTxt = sTxt + "<td><strong> Ranking</strong></td>";
sTxt = sTxt + "</tr>";
sCommand = "SELECT BidDetailNo, ItemName, VendorName, Qty, CONVERT(VARCHAR(20), CONVERT(MONEY, TotalCost), 1) TotalCost, Ranking ";
sCommand = sCommand + "FROM tblBACEvaluationDetails WHERE BidRefNo=" + Session["BuyerBidForBac"] + " AND Chkd=1";
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
while (oReader.Read())
{
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["BidDetailNo"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["ItemName"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["VendorName"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["Qty"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["TotalCost"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["Ranking"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "</tr>";
}
}
oReader.Close();
sTxt = sTxt + "<tr></table>";
// Approvers
string oApprovers = "";
sCommand = "select BACId, NAME1, ApprovingLimit, ApprovedDt from ( SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_1 ApprovedDt, 1 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_1 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_2 ApprovedDt, 2 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_2 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_3 ApprovedDt, 3 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_3 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_4 ApprovedDt, 4 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_4 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_5 ApprovedDt, 5 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_5 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_6 ApprovedDt, 6 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_6 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_7 ApprovedDt, 7 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_7 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_8 ApprovedDt, 8 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_8 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_9 ApprovedDt, 9 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_9 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_10 ApprovedDt, 10 AS ApprovingLimit FROM tblBidAwardingCommittee t1, tblBacBidItems t2 WHERE t1.BACId = t2.Approver_10 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.PurchasingID BACId, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t2.ApprovedDt_0 ApprovedDt, 0 AS ApprovingLimit FROM tblPurchasing t1, tblBacBidItems t2 WHERE t1.PurchasingID=t2.Approver_0 AND t2.BidRefNo = " + Session["BuyerBidForBac"] + ") as table_1 order by ApprovingLimit";
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
while (oReader.Read())
{
if (oReader["ApprovingLimit"].ToString() == "0")
{
oApprovers = oApprovers + "Purchasing: " + oReader["Name1"].ToString() + "<br>";
}
else
{
oApprovers = oApprovers + "Approver " + oReader["ApprovingLimit"].ToString() + ": " + oReader["Name1"].ToString() + "<br>";
}
}
}
oReader.Close();
string ItemDesc = "";
sCommand = "SELECT ItemDesc FROM tblBacBidItems WHERE BidRefNo=" + Session["BuyerBidForBac"];
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
ItemDesc = oReader["ItemDesc"].ToString();
}
oReader.Close();
sb.Append("<tr><td><p><strong>BAC Approved to Award</strong> <br> Sent: " + DateTime.Now.ToLongDateString() + "</p> <p>From: " + BuyersName1 + "<br><br> To: " + BuyersName1 + "<br><br> Dear " + BuyersName1 + ", <br><br> Re: Approved to Award – <strong>" + ItemDesc + "</strong><br><br> We are pleased to inform you that your Bid for Award was approved as follows:<br><br> <b>Bid Reference Number:</b> " + Session["BuyerBidForBac"] + "<br> <b>Bid Event Name:</b> " + ItemDesc + "<br> </p> " + sTxt + " <p>Very truly yours,<br><br><br> <strong>" + oApprovers + "</strong></p><p> </p> Please do not reply to this auto-generated message. </td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateNotificationBodyApprove()
{
StringBuilder sb = new StringBuilder();
string sCommand;
string BuyersName1 = "";
string ApproverName1 = "";
string connstring = HttpContext.Current.Session["ConnectionString"].ToString();
SqlDataReader oReader;
//GET BUYER EMAIL AS THE SENDER
//sCommand = "SELECT t1.BuyerFirstName + ' ' + t1.BuyerMidName + ' ' + t1.BuyerLastName AS Name1 FROM tblBuyers t1, tblBacBidItems t2 WHERE t1.BuyerID=t2.BuyerId AND t2.BidRefNo=" + Session["BuyerBidForBac"];
//GET BUYER EMAIL AS THE SENDER
sCommand = "SELECT Name1, EmailAdd FROM ( ";
sCommand = sCommand + "SELECT t1.BuyerID UserId, t1.BuyerFirstName + ' ' + t1.BuyerMidName + ' ' + t1.BuyerLastName AS Name1, t1.EmailAdd FROM tblBuyers t1, tblBacBidItems t2 WHERE t1.BuyerID=t2.BuyerId AND t2.BidRefNo=" + Session["BuyerBidForBac"] + " ";
sCommand = sCommand + "union ";
sCommand = sCommand + "SELECT t1.PurchasingID UserId, t1.FirstName + ' ' + t1.MiddleName + ' ' + t1.LastName AS Name1, t1.EmailAdd FROM tblPurchasing t1 ";
sCommand = sCommand + "union ";
sCommand = sCommand + "SELECT t1.BACID UserId, t1.FirstName + ' ' + t1.MiddleName + ' ' + t1.LastName AS Name1, t1.EmailAdd FROM tblBidAwardingCommittee t1 ) t2 ";
sCommand = sCommand + "WHERE UserId = (select TOP 1 ToUserId from tblBacClarifications where BidRefNo = " + Session["BuyerBidForBac"] + " ORDER BY ID desc)";
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
BuyersName1 = oReader["Name1"].ToString();
}
oReader.Close();
sCommand = "SELECT FirstName+ ' ' + MiddleName + ' '+LastName as Name1, EmailAdd from tblBidAwardingCommittee where BACId=" + Session["ClarifiedBy"];
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
ApproverName1 = oReader["Name1"].ToString();
}
oReader.Close();
// Awarded To
string sTxt = "<table border='1' style='font-size:12px'><tr>";
sTxt = sTxt + "<td><strong> Item #</strong></td>";
sTxt = sTxt + "<td><strong> Item Details</strong></td>";
sTxt = sTxt + "<td><strong> Vendor Name</strong></td>";
sTxt = sTxt + "<td><strong> Qty</strong></td>";
sTxt = sTxt + "<td><strong> Total</strong></td>";
sTxt = sTxt + "<td><strong> Ranking</strong></td>";
sTxt = sTxt + "</tr>";
sCommand = "SELECT BidDetailNo, ItemName, VendorName, Qty, CONVERT(VARCHAR(20), CONVERT(MONEY, TotalCost), 1) TotalCost, Ranking ";
sCommand = sCommand + "FROM tblBACEvaluationDetails WHERE BidRefNo=" + Session["BuyerBidForBac"] + " AND Chkd=1";
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
while (oReader.Read())
{
sTxt = sTxt + "<tr>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["BidDetailNo"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["ItemName"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["VendorName"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["Qty"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["TotalCost"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "<td>";
sTxt = sTxt + " " + oReader["Ranking"].ToString() + " ";
sTxt = sTxt + "</td>";
sTxt = sTxt + "</tr>";
}
}
sTxt = sTxt + "<tr></table>";
string ItemDesc = "";
sCommand = "SELECT ItemDesc FROM tblBacBidItems WHERE BidRefNo=" + Session["BuyerBidForBac"];
oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand);
if (oReader.HasRows)
{
oReader.Read();
ItemDesc = oReader["ItemDesc"].ToString();
}
oReader.Close();
//sb.Append("<tr><td align='right'><h5>" + DateTime.Now.ToLongDateString() + "</h5></td></tr>");
sb.Append("<tr><td><p><strong>BAC for Approval</strong> <br> Sent: " + DateTime.Now.ToLongDateString() + "</p> <p>From: " + BuyersName1 + "<br><br> To: " + ApproverName1 + "<br><br> Subject: " + ItemDesc + "<br><br> Dear Bid Award Approvers, <br><br> Re: Request for Bid Award Approval – <strong>" + ItemDesc + "</strong><br><br> This is to request for your Bid Award Approval of the ff:<br><br> <b>Bid Reference Number:</b> " + Session["BuyerBidForBac"] + "<br> <b>Bid Event Name:</b> " + ItemDesc + "<br> </p> <p>Very truly yours,<br><br><br> <strong>e-Sourcing Procurement</strong></p><p> </p> <p><strong>Instructions:</strong></p> <ol> <li>Go to <a href='https://e-sourcing.Trans-Asia.com.ph/'>https://e-sourcing.Trans-Asia.com.ph</a></li> <li>Enter your Username and Password then click Login</li> <li>Click Received Bid Events for Awarding</li> <li>Click Bid Events Name</li> <li>Review / Endorse / Approve Bid event for Awarding</li> <li>Click Clarify if you have clarification or click Approved to award Bid Events</li> </ol> Please do not reply to this auto-generated message. </td></tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
protected void btnForgotPwd_Click(object sender, EventArgs e)
{
DataTable dt;
SqlParameter[] sqlparams = new SqlParameter[1];
sqlparams[0] = new SqlParameter("@UserName", SqlDbType.NVarChar, 100);
sqlparams[0].Value = txtUserName.Text.Trim();
try
{
dt = SqlHelper.ExecuteDataset(connString, "sp_GetUserPasswordAndEmail", sqlparams).Tables[0];
string Pwd = dt.Rows[0]["Password"].ToString();
string EmailAdd = dt.Rows[0]["EmailAddress"].ToString();
if (Pwd.Equals("NONE") || EmailAdd.Equals("NONE"))
{
txtNote.Text = "Username not found.";
}
else
{
string from = MailHelper.ChangeToFriendlyName(ConfigurationManager.AppSettings["AdminEmailName"], ConfigurationManager.AppSettings["AdminEmailAddress"]);
string to = EmailAdd;
string subject = "Globe Telecom Vendor Accreditation : Password Request";
try
{
if (MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), from, to, subject, MailTemplate.IntegrateBodyIntoTemplate(CreateRequestPasswordBody(Pwd)), MailTemplate.GetTemplateLinkedResources(this)))
{
txtNote.Text = "Password sent!";
}
else
{
txtNote.Text = "Password not sent this time.";
}
}
catch
{
txtNote.Text = "Password not sent this time.";
}
txtUserName.Text = "";
}
}
catch (Exception ex)
{
txtNote.Text = ex.Message.ToString();
}
}
private string CreateBodyWithdrawn(
string vendorname,
string vendorAddress,
string vendorAddress1,
string vendorAddress2,
string vendorAddress3,
string vendorcontactperson,
string vendorphone,
string vendorfax
)
{
String b_Event = ((Label)((DetailsView)Biddetails_details1.FindControl("dvEventDetails")).Rows[1].Cells[1].FindControl("lblItemDesc")).Text;
String b_Item = ((Label)(gvBidItemDetails.Rows[0].Cells[0].FindControl("lblDescription"))).Text;
StringBuilder sb = new StringBuilder();
#region WITHDRAWN EMAIL BODY
sb.Append("<tr><td style='width: 1px'></td><td style='width: auto' colspan=''></td><td style='width: 1px'></td></tr>");
sb.Append("<tr><td style='width: auto; height: 635px'></td>");
sb.Append("<td style='width: 100%; height: auto; text-align: justify;'>");
sb.Append("<br /><br /><br />");
sb.Append("" + DateTime.Now.ToLongDateString() + "");
sb.Append("<br /><br /><br /><strong>");
sb.Append(vendorname.Trim());
sb.Append("<br /></strong>");
sb.Append(vendorAddress.Trim());
sb.Append("<br />");
sb.Append(vendorAddress1.Trim());
sb.Append("<br />");
sb.Append(vendorAddress2.Trim());
sb.Append("<br />");
sb.Append(vendorAddress3.Trim());
sb.Append("<br /><br />");
sb.Append("<table style='width: 100%'><tr><td style='width: 1px; height: 8px'>Attention :</td><td style='width: 548px; height: 8px'><strong>");
sb.Append(vendorcontactperson.Trim());
sb.Append("</strong></td><td style='width: 1px; height: 8px'></td></tr><tr><td style='width: 1px'></td><td style='width: 548px'>");
sb.Append(vendorAddress.Trim());
sb.Append("</td><td style='width: 1px'></td></tr><tr><td style='width: 1px'></td><td style='width: 548px'>");
sb.Append(vendorAddress1.Trim());
sb.Append("</td><td style='width: 1px'></td></tr><tr><td style='width: 1px'></td><td style='width: 548px'>");
sb.Append(vendorAddress2.Trim());
sb.Append("</td><td style='width: 1px'></td></tr><tr><td style='width: 1px'></td><td style='width: 548px'>");
sb.Append(vendorAddress3.Trim());
sb.Append("</td><td style='width: 1px'></td></tr></table>");
sb.Append("<br /><br />");
sb.Append("<table style='width: 100%'><tr><td style='width: 12px'>");
sb.Append("Bid Event:");
sb.Append("</td><td style='width: auto'>");
sb.Append(b_Event);
sb.Append("</td></tr><tr><td style='width: 12px'>");
sb.Append("Bid Item:");
sb.Append("</td><td style='width: auto'>");
sb.Append(b_Item);
sb.Append("</td></tr></table>");
sb.Append("<br /><br />");
sb.Append("Dear Sir:");
sb.Append("<br /><br />");
sb.Append("Thank you for your interest to help Trans-Asia / Commnunications in finding a solution for ");
sb.Append("" + b_Event + ". It certainly was a pleasure to ");
sb.Append("have worked with your company during the RFP and the succeeding clarificatory discussions.");
sb.Append("<br /><br />");
sb.Append("We regret to inform you that " + b_Item + " has been withdrawn. We will, however, keep in mind your cooperation ");
sb.Append("and commitment when we have the opportunity to implement other projects. ");
sb.Append("<br /><br />");
sb.Append("We sincerely appreciate the time and effort you dedicated for the completion of ");
sb.Append("this RFP and we look forward to working with you again in the future.");
sb.Append("<br /><br /><br />");
sb.Append("Sincerely,");
sb.Append("<br /><br /><br /><br />");
sb.Append(Session[Constant.SESSION_USERFULLNAME].ToString());
sb.Append("<br />");
sb.Append("Head, Corporate Procurement Department");
sb.Append("<br /><br /><br /><br /></td><td style='width: auto; height: auto'></td></tr><tr><td style='width: auto'></td><td style='width: auto'></td><td style='width: auto'></td></tr>");
#endregion
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}
private string CreateInvitationBody(BidDetails biddetails, BidParticipant participant)
{
StringBuilder sb = new StringBuilder();
sb.Append("<tr><td align='left'><h5>" + DateTime.Now.ToLongDateString() + "</h5></td></tr>");
sb.Append("<tr><td align='left'><h3>INVITATION TO BID</h3></td></tr>");
sb.Append("<tr>");
sb.Append("<td valign='top'>");
sb.Append("<p>");
sb.Append("<b>TO: <u>" + participant.Name + "</u></b>");
sb.Append("<br /><br />");
sb.Append("Good Day!");
sb.Append("<br /><br />");
sb.Append("We are glad to inform you that you have been invited to participate in an online bidding event which was initiated by Trans-Asia");
sb.Append("</p>");
sb.Append("<table style='font-size: 12px;width:100%;'>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>1.</td>");
sb.Append("<td style='font-weight:bold;'>Bid Description</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>" + biddetails.Description + "</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>2.</td>");
sb.Append("<td style='font-weight:bold;'>Schedule of Bid</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("Submission Deadline : " + biddetails.SubmissionDeadline + "<br />");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>3.</td>");
sb.Append("<td style='font-weight:bold;'>Payment Details</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("<ul>");
sb.Append("<li>Payment Terms - indicate applicable terms.</li>");
// Commented by Angel 10/22/2008 :: requested by Sir Seth
//sb.Append("<br />");
//sb.Append("<li>Billing Details</li>");
//sb.Append("<ul>");
//sb.Append("<li>Contact Person: Rose Soteco T# 730 2413</li>");
//sb.Append("<li>Contact Details: 2F GT Plaza Tower 1, Pioneer cor Madison Sts., Mandaluyong City</li>");
//sb.Append("</ul>");
sb.Append("</ul>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>4.</td>");
sb.Append("<td style='font-weight:bold;'>Bid Price Details</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>The bid price submitted by the supplier shall be exclusive of VAT.</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>5.</td>");
sb.Append("<td style='font-weight:bold;'>Price Validity</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("The price quoted must be valid and firm for a period of 90 days.");
sb.Append("No change in price quoted shall be allowed after bid submission unless negotiated by Trans-Asia");
sb.Append("</td.");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>6.</td>");
sb.Append("<td style='font-weight:bold;'>Price Confirmation</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("Responses to the Invitation to Bid/Tender shall be sent by the vendors using the e-Sourcing Portal.");
sb.Append("Price schedules (details) and other attachments shall be in Acrobat Format(i.e. PDF),");;
sb.Append("or in any password-protected file (e.g. MS Word, Excel)");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>7.</td>");
sb.Append("<td style='font-weight:bold;'>Grounds for Invalidating Bids</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("A supplier's bid may be invalidated under any of the following circumstances:");
sb.Append("<ul>");
sb.Append("<li>Incomplete bid documents</li>");
sb.Append("<li>Scanned Summary documents without bidder's signature</li>");
sb.Append("</ul>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>8.</td>");
sb.Append("<td style='font-weight:bold;'>Awarding of Bid</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td width='30px' colspan='2'></td>");
sb.Append("<td>");
sb.Append("The lowest/highest bidder is not necessarily the winning bidder. Trans-Asia shall not be bound to assign any reason for not accepting any bid or accepting it in part.");
sb.Append("Bids are still subject to further ecaluation. Trans-Asia shall award the winning supplier through a Purchase Order.");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("<tr>");
sb.Append("<td width='10px'></td>");
sb.Append("<td style='font-weight:bold;width:20px;'>9.</td>");
sb.Append("<td style='font-weight:bold;'>Penalties (depends on the items to be purchased)</td>");
sb.Append("</tr>");
sb.Append("<tr><td height='10px' colspan='3'></td></tr>");
sb.Append("</table>");
sb.Append("<p>");
sb.Append("<br /><br />");
sb.Append("######################################################################################<br />");
sb.Append(" Credentials:<br />");
sb.Append(" Username: "******"<br /><br />");
sb.Append(" Notes:<br />");
sb.Append(" Password is for login.<br />");
sb.Append(" Username is NOT CASE SENSITIVE.<br />");
sb.Append(" If you don't know or forgot your password, go to eBid login page and click forgot password.<br />");
sb.Append(" Use the username provided. Click Send. Your password will be sent to this email address.<br />");
sb.Append("######################################################################################<br />");
sb.Append("<br /><br /><br />");
sb.Append("Sincerely Yours,");
sb.Append("<br /><br />");
sb.Append(biddetails.Creator);
sb.Append("<br /><br />");
sb.Append("</p>");
sb.Append("</td>");
sb.Append("</tr>");
return(MailTemplate.IntegrateBodyIntoTemplate(sb.ToString()));
}