private void sendNotification(string requestlistID) { DataTable result = null; try { using (SqlConnection conPrintDB = new SqlConnection(ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString)) { string strSelect = "Select CustomerEmail, CustomerPhoneNo, CustomerContactMethod, CompanyName From Customer c, Request r, Requestlist rl, Company cp WHERE rl.RequestID = r.RequestID AND r.CustomerID = c.CustomerID AND r.CompanyID = cp.CompanyID AND rl.RequestlistID = @requestlistID"; using (SqlCommand cmdSelect = new SqlCommand(strSelect, conPrintDB)) { cmdSelect.Parameters.AddWithValue("@requestlistID", requestlistID); using (SqlDataAdapter da = new SqlDataAdapter(cmdSelect)) { result = new DataTable(); da.Fill(result); } //return new User((string)result.Rows[0]["ID"], (string)result.Rows[0]["Name"], GetUserRoles(username, loginType), (string)result.Rows[0]["Email"]); string contactNo = (string)result.Rows[0]["CustomerPhoneNo"]; string email = (string)result.Rows[0]["CustomerEmail"]; string contactMethod = (string)result.Rows[0]["CustomerContactMethod"]; string companyName = (string)result.Rows[0]["CompanyName"]; switch (contactMethod) { case "whatsapp": WhatappClass.sendWhatsappWithURL(contactNo, "Your Document is Printed and Ready", Response); break; case "wechat": case "E-mail": string emailContent = EmailClass.populateNotificationEmail(companyName);// content of the email EmailClass emailClass = new EmailClass(email, "Document is Printed and Ready", emailContent, true); if (EmailClass.isCredentialed()) { EmailCredential credential = (EmailCredential)Session["EmailCredential"]; emailClass.sendEmail(credential); } else { Session["tempEmail"] = emailClass; Response.Redirect(ResolveUrl("~/Staff/VerifyEmail.aspx?ReturnURL=" + Request.Url.AbsoluteUri)); } break; case "SMS": break; default: break; } } } } catch (Exception ex) { throw new Exception(ex.ToString()); } }