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