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(); // }