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