public JsonResult AddReqBR(string NamaBank, string txtKeperluan) { 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 = "BREK-" + 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(); buku_rekening bk = new buku_rekening(); bk.id_req = req.id_req; bk.keperluan = txtKeperluan; bk.nama_bank = NamaBank; sopace.buku_rekening.Add(bk); sopace.SaveChanges(); return(Json("Insert Request Success", JsonRequestBehavior.AllowGet)); } else { return(Json("Insert Request Failed", JsonRequestBehavior.AllowGet)); } }
public JsonResult EditBT(string txtIDReq, string NamaBank, string txtKeperluan) { buku_rekening bk = sopace.buku_rekening.Where(e => e.id_req == txtIDReq).First(); bk.keperluan = txtKeperluan; bk.nama_bank = NamaBank; sopace.Entry(bk).State = EntityState.Modified; sopace.SaveChanges(); return(Json("Update Data Request Success", JsonRequestBehavior.AllowGet)); }