public static DataTable GetAllCustomer(string CompanyLink) { MySqlParameter[] parameters = { new MySqlParameter("CompanyLink", CompanyLink) }; return(DatabaseConnectionSqlServer.GetDataTable("GetAllCustomer", parameters)); }
public static DataTable GetAllProjectFilter(string filter, string CompanyLink) { MySqlParameter[] parameters = { new MySqlParameter("filter", filter), new MySqlParameter("CompanyLink", CompanyLink), }; return(DatabaseConnectionSqlServer.GetDataTable("GetAllProjectFilter", parameters)); }
public static bool SendMail(string subject, string body, string MailTo, string CompanyLink) { // SEND MAIL bool issuccess = false; string emailfrom = string.Empty; string password = string.Empty; DataTable dt = DatabaseConnectionSqlServer.GetDataTable("Select Email.* from Email where Email.IsDeactivate=0 and Email.CompanyLink='" + CompanyLink + "'"); if (dt.Rows.Count > 0) { emailfrom = dt.Rows[0]["Email"].ToString(); password = dt.Rows[0]["Password"].ToString(); } else { emailfrom = ConfigurationManager.AppSettings["EmailId"].ToString(); password = ConfigurationManager.AppSettings["Password"].ToString(); } string port = ConfigurationManager.AppSettings["Port"].ToString(); string host = ConfigurationManager.AppSettings["Host"].ToString(); string enablessl = ConfigurationManager.AppSettings["EnableSSL"].ToString(); SmtpClient SmtpServer = new SmtpClient(); SmtpServer.Credentials = new System.Net.NetworkCredential(emailfrom, password); SmtpServer.Port = Convert.ToInt32(port); SmtpServer.Host = host; SmtpServer.EnableSsl = Convert.ToBoolean(enablessl); MailMessage mail = new MailMessage(); //mail.IsBodyHtml = true; mail.From = new MailAddress(emailfrom, emailfrom, System.Text.Encoding.UTF8); mail.Subject = subject; mail.To.Add(MailTo); //mail.To.Add("*****@*****.**"); //mail.To.Add("*****@*****.**"); mail.IsBodyHtml = true; mail.Body = body; try { SmtpServer.Send(mail); issuccess = true; } catch (Exception ex) { issuccess = false; //File.AppendAllText(@"c:\projects\ScheduledService.txt", "\nError at :\n " + ex.Message + "\n" + DateTime.Now.ToString()); } return(issuccess); }
public static DataTable GetItemByProjectNo(string ProjectNo) { // GET PROJECT DETAIL USING PROJECT NUMBER MySqlParameter[] parameters = { new MySqlParameter("ProjectNo", ProjectNo) }; return(DatabaseConnectionSqlServer.GetDataTable("GetItemByProjectNo", parameters)); }
public static DataTable GetDuplicateCustomer(string Customer, string CompanyLink) { // GET DUPLICATE CUSTOMER USING NAME MySqlParameter[] parameters = { new MySqlParameter("Customer", Customer), new MySqlParameter("CompanyLink", CompanyLink) }; return(DatabaseConnectionSqlServer.GetDataTable("GetDuplicateCustomer", parameters)); }
public static DataTable GetDocNo(string DocType) { // GET DOCUMENT NUMBER MySqlParameter[] parameters = { new MySqlParameter("DocType", DocType) }; DataTable dt = DatabaseConnectionSqlServer.GetDataTable("GetDocNo", parameters); return(dt); }
public static DataTable GetMenusByUserType(int PLink, string UserLink, string UserType, string IsTop) { // GET MENUS FOR LOGIN USER USING USER TYPE MySqlParameter[] parameters = { new MySqlParameter("ParentLink", PLink), new MySqlParameter("UserLink", UserLink), new MySqlParameter("UserType", UserType), new MySqlParameter("IsTop", IsTop) }; return(DatabaseConnectionSqlServer.GetDataTable("GetMenusByUserType", parameters)); }