public JsonResult AddReqPBTH(string txtTujuan, string txtDesc) { 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 = "PBTH-" + 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(); pemberitahuan pb = new pemberitahuan(); pb.id_req = req.id_req; pb.tujuan = txtTujuan; pb.deskripsi = txtDesc; sopace.pemberitahuans.Add(pb); sopace.SaveChanges(); return(Json("Insert Request Success", JsonRequestBehavior.AllowGet)); } else { return(Json("Insert Request Failed", JsonRequestBehavior.AllowGet)); } }
public JsonResult EditPBTH(string txtIDReq, string txtTujuan, string txtDesc) { pemberitahuan pb = sopace.pemberitahuans.Where(e => e.id_req == txtIDReq).First(); pb.tujuan = txtTujuan; pb.deskripsi = txtDesc; sopace.Entry(pb).State = EntityState.Modified; sopace.SaveChanges(); return(Json("Update Data Request Success", JsonRequestBehavior.AllowGet)); }