private bool SendEmail ( string vVendorname, string vVendoremail, string vVendoraddress, string vVendoraddress1, string vVendoraddress2, string vVendoraddress3, string vVendorcontactperson, string vVendorphone, string vVendorfax, int vStatus, string subj ) { bool success = false; string fullname = vVendorname; string subject; //vVendoremail = "*****@*****.**"; subject = subj; if (MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), MailHelper.ChangeToFriendlyName(ConfigurationManager.AppSettings["AdminEmailName"], ConfigurationManager.AppSettings["AdminEmailAddress"]), MailHelper.ChangeToFriendlyName(vVendorname, vVendoremail), subject, CreateBody(vStatus, vVendorname, vVendoraddress, vVendoraddress1, vVendoraddress2, vVendoraddress3, vVendorcontactperson, vVendorphone, vVendorfax), MailTemplate.GetTemplateLinkedResources(this))) { success = true; } return(success); }
private bool SendEmailNotification(BidDetails biddetails, PurchaseOfficerInfo info) { bool success = false; string subject = "Trans-Asia : Notification"; try { if (!MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), MailHelper.ChangeToFriendlyName(biddetails.Creator, biddetails.CreatorEmail), MailHelper.ChangeToFriendlyName(info.Supervisor, info.EmailAdd), subject, CreateNotificationBody(), MailTemplate.GetTemplateLinkedResources(this))) { // if sending failed LogHelper.EventLogHelper.Log("Bid > Send Notification : Sending Failed to " + info.EmailAdd, System.Diagnostics.EventLogEntryType.Error); } else { // if sending successful LogHelper.EventLogHelper.Log("Bid > Send Notification : Email Sent to " + info.EmailAdd, System.Diagnostics.EventLogEntryType.Information); } success = true; } catch (Exception ex) { success = false; LogHelper.EventLogHelper.Log("Bid > Send Notification : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } return(success); }
//############################################################ //############################################################ // SEND EMAIL NOTIFICATION TO VM RECO private bool SendEmailNotification(string sfromName, string sfromEmail, string stoName, string stoEmail, string sAuthenticationTicket, string sVendorName) { bool success = false; string from = sfromName + "<" + sfromEmail + ">"; string to = stoName + "<" + stoEmail + ">"; string subject = ""; try { subject = "Trans-Asia VMS Accreditation application reviewed for your approval."; if (!MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), from, to, subject, CreateNotificationBody(sfromName, stoName, sAuthenticationTicket, sVendorName), MailTemplate.GetTemplateLinkedResources(this))) { //if sending failed LogHelper.EventLogHelper.Log("Bid > Send Notification : Sending Failed to " + from, System.Diagnostics.EventLogEntryType.Error); } else { //if sending successful LogHelper.EventLogHelper.Log("Bid > Send Notification : Email Sent to " + from, System.Diagnostics.EventLogEntryType.Information); } success = true; } catch (Exception ex) { success = false; LogHelper.EventLogHelper.Log("Bid > Send Notification : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); //Response.Write(ex.ToString()); } return(success); }
private bool SendEmailInvitation(AuctionDetails auctiondetails, ArrayList recipients, ref int failedcount, ref int successcount) { bool success = false; string subject = "Trans-Asia / Commnunications : Invitation to Auction"; failedcount = 0; successcount = 0; try { for (int i = 0; i < recipients.Count; i++) { AuctionParticipant p = (AuctionParticipant)recipients[i]; if (!MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), MailHelper.ChangeToFriendlyName(auctiondetails.Creator, auctiondetails.CreatorEmail), MailHelper.ChangeToFriendlyName(p.Name, p.EmailAddress), subject, CreateInvitationBody(auctiondetails, p), MailTemplate.GetTemplateLinkedResources(this))) { // if sending failed failedcount++; LogHelper.EventLogHelper.Log("Auction > Send Invitation : Sending Failed to " + p.EmailAddress, System.Diagnostics.EventLogEntryType.Error); } else { // if sending successful successcount++; LogHelper.EventLogHelper.Log("Auction > Send Invitation : Email Sent to " + p.EmailAddress, System.Diagnostics.EventLogEntryType.Information); // update sent mail count SqlHelper.ExecuteNonQuery(connstring, "sp_SendEmailInvitation", new SqlParameter[] { new SqlParameter("@ParticipantId", p.ID) }); } } success = true; } catch (Exception ex) { success = false; LogHelper.EventLogHelper.Log("Auction > Send Invitation : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } try { for (int j = 0; j < recipients.Count; j++) { AuctionParticipant p = (AuctionParticipant)recipients[j]; if (SMSHelper.AreValidMobileNumbers(p.MobileNo.Trim())) { SMSHelper.SendSMS(new SMSMessage(CreateSMSInvitationBody(auctiondetails, p).Trim(), p.MobileNo.Trim())).ToString(); } } } catch (Exception ex) { LogHelper.EventLogHelper.Log("Auction > Send SMS Invitation : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } return(success); }
private bool SendEmail(int userid) { bool success = false; string fullname = tbFirstName.Text.Trim() + " " + tbLastName.Text.Trim(); string subject = ""; if ((Request.QueryString["userID"] != null) && (Request.QueryString["userType"] != null)) { subject = "Trans-Asias : User Profile Changed"; } else { subject = "Trans-Asias : User Profile Created"; } if (MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), MailHelper.ChangeToFriendlyName(ConfigurationManager.AppSettings["AdminEmailName"], ConfigurationManager.AppSettings["AdminEmailAddress"]), MailHelper.ChangeToFriendlyName(fullname, tbEmail.Text.Trim()), subject, CreateBody(userid), MailTemplate.GetTemplateLinkedResources(this))) { success = true; } return(success); }
private bool SendEmail(string From, string To, string Cc, string Bcc, string Subject, string Body) { bool success = false; if (MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), From, To, Subject, Body, MailTemplate.GetTemplateLinkedResources(this))) { success = true; } return(success); }
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); } }
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(); } }
//############################################################ //############################################################ // SEND EMAIL NOTIFICATION TO VENDOR IF REJECTED private bool SendEmailNotification() { //"From Test", "*****@*****.**", "To Test", "*****@*****.**", "13412341234", "Test CompanyName", "1000999" //"Judith Mercado. Ponce" <*****@*****.**> //"Consolacion G.. Lim" <*****@*****.**> //string sCommand; //string connstring = HttpContext.Current.Session["ConnectionString"].ToString(); SqlDataReader oReader; bool success = false; string fromName = "From TestName"; string fromEmail = "*****@*****.**"; string from = '"' + "From TestName" + '"' + "<*****@*****.**>"; string toName = "To Testname"; string toEmail = "*****@*****.**>"; string to = '"' + "To Testname" + '"' + "<*****@*****.**>"; string subject = "Test eMail"; try { if (!MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), from, to, subject, CreateNotificationBody(), MailTemplate.GetTemplateLinkedResources(this))) { //if sending failed LogHelper.EventLogHelper.Log("Bid > Send Notification : Sending Failed to " + from, System.Diagnostics.EventLogEntryType.Error); } else { //if sending successful LogHelper.EventLogHelper.Log("Bid > Send Notification : Email Sent to " + from, System.Diagnostics.EventLogEntryType.Information); } success = true; } catch (Exception ex) { success = false; LogHelper.EventLogHelper.Log("Bid > Send Notification : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } return(success); }
private bool SendEmailInvitation(int userid) { bool success = false; string subject = "Trans-Asias : New User Profile Created"; if (MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), MailHelper.ChangeToFriendlyName(ConfigurationManager.AppSettings["AdminEmailName"], ConfigurationManager.AppSettings["AdminEmailAddress"]), MailHelper.ChangeToFriendlyName(tbFirstName.Text.Trim() + " " + tbLastName.Text.Trim(), tbEmail.Text.Trim()), subject, CreateInvitationBody(userid), MailTemplate.GetTemplateLinkedResources(this))) { success = true; } return(success); }
private bool SendEmail() { bool success = false; string fullname = txtVendorName.Text.Trim(); string subject; subject = "Trans-Asia : User Profile Created"; if (MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), MailHelper.ChangeToFriendlyName(ConfigurationManager.AppSettings["AdminEmailName"], ConfigurationManager.AppSettings["AdminEmailAddress"]), MailHelper.ChangeToFriendlyName(fullname, txtEmailAddress.Text.Trim()), subject, CreateBody(), MailTemplate.GetTemplateLinkedResources(this))) { success = true; } return(success); }
//############################################################ //############################################################ private bool SendEmailNotification(string strVSFId) { SqlDataReader oReader; string connstring = HttpContext.Current.Session["ConnectionString"].ToString(); string query; SqlCommand cmd; SqlConnection conn; bool success = false; string fromName = ""; string fromEmail = ""; string from = ""; string toName = ""; string toEmail = ""; string to = ""; string subject = ""; string oProjectName = ""; string oVSFId = ""; query = "SELECT t1.VSFId, t1.ProjectName, t2.BuyerFirstName + ' ' + t2.BuyerMidName + ' ' + t2.BuyerLastName AS BuyerName, t2.EmailAdd as BuyerEmail, t3.FirstName + ' ' + t3.MiddleName + ' ' + t3.LastName AS PurchasingName, t3.EmailAdd as PurchasingEmail FROM tblVendorShortlistingForm t1, tblBuyers t2, tblPurchasing t3 WHERE t1.VSFId=@VSFId AND t2.BuyerId = t1.BuyerId AND t3.PurchasingId = t1.PurchasingId"; //query = "sp_GetVendorInformation"; //##storedProcedure using (conn = new SqlConnection(connstring)) { using (cmd = new SqlCommand(query, conn)) { //cmd.CommandType = CommandType.StoredProcedure; //##storedProcedure cmd.Parameters.AddWithValue("@VSFId", Convert.ToInt32(strVSFId)); conn.Open(); //Process results oReader = cmd.ExecuteReader(); if (oReader.HasRows) { while (oReader.Read()) { oVSFId = oReader["VSFId"].ToString(); oProjectName = oReader["ProjectName"].ToString(); fromName = oReader["PurchasingName"].ToString(); fromEmail = oReader["PurchasingEmail"].ToString(); from = '"' + oReader["PurchasingName"].ToString() + '"' + " <" + oReader["BuyerEmail"].ToString() + ">"; toName = oReader["BuyerName"].ToString(); toEmail = oReader["BuyerEmail"].ToString(); to = '"' + oReader["BuyerName"].ToString() + '"' + " <" + oReader["PurchasingEmail"].ToString() + ">"; } } } } try { subject = "VSF Approved"; if (!MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), from, to, subject, CreateNotificationBody(oVSFId, oProjectName, fromName, toName), MailTemplate.GetTemplateLinkedResources(this))) { //if sending failed LogHelper.EventLogHelper.Log("Bid > Send Notification : Sending Failed to " + from, System.Diagnostics.EventLogEntryType.Error); } else { //if sending successful LogHelper.EventLogHelper.Log("Bid > Send Notification : Email Sent to " + from, System.Diagnostics.EventLogEntryType.Information); } success = true; } catch (Exception ex) { success = false; LogHelper.EventLogHelper.Log("Bid > Send Notification : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } return(success); }
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 bool SendEmail_ChangeDeadline(BidDetails biddetails, ArrayList recipients) { //String b_Company = ((Label)((DetailsView)Biddetails_details1.FindControl("dvEventDetails")).Rows[5].Cells[1].FindControl("lblCompany")).Text; bool success = false; string subject = "Trans-Asia / Commnunications : Changed Submission Deadline Notification"; int failedcount = 0; int successcount = 0; try { #region NOTIFY VENDORS for (int i = 0; i < recipients.Count; i++) { BidParticipant p = (BidParticipant)recipients[i]; if (!MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), MailHelper.ChangeToFriendlyName(Session[Constant.SESSION_USERFULLNAME].ToString(), Session[Constant.SESSION_USEREMAIL].ToString()), MailHelper.ChangeToFriendlyName(p.Name, p.EmailAddress), subject, CreateNotificationBody(biddetails, p), MailTemplate.GetTemplateLinkedResources(this))) { // if sending failed failedcount++; LogHelper.EventLogHelper.Log("Bids > Send Notification : Sending Failed to " + p.EmailAddress, System.Diagnostics.EventLogEntryType.Error); } else { // if sending successful successcount++; LogHelper.EventLogHelper.Log("Bids > Send Notification : Email Sent to " + p.EmailAddress, System.Diagnostics.EventLogEntryType.Information); #region add 1 to emailsent field based on vendorID and BidRefNo //SqlParameter[] sqlparams = new SqlParameter[2]; //sqlparams[0] = new SqlParameter("@Vendorid", SqlDbType.Int); //sqlparams[0].Value = p.ID; //sqlparams[1] = new SqlParameter("@BidRefNo", SqlDbType.VarChar); //sqlparams[1].Value = Int32.Parse(Session["BidRefNo"].ToString()); //SqlHelper.ExecuteNonQuery(connstring, CommandType.StoredProcedure, "sp_BidInvitationAddEmailSent", sqlparams); #endregion } } #region SMS SENDER try { for (int j = 0; j < recipients.Count; j++) { BidParticipant BP = (BidParticipant)recipients[j]; if (SMSHelper.AreValidMobileNumbers(BP.MobileNo.Trim())) { SMSHelper.SendSMS(new SMSMessage(CreateInvitationSmsBody(biddetails, BP).Trim(), BP.MobileNo.Trim())).ToString(); } } } catch (Exception ex) { LogHelper.EventLogHelper.Log("Bid Event > Send SMS Invitation : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } #endregion #endregion #region NOTIFY BUYER if (!MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), MailHelper.ChangeToFriendlyName(Session[Constant.SESSION_USERFULLNAME].ToString(), Session[Constant.SESSION_USEREMAIL].ToString()), MailHelper.ChangeToFriendlyName(biddetails.Creator, biddetails.CreatorEmail), subject, CreateNotificationBody(biddetails), MailTemplate.GetTemplateLinkedResources(this))) { failedcount++; LogHelper.EventLogHelper.Log("Bids > Send Notification : Sending Failed to " + Session[Constant.SESSION_USEREMAIL].ToString(), System.Diagnostics.EventLogEntryType.Error); } else { successcount++; LogHelper.EventLogHelper.Log("Bids > Send Notification : Email Sent to " + Session[Constant.SESSION_USEREMAIL].ToString(), System.Diagnostics.EventLogEntryType.Information); } #endregion success = true; } catch (Exception ex) { success = false; LogHelper.EventLogHelper.Log("Bid Item > Send ??? Change Notice : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } return(success); }
private bool SendEmailNotificationClarify() { //"Fistname Lastname" <*****@*****.**> //"Fistname Lastname" <*****@*****.**> string sCommand; string connstring = HttpContext.Current.Session["ConnectionString"].ToString(); SqlDataReader oReader; bool success = false; string fromName = ""; string fromEmail = ""; string from = ""; string toName = ""; string toEmail = ""; string to = ""; string subject = "BAC For Clarification"; //GET PURCHASING EMAIL AS THE SENDER sCommand = "SELECT t1.PurchasingID, t2.FirstName + ' ' + t2.MiddleName + ' ' + t2.LastName AS Name1, CONVERT(VARCHAR(17), t3.ApprovedDt_0, 113) ApprovedDt, t2.EmailAdd FROM tblSupervisor t1, tblPurchasing t2, tblBacBidItems t3 WHERE 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(); fromName = oReader["Name1"].ToString(); fromEmail = oReader["EmailAdd"].ToString(); from = '"' + oReader["Name1"].ToString() + '"' + " <" + oReader["EmailAdd"].ToString() + ">"; } oReader.Close(); //GET BUYER EMAIL AS THE RECEPIENT sCommand = "SELECT PurchasingID, Name1, EmailAdd FROM (SELECT t2.PurchasingID, t2.FirstName + ' ' + t2.MiddleName + ' ' + t2.LastName AS Name1, t2.EmailAdd FROM tblPurchasing t2, tblBacBidItems t3 WHERE t2.PurchasingID=t3.Approver_0 and t3.BidRefNo= " + Session["BuyerBidForBac"] + " UNION SELECT t1.BuyerId PurchasingID, t1.BuyerLastName + ', ' + t1.BuyerFirstName + ' ' + t1.BuyerMidName AS Name1, t1.EmailAdd FROM tblBuyers t1, tblBacBidItems t2 WHERE t1.BuyerId = t2.BuyerId AND t2.BidRefNo = " + Session["BuyerBidForBac"] + " UNION SELECT t1.BACId PurchasingID, t1.LastName + ', ' + t1.FirstName + ' ' + t1.MiddleName AS Name1, t1.EmailAdd FROM tblBidAwardingCommittee t1 ) as a1 INNER JOIN (SELECT TOP 1 * FROM tblBACClarifications d WHERE d.BidRefNo = " + Session["BuyerBidForBac"] + " ORDER BY d.DatePosted desc) t2 ON t2.FrUserId = a1.PurchasingID"; oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand); if (oReader.HasRows) { oReader.Read(); toName = oReader["Name1"].ToString(); toEmail = oReader["EmailAdd"].ToString(); to = '"' + oReader["Name1"].ToString() + '"' + " <" + oReader["EmailAdd"].ToString() + ">"; } oReader.Close(); Response.Write(from + "<br>"); Response.Write(to + "<br>"); Response.Write(subject + "<br>"); Response.Write(CreateNotificationBodyClarify() + "<br>"); Response.Write(MailTemplate.GetTemplateLinkedResources(this) + "<br>"); try { if (!MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), from, to, subject, CreateNotificationBodyClarify(), MailTemplate.GetTemplateLinkedResources(this))) { //if sending failed LogHelper.EventLogHelper.Log("Bid > Send Notification : Sending Failed to " + from, System.Diagnostics.EventLogEntryType.Error); } else { //if sending successful LogHelper.EventLogHelper.Log("Bid > Send Notification : Email Sent to " + from, System.Diagnostics.EventLogEntryType.Information); } success = true; } catch (Exception ex) { success = false; LogHelper.EventLogHelper.Log("Bid > Send Notification : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } return(success); }
private bool SendEmailNotificationApprove() { //"Fistname Lastname" <*****@*****.**> //"Fistname Lastname" <*****@*****.**> string sCommand; string connstring = HttpContext.Current.Session["ConnectionString"].ToString(); SqlDataReader oReader; bool success = false; string fromName = ""; string fromEmail = ""; string from = ""; string toName = ""; string toEmail = ""; string to = ""; string subject = "BAC For Approval"; //GET STATUS IF FOR APPROVAL OR ALREADY AWARDED string Status = ""; sCommand = "SELECT Status FROM tblBacBidItems WHERE BidRefNo=" + Session["BuyerBidForBac"]; oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand); if (oReader.HasRows) { oReader.Read(); Status = oReader["Status"].ToString(); } oReader.Close(); //GET BUYER EMAIL AS THE SENDER //sCommand = "SELECT 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"]; //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(); fromName = oReader["Name1"].ToString(); fromEmail = oReader["EmailAdd"].ToString(); from = '"' + oReader["Name1"].ToString() + '"' + " <" + oReader["EmailAdd"].ToString() + ">"; } oReader.Close(); //GET APPROVER EMAIL AS THE RECEPIENT OR IF NULL, NOTIFY BUYER AS AWARDED BAC 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(); toName = oReader["Name1"].ToString(); toEmail = oReader["EmailAdd"].ToString(); to = '"' + oReader["Name1"].ToString() + '"' + " <" + oReader["EmailAdd"].ToString() + ">"; } oReader.Close(); //Response.Write(from + "<br>"); //Response.Write(to + "<br>"); //Response.Write(subject + "<br>"); //Response.Write(CreateNotificationBodyApprove() + "<br>"); //Response.Write(MailTemplate.GetTemplateLinkedResources(this) + "<br>"); try { if (!MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), from, to, subject, CreateNotificationBodyApprove(), MailTemplate.GetTemplateLinkedResources(this))) { //if sending failed LogHelper.EventLogHelper.Log("Bid > Send Notification : Sending Failed to " + from, System.Diagnostics.EventLogEntryType.Error); } else { //if sending successful LogHelper.EventLogHelper.Log("Bid > Send Notification : Email Sent to " + from, System.Diagnostics.EventLogEntryType.Information); } success = true; } catch (Exception ex) { success = false; LogHelper.EventLogHelper.Log("Bid > Send Notification : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } return(success); }
private bool SendEmailInvitation(BidDetails biddetails, ArrayList recipients, ref int failedcount, ref int successcount) { bool success = false; string subject = "Trans-Asia Incorporated/ Commnunications : Invitation to Bid"; failedcount = 0; successcount = 0; try { for (int i = 0; i < recipients.Count; i++) { BidParticipant p = (BidParticipant)recipients[i]; if (!MailHelper.SendEmail(MailTemplate.GetDefaultSMTPServer(), MailHelper.ChangeToFriendlyName(biddetails.Creator, biddetails.CreatorEmail), MailHelper.ChangeToFriendlyName(p.Name, p.EmailAddress), subject, CreateInvitationBody(biddetails, p), MailTemplate.GetTemplateLinkedResources(this))) { // if sending failed failedcount++; LogHelper.EventLogHelper.Log("Bid Event > Send Invitation : Sending Failed to " + p.EmailAddress, System.Diagnostics.EventLogEntryType.Error); } else { // if sending successful successcount++; LogHelper.EventLogHelper.Log("Bid Event > Send Invitation : Email Sent to " + p.EmailAddress, System.Diagnostics.EventLogEntryType.Information); //add 1 to emailsent field based on vendorID and BidRefNo SqlParameter[] sqlparams = new SqlParameter[2]; sqlparams[0] = new SqlParameter("@Vendorid", SqlDbType.Int); sqlparams[0].Value = p.ID; sqlparams[1] = new SqlParameter("@BidRefNo", SqlDbType.VarChar); sqlparams[1].Value = Int32.Parse(Session["BidRefNo"].ToString()); SqlHelper.ExecuteNonQuery(connstring, CommandType.StoredProcedure, "sp_BidInvitationAddEmailSent", sqlparams); } } success = true; } catch (Exception ex) { success = false; LogHelper.EventLogHelper.Log("Bid Event > Send Invitation : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } try { for (int j = 0; j < recipients.Count; j++) { BidParticipant p = (BidParticipant)recipients[j]; if (SMSHelper.AreValidMobileNumbers(p.MobileNo.Trim())) { SMSHelper.SendSMS(new SMSMessage(CreateInvitationSmsBody(biddetails, p).Trim(), p.MobileNo.Trim())).ToString(); } } } catch (Exception ex) { LogHelper.EventLogHelper.Log("Bid Event > Send SMS Invitation : " + ex.Message, System.Diagnostics.EventLogEntryType.Error); } return(success); }