public ActionResult Create(TRN_MSG msg)
{
if (ModelState.IsValid)
{
decimal?USER_NO = Session["sess_USER_NO"] as decimal?;
decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?;
//db.TRN_MSG.AddObject(trn_msg);
//db.SaveChanges();
decimal?msg_no = db.TRN_MSG_INSERT(USER_NO, LOGON_NO, USER_NO, msg.MSG_SUBJECT, msg.MSG_BODY,
null, null, null, null).FirstOrDefault().Value;
foreach (ZonalManagerViewModel manager in msg.ZonalManagers)
{
db.TRN_MSG_RECIEVER_INSERT(USER_NO, LOGON_NO, msg_no, manager.USER_NO);
}
return(RedirectToAction("Index"));
}
ViewBag.REF_MSG_NO = new SelectList(db.TRN_MSG, "MSG_NO", "LAST_ACTION", msg.REF_MSG_NO);
ViewBag.ZONAL_USER_NO = new SelectList(db.SEC_USERS
.Where(u => u.USER_TYPE_NO == (decimal)EUserTypes.ZonalManager), "USER_NO", "USER_FULL_NAME");
return(View(msg));
}
public ActionResult DeleteConfirmed(decimal id)
{
TRN_MSG trn_msg = db.TRN_MSG.Single(t => t.MSG_NO == id);
db.TRN_MSG.DeleteObject(trn_msg);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Msg/Delete/5
public ActionResult Delete(decimal id = 0)
{
TRN_MSG trn_msg = db.TRN_MSG.Single(t => t.MSG_NO == id);
if (trn_msg == null)
{
return(HttpNotFound());
}
return(View(trn_msg));
}
//
// GET: /Msg/Edit/5
public ActionResult Edit(decimal id = 0)
{
TRN_MSG trn_msg = db.TRN_MSG.Single(t => t.MSG_NO == id);
if (trn_msg == null)
{
return(HttpNotFound());
}
ViewBag.REF_MSG_NO = new SelectList(db.TRN_MSG, "MSG_NO", "LAST_ACTION", trn_msg.REF_MSG_NO);
return(View(trn_msg));
}
public ActionResult Edit(TRN_MSG trn_msg)
{
if (ModelState.IsValid)
{
db.TRN_MSG.Attach(trn_msg);
db.ObjectStateManager.ChangeObjectState(trn_msg, EntityState.Modified);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.REF_MSG_NO = new SelectList(db.TRN_MSG, "MSG_NO", "LAST_ACTION", trn_msg.REF_MSG_NO);
return(View(trn_msg));
}
