protected void txtLogin_TextChanged(object sender, EventArgs e)
{
using (var ctx = new dsSPDDataContext())
{
if (String.IsNullOrEmpty(txtLogin.Text))
{
txtLogin.Text = SetLabelWelcome();
}
strLoginID = txtLogin.Text;
Session["IDLogin"] = strLoginID;
classSpd oSPD = new classSpd();
karyawan = oSPD.getKaryawan(strLoginID);
Session["nrpLogin"] = karyawan.nrp;
dsSPDDataContext data = new dsSPDDataContext();
msUser sekretaris = (from u in data.msUsers
where u.nrp == karyawan.nrp && u.roleId == Konstan.SEKRETARIS
select u).FirstOrDefault();
if (sekretaris != null)
{
Session["sekretaris"] = true;
}
else
{
Session["sekretaris"] = false;
}
}
}
public msKaryawan fillK()
{
msKaryawan kx = new msKaryawan();
kx.nrp = txtNRP.Text;
kx.coCd = txtCocd.Text;
kx.companyCode = txtCompanyCode.Text;
kx.EMail = txtEmail.Text;
kx.golongan = txtGolongan.Text;
kx.Job = txtJob.Text;
kx.karyawanSubGroup = txtSubGroup.Text;
kx.kodeJob = txtKdJob.Text;
kx.kodeOrganisasiUnit = txtKdOrg.Text;
kx.kodePA = txtKdPA.Text;
kx.kodePosisi = txtKdPosisi.Text;
kx.kodePSubArea = txtKdPSA.Text;
kx.namaAtasan = txtNamaAtasan.Text;
kx.namaLengkap = txtNama.Text;
kx.nrpAtasan = txtNRPAtasan.Text;
kx.organisasiUnit = txtOrg.Text;
kx.personelArea = txtPA.Text;
kx.posisi = txtPosisi.Text;
kx.pSubArea = txtPSA.Text;
kx.startDate = DateTime.Parse(txtTglMasuk.Text);
kx.statusKaryawan = ddlStatus.SelectedValue.ToString();
kx.tanggal = DateTime.Parse(txtTgl.Text);
return(kx);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IDLogin"] == null)
{
Response.Redirect("frmHome.aspx");
}
strID = (string)Session["IDLogin"];
karyawan = oSPD.getKaryawan(strID);
Session["nrpLogin"] = karyawan.nrp;
if (string.IsNullOrEmpty(karyawan.nrp))
{
Response.Redirect("frmHome.aspx");
}
if (!IsPostBack)
{
if (ifga(karyawan.nrp))
{
bindFindSPDGa();
spdGA.Visible = true;
BindAtasan();
}
header.Text = "List Approval SPD";
bindFind();
bindFindTujuan();
BindAtasan();
BindSPDViewForADH();
if (Session["IDLogin"].ToString() == "siska90000308")
{
PnlChange.Visible = true;
}
}
}
public msKaryawan getKaryawan(string LoginID)
{
dsSPDDataContext data = new dsSPDDataContext();
string mail = string.Empty;
//IMultipleResults result = data.stpGetKaryawanEmail(LoginID);
stpGetKaryawanEmailResult hasil = (stpGetKaryawanEmailResult)data.stpGetKaryawanEmail(LoginID).SingleOrDefault();
msKaryawan karyawanQ = new msKaryawan();
if (LoginID.ToLower() == "spd")
{
karyawanQ.nrp = "99999999";
karyawanQ.golongan = "III";
karyawanQ.coCd = "1";
karyawanQ.kodePSubArea = "1";
karyawanQ.kodePA = "1";
}
else if (LoginID.ToLower() == "is07")
{
karyawanQ = (from q in data.msKaryawans
where q.nrp == "98989898"
select q).FirstOrDefault();
}
else
{
karyawanQ = (from q in data.msKaryawans
where q.email == hasil.EmailID
select q).FirstOrDefault();
}
//var dts = result.GetResult<DateTime>();
return(karyawanQ);
}
private void fill_form(ref msKaryawan kx)
{
txtNRP.Text = kx.nrp;
txtCocd.Text = kx.coCd;
txtCompanyCode.Text = kx.companyCode;
txtEmail.Text = kx.EMail;
txtGolongan.Text = kx.golongan;
txtJob.Text = kx.Job;
txtSubGroup.Text = kx.karyawanSubGroup;
txtKdJob.Text = kx.kodeJob;
txtKdOrg.Text = kx.kodeOrganisasiUnit;
txtKdPA.Text = kx.kodePA;
txtKdPosisi.Text = kx.kodePosisi;
txtKdPSA.Text = kx.kodePSubArea;
txtNamaAtasan.Text = kx.namaAtasan;
txtNama.Text = kx.namaLengkap;
txtNRPAtasan.Text = kx.nrpAtasan;
txtOrg.Text = kx.organisasiUnit;
txtPA.Text = kx.personelArea;
txtPosisi.Text = kx.posisi;
txtPSA.Text = kx.pSubArea;
txtTglMasuk.Text = DateTime.Parse(kx.startDate.ToString()).ToShortDateString();
ddlStatus.SelectedValue = kx.statusKaryawan;
txtTgl.Text = DateTime.Parse(kx.tanggal.ToString()).ToShortDateString();
pnlForm.Visible = false;
btnTambah.Visible = true;
}
private bool cek_su(string LoginID)
{
dsSPDDataContext data = new dsSPDDataContext();
classSpd oSPD = new classSpd();
msKaryawan karyawan = new msKaryawan();;
string t_nrp = oSPD.getKaryawan(LoginID).nrp;
var user = (from u in data.msUsers
join k in data.msKaryawans on u.nrp equals k.nrp
where u.roleId == 24 && k.nrp == t_nrp
orderby k.namaLengkap
select new
{
namaLengkap = k.namaLengkap,
nrp = k.nrp
}).Distinct();
if (user.Count() > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IDLogin"] == null)
{
Response.Redirect("frmHome.aspx");
}
string noSPD = Encrypto.Decrypt(Request.QueryString["encrypt"]);
Id.Value = noSPD;
strID = (string)Session["IDLogin"];
karyawan = oSPD.getKaryawan(strID);
Session["nrpLogin"] = karyawan.nrp;
if (string.IsNullOrEmpty(karyawan.nrp))
{
Response.Redirect("frmHome.aspx");
}
using (var ctx = new dsSPDDataContext())
{
var spd = ctx.trSPDs.FirstOrDefault(o => o.noSPD == Id.Value);
// jika sekertaris
if ((spd.dibuatOleh == karyawan.nrp && spd.isSubmit != true) || (isSec(karyawan.nrp, spd.nrp) && spd.isSubmit != true))
{
btnSubmit.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Session["noSPD"] = string.Empty;
//Session["editable"] = false;
AD ad = new AD();
//ArrayList al = ad.Groups("trac\\"+LoginID,true);
ArrayList o = ad.Groups();
string strLoginID = string.Empty;
if (Session["IDLogin"] != null)
{
strLoginID = (string)Session["IDLogin"];
}
else
{
strLoginID = SetLabelWelcome();
}
if (strLoginID.ToLower() == "wawan010193")
{
//strLoginID = "spd";
// strLoginID = "Putu005001";
// strLoginID = "arum00003359";
//!!!!!! debug Only";
}
Session["IDLogin"] = strLoginID;
classSpd oSPD = new classSpd();
karyawan = oSPD.getKaryawan(strLoginID);
btnListFind_Click(null, null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
pnlView.Visible = false;//param();
string strLoginID = SetLabelWelcome();
if (strLoginID.ToLower() == "wawan010193")
{
//!! debug Only
//strLoginID = "Putu005001";
//strLoginID = "rika009692";
}
Session["IDLogin"] = strLoginID;
classSpd oSPD = new classSpd();
//untuk non karyawan
Panel1.Visible = false;
if (strLoginID.ToUpper() != "SPD")
{
karyawan = oSPD.getKaryawan(strLoginID);
// msUser user = new msUser;
dsSPDDataContext data = new dsSPDDataContext();
var user = from r in data.msUsers
where r.nrp == karyawan.nrp
select r;
foreach (msUser item in user)
{
if (item.roleId == 17 || item.roleId == 19 || item.roleId == 20)
{
Panel1.Visible = true;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
classSpd cspd = new classSpd();
string strLoginID = string.Empty;
classSpd oSPD = new classSpd();
if (Session["IDLogin"] != null)
{
strLoginID = (string)Session["IDLogin"];
}
else
{
strLoginID = SetLabelWelcome();
}
msKaryawan karyawan = oSPD.getKaryawan(strLoginID);
dsSPDDataContext data = new dsSPDDataContext();
Int32 roleid = (from k in data.msUsers
where k.nrp == karyawan.nrp && (k.roleId == Konstan.SYSADMIN || k.roleId == Konstan.GA)
select k.roleId).FirstOrDefault();
if (!IsPostBack)
{
pnlForm.Visible = false;
}
if (roleid == Konstan.GA || strLoginID.Contains("yudisss") || roleid == Konstan.SYSADMIN)
{
//trSPD SPD = new trSPD();
//Calendar1.StartDate = ctx.AddWorkDaysToGetdate().Value;CalculateFutureDate
// Calendar1.StartDate = GetPreviousWorkDay(DateTime.Now);
Calendar1.StartDate = GetPreviousWorkDay(DateTime.Now);
Calendar1.EndDate = (DateTime.Now);
CalendarExtendersabtu.StartDate = GetPreviousWorkDay(DateTime.Now.AddDays(-4));
CalendarExtendersabtu.EndDate = (DateTime.Now.AddDays(-4));
CalendarExtenderMinggu.StartDate = GetPreviousWorkDay(DateTime.Now.AddDays(-3));
CalendarExtenderMinggu.EndDate = (DateTime.Now.AddDays(-3));
CalendarExtenderSenin.StartDate = GetPreviousWorkDay(DateTime.Now.AddDays(-2));
CalendarExtenderSenin.EndDate = (DateTime.Now.AddDays(-2));
CalendarExtenderSelasa.StartDate = GetPreviousWorkDay(DateTime.Now.AddDays(-1));
CalendarExtenderSelasa.EndDate = (DateTime.Now.AddDays(-1));
pnlForm.Visible = true;
}
else
{
pnlForm.Visible = false;
}
userLoginID = !String.IsNullOrEmpty(strLoginID) ? strLoginID.Length > 10 ? strLoginID.Substring(0, 10).ToString() : strLoginID : "";
}
protected void BtnChange_Click(object sender, EventArgs e)
{
Session["IDLogin"] = TxtChange.Text;
strID = (string)Session["IDLogin"];
karyawan = oSPD.getKaryawan(strID);
Session["nrpLogin"] = karyawan.nrp;
spdGA.Visible = true;
BindAtasan();
bindFind();
bindFindTujuan();
bindFindSPDGa();
}
protected void lbDelete_Click(object sender, EventArgs e)
{
dsSPDDataContext data = new dsSPDDataContext();
LinkButton link = (LinkButton)sender;
GridViewRow gv = (GridViewRow)(link.NamingContainer);
string nrp = gv.Cells[0].Text;
msKaryawan kr = (from k in data.msKaryawans where k.nrp.Trim() == nrp.Trim() select k).FirstOrDefault();
kr.statusKaryawan = "Not Active";
data.SubmitChanges();
data.Dispose();
fillGV();
}
protected void lbEdit_Click(object sender, EventArgs e)
{
dsSPDDataContext dss = new dsSPDDataContext();
LinkButton link = (LinkButton)sender;
GridViewRow gv = (GridViewRow)(link.NamingContainer);
string nrp = gv.Cells[0].Text;
msKaryawan kr = (from k in dss.msKaryawans where k.nrp.Trim() == nrp.Trim() select k).FirstOrDefault();
fill_form(ref kr);
hfmode.Value = "edit";
pnlForm.Visible = true;
txtNRP.ReadOnly = true;
btnTambah.Visible = false;
}
protected void lbListClaimCancel_Click(object sender, EventArgs e)
{
if (cek_ga(Session["IDLogin"].ToString()))
{
//cr : 2015-01-30 ian
try
{
var lb = (Control)sender;
GridViewRow row = (GridViewRow)lb.NamingContainer;
classSpd oSPD = new classSpd();
karyawan = oSPD.getKaryawan(Session["IDLogin"].ToString());
string noSPD = row.Cells[0].Text;
string nrpApproval = karyawan.nrp;
string emailApproval = karyawan.EMail;
string action = "cancel";
string claimApprove = "ga";
ClaimApprovalUrl claimApprovalUrl = new ClaimApprovalUrl();
lblStat2.Text = claimApprovalUrl.ChangeStatus(noSPD, action, nrpApproval, claimApprove);
//bool approvalMethod = claimApprovalUrl.ChangeStatus(noSPD, action, nrpApproval, claimApprove);
//if (approvalMethod)
//{
// lblStat2.Text = noSPD + " berhasil di" + action + " oleh " + nrpApproval + " " + emailApproval;
//}
//else
//{
// lblStat2.Text = noSPD + " gagal di" + action + " oleh " + nrpApproval + " " + emailApproval;
//}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
#region changed
//string status = "29-SPD Cancel";
//cek_claim(sender, status);
//historyApproval(sender, status);
#endregion
btnFind_Click(null, null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
classSpd cspd = new classSpd();
string strLoginID = string.Empty;
classSpd oSPD = new classSpd();
if (Session["IDLogin"] != null)
{
strLoginID = (string)Session["IDLogin"];
}
else
{
strLoginID = SetLabelWelcome();
}
msKaryawan karyawan = oSPD.getKaryawan(strLoginID);
dsSPDDataContext data = new dsSPDDataContext();
Int32 roleid = (from k in data.msUsers
where k.nrp == karyawan.nrp && (k.roleId == Konstan.SYSADMIN || k.roleId == Konstan.GA)
select k.roleId).FirstOrDefault();
if (roleid == Konstan.GA || strLoginID.Contains("yudisss") || roleid == Konstan.SYSADMIN)
{
pnlFilter.Visible = true;
}
else
{
pnlFilter.Visible = false;
pnlView.Visible = false;
}
if (!Page.IsPostBack)
{
dsSPDDataContext dsp = new dsSPDDataContext();
//var query = (from k in dsp.msKaryawans where k.statusKaryawan.Trim() == "Active" select k);
var query = (from k in dsp.msKaryawans orderby k.namaLengkap select k);
checkBoxes1.DataTextField = "namaLengkap";
checkBoxes1.DataValueField = "namaLengkap";
checkBoxes1.DataSource = query.ToList();
checkBoxes1.DataBind();
//checkBoxes1.Items.Add(new ListItem("Test", "Test"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
classSpd cspd = new classSpd();
string strLoginID = string.Empty;
classSpd oSPD = new classSpd();
if (Session["IDLogin"] != null)
{
strLoginID = (string)Session["IDLogin"];
}
else
{
strLoginID = SetLabelWelcome();
}
msKaryawan karyawan = oSPD.getKaryawan(strLoginID);
dsSPDDataContext data = new dsSPDDataContext();
Int32 roleid = (from k in data.msUsers
where k.nrp == karyawan.nrp && (k.roleId == Konstan.SYSADMIN || k.roleId == Konstan.GA)
select k.roleId).FirstOrDefault();
if (!IsPostBack)
{
pnlForm.Visible = false;
fillGV(txtFilterName.Text.Trim());
}
if (roleid == Konstan.GA || strLoginID.Contains("yudisss") || strLoginID.Contains("Syam005812") || roleid == Konstan.SYSADMIN)
{
pnlGrid.Visible = true;
gvRole.Visible = true;
}
else
{
pnlGrid.Visible = false;
gvRole.Visible = false;
}
userLoginID = !String.IsNullOrEmpty(strLoginID) ? strLoginID.Length > 10 ? strLoginID.Substring(0, 10).ToString() : strLoginID : "";
}
protected void Page_Load(object sender, EventArgs e)
{
classSpd cspd = new classSpd();
string strLoginID = string.Empty;
classSpd oSPD = new classSpd();
if (Session["IDLogin"] != null)
{
strLoginID = (string)Session["IDLogin"];
}
else
{
strLoginID = SetLabelWelcome();
}
msKaryawan karyawan = oSPD.getKaryawan(strLoginID);
dsSPDDataContext data = new dsSPDDataContext();
Int32 roleid = (from k in data.msUsers
where k.nrp == karyawan.nrp && (k.roleId == Konstan.SYSADMIN || k.roleId == Konstan.GA)
select k.roleId).FirstOrDefault();
if (roleid == Konstan.GA || strLoginID.Contains("yudisss") || roleid == Konstan.SYSADMIN)
{
gvMasterHardship.Visible = true;
btnTambah.Visible = true;
}
else
{
gvMasterHardship.Visible = false;
btnTambah.Visible = false;
}
if (!IsPostBack)
{
inputForm.Visible = false;
hfmode.Value = "add";
BindDropdowListPropinsi();
BindGridMasterHardship();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IDLogin"] == null)
{
Response.Redirect("frmHome.aspx");
}
strID = (string)Session["IDLogin"];
karyawan = oSPD.getKaryawan(strID);
Session["nrpLogin"] = karyawan.nrp;
if (string.IsNullOrEmpty(karyawan.nrp))
{
Response.Redirect("frmHome.aspx");
}
if (!IsPostBack)
{
ClaimGA.Visible = false;
finance.Visible = false;
switch (userType(karyawan.nrp))
{
case 17: // GA
BindGA();
ClaimGA.Visible = true;
break;
case 19: // GA
BindFinance();
finance.Visible = true;
break;
default:
break;
}
}
}
protected void btnView_Click(object sender, EventArgs e)
{
if (tbNoSPD.Text == "")
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", string.Format("alert('Isi no SPD');"), true);
return;
}
//this.CrystalReportSource1.Report.FileName = "~/UserControls/Reports/DriverAbsence.rpt";
//validasi spd punya user login
string strLoginID = "";
if (Session["IDLogin"] == null)
{
Response.Redirect("frmHome.aspx");
}
else
{
strLoginID = (string)Session["IDLogin"];
}
dsSPDDataContext dsp = new dsSPDDataContext();
classSpd oSPD = new classSpd();
msKaryawan karyawan = oSPD.getKaryawan(strLoginID);
var trSpd = (from k in dsp.trSPDs
where k.nrp == karyawan.nrp
select k).First();
if (trSpd == null)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alertAkses", string.Format("alert('Akses di tolak');"), true);
}
else
{
this.CrystalReportSource1.ReportDocument.SetParameterValue("noSPDClaim", tbNoSPD.Text);
LogonReport(this.CrystalReportSource1.ReportDocument);
pnlView.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string strLoginID = string.Empty;
bool ga = false;
if (Session["IDLogin"] != null)
{
strLoginID = (string)Session["IDLogin"];
}
else
{
strLoginID = SetLabelWelcome();
}
ga = cek_ga(strLoginID);
if (cek_ga(strLoginID) == false && cek_su(strLoginID) == false)
{
Response.Redirect("frmHome.aspx");
}
classSpd oSPD = new classSpd();
karyawan = oSPD.getKaryawan(strLoginID);
if (ddlTipe.SelectedValue == "spd")
{
PanelSPD.Visible = false;
PanelClaim.Visible = false;
}
else
{
PanelSPD.Visible = false;
PanelClaim.Visible = false;
}
}
}
protected void btnSimpan_Click(object sender, EventArgs e)
{
dsSPDDataContext dss = new dsSPDDataContext();
string mode = "add";
mode = hfmode.Value.ToString();
msKaryawan kr = (from k in dss.msKaryawans where k.nrp.Trim() == txtNRP.Text.Trim() select k).FirstOrDefault();
if (kr == null)
{
msKaryawan krs = new msKaryawan();
krs = fillK();
dss.msKaryawans.InsertOnSubmit(krs);
dss.SubmitChanges();
dss.Dispose();
clear_form();
notif.Text = "Data berhasil disimpan";
fillGV();
}
else
{
//clear_form();
if (mode == "add")
{
notif.Text = "Simpan gagal : NRP Karyawan Sudah Terdaftar";
}
else
{
fillEdit(ref kr);
dss.SubmitChanges();
dss.Dispose();
clear_form();
notif.Text = "Data berhasil disimpan";
fillGV();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strLoginID = string.Empty;
classSpd oSPD = new classSpd();
if (Session["IDLogin"] != null)
{
strLoginID = (string)Session["IDLogin"];
}
else
{
strLoginID = SetLabelWelcome();
}
msKaryawan karyawan = oSPD.getKaryawan(strLoginID);
dsSPDDataContext data = new dsSPDDataContext();
Int32 roleid = (from k in data.msUsers
where k.nrp == karyawan.nrp && (k.roleId == Konstan.SYSADMIN || k.roleId == Konstan.GA)
select k.roleId).FirstOrDefault();
if (roleid == Konstan.SYSADMIN || roleid == Konstan.GA || strLoginID.Contains("yudi"))
{
cmbxUser.Visible = true;
cmbxUserRole.Visible = true;
gvRole.Visible = true;
btnAdd.Visible = true;
Label1.Visible = true;
Label2.Visible = false;
}
else
{
cmbxUser.Visible = false;
cmbxUserRole.Visible = false;
gvRole.Visible = false;
btnAdd.Visible = false;
Label1.Visible = false;
Label2.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IDLogin"] == null)
{
Response.Redirect("frmHome.aspx");
}
strID = (string)Session["IDLogin"];
karyawan = oSPD.getKaryawan(strID);
Session["nrpLogin"] = karyawan.nrp;
if (string.IsNullOrEmpty(karyawan.nrp))
{
Response.Redirect("frmHome.aspx");
}
nrp.Value = karyawan.nrp;
if ((bool)Session["sekretaris"])
{
if (!IsPostBack)
{
spdDirector.Visible = true;
bindDirect();
ddlstatus.Visible = false;
txtcari.Visible = false;
}
}
else
{
if (!IsPostBack)
{
bindGvlist();
}
}
}
protected void lbListSPDCancel_Click(object sender, EventArgs e)
{
if (cek_ga(Session["IDLogin"].ToString()))
{
//cr : 2015-1-30 ian
try
{
var lb = (Control)sender;
GridViewRow row = (GridViewRow)lb.NamingContainer;
classSpd oSPD = new classSpd();
karyawan = oSPD.getKaryawan(Session["IDLogin"].ToString());
string noSPD = row.Cells[0].Text;
string nrpApproval = karyawan.nrp;
string emailApproval = karyawan.EMail;
string action = "cancel";
ApprovalUrl1 approvalUrl = new ApprovalUrl1();
lblStat.Text = approvalUrl.ChangeStatus(noSPD, action, nrpApproval);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
#region changed
//string status = "29-SPD Cancel";
//cek_spd(sender, status);
//historyApproval(sender, status);
#endregion
btnFind_Click(null, null);
}
}
private void ubahStatusSPD(string strNoSpd, string stat, string subject, HttpContext ctx)
{
string role = string.Empty, Approver = string.Empty;
bool sending = false;
dsSPDDataContext data = new dsSPDDataContext();
trSPD oSpd = (from spd in data.trSPDs
where spd.noSPD == strNoSpd
select spd).FirstOrDefault();
msKaryawan kary = new msKaryawan();
if (oSpd.nrp != "99999999")
{
kary = (from kar in data.msKaryawans
where kar.nrp == oSpd.nrp
select kar).FirstOrDefault();
}
//Ditambahkan oleh martha
else if (oSpd.nrp == "2950")
{
kary.EMail = "*****@*****.**";
kary.nrp = oSpd.nrp;
kary.namaLengkap = oSpd.namaLengkap;
kary.golongan = "III";
kary.Job = oSpd.jabatan;
kary.posisi = oSpd.jabatan;
kary.coCd = "1";
kary.kodePSubArea = "1";
kary.kodePA = "1";
}
else
{
kary.EMail = oSpd.email;
kary.nrp = oSpd.nrp;
kary.namaLengkap = oSpd.namaLengkap;
kary.golongan = "III";
kary.Job = oSpd.jabatan;
kary.posisi = oSpd.jabatan;
kary.coCd = "1";
kary.kodePSubArea = "1";
kary.kodePA = "1";
}
if (subject.ToLower().Trim() == "atasan")
{
if (stat.ToLower().Trim() == "approve")
{
if (oSpd.status.Split('-')[0] == "2")
{
oSpd.status = "3-Atasan Approve";
ctx.Response.Write("Berhasil di approve");
sending = true;
}
else
{
ctx.Response.Write("SPD Sudah Diapprove sebelumnya");
sending = false;
}
}
else
{
if (oSpd.status.Split('-')[0] == "2")
{
oSpd.status = "12-SPD Tolak (Atasan)";
ctx.Response.Write("Berhasil di reject");
sending = true;
}
else
{
ctx.Response.Write("SPD Sudah di tolak sebelumnya");
sending = false;
}
}
role = "1";
Approver = oSpd.nrpAtasan;
}
else if (subject.ToLower().Trim() == "tujuan")
{
if (oSpd.tglBerangkat.Date > DateTime.Now.Date)
{
ctx.Response.Write("SPD belum bisa approve/reject karena tanggal berangkat harus sesudah atau sama dengan hari ini");
sending = false;
return;
}
if (stat.ToLower().Trim() == "approve")
{
if (oSpd.status.Split('-')[0] == "3")
{
oSpd.status = "7-Tempat Tujuan Approve";
ctx.Response.Write("Berhasil di approve");
sending = true;
}
else
{
ctx.Response.Write("SPD Sudah Diapprove sebelumnya");
sending = false;
}
}
else
{
if (oSpd.status.Split('-')[0] == "3")
{
oSpd.status = "13-SPD Tolak (Tujuan)";
ctx.Response.Write("Berhasil di reject");
sending = true;
}
else
{
ctx.Response.Write("SPD sudah ditolak sebelumnya");
sending = false;
}
}
role = "2";
Approver = oSpd.nrpApprovalTujuan;
}
if (sending)
{
trApprovalHistory ah = new trApprovalHistory();
ah.noSPD = strNoSpd;
ah.idRole = role;
ah.statusApproval = oSpd.status;
ah.nrpApprover = Approver;
ah.approvalDatetime = DateTime.Now;
data.trApprovalHistories.InsertOnSubmit(ah);
data.SubmitChanges();
classSpd oClassSPD = new classSpd();
switch (oSpd.status.Split('-')[0])
{
case "2":
oClassSPD.sendMail(oSpd, "Atasan", kary);
break;
case "3":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
oClassSPD.sendMail(oSpd, "Tujuan", kary);
oClassSPD.sendMail(oSpd, "GA", kary);
break;
case "6":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
oClassSPD.sendMail(oSpd, "Tujuan", kary);
oClassSPD.sendMail(oSpd, "GA", kary);
break;
case "7":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "8":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "9":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "12":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "13":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
}
}
data.Dispose();
}
private void ubahStatusClaim(string strNoSpd, string stat, string subject, HttpContext ctx)
{
string role = string.Empty, Approver = string.Empty;
dsSPDDataContext data = new dsSPDDataContext();
bool sending = false;
trSPD oSpd = (from spd in data.trSPDs
where spd.noSPD == strNoSpd
select spd).First();
trClaim oClaim = (from spd in data.trClaims
where spd.noSPD == strNoSpd
select spd).First();
msKaryawan kary = new msKaryawan();
if (oSpd.nrp != "99999999")
{
kary = (from kar in data.msKaryawans
where kar.nrp == oSpd.nrp
select kar).FirstOrDefault();
}
else
{
kary.EMail = oSpd.email;
kary.nrp = oSpd.nrp;
kary.namaLengkap = oSpd.namaLengkap;
kary.golongan = "III";
kary.Job = oSpd.jabatan;
kary.posisi = oSpd.jabatan;
kary.coCd = "1";
kary.kodePSubArea = "1";
kary.kodePA = "1";
}
if (subject.ToLower().Trim() == "atasan")
{
if (stat.ToLower().Trim() == "approve")
{
if (oSpd.status.Split('-')[0] == "11")
{
oClaim.status = "16-Claim Approve (Atasan)";
oSpd.status = "16-Claim Approve (Atasan)";
ctx.Response.Write("Berhasil di approve");
sending = true;
}
else
{
ctx.Response.Write("Claim sudah berhasil Di approve sebelumnya");
sending = false;
}
}
else
{
if (oSpd.status.Split('-')[0] == "11")
{
oClaim.status = "14-Claim Tolak (Atasan)";
oSpd.status = "14-Claim Tolak (Atasan)";
ctx.Response.Write("Berhasil di reject");
sending = true;
}
else
{
ctx.Response.Write("Claim sudah berhasil ditolak sebelumnya");
sending = false;
}
}
role = "1";
Approver = oSpd.nrpAtasan;
}
else if (subject.ToLower().Trim() == "ga")
{
if (stat.ToLower().Trim() == "approve")
{
if (oSpd.status.Split('-')[0] == "16")
{
oClaim.status = "17-Claim Approve (GA)";
oSpd.status = "17-Claim Approve (GA)";
ctx.Response.Write("Berhasil di approve");
sending = true;
}
else
{
ctx.Response.Write("Claim sudah berhasil di-approve sebelumnya");
sending = false;
}
}
else
{
if (oSpd.status.Split('-')[0] == "16")
{
oClaim.status = "15-Claim Tolak (GA)";
oSpd.status = "15-Claim Tolak (GA)";
ctx.Response.Write("Berhasil di reject");
sending = true;
}
else
{
ctx.Response.Write("Claim sudah berhasil di-reject sebelumnya");
sending = false;
}
}
role = "17";
Approver = oSpd.nrpAtasan;
}
else if (subject.ToLower().Trim() == "finance")
{
if (stat.ToLower().Trim() == "approve")
{
if (oSpd.status.Split('-')[0] == "17")
{
oClaim.status = "26-Finance Approve";
oSpd.status = "26-Finance Approve";
ctx.Response.Write("Berhasil di approve");
sending = true;
}
else
{
ctx.Response.Write("Claim sudah berhasil di-Approve sebelumnya");
sending = false;
}
}
else
{
if (oSpd.status.Split('-')[0] == "17")
{
oClaim.status = "27-Finance Tolak";
oSpd.status = "27-Finance Tolak";
ctx.Response.Write("Berhasil di reject");
sending = true;
}
else
{
ctx.Response.Write("Claim sudah berhasil di-reject sebelumnya");
sending = false;
}
}
role = "19";
Approver = oSpd.nrpAtasan;
}
else if (subject.ToLower().Trim() == "kasir")
{
if (oSpd.status.Split('-')[0] == "26")
{
oClaim.status = "20-Claim Close";
oSpd.status = "20-Claim Close";
ctx.Response.Write("Berhasil di Close");
sending = true;
}
else
{
ctx.Response.Write("Claim sudah berhasil di-Close sebelumnya");
sending = false;
}
role = "20";
Approver = oSpd.nrpAtasan;
}
//data.SubmitChanges();
if (sending)
{
classSpd oClassSPD = new classSpd();
trApprovalHistory ah = new trApprovalHistory();
ah.noSPD = strNoSpd;
ah.idRole = role;
ah.statusApproval = oSpd.status;
ah.nrpApprover = Approver;
ah.approvalDatetime = DateTime.Now;
data.trApprovalHistories.InsertOnSubmit(ah);
data.SubmitChanges();
switch (oSpd.status.Split('-')[0])
{
case "2":
oClassSPD.sendMail(oSpd, "Atasan", kary);
break;
case "3":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
oClassSPD.sendMail(oSpd, "GA", kary);
oClassSPD.sendMail(oSpd, "Tujuan", kary);
break;
case "6":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
oClassSPD.sendMail(oSpd, "GA", kary);
oClassSPD.sendMail(oSpd, "Tujuan", kary);
break;
case "8":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "9":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "12":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "13":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "14":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "16":
oClassSPD.sendMail(oSpd, "GA", kary);
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "15":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "17":
oClassSPD.sendMail(oSpd, "finance", kary);
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "27":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "26":
//oClassSPD.sendMail(oSpd, "kasir", kary);
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
case "20":
oClassSPD.sendMail(oSpd, "Pembuat", kary);
break;
}
}
data.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
strID = (string)Session["IDLogin"];
karyawan = oSPD.getKaryawan(strID);
}
internal void sendMail(trSPD spd, string To, msKaryawan kar)
{
System.Net.Mail.MailMessage email = new System.Net.Mail.MailMessage();
StringBuilder emailMessage = new StringBuilder();
StringBuilder emailMessageFrom = new StringBuilder();
StringBuilder Content = new StringBuilder();
dsSPDDataContext data = new dsSPDDataContext();
var Atasan = (from k in data.msKaryawans
where k.nrp == spd.nrpAtasan
select k);
//nrp ilang
msKaryawan Tujuan = new msKaryawan();
Tujuan = (from k in data.msKaryawans
where k.nrp == spd.nrpApprovalTujuan
select k).SingleOrDefault();
msKaryawan Pengirim = new msKaryawan();
Pengirim = (from k in data.msKaryawans
where k.nrp == spd.nrp
select k).FirstOrDefault();
if (kar.nrp == "99999999")
{
Pengirim = kar;
//Pengirim.nrp = kar.nrp;
//Pengirim.job = kar.job;
//Pengirim.golongan = kar.golongan;
Pengirim.email = spd.email;
}
//hardcode untuk TRAC HO yang melakukan SPD, GAnya masi ke yulia
if (Pengirim.kodePA == "1000")
{
Pengirim.kodePA = "1";
}
if (Pengirim.kodePSubArea == "1000")
{
Pengirim.kodePSubArea = "1";
}
var gaAsal = (from k in data.msKaryawans
join u in data.msUsers on k.nrp equals u.nrp
where u.roleId == 17 && k.coCd == Pengirim.coCd && k.kodePA == Pengirim.kodePA && k.kodePSubArea == Pengirim.kodePSubArea
select k);
//msKaryawan atasanGaAsal = (from k in data.msKaryawans
// where k.nrp == gaAsal.nrpAtasan
// select k).SingleOrDefault();
var KasirAsal = (from k in data.msKaryawans
join u in data.msUsers on k.nrp equals u.nrp
where u.roleId == 20 && k.coCd == Pengirim.coCd && k.kodePA == Pengirim.kodePA && k.kodePSubArea == Pengirim.kodePSubArea
select k);
var FinanceAsal = (from k in data.msKaryawans
join u in data.msUsers on k.nrp equals u.nrp
where u.roleId == 19 && k.coCd == Pengirim.coCd && k.kodePA == Pengirim.kodePA && k.kodePSubArea == Pengirim.kodePSubArea
select k);
trClaim claim = new trClaim();
claim = (from c in data.trClaims
where c.noSPD == spd.noSPD
select c).FirstOrDefault();
if (To == "Extend")
{
email.Subject = "Extend SPD " + spd.noSPD + "-" + spd.namaLengkap;
string mailAddress = string.Empty;
string NamaLengkap = string.Empty;
foreach (msKaryawan item in Atasan)
{
mailAddress += item.email.Trim() + ",";
NamaLengkap += item.namaLengkap + "/";
}
mailAddress = mailAddress.Remove(mailAddress.Length - 1);
NamaLengkap = NamaLengkap.Remove(NamaLengkap.Length - 1);
email.To.Add(mailAddress);
email.Bcc.Add("*****@*****.**");
emailMessage.Append(string.Format("Kepada Yth, "));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}", NamaLengkap));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0} telah melakukan <b>Extend SPD</b> dengan rincian sebagai berikut : ", spd.namaLengkap));
emailMessage.Append("<br />");
Content = ContentBodymail(Content, spd, null, kar);
emailMessage.Append(Content);
emailMessage.Append("Terima kasih.");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
//send extend mail here
}
else
{
if (spd.status.Split('-')[0] == "2")
{
email.Subject = "Approval SPD " + spd.noSPD + "-" + spd.namaLengkap;
string mailAddress = string.Empty;
string NamaLengkap = string.Empty;
foreach (var item in gaAsal)
{
mailAddress += item.email.Trim() + ",";
NamaLengkap += item.namaLengkap + "/";
}
foreach (msKaryawan item in Atasan)
{
mailAddress += item.email.Trim() + ",";
NamaLengkap += item.namaLengkap + "/";
}
mailAddress = mailAddress.Remove(mailAddress.Length - 1);
NamaLengkap = NamaLengkap.Remove(NamaLengkap.Length - 1);
email.To.Add(mailAddress);
email.Bcc.Add("*****@*****.**");
emailMessage.Append(string.Format("Kepada Yth, "));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}", NamaLengkap));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0} telah mengirim <b>Request Approval SPD</b> dengan rincian sebagai berikut : ", spd.namaLengkap));
emailMessage.Append("<br />");
Content = ContentBodymail(Content, spd, null, kar);
emailMessage.Append(Content);
emailMessage.Append("Apabila Bapak/ Ibu berada di kantor bisa menggunakan link dibawah ini untuk melakukan approve/reject Request Claim SPD tersebut");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<a href='http://trac54/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}'>Approve</a>", spd.noSPD, "atasan", "spd"));
emailMessage.Append(" ");
emailMessage.Append("|");
emailMessage.Append(" ");
emailMessage.Append(string.Format("<a href='http://trac54/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}'>Reject</a>", spd.noSPD, "atasan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Jika link di atas tidak dapat diklik, copy dan gunakan URL dibawah ini di browser: ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Approve : http://trac54/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2} ", spd.noSPD, "atasan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Reject : http://trac54/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2} ", spd.noSPD, "atasan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Apabila Bapak/ Ibu berada di luar kantor bisa menggunakan link dibawah ini ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<a href='http://118.97.80.12/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}'>Approve</a>", spd.noSPD, "atasan", "spd"));
emailMessage.Append(" ");
emailMessage.Append("|");
emailMessage.Append(" ");
emailMessage.Append(string.Format("<a href='http://118.97.80.12/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}'>Reject</a>", spd.noSPD, "atasan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Jika link di atas tidak dapat diklik, copy dan gunakan URL dibawah ini di browser: ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Approve : http://118.97.80.12/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2} ", spd.noSPD, "atasan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Reject : http://118.97.80.12/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2} ", spd.noSPD, "atasan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
}
else if ((spd.status.Split('-')[0] == "3" || spd.status.Split('-')[0] == "6" || spd.status.Split('-')[0] == "7" || spd.status.Split('-')[0] == "8" || spd.status.Split('-')[0] == "9" ||
spd.status.Split('-')[0] == "12" || spd.status.Split('-')[0] == "13") && To == "Pembuat")
{
email.Subject = "Informasi SPD " + spd.noSPD + "-" + spd.namaLengkap;
email.To.Add(Pengirim.email.Trim());
email.Bcc.Add("*****@*****.**");
emailMessage.Append(string.Format("Kepada Yth, "));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}", Pengirim.namaLengkap));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Status Request SPD Bapak/Ibu {0} adalah <b>{1}</b>.Berikut ini rincian SPD tersebut : ", spd.namaLengkap, spd.status.Split('-')[1]));
emailMessage.Append("<br />");
Content = ContentBodymail(Content, spd, null, kar);
emailMessage.Append(Content);
emailMessage.Append("Terima kasih.");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
}
else if ((spd.status.Split('-')[0] == "3" || spd.status.Split('-')[0] == "6") && To == "GA")
{
email.Subject = "Informasi SPD " + spd.noSPD + "-" + spd.namaLengkap;
string mailAddress = string.Empty;
string NamaLengkap = string.Empty;
foreach (var item in gaAsal)
{
mailAddress += item.email.Trim() + ",";
NamaLengkap += item.namaLengkap + "/";
}
mailAddress = mailAddress.Remove(mailAddress.Length - 1);
NamaLengkap = NamaLengkap.Remove(NamaLengkap.Length - 1);
email.To.Add(mailAddress);
email.Bcc.Add("*****@*****.**");
emailMessage.Append(string.Format("Kepada Yth, "));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}", NamaLengkap));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Status Request SPD Bapak/Ibu {0} <b>Sudah Disetujui atasan</b>. Mohon bantuannya untuk mencarikan tiket dengan rincian sebagai berikut : ", spd.namaLengkap, spd.status.Split('-')[1]));
emailMessage.Append("<br />");
Content = ContentBodymail(Content, spd, null, kar);
emailMessage.Append(Content);
emailMessage.Append("Terima kasih.");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
}
else if ((spd.status.Split('-')[0] == "3" || spd.status.Split('-')[0] == "6") && To == "Tujuan")
{
email.Subject = "Approval SPD " + spd.noSPD + "-" + spd.namaLengkap;
email.To.Add(Tujuan.email.Trim());
email.Bcc.Add("*****@*****.**");
emailMessage.Append(string.Format("Kepada Yth, "));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}", Tujuan.namaLengkap));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}, telah mengirim <b>Request Approval SPD atasan tempat tujuan</b> dengan rincian sebagai berikut : ", spd.namaLengkap));
emailMessage.Append("<br />");
Content = ContentBodymail(Content, spd, null, kar);
emailMessage.Append(Content);
emailMessage.Append("Apabila Bapak/ Ibu berada di kantor bisa menggunakan link dibawah ini untuk melakukan approve/reject Request Claim SPD tersebut");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<a href='http://trac54/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}'>Approve</a>", spd.noSPD, "tujuan", "spd"));
emailMessage.Append(" ");
emailMessage.Append("|");
emailMessage.Append(" ");
emailMessage.Append(string.Format("<a href='http://trac54/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}'>Reject</a>", spd.noSPD, "tujuan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Jika link di atas tidak dapat diklik, copy dan gunakan URL dibawah ini di browser: ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Approve : http://trac54/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2} ", spd.noSPD, "tujuan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Reject : http://trac54/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2} ", spd.noSPD, "tujuan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Apabila Bapak/ Ibu berada di luar kantor bisa menggunakan link dibawah ini ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<a href='http://118.97.80.12/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}'>Approve</a>", spd.noSPD, "tujuan", "spd"));
emailMessage.Append(" ");
emailMessage.Append("|");
emailMessage.Append(" ");
emailMessage.Append(string.Format("<a href='http://118.97.80.12/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}'>Reject</a>", spd.noSPD, "tujuan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Jika link di atas tidak dapat diklik, copy dan gunakan URL dibawah ini di browser: ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Approve : http://118.97.80.12/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}", spd.noSPD, "tujuan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Reject : http://118.97.80.12/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}", spd.noSPD, "tujuan", "spd"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("*Catatan : Mohon lakukan approval apabila karyawan yang melakukan SPD sudah tiba di tempat tujuan");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b style='color: red;'>**Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
}
else if (spd.status.Split('-')[0] == "11")
{
string mailAddress = string.Empty;
string NamaLengkap = string.Empty;
foreach (var item in Atasan)
{
mailAddress += item.email.Trim() + ",";
NamaLengkap += item.namaLengkap + "/";
}
mailAddress = mailAddress.Remove(mailAddress.Length - 1);
NamaLengkap = NamaLengkap.Remove(NamaLengkap.Length - 1);
email.Subject = "Approval Claim " + spd.noSPD + "-" + spd.namaLengkap;
email.To.Add(mailAddress);
email.Bcc.Add("*****@*****.**");
emailMessage.Append(string.Format("Kepada Yth, "));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}", NamaLengkap));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0} telah mengirim <b>Request Approval Claim SPD</b> dengan rincian sebagai berikut : ", spd.namaLengkap));
emailMessage.Append("<br />");
Content = ContentBodymail(Content, spd, claim, kar);
emailMessage.Append(Content);
emailMessage.Append("Apabila Bapak/ Ibu berada di kantor bisa menggunakan link dibawah ini untuk melakukan approve/reject Request Claim SPD tersebut");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<a href='http://trac54/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}'>Approve</a>", spd.noSPD, "atasan", "claim"));
emailMessage.Append(" ");
emailMessage.Append("|");
emailMessage.Append(" ");
emailMessage.Append(string.Format("<a href='http://trac54/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}'>Reject</a>", spd.noSPD, "atasan", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("Jika link di atas tidak dapat diklik, copy dan gunakan URL dibawah ini di browser: ");
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Approve : http://trac54/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}", spd.noSPD, "atasan", "claim"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Reject : http://trac54/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}", spd.noSPD, "atasan", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Apabila Bapak/ Ibu berada di luar kantor bisa menggunakan link dibawah ini ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<a href='http://118.97.80.12/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}'>Approve</a>", spd.noSPD, "atasan", "claim"));
emailMessage.Append(" ");
emailMessage.Append("|");
emailMessage.Append(" ");
emailMessage.Append(string.Format("<a href='http://118.97.80.12/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}'>Reject</a>", spd.noSPD, "atasan", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Jika link di atas tidak dapat diklik, copy dan gunakan URL dibawah ini di browser: ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Approve : http://118.97.80.12/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}", spd.noSPD, "atasan", "claim"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Reject : http://118.97.80.12/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}", spd.noSPD, "atasan", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
}
else if ((spd.status.Split('-')[0] == "14" || spd.status.Split('-')[0] == "15" || spd.status.Split('-')[0] == "16" || spd.status.Split('-')[0] == "17" ||
spd.status.Split('-')[0] == "18" || spd.status.Split('-')[0] == "19" || spd.status.Split('-')[0] == "20" || spd.status.Split('-')[0] == "26" || spd.status.Split('-')[0] == "27") && To == "Pembuat")
{
email.Subject = "Info Claim " + spd.noSPD + "-" + spd.namaLengkap;
email.To.Add(Pengirim.email.Trim());
email.Bcc.Add("*****@*****.**");
emailMessage.Append(string.Format("Kepada Yth, "));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}", Pengirim.namaLengkap));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Status Request Claim SPD Bapak/Ibu {0} adalah <b>{1}</b>.Berikut ini rincian Claim SPD tersebut: ", spd.namaLengkap, spd.status.Split('-')[1]));
emailMessage.Append("<br />");
Content = ContentBodymail(Content, spd, claim, kar);
emailMessage.Append(Content);
emailMessage.Append("Terima kasih.");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
}
else if ((spd.status.Split('-')[0] == "16") && To == "GA")
{
string mailAddress = string.Empty;
string NamaLengkap = string.Empty;
foreach (var item in gaAsal)
{
mailAddress += item.email.Trim() + ",";
NamaLengkap += item.namaLengkap + "/";
}
mailAddress = mailAddress.Remove(mailAddress.Length - 1);
NamaLengkap = NamaLengkap.Remove(NamaLengkap.Length - 1);
email.Subject = "Approval Claim " + spd.noSPD + "-" + spd.namaLengkap;
email.To.Add(mailAddress);
email.Bcc.Add("*****@*****.**");
emailMessage.Append(string.Format("Kepada Yth, "));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}", NamaLengkap));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Status Request SPD Bapak/Ibu {0} <b>Sudah Di-Approve atasan</b> dengan rincian sebagai berikut : ", spd.namaLengkap, spd.status.Split('-')[1]));
emailMessage.Append("<br />");
Content = ContentBodymail(Content, spd, claim, kar);
emailMessage.Append(Content);
emailMessage.Append("Apabila Bapak/ Ibu berada di kantor bisa menggunakan link dibawah ini untuk melakukan approve/reject Request Claim SPD tersebut");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<a href='http://trac54/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}'>Approve</a>", spd.noSPD, "ga", "claim"));
emailMessage.Append(" ");
emailMessage.Append("|");
emailMessage.Append(" ");
emailMessage.Append(string.Format("<a href='http://trac54/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}'>Reject</a>", spd.noSPD, "ga", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Jika link di atas tidak dapat diklik, copy dan gunakan URL dibawah ini di browser: ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Approve : http://trac54/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}", spd.noSPD, "ga", "claim"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Reject : http://trac54/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}", spd.noSPD, "ga", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Apabila Bapak/ Ibu berada di luar kantor bisa menggunakan link dibawah ini ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<a href='http://118.97.80.12/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}'>Approve</a>", spd.noSPD, "ga", "claim"));
emailMessage.Append(" ");
emailMessage.Append("|");
emailMessage.Append(" ");
emailMessage.Append(string.Format("<a href='http://118.97.80.12/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}'>Reject</a>", spd.noSPD, "ga", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Jika link di atas tidak dapat diklik, copy dan gunakan URL dibawah ini di browser: ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Approve : http://118.97.80.12/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}", spd.noSPD, "ga", "claim"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Reject : http://118.97.80.12/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}", spd.noSPD, "ga", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
}
else if ((spd.status.Split('-')[0] == "17") && To == "finance")
{
string mailAddress = string.Empty;
string NamaLengkap = string.Empty;
foreach (var item in FinanceAsal)
{
mailAddress += item.email.Trim() + ",";
NamaLengkap += item.namaLengkap + "/";
}
mailAddress = mailAddress.Remove(mailAddress.Length - 1);
NamaLengkap = NamaLengkap.Remove(NamaLengkap.Length - 1);
email.Subject = "Approval Claim " + spd.noSPD + "-" + spd.namaLengkap;
email.To.Add(mailAddress);
email.Bcc.Add("*****@*****.**");
emailMessage.Append(string.Format("Kepada Yth, "));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}", NamaLengkap));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Status Request SPD Bapak/Ibu {0} <b>Sudah Di-Approve GA</b> dengan rincian sebagai berikut : ", spd.namaLengkap, spd.status.Split('-')[1]));
emailMessage.Append("<br />");
Content = ContentBodymail(Content, spd, claim, kar);
emailMessage.Append(Content);
emailMessage.Append("Apabila Bapak/ Ibu berada di kantor bisa menggunakan link dibawah ini untuk melakukan approve/reject Request Claim SPD tersebut");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<a href='http://trac54/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}'>Approve</a>", spd.noSPD, "finance", "claim"));
emailMessage.Append(" ");
emailMessage.Append("|");
emailMessage.Append(" ");
emailMessage.Append(string.Format("<a href='http://trac54/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}'>Reject</a>", spd.noSPD, "finance", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Jika link di atas tidak dapat diklik, copy dan gunakan URL dibawah ini di browser: ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Approve : http://trac54/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}", spd.noSPD, "finance", "claim"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Reject : http://trac54/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}", spd.noSPD, "finance", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Apabila Bapak/ Ibu berada di luar kantor bisa menggunakan link dibawah ini ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<a href='http://118.97.80.12/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}'>Approve</a>", spd.noSPD, "finance", "claim"));
emailMessage.Append(" ");
emailMessage.Append("|");
emailMessage.Append(" ");
emailMessage.Append(string.Format("<a href='http://118.97.80.12/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}'>Reject</a>", spd.noSPD, "finance", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append("Jika link di atas tidak dapat diklik, copy dan gunakan URL dibawah ini di browser: ");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Approve : http://118.97.80.12/SPD/approvalSPD.ashx?conf=approve&nospd={0}&subject={1}&type={2}", spd.noSPD, "finance", "claim"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Reject : http://118.97.80.12/SPD/approvalSPD.ashx?conf=reject&nospd={0}&subject={1}&type={2}", spd.noSPD, "finance", "claim"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
}
else if ((spd.status.Split('-')[0] == "26") && To == "kasir")
{
string mailAddress = string.Empty;
string NamaLengkap = string.Empty;
foreach (var item in KasirAsal)
{
mailAddress += item.email.Trim() + ",";
NamaLengkap += item.namaLengkap + "/";
}
mailAddress = mailAddress.Remove(mailAddress.Length - 1);
NamaLengkap = NamaLengkap.Remove(NamaLengkap.Length - 1);
email.Subject = "Approval Claim " + spd.noSPD + "-" + spd.namaLengkap;
email.To.Add(mailAddress);
email.Bcc.Add("*****@*****.**");
emailMessage.Append(string.Format("Kepada Yth, "));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Bapak/Ibu {0}", NamaLengkap));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Status Request SPD Bapak/Ibu {0} <b>Sudah Di-Approve Finance</b> dengan rincian sebagai berikut : ", spd.namaLengkap, spd.status.Split('-')[1]));
emailMessage.Append("<br />");
Content = ContentBodymail(Content, spd, claim, kar);
emailMessage.Append(Content);
emailMessage.Append("Terima kasih.");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
}
}
#region Unused
//else if ((spd.status.Split('-')[0] == "17") && To == "GA")
//{
// email.Subject = "Informasi Claim";
// //next to do
// //email.To.Add(Atasan.email);
// emailMessage.Append(string.Format("Kepada Yth, "));
// emailMessage.Append("<br />");
// emailMessage.Append(string.Format("Bapak/Ibu {0}", Atasan.namaLengkap));
// emailMessage.Append("<br />");
// emailMessage.Append("<br />");
// emailMessage.Append(string.Format("Status Request SPD Bapak/Ibu {0} Sudah Di-Approve atasan dengan rincian sebagai berikut : ", spd.namaLengkap, spd.status.Split('-')[1]));
// emailMessage.Append("<br />");
// Content = ContentBodymail(Content, spd, null);
// emailMessage.Append(Content);
// emailMessage.Append("Terima kasih.");
// emailMessage.Append("<br />");
// emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
//}
//else if ((spd.status.Split('-')[0] == "20") && To == "GA")
//{
// email.Subject = "Informasi Claim";
// //next to do
// //email.To.Add(Atasan.email);
// emailMessage.Append(string.Format("Kepada Yth, "));
// emailMessage.Append("<br />");
// emailMessage.Append(string.Format("Bapak/Ibu {0}", Atasan.namaLengkap));
// emailMessage.Append("<br />");
// emailMessage.Append("<br />");
// emailMessage.Append(string.Format("Status Request SPD Bapak/Ibu {0} Sudah Di-Approve atasan dengan rincian sebagai berikut : ", spd.namaLengkap, spd.status.Split('-')[1]));
// emailMessage.Append("<br />");
// Content = ContentBodymail(Content, spd, null);
// emailMessage.Append(Content);
// emailMessage.Append("Terima kasih.");
// emailMessage.Append("<br />");
// emailMessage.Append(string.Format("<b style='color: red;'>Catatan : E-mail ini dikirim otomatis oleh Sistem Pembuatan SPD.Tidak perlu membalas E-mail ini </b>"));
//}
#endregion
email.From = new System.Net.Mail.MailAddress("*****@*****.**");
email.Priority = System.Net.Mail.MailPriority.High;
email.Body = emailMessage.ToString();
email.IsBodyHtml = true;
System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient();
smtp.Send(email);
}
private StringBuilder ContentBodymail(StringBuilder emailMessage, trSPD spd, trClaim claim, msKaryawan kar)
{
//System.Net.Mail.MailMessage email = new System.Net.Mail.MailMessage();
//StringBuilder Content = new StringBuilder();
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b>Detail Karyawan </b>"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("No. SPD : {0}", spd.noSPD));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("NRP : {0}", spd.nrp));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Nama Lengkap : {0}", spd.namaLengkap));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("No Handphone : {0}", spd.NoHP != null ? spd.NoHP : "-"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Jabatan : {0}", kar.posisi));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Organisasi Unit : {0}", kar.organisasiUnit != null ? kar.organisasiUnit : "-"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Company Code : {0}", kar.companyCode != null ? kar.companyCode : "-"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Personel Area : {0}", kar.personelArea != null ? kar.personelArea : "-"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Personel Sub Area : {0}", kar.pSubArea != null ? kar.pSubArea : "-"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Cost Center Pembebanan : {0}", spd.costCenter != null ? spd.costCenter : "-"));
emailMessage.Append("<br />");
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b>Detail SPD </b>"));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Tempat Tujuan : {0}", spd.tempatTujuanLain != null ? spd.tempatTujuanLain : spd.companyCodeTujuan + " - " + spd.personelAreaTujuan + " - " + spd.pSubAreaTujuan));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Keperluan : {0}", spd.keperluanLain != null ? spd.keperluanLain : spd.msKeperluan.keperluan));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Tanggal Berangkat : {0} ", String.Format("{0:MM/dd/yyyy}", spd.tglBerangkat)));
emailMessage.Append(string.Format("Jam Berangkat : {0} ", spd.jamBerangkat));
emailMessage.Append(string.Format("Menit Berangkat : {0} ", spd.menitBerangkat));
emailMessage.Append("<br />");
emailMessage.Append(string.Format("Tanggal Kembali : {0} ", String.Format("{0:MM/dd/yyyy}", spd.tglKembali)));
emailMessage.Append(string.Format("Jam Kembali : {0} ", spd.jamKembali));
emailMessage.Append(string.Format("Menit Kembali : {0} ", spd.menitKembali));
if (claim != null)
{
emailMessage.Append("<br />");
emailMessage.Append(string.Format("<b>Total Claim : {0} </b>", claim.total));
}
emailMessage.Append("<br />");
emailMessage.Append("<br />");
return(emailMessage);
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (var ctx = new dsSPDDataContext())
{
List <string> errorMessageHidden = new List <string>();
trSPD spd = ctx.trSPDs.FirstOrDefault(o => o.noSPD == hiddenSPD.Value);
if (spd == null)
{
errorMessageHidden.Add("Data SPD tidak ditemukan");
}
if (string.IsNullOrEmpty(hiddenNrpAtasan.Value))
{
errorMessageHidden.Add("Data approval atasan tidak ditemukan");
}
trClaim claim = ctx.trClaims.FirstOrDefault(o => o.noSPD == spd.noSPD);
if (claim != null)
{
claim.ApprovedAtasanBy = spd.trClaim.ApprovedAtasanBy;
claim.ApprovedGABy = spd.trClaim.ApprovedGABy;
claim.ApprovedFinanceBy = spd.trClaim.ApprovedFinanceBy;
claim.isApprovedAtasan = spd.trClaim.isApprovedAtasan;
claim.isApprovedAtasanDate = spd.trClaim.isApprovedAtasanDate;
claim.isApprovedFinance = spd.trClaim.isApprovedFinance;
claim.isApprovedFinanceDate = spd.trClaim.isApprovedFinanceDate;
claim.isApprovedGA = spd.trClaim.isApprovedGA;
claim.isApprovedGADate = spd.trClaim.isApprovedGADate;
claim.isCancel = spd.trClaim.isCancel;
claim.isCancelDate = spd.trClaim.isCancelDate;
claim.isSubmit = spd.trClaim.isSubmit;
claim.isSubmitDate = spd.trClaim.isSubmitDate;
claim.status = spd.trClaim.status;
}
if (errorMessageHidden.Count == 0 && claim == null)
{
claim = new trClaim();
claim.noSPD = hiddenSPD.Value;
claim.dibuatOleh = karyawan.nrp;
claim.dibuatTanggal = DateTime.Now;
claim.status = "Saved";
claim.nrpAtasan = hiddenNrpAtasan.Value;
ctx.trClaims.InsertOnSubmit(claim);
}
// convert ke integer
var kursInt = Convert.ToInt32(txtKurs.Text);
var uangMakan = Convert.ToInt32(UangMakan.Text);
var uangSaku = Convert.ToInt32(UangSaku.Text);
var tiket = Convert.ToInt32(Tiket.Text);
var hotel = Convert.ToInt32(Hotel.Text);
var laundry = Convert.ToInt32(Laundry.Text);
var komunikasi = Convert.ToInt32(Komunikasi.Text);
var airPortTax = Convert.ToInt32(AirPortTax.Text);
var bbm = Convert.ToInt32(BBM.Text);
var tol = Convert.ToInt32(Tol.Text);
var taxi = Convert.ToInt32(Taxi.Text);
var parkir = Convert.ToInt32(Parkir.Text);
var tunjanganKejauhan = Convert.ToInt32(Tunjangankejauhan.Text);//9 oktober 2018
var biayaLainlain = Convert.ToInt32(BiayaLainlain.Text);
var total =
uangMakan +
uangSaku +
tiket +
hotel +
laundry +
komunikasi +
airPortTax +
bbm +
tol +
taxi +
parkir +
tunjanganKejauhan +
biayaLainlain;
var uangMuka = Convert.ToInt64(UangMuka.Text);
claim.biayaMakan = uangMakan;
claim.uangSaku = uangSaku;
claim.tiket = tiket;
claim.hotel = hotel;
claim.BBM = bbm;
claim.tol = tol;
claim.taxi = taxi;
claim.airportTax = airPortTax;
claim.laundry = laundry;
claim.parkir = parkir;
claim.komunikasi = komunikasi;
claim.UangTunjanganKejauhan = tunjanganKejauhan; // 9 oktober 2018
claim.ketLainLain = txtKeteranganBiayaLainlain.Text;
claim.biayaLainLain = biayaLainlain;
claim.total = total;
claim.kurs = kursInt;
claim.diubahOleh = karyawan.nrp;
claim.diubahTanggal = DateTime.Now;
spd.uangMuka = uangMuka.ToString();
if (ifga(karyawan.nrp))
{
spd.costCenter = DdlCostCenter.SelectedValue;
}
//update 26 september 2018
claim.uangSaku_cek = cbUangSaku.Checked;
claim.hotelTanpaPenginapan_cek = cbHotelTanpaPenginapan.Checked;//
claim.tiket_cek = cbTiket.Checked;
claim.hotel_cek = cbHotel.Checked;
claim.laundry_cek = cbLaundry.Checked;
claim.komunikasi_cek = cbKomunikasi.Checked;
claim.airportTax_cek = cbAirPortTax.Checked;
claim.BBM_cek = cbBBM.Checked;
claim.tol_cek = cbTol.Checked;
claim.taxi_cek = cbTaxi.Checked;
claim.parkir_cek = cbParkir.Checked;
string rgPattern = "[\\\\\\/:\\*\\?\"\'<>|]";
Regex objRegEx = new Regex(rgPattern);
if (fuDoc.HasFile)
{
string uploadDirbpkb = spd.noSPD + "_1_" + System.IO.Path.GetFileName(fuDoc.PostedFile.FileName);
string strBaseLocation = Server.MapPath("Attach") + "\\" + objRegEx.Replace(uploadDirbpkb, "");
fuDoc.PostedFile.SaveAs(strBaseLocation);
string nama = objRegEx.Replace(uploadDirbpkb, "");
claim.urlBoardingPass = nama;
}
if (fuDoc1.HasFile)
{
string uploadDirbpkb1 = spd.noSPD + "_2_" + System.IO.Path.GetFileName(fuDoc1.PostedFile.FileName);
string strBaseLocation1 = Server.MapPath("Attach") + "\\" + objRegEx.Replace(uploadDirbpkb1, "");
fuDoc1.PostedFile.SaveAs(strBaseLocation1);
string nama1 = objRegEx.Replace(uploadDirbpkb1, "");
claim.urlBoardingPass1 = nama1;
}
try
{
ctx.SubmitChanges();
}
catch (Exception ex)
{
errorMessageHidden.Add("Gagal save claim|" + ex.Message.ToString());
errorMessageHidden.Add(ex.Message);
}
finally
{
pnlSuccess.Visible = true;
pnlError.Visible = false;
lblSuccess.Text += "Claim Berhasil di Save" + Environment.NewLine;
if (ifga(karyawan.nrp))
{
lblSuccess.Text += "Jika submit diclick (GA), maka proses approval akan diulang dari awal.";
}
btnSave.Enabled = false;
btnReset.Disabled = true;
//ian 2015-04-10
if (claim != null)
{
if (claim.isSubmit == true)
{
btnSubmit.Enabled = false;
}
if (claim.isSubmit == null)
{
btnSubmit.Enabled = true;
}
}
else
{
btnSubmit.Enabled = true;
}
//end
if (ifga(karyawan.nrp))
{
if (claim.uangSaku_cek == true || claim.tiket_cek == true || claim.hotel_cek == true || claim.laundry_cek == true || claim.komunikasi_cek == true || claim.airportTax_cek == true || claim.BBM_cek == true || claim.tol_cek == true || claim.taxi_cek == true || claim.parkir_cek == true)
{
msKaryawan kary = new msKaryawan();
if (spd.nrp == "99999999")
{
kary.EMail = spd.email;
kary.nrp = spd.nrp;
kary.namaLengkap = spd.namaLengkap;
kary.golongan = "III";
kary.Job = spd.jabatan;
kary.posisi = spd.jabatan;
kary.coCd = "1";
kary.kodePSubArea = "1";
kary.kodePA = "1";
}
else
{
kary = (from kar in ctx.msKaryawans
where kar.nrp == spd.nrp
select kar).First();
}
classSpd oSpd = new classSpd();
oSpd.sendMailClaim(claim, kary, spd);
}
}
}
if (errorMessageHidden.Count() > 0)
{
errorMessage.DataSource = errorMessageHidden;
errorMessage.DataBind();
pnlError.Visible = true;
pnlSuccess.Visible = false;
btnSubmit.Enabled = false;
}
}
}
