public PartialViewResult AddRouteOfficer(int menuid)
{
try
{
BindComboMsc();
ViewBag.HeaderTitle = "Add Approver User";
ViewBag.ButtonText = "Add";
var obj = new ApprovalRouteOffObj()
{
MENUID = menuid
};
return(PartialView("_AddRouteOfficer", obj));
// return Json(new { RespCode = 99, RespMessage = "Bad Request" }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return(null);
}
}
public OutPutObj PostRouteOfficer(ApprovalRouteOffObj obj, int postType)
{
OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("PID", obj.PID, DbType.String);
p.Add("APPROVER_ID", obj.APPROVER_ID, DbType.String);
p.Add("MENUID", obj.MENUID, DbType.Int32);
p.Add("PRIORITY", obj.PRIORITY, DbType.Int32);
p.Add("CREATEDATE", obj.CREATEDATE, DbType.DateTime);
p.Add("USERID", obj.USERID, DbType.String);
p.Add("DB_ITBID", obj.DB_ITBID, DbType.Int32);
p.Add("EVENTTYPE", obj.EVENTTYPE, DbType.String);
p.Add("POSTTYPE", postType, DbType.Int16);
using (var con = new RepoBase().OpenConnection(null))
{
ret = con.Query <OutPutObj>("SESS_POST_APPROVALOFFICER", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
return(ret);
}
}
public ActionResult DeleteRouteOfficerLocal(int id)
{
string msg = "";
var rv = new AppRouteSession();
var model = _repo.GetRouteOfficer(id);
if (model == null)
{
msg = "Bad Request";
return(Json(new { RespCode = 0, RespMessage = msg }, JsonRequestBehavior.AllowGet));
}
var obj = new ApprovalRouteOffObj()
{
APPROVER_ID = model.APPROVER_ID,
MENUID = model.MENUID,
PRIORITY = model.PRIORITY,
USERID = User.Identity.Name,
DB_ITBID = model.DB_ITBID,
PID = model.PID,
EVENTTYPE = eventDelete,
};
OutPutObj rst;
rst = rv.PostRouteOfficer(obj, 2);
if (rst != null && rst.RespCode != 0)
{
msg = rst.RespMessage; // "Revenue Code Already exist. Duplicate Record is not allowed.";
return(Json(new { RespCode = 1, RespMessage = msg }, JsonRequestBehavior.AllowGet));
}
//SessionHelper.GetRvHead(Session).UpdateItem(obj);
// rv.PostRevenueHead(obj, 2);
var w = rv.GetRouteOfficer(User.Identity.Name); // GetRvHeadLines().ToList();
var html = PartialView("_ViewRouteOfficer", w).RenderToString();
msg = "Record Updated to List";
return(Json(new { data_html = html, RespCode = 0, RespMessage = msg }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddRouteOfficer(ApprovalRouteOffObj model, string m)
{
var rv = new AppRouteSession();
string msg = "";
try
{
//var lst = GetRvHeadLines().ToList();
if (string.IsNullOrEmpty(model.PID) && model.DB_ITBID.GetValueOrDefault() <= 0)
{
var obj = new ApprovalRouteOffObj()
{
APPROVER_ID = model.APPROVER_ID,
MENUID = model.MENUID,
PRIORITY = model.PRIORITY,
PID = model.PID,
EVENTTYPE = eventInsert,
USERID = User.Identity.Name
};
//SessionHelper.GetRvHead(Session).AddItem(obj);
var rst = rv.PostRouteOfficer(obj, 1);
if (rst != null && rst.RespCode != 0)
{
msg = rst.RespMessage; // "Revenue Code Already exist. Duplicate Record is not allowed.";
return(Json(new { RespCode = 1, RespMessage = msg }, JsonRequestBehavior.AllowGet));
}
var w = rv.GetRouteOfficer(User.Identity.Name); // GetRvHeadLines().ToList();
var html = PartialView("_ViewRouteOfficer", w).RenderToString();
msg = "Record Added to List";
return(Json(new { data_html = html, RespCode = 0, RespMessage = msg }, JsonRequestBehavior.AllowGet));
}
else
{
var obj = new ApprovalRouteOffObj()
{
APPROVER_ID = model.APPROVER_ID,
MENUID = model.MENUID,
PRIORITY = model.PRIORITY,
USERID = User.Identity.Name,
DB_ITBID = model.DB_ITBID,
PID = model.PID,
EVENTTYPE = model.DB_ITBID > 0 ? eventEdit : eventInsert,
};
OutPutObj rst;
rst = rv.PostRouteOfficer(obj, 2);
if (rst != null && rst.RespCode != 0)
{
msg = rst.RespMessage; // "Revenue Code Already exist. Duplicate Record is not allowed.";
return(Json(new { RespCode = 1, RespMessage = msg }, JsonRequestBehavior.AllowGet));
}
//SessionHelper.GetRvHead(Session).UpdateItem(obj);
// rv.PostRevenueHead(obj, 2);
var w = rv.GetRouteOfficer(User.Identity.Name); // GetRvHeadLines().ToList();
var html = PartialView("_ViewRouteOfficer", w).RenderToString();
msg = "Record Updated to List";
return(Json(new { data_html = html, RespCode = 0, RespMessage = msg }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
msg = ex.Message;
return(Json(new { RespCode = 1, RespMessage = msg }, JsonRequestBehavior.AllowGet));
}
}
