public JsonResult AddReqSG(DateTime txtTgl1, DateTime txtTgl2)
{
cekSession();
const string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
Random random = new Random();
string unique = new string(Enumerable.Repeat(chars, 4).Select(s => s[random.Next(s.Length)]).ToArray());
string nama = sopace.personal_information.Where(e => e.NIP == nip).Select(e => e.nama_pegawai).FirstOrDefault();
if (nama != null)
{
request req = new request();
req.id_req = "GAJI-" + DateTime.Now.ToString("yyyy").ToString() + "-" + unique;
req.NIP = nip;
req.nama_pegawai = nama;
req.tanggal_request = DateTime.Now;
req.status = "requested";
sopace.requests.Add(req);
sopace.SaveChanges();
slip_gaji sg = new slip_gaji();
sg.id_req = req.id_req;
sg.durasi_awal = txtTgl1.ToString("yyyy-MM-dd");
sg.durasi_akhir = txtTgl2.ToString("yyyy-MM-dd");
sopace.slip_gaji.Add(sg);
sopace.SaveChanges();
return(Json("Insert Request Success", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Insert Request Failed", JsonRequestBehavior.AllowGet));
}
}
public JsonResult EditSG(string txtIDReq, string txtTgl1, string txtTgl2)
{
slip_gaji sg = sopace.slip_gaji.Where(e => e.id_req == txtIDReq).First();
sg.durasi_awal = txtTgl1;
sg.durasi_akhir = txtTgl2;
sopace.Entry(sg).State = EntityState.Modified;
sopace.SaveChanges();
return(Json("Update Data Request Success", JsonRequestBehavior.AllowGet));
}
