protected void gvAtasan_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Detail")
{
string URL = "~/newFormRequestDetailClaim.aspx?encrypt=" + Encrypto.Encrypt(e.CommandArgument.ToString());
URL = Page.ResolveClientUrl(URL);
ScriptManager.RegisterStartupScript(this, GetType(), "openDetail", "openDetail('" + URL + "');", true);
}
if (e.CommandName == "Approve")
{
lblMessage.Text = claimApproval.ChangeStatus(e.CommandArgument.ToString(), e.CommandName, karyawan.nrp, "Atasan");
lblMessage.Visible = true;
}
if (e.CommandName == "Reject")
{
lblMessage.Text = claimApproval.ChangeStatus(e.CommandArgument.ToString(), e.CommandName, karyawan.nrp, "Atasan");
lblMessage.Visible = true;
}
if (e.CommandName != "Detail")
{
BindAtasan();
}
}
protected void gvViewSPDTujuan_RowCommand(object sender, GridViewCommandEventArgs e)
{
lblMessageTujuan.Visible = false;
switch (e.CommandName)
{
case "Detail":
string URL = "~/newFormRequestDetail.aspx?encrypt=" + Encrypto.Encrypt(e.CommandArgument.ToString());
URL = Page.ResolveClientUrl(URL);
ScriptManager.RegisterStartupScript(this, GetType(), "openDetail", "openDetail('" + URL + "');", true);
break;
case "Approve":
lblMessageTujuan.Text = approvalSPDUrl.ChangeStatus(e.CommandArgument.ToString(), e.CommandName, karyawan.nrp, string.Empty);
break;
case "Reject":
lblMessageTujuan.Text = approvalSPDUrl.ChangeStatus(e.CommandArgument.ToString(), e.CommandName, karyawan.nrp, string.Empty);
break;
default:
break;
}
lblMessageTujuan.Visible = true;
bindFindTujuan();
}
protected void btnDetail_Click(object sender, EventArgs e)
{
string URL = "~/newFormRequestDetail.aspx?encrypt=" + Encrypto.Encrypt(Session["noSPD"].ToString());
URL = Page.ResolveClientUrl(URL);
ScriptManager.RegisterStartupScript(this, GetType(), "openDetail", "openDetail('" + URL + "');", true);
}
protected void gvViewSPDGA_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Detail")
{
string URL = "~/newFormRequestDetail.aspx?encrypt=" + Encrypto.Encrypt(e.CommandArgument.ToString());
URL = Page.ResolveClientUrl(URL);
ScriptManager.RegisterStartupScript(this, GetType(), "openDetail", "openDetail('" + URL + "');", true);
}
if (e.CommandName == "Cancel")
{
lblMessageGA.Text = approvalSPDUrl.ChangeStatus(e.CommandArgument.ToString(), e.CommandName, karyawan.nrp, string.Empty);
}
}
protected void gvViewSPD_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
lblMessage.Visible = false;
string[] command = e.CommandArgument.ToString().Split(';');
ViewState["NoSPD"] = command[0];
//split parameter nospd, nrpapproval, index
switch (e.CommandName)
{
case "Detail":
string URL = "~/newFormRequestDetail.aspx?encrypt=" + Encrypto.Encrypt(e.CommandArgument.ToString());
URL = Page.ResolveClientUrl(URL);
ScriptManager.RegisterStartupScript(this, GetType(), "openDetail", "openDetail('" + URL + "');", true);
break;
case "Approve":
lblMessage.Text = approvalSPDUrl.ChangeStatus(command[0], e.CommandName, command[1], command[2]);
break;
case "Reject":
lblMessage.Text = approvalSPDUrl.ChangeStatus(command[0], e.CommandName, command[1], command[2]);
break;
default:
break;
}
lblMessage.Visible = true;
bindFind();
}
catch (Exception ex)
{
LogError.Log_Error(ex, "copy file request", ViewState["NoSPD"].ToString());
}
}
protected void btnTry_Click(object sender, EventArgs e)
{
lblHasil.Text = string.Empty;
using (var ctx = new dsSPDDataContext())
{
// ngga bis diembed ke template jadi manual
var spd = (from p in ctx.trSPDs
where
(p.tglBerangkat.Date - DateTime.Now.Date).Days >= 0 &&
p.isSubmit == true && p.isCancel == null && p.isApproved == null
select p).ToList();
var nospd = (from p in spd select p.noSPD).Distinct();
var approval = (from p in ctx.ApprovalStatus
where nospd.Contains(p.NoSPD) && p.Status == null
group p by p.NoSPD
into groups
select groups.OrderBy(p => p.IndexLevel).First()).ToList();
var nrpApproval = (from p in approval
group p by p.NrpApproval
into groups
select groups.OrderBy(p => p.IndexLevel).First().NrpApproval).Distinct().ToList();
foreach (var item in nrpApproval)
{
var nama = approval.FirstOrDefault(o => o.NrpApproval == item).Nama;
var datatoSend = (from p in approval
join o in spd on p.NoSPD equals o.noSPD
where p.NrpApproval == item
select new Outstanding
{
NoSPD = o.noSPD,
Nama = o.namaLengkap,
TglBerangkat = o.tglBerangkat,
Keperluan = o.msKeperluan.keperluan + " - " + o.ketKeperluan + " - " + o.keperluanLain
}).ToList();
if (datatoSend.Count != 0 || datatoSend != null)
{
using (var smtpClient = new SmtpClient())
{
string data = string.Empty;
string trtd = string.Empty;
foreach (var detail in datatoSend.OrderBy(o => o.TglBerangkat.Date))
{
string urlExternal = "http://118.97.80.12/SPD/" + "newFormRequestDetail.aspx?encrypt=" + Encrypto.Encrypt(detail.NoSPD);
string urlInternal = "http://trac39/SPD/" + "newFormRequestDetail.aspx?encrypt=" + Encrypto.Encrypt(detail.NoSPD);
trtd +=
"<tr style='border:1px solid #eee;'>" +
"<td style='border:1px solid #dedede;padding:5px;'>" + detail.NoSPD + "</td>" +
"<td style='border:1px solid #dedede;padding:5px;'>" + detail.Nama + "</td>" +
"<td style='border:1px solid #dedede;padding:5px;'>" + detail.Keperluan + "</td>" +
"<td style='border:1px solid #dedede;padding:5px;'>" + detail.TglBerangkat.ToString("dd MMMM yyyy") + " <b>(H-" + (detail.TglBerangkat.Date - DateTime.Now.Date).Days.ToString() + ")</b></td>" +
"<td style='border:1px solid #dedede;padding:5px;'><a href='" + urlInternal + "'>Internal</a> | <a href='" + urlExternal + "'>External</a></td>" +
"</tr>";
}
data += "<h4 style='color: #1b809e; border-bottom: 1px solid #eee;'>Kepada Yth " + nama + "</h4>" + "<br/>Berikut adalah data Approval yang masih outstanding per tanggal " + DateTime.Now.ToString("dd MMMM yyyy") + "<br/><br/>" +
"<table style='border-color: #eee;border-collapse: collapse;border-width: 1px;color: #333333;'>" +
"<tr style='border-width: 1px;padding: 8px;border-style: solid;border-color: #eee;background-color: #dedede;'>" +
"<th style='border:1px solid #fff;padding:5px;'>No</th>" +
"<th style='border:1px solid #fff;padding:5px;'>Nama</th>" +
"<th style='border:1px solid #fff;padding:5px;'>Keperluan</th>" +
"<th style='border:1px solid #fff;padding:5px;'>Tgl Berangkat</th>" +
"<th style='border:1px solid #fff;padding:5px;'>#</th>" +
"</tr>" +
trtd +
"</table><br/><br/><br/>" +
"Terima kasih. <br/>" +
"Catatan : Internal (jika berada dikantor) dan External (jika berada diluar kantor)<br/>" +
"<span style='color: #FF0000'><b>E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini</b></span>";
SmtpSection section = (SmtpSection)ConfigurationManager.GetSection("system.net/mailSettings/smtp");
MailMessage message = new MailMessage
{
Sender = new MailAddress(section.From), // on Behave of When From differs
From = new MailAddress(section.From),
Subject = "Outstanding Approval SPD " + DateTime.Now.Date.ToString("dd MMMM yyyy"),
Body = data,
IsBodyHtml = true,
};
var getEmail = approval.FirstOrDefault(o => o.NrpApproval == item);
string email = string.Empty;
email = getEmail != null ? getEmail.Email : string.Empty;
if (!string.IsNullOrEmpty(email))
{
message.To.Add("*****@*****.**");
smtpClient.Send(message);
}
HasilEmail++;
lblHasil.Text += HasilEmail.ToString() + " " + data + "<b/><hr/><br/>";
}
}
}
}
lblHasil.Text += "<br/>" + HasilEmail.ToString();
//
}
