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>"
);
}
}
