// // GET: /ClientEntry/Edit/5 public ActionResult Edit(decimal id = 0) { SET_CLIENT_INFO client = db.SET_CLIENT_INFO.Single(s => s.CLIENT_NO == id); if (client == null) { return(HttpNotFound()); } ViewBag.DIVISION_NO = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME", client.DIVISION_NO); //ViewBag.ZONE_NO = new SelectList(db.SET_ZONE, "ZONE_NO", "LAST_ACTION", client.ZONE_NO); if (client.DIVISION_NO.HasValue) { ViewBag.ZILLA_NO = new SelectList(db.SET_ZILLA.Where(z => z.DIVISION_NO == client.DIVISION_NO), "ZILLA_NO", "ZILLA_NAME", client.ZILLA_NO); } else { ViewBag.ZILLA_NO = new SelectList(db.SET_ZILLA.Where(z => z.ZILLA_NO < 0), "ZILLA_NO", "ZILLA_NAME", client.ZILLA_NO); } if (client.ZILLA_NO.HasValue) { ViewBag.THANA_NO = new SelectList(db.SET_THANA.Where(t => t.ZILLA_NO == client.ZILLA_NO), "THANA_NO", "THANA_NAME", client.THANA_NO); } else { ViewBag.THANA_NO = new SelectList(db.SET_THANA.Where(t => t.THANA_NO < 0), "THANA_NO", "THANA_NAME", client.THANA_NO); } return(View(client)); }
// // GET: /ClientEntry/Delete/5 public ActionResult Delete(decimal id = 0) { SET_CLIENT_INFO set_client_info = db.SET_CLIENT_INFO.Single(s => s.CLIENT_NO == id); if (set_client_info == null) { return(HttpNotFound()); } return(View(set_client_info)); }
public ActionResult Edit(SET_CLIENT_INFO client) { if (ModelState.IsValid) { //db.SET_CLIENT_INFO.Attach(set_client_info); //db.ObjectStateManager.ChangeObjectState(set_client_info, EntityState.Modified); //db.SaveChanges(); decimal?USER_NO = Session["sess_USER_NO"] as decimal?; decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?; db.SET_CLIENT_INFO_UPDATE(client.CLIENT_NO, USER_NO, LOGON_NO, client.CLIENT_NAME, client.CLIENT_NAME_BNG, client.CLIENT_NICK_NAME, client.CLIENT_MOBILE, client.CLIENT_DOB, client.CLIENT_MARRIAGE_DATE, client.CLIENT_ADDR, client.CLIENT_COMENTS, client.DIVISION_NO, client.ZONE_NO, client.ZILLA_NO, client.THANA_NO, client.IS_OFFLINE_ENTRY, client.OFFLINE_ENTRY_TIME, client.OFFLINE_ENTRY_SYNC, client.IS_ACTIVE, client.ACTIVE_FROM, client.ACTIVE_TO, client.SL_NUM); return(RedirectToAction("Index")); } ViewBag.DIVISION_NO = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME", client.DIVISION_NO); //ViewBag.ZONE_NO = new SelectList(db.SET_ZONE, "ZONE_NO", "LAST_ACTION", client.ZONE_NO); if (client.DIVISION_NO.HasValue) { ViewBag.ZILLA_NO = new SelectList(db.SET_ZILLA.Where(z => z.DIVISION_NO == client.DIVISION_NO), "ZILLA_NO", "ZILLA_NAME", client.ZILLA_NO); } else { ViewBag.ZILLA_NO = new SelectList(db.SET_ZILLA.Where(z => z.ZILLA_NO < 0), "ZILLA_NO", "ZILLA_NAME", client.ZILLA_NO); } if (client.ZILLA_NO.HasValue) { ViewBag.THANA_NO = new SelectList(db.SET_THANA.Where(t => t.ZILLA_NO == client.ZILLA_NO), "THANA_NO", "THANA_NAME", client.THANA_NO); } else { ViewBag.THANA_NO = new SelectList(db.SET_THANA.Where(t => t.THANA_NO < 0), "THANA_NO", "THANA_NAME", client.THANA_NO); } return(View(client)); }
public ActionResult Create(SET_CLIENT_INFO client) { if (ModelState.IsValid) { //db.SET_CLIENT_INFO.AddObject(set_client_info); //db.SaveChanges(); decimal?USER_NO = Session["sess_USER_NO"] as decimal?; decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?; db.SET_CLIENT_INFO_INSERT(USER_NO, LOGON_NO, client.CLIENT_NAME, client.CLIENT_NAME_BNG, client.CLIENT_NICK_NAME, client.CLIENT_MOBILE, client.CLIENT_DOB, client.CLIENT_MARRIAGE_DATE, client.CLIENT_ADDR, client.CLIENT_COMENTS, client.DIVISION_NO, client.ZONE_NO, client.ZILLA_NO, client.THANA_NO, client.IS_OFFLINE_ENTRY, client.OFFLINE_ENTRY_TIME, client.OFFLINE_ENTRY_SYNC, client.IS_ACTIVE, client.ACTIVE_FROM, client.ACTIVE_TO, client.SL_NUM); return(RedirectToAction("Index")); } ViewBag.DIVISION_NO = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME", client.DIVISION_NO); //ViewBag.ZONE_NO = new SelectList(db.SET_ZONE, "ZONE_NO", "LAST_ACTION", client.ZONE_NO); ViewBag.ZILLA_NO = new SelectList(db.SET_ZILLA.Where(z => z.ZILLA_NO < 0), "ZILLA_NO", "ZILLA_NAME"); ViewBag.THANA_NO = new SelectList(db.SET_THANA.Where(t => t.THANA_NO < 0), "THANA_NO", "THANA_NAME"); return(View(client)); }