static void sendMails(int ID) { MailMessage mail = new MailMessage(); SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com"); mail.From = new MailAddress("*****@*****.**"); mail.To.Add(DAT.forMailSend(ID).ToString()); mail.Subject = "Test Mail SMTP"; mail.Body = "This is a system message. You have been notified for a work order, please log-in and check your PRIMS Account."; SmtpServer.Port = 587; SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "passwierd123"); SmtpServer.EnableSsl = true; SmtpServer.Send(mail); }
public static Tuple <bool, string[]> chkLogIn(string usern, string passw) { DataTable dt = DAT.logIn(int.Parse(usern), passw); bool result = true; string[] arr = new string[3]; if (dt.Rows.Count.Equals(0)) { result = false; } else { arr[0] = usern; arr[1] = dt.Rows[0][1].ToString(); arr[2] = dt.Rows[0][2].ToString(); } return(Tuple.Create(result, arr)); }
public static void createProj(string Pr_ID, string pr_Title, string SAP_Ref, string Details, string Client, string Supervisor, string Pr_Lead, string S_Date, string E_Date, DataTable TaskMem, DataTable Task) { //Pr_ID, Pr_Title, SAP_Ref, Details, Client, Supervisor, Pr_Lead, S_Date, E_Date DAT.createProject(Pr_ID, pr_Title, int.Parse(SAP_Ref), Details, int.Parse(Client), int.Parse(Supervisor), int.Parse(Pr_Lead), S_Date, E_Date); foreach (DataRow row in Task.Rows) { DAT.insertTask(int.Parse(row[0].ToString()), Pr_ID, row[1].ToString(), row[2].ToString(), row[3].ToString(), int.Parse(row[4].ToString())); } foreach (DataRow row in TaskMem.Rows) { DAT.insertTaskEm(int.Parse(row[2].ToString()), int.Parse(row[0].ToString())); } //DataView DV = new DataView(TaskMem); //DataTable Test = DV.ToTable(true, "Task Assigned ID"); //foreach (DataRow row in Test.Rows) //{ // sendMails(int.Parse(row[0].ToString())); //} }
public string getItemDesc(string ItemID) { return(DAT.getItemDetail(int.Parse(ItemID))); }
public static void updateThisTask(string ID) { DAT.updateTask(int.Parse(ID)); }
public DataTable kliyent(string ID) { return(DAT.kliyente(int.Parse(ID))); }
public DataTable getMyTask(string ID) { return(DAT.getMyTasks(int.Parse(ID))); }
public DataTable getEmp() { return(DAT.getEmployees()); }
public static void insrtBD(string BOMid, string stockcode) { DAT.insertBOMDet(stockcode, int.Parse(BOMid)); }
public static string insrtBOM(string pono, string prepBy, string projCode) { return(DAT.insertBOM(pono, int.Parse(prepBy), projCode)); }