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