protected void Page_Load(object sender, EventArgs e) { MailMessage mail = new MailMessage(); DataTable rs = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "SECURITY..REF_PROJECT WHERE Project IN (" + Act.ProjectListSql + ")"); for (int i = 0; i < rs.Rows.Count; i++) { try { string EmailFrom = Db.SingleString("SELECT ISNULL(Value, '') FROM " + Mi.DbPrefix + "SECURITY..REF_PARAM WHERE ParamID = 'EmailFrom" + rs.Rows[i]["Project"] + "'"); string Password = Db.SingleString("SELECT ISNULL(Value, '') FROM " + Mi.DbPrefix + "SECURITY..REF_PARAM WHERE ParamID = 'EmailPassword" + rs.Rows[i]["Project"] + "'"); string EmailDisplayName = Db.SingleString("SELECT ISNULL(Value, '') FROM " + Mi.DbPrefix + "SECURITY..REF_PARAM WHERE ParamID = 'EmailDisplayName" + rs.Rows[i]["Project"] + "'"); string EmailSMTP = Db.SingleString("SELECT ISNULL(Value, '') FROM " + Mi.DbPrefix + "SECURITY..REF_PARAM WHERE ParamID = 'EmailSMTP" + rs.Rows[i]["Project"] + "'"); string EmailSMTPPort = Db.SingleString("SELECT ISNULL(Value, '') FROM " + Mi.DbPrefix + "SECURITY..REF_PARAM WHERE ParamID = 'EmailSMTPPort" + rs.Rows[i]["Project"] + "'"); //Sender mail.From = new MailAddress(EmailFrom, EmailDisplayName); DataTable Recipient = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "SECURITY..REF_EMAIL WHERE Project = '" + rs.Rows[i]["Project"] + "'"); for (int j = 0; j < Recipient.Rows.Count; j++) { //Recipient mail.To.Add(new MailAddress(Recipient.Rows[j]["Email"].ToString())); } //Subject and Body //string Body = BodyEmail(); mail.Subject = "Daily Report " + Cf.Day(DateTime.Now.AddDays(-1)); mail.Body = BodyEmail(); mail.IsBodyHtml = true; var client = new SmtpClient(EmailSMTP, Convert.ToInt32(EmailSMTPPort)); client.EnableSsl = true; client.UseDefaultCredentials = true; System.Net.NetworkCredential credentials = new System.Net.NetworkCredential(EmailFrom, Password); client.Credentials = credentials; client.Send(mail); } catch (Exception err) { Response.Write("Can't send email" + err + "<br>"); } } }
public static string Periode(object r1, object r2) { if (r1 is DBNull || r2 is DBNull) { return(""); } else { DateTime x1 = Convert.ToDateTime(r1); DateTime x2 = Convert.ToDateTime(r2); if (x1 == x2) { return(Cf.Day(x1)); } else { string s1 = ""; string s2 = ""; if (x1.Day != 1) { s1 = x1.Day + " " + Cf.Month(x1); } else { s1 = Cf.Month(x1); } if (x2.Day != AkhirBulan(x2.Month, x2.Year).Day) { s2 = x2.Day + " " + Cf.Month(x2); } else { s2 = Cf.Month(x2); } return(s1 + " - " + s2); } } }
protected void cal_SelectionChanged(object sender, System.EventArgs e) { if (Request.QueryString["ctrl"] != null) { string ctrl = Request.QueryString["ctrl"]; RegisterStartupScript( "selectCal" , "<script language='javascript'>" + " window.opener.getCalendar('" + ctrl + "','" + Cf.Day(cal.SelectedDate) + "');" + " window.close();" + "</script>" ); } else { RegisterStartupScript( "selectCal" , "<script language='javascript'>" + " window.close();" + "</script>" ); } }