public ActionResult DeleteConfirmed(decimal id)
{
GEN_CONTROLLER_ACTION gen_controller_action = db.GEN_CONTROLLER_ACTION.Single(g => g.ACTION_NO == id);
db.GEN_CONTROLLER_ACTION.DeleteObject(gen_controller_action);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Actions/Delete/5
public ActionResult Delete(decimal id = 0)
{
GEN_CONTROLLER_ACTION gen_controller_action = db.GEN_CONTROLLER_ACTION.Single(g => g.ACTION_NO == id);
if (gen_controller_action == null)
{
return(HttpNotFound());
}
return(View(gen_controller_action));
}
//
// GET: /Actions/Edit/5
public ActionResult Edit(decimal id = 0)
{
GEN_CONTROLLER_ACTION gen_controller_action = db.GEN_CONTROLLER_ACTION.Single(g => g.ACTION_NO == id);
if (gen_controller_action == null)
{
return(HttpNotFound());
}
ViewBag.PARENT_ACTION_NO = new SelectList(db.GEN_CONTROLLER_ACTION, "ACTION_NO", "CONTROLLER_NAME", gen_controller_action.PARENT_ACTION_NO);
ViewBag.PARENT_MENU_NO = new SelectList(db.GEN_CONTROLLER_ACTION, "ACTION_NO", "CONTROLLER_NAME", gen_controller_action.PARENT_MENU_NO);
return(View(gen_controller_action));
}
public ActionResult Edit(GEN_CONTROLLER_ACTION gen_controller_action)
{
if (ModelState.IsValid)
{
db.GEN_CONTROLLER_ACTION.Attach(gen_controller_action);
db.ObjectStateManager.ChangeObjectState(gen_controller_action, EntityState.Modified);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PARENT_ACTION_NO = new SelectList(db.GEN_CONTROLLER_ACTION, "ACTION_NO", "CONTROLLER_NAME", gen_controller_action.PARENT_ACTION_NO);
ViewBag.PARENT_MENU_NO = new SelectList(db.GEN_CONTROLLER_ACTION, "ACTION_NO", "CONTROLLER_NAME", gen_controller_action.PARENT_MENU_NO);
return(View(gen_controller_action));
}
public ActionResult Create(GEN_CONTROLLER_ACTION gen_controller_action)
{
if (ModelState.IsValid)
{
db.GEN_CONTROLLER_ACTION.AddObject(gen_controller_action);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PARENT_ACTION_NO = new SelectList(db.GEN_CONTROLLER_ACTION, "ACTION_NO", "CONTROLLER_NAME", gen_controller_action.PARENT_ACTION_NO);
ViewBag.PARENT_MENU_NO = new SelectList(db.GEN_CONTROLLER_ACTION, "ACTION_NO", "CONTROLLER_NAME", gen_controller_action.PARENT_MENU_NO);
return(View(gen_controller_action));
}
public ActionResult Index(ControllerActionViewModel[] controllers)
{
foreach (var cont in controllers)
{
GEN_CONTROLLER_ACTION record = db.GEN_CONTROLLER_ACTION.
Where(a => a.ACTION_NAME == cont.actionName && a.CONTROLLER_NAME == cont.controllerName).
FirstOrDefault();
if (record == null)
{
GEN_CONTROLLER_ACTION conac = new GEN_CONTROLLER_ACTION();
conac.ACTION_NAME = cont.actionName;
conac.CONTROLLER_NAME = cont.controllerName;
conac.IS_AUTO_INCLUDE = cont.IsAutoInclude == true ? 1 : 0;
conac.IS_ACTIVE = cont.IsActive == true ? 1 : 0;
conac.IS_PUBLIC = cont.IsPublic == true ? 1 : 0;
conac.IS_MENU = cont.IsMenu == true ? 1 : 0;
conac.MENU_NAME = cont.menuName;
db.GEN_CONTROLLER_ACTION_INSERT(conac.CONTROLLER_NAME, conac.ACTION_NAME, conac.IS_ACTIVE,
conac.IS_PUBLIC, conac.IS_AUTO_INCLUDE, conac.PARENT_ACTION_NO, conac.IS_MENU,
conac.MENU_NAME, conac.PARENT_MENU_NO, conac.IS_SUB_MENU, conac.DETAILS, conac.SL_NUM);
}
else
{
record.IS_AUTO_INCLUDE = cont.IsAutoInclude == true ? 1 : 0;
record.IS_ACTIVE = cont.IsActive == true ? 1 : 0;
record.IS_PUBLIC = cont.IsPublic == true ? 1 : 0;
record.IS_MENU = cont.IsMenu == true ? 1 : 0;
record.MENU_NAME = cont.menuName;
db.GEN_CONTROLLER_ACTION_UPDATE(record.ACTION_NO, record.CONTROLLER_NAME, record.ACTION_NAME,
record.IS_ACTIVE, record.IS_PUBLIC, record.IS_AUTO_INCLUDE, record.PARENT_ACTION_NO,
record.IS_MENU, record.MENU_NAME, record.PARENT_MENU_NO, record.IS_SUB_MENU,
record.DETAILS, record.SL_NUM);
}
}
//db.SaveChanges();
ControllerList list = new ControllerList();
List <ControllerActionViewModel> clist = list.GetControllerActions().OrderBy(a => a.actionName).OrderBy(a => a.controllerName).ToList();
return(View(clist));
}
public ActionResult Login(SEC_USERS sec_user)
{
SEC_USERS_LOGIN_Result1 user = db.SEC_USERS_LOGIN(sec_user.USER_NAME, sec_user.USER_PWD, null).FirstOrDefault();
if (user != null && user.USER_NO > 0)
{
Session["sess_sec_users"] = user;
Session["sess_USER_NO"] = user.USER_NO;
if (user.USER_TYPE_NO == (decimal)EUserTypes.Agent)
{
Session["sess_entry_user_no"] = user.USER_NO;
Session["sess_zm_user_no"] = user.USER_PARENT_NO;
Session["sess_agent_user_no"] = user.USER_NO;
}
else
{
Session["sess_entry_user_no"] = user.USER_NO;
Session["sess_zm_user_no"] = user.USER_NO;
Session["sess_agent_user_no"] = null;
}
bool Is_ZonalOrAgent = ((decimal)user.USER_TYPE_NO == (decimal)EUserTypes.ZonalManager ||
(decimal)user.USER_TYPE_NO == (decimal)EUserTypes.Agent);
Session["sess_Is_ZonalOrAgent"] = Is_ZonalOrAgent;
string sess_id = Session.SessionID;
string ip_addr = CustomValidator.GetRequestIpAddress();
string device_id = CustomValidator.GetDeviceId();
string login_mobile = sec_user.USER_MOBILE;
string ws_id = CustomValidator.GetWebServerId();
string app_version = sec_user.APP_VERSION;
decimal LOGON_NO = db.SEC_USER_LOGONS_INSERT(user.USER_NO, ip_addr, device_id, null, null, null,
(decimal)ApproveType.Approved, null, null, sess_id,
login_mobile, ws_id, app_version, login_mobile).First().Value;
Session["sess_LOGON_NO"] = LOGON_NO;
if (user.USER_TYPE_NO == (decimal)EUserTypes.GeneralUser)
{
List <SET_USER_ACTION> per_list = new List <SET_USER_ACTION>();
per_list = db.SET_USER_ACTION.Include(a => a.GEN_CONTROLLER_ACTION)
.Where(a => (a.USER_NO == user.USER_NO) && (a.IS_ACTIVE == 1))
.ToList();
List <GEN_CONTROLLER_ACTION> menu_list = (from c in per_list
where (c.GEN_CONTROLLER_ACTION.IS_MENU == 1 &&
c.GEN_CONTROLLER_ACTION.IS_ACTIVE == 1
)
orderby c.GEN_CONTROLLER_ACTION.SL_NUM
select c.GEN_CONTROLLER_ACTION).ToList();
Session["sess_MENU_LIST"] = menu_list;
Session["sess_PERMISSION_LIST"] = per_list;
if (menu_list != null)
{
GEN_CONTROLLER_ACTION redirect_action = menu_list.First();
return(RedirectToAction(redirect_action.ACTION_NAME, redirect_action.CONTROLLER_NAME));
}
}
else
{
SET_ROLE role = db.SET_ROLE.Where(r => r.USER_TYPE_NO == user.USER_TYPE_NO).FirstOrDefault();
decimal?ROLE_NO = null;
if (role != null)
{
ROLE_NO = role.ROLE_NO;
Session["ROLE_NO"] = role.ROLE_NO;
}
//ROLE_NO = decimal.Parse(Session["ROLE_NO"].ToString());
List <SET_ROLE_ACTION> per_list = new List <SET_ROLE_ACTION>();
if (ROLE_NO.HasValue)
{
per_list = db.SET_ROLE_ACTION.Include(a => a.GEN_CONTROLLER_ACTION)
.Where(a => (a.ROLE_NO == ROLE_NO.Value) && (a.IS_ACTIVE == 1))
.ToList();
List <GEN_CONTROLLER_ACTION> menu_list = (from c in per_list
where (c.GEN_CONTROLLER_ACTION.IS_MENU == 1 &&
c.GEN_CONTROLLER_ACTION.IS_ACTIVE == 1
)
orderby c.GEN_CONTROLLER_ACTION.SL_NUM
select c.GEN_CONTROLLER_ACTION).ToList();
Session["sess_MENU_LIST"] = menu_list;
Session["sess_PERMISSION_LIST"] = per_list;
if (menu_list != null)
{
GEN_CONTROLLER_ACTION redirect_action = menu_list.First();
return(RedirectToAction(redirect_action.ACTION_NAME, redirect_action.CONTROLLER_NAME));
}
}
}
}
return(View());
}
public ActionResult GetSubjects(decimal?p_ins, string type)
{
ViewBag.Download_Allowed = false;
ViewBag.Reset_Allowed = false;
SEC_USERS_LOGIN_Result1 user = Session["sess_sec_users"] as SEC_USERS_LOGIN_Result1;
if (user.USER_TYPE_NO == (decimal)EUserTypes.GeneralUser)
{
List <SET_USER_ACTION> perm_list = Session["sess_PERMISSION_LIST"] as List <SET_USER_ACTION>;
foreach (var perm in perm_list)
{
GEN_CONTROLLER_ACTION controller_action = perm.GEN_CONTROLLER_ACTION;
if (controller_action.CONTROLLER_NAME == "QuestionMonitor" && controller_action.ACTION_NAME == "Download")
{
ViewBag.Download_Allowed = true;
}
if (controller_action.CONTROLLER_NAME == "QuestionMonitor" && controller_action.ACTION_NAME == "Reset")
{
ViewBag.Reset_Allowed = true;
}
}
}
else
{
List <SET_ROLE_ACTION> perm_list = Session["sess_PERMISSION_LIST"] as List <SET_ROLE_ACTION>;
foreach (var perm in perm_list)
{
GEN_CONTROLLER_ACTION controller_action = perm.GEN_CONTROLLER_ACTION;
if (controller_action.CONTROLLER_NAME == "QuestionMonitor" && controller_action.ACTION_NAME == "Download")
{
ViewBag.Download_Allowed = true;
}
if (controller_action.CONTROLLER_NAME == "QuestionMonitor" && controller_action.ACTION_NAME == "Reset")
{
ViewBag.Reset_Allowed = true;
}
}
}
TPR_PROJECT_INSTITUTE pins = db.TPR_PROJECT_INSTITUTE
.Single(t => t.PROJECT_INS_NO == p_ins);
TPR_PROJECT project = db.TPR_PROJECT.Include("SET_CLASS")
.Single(p => p.PROJECT_NO == pins.PROJECT_NO);
USER_INFO_VIEWMODEL zonal_info =
(from u in db.SEC_USERS
join d in db.SET_DESIGNATION on u.DESIG_NO equals d.DESIG_NO
join t in db.SET_THANA on u.THANA_NO equals t.THANA_NO
join z in db.SET_ZILLA on t.ZILLA_NO equals z.ZILLA_NO
join div in db.SET_DIVISION on z.DIVISION_NO equals div.DIVISION_NO
where u.USER_NO == pins.USER_NO
select new USER_INFO_VIEWMODEL
{
userno = u.USER_NO,
fullname = u.USER_FULL_NAME,
username = u.USER_NAME,
hrid = u.HR_EMP_ID,
mobile = u.USER_MOBILE,
designation = d.DESIG_NAME,
thana = t.THANA_NAME,
zilla = z.ZILLA_NAME,
division = div.DIVISION_NAME
}).FirstOrDefault();
INSTITUTE_INFO_VIEWMODEL institute_info =
(from i in db.SET_INSTITUTE
join t in db.SET_THANA on i.THANA_NO equals t.THANA_NO
join z in db.SET_ZILLA on t.ZILLA_NO equals z.ZILLA_NO
join d in db.SET_DIVISION on z.DIVISION_NO equals d.DIVISION_NO
where i.INSTITUTE_NO == pins.INSTITUTE_NO
select new INSTITUTE_INFO_VIEWMODEL
{
insname = i.INSTITUTE_NAME,
inscode = i.INSTITUTE_NO,
thana = t.THANA_NAME,
zilla = z.ZILLA_NAME,
division = d.DIVISION_NAME
}).FirstOrDefault();
ViewBag.PROJECT = project;
ViewBag.ZONAL_INFO = zonal_info;
ViewBag.INSTITUTE_INFO = institute_info;
ViewBag.PROJECT_INSTITUTE = pins;
decimal?USER_NO = Session["sess_USER_NO"] as decimal?;
decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?;
var subjects = db.TPR_SUBJECTS_GET(p_ins, type, 0, null, USER_NO, LOGON_NO).ToList();
return(PartialView("_GetSubjects", subjects));
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
using (OGDBEntities db = new OGDBEntities())
{
HttpBrowserCapabilitiesBase browser = httpContext.Request.Browser;
string controllerName = httpContext.Request.RequestContext.RouteData.GetRequiredString("controller").Trim();
string actionName = httpContext.Request.RequestContext.RouteData.GetRequiredString("action").Trim();
List <GEN_CONTROLLER_ACTION> public_list = httpContext.Session["sess_PUBLIC_LIST"] as List <GEN_CONTROLLER_ACTION>;
if (public_list == null)
{
public_list = db.GEN_CONTROLLER_ACTION.Where(a => (a.IS_ACTIVE == 1) && (a.IS_PUBLIC == 1)).ToList();
httpContext.Session["sess_PUBLIC_LIST"] = public_list;
}
GEN_CONTROLLER_ACTION public_allow = public_list.Where(a =>
(a.CONTROLLER_NAME.Trim().ToUpper() == controllerName.Trim().ToUpper()) &&
(a.ACTION_NAME.Trim().ToUpper() == actionName.Trim().ToUpper())
).FirstOrDefault();
if (public_allow != null)
{
return(true);
}
SEC_USERS_LOGIN_Result1 user = httpContext.Session["sess_sec_users"] as SEC_USERS_LOGIN_Result1;
if (user != null && user.USER_TYPE_NO == (decimal)EUserTypes.GeneralUser)
{
List <SET_USER_ACTION> perm_list = httpContext.Session["sess_PERMISSION_LIST"] as List <SET_USER_ACTION>;
if (perm_list == null)
{
perm_list = db.SET_USER_ACTION.Include(a => a.GEN_CONTROLLER_ACTION)
.Where(a => a.USER_NO == user.USER_NO).ToList();
httpContext.Session["sess_PERMISSION_LIST"] = perm_list;
}
if ((perm_list == null) || (perm_list.Count == 0))
{
return(false);
}
else
{
SET_USER_ACTION action_allow = perm_list.Where(a =>
(a.GEN_CONTROLLER_ACTION.CONTROLLER_NAME.Trim().ToUpper() == controllerName.Trim().ToUpper()) &&
(a.GEN_CONTROLLER_ACTION.ACTION_NAME.Trim().ToUpper() == actionName.Trim().ToUpper())
/*&& (a.IS_ALLOWED == 1)*/).FirstOrDefault();
if (action_allow != null)
{
return(true);
}
}
}
else
{
List <SET_ROLE_ACTION> perm_list = httpContext.Session["sess_PERMISSION_LIST"] as List <SET_ROLE_ACTION>;
long?role_no = null;
if (httpContext.Session["ROLE_NO"] != null)
{
role_no = long.Parse(httpContext.Session["ROLE_NO"].ToString());
}
if (role_no == null)
{
//userType = (long)UserTypes.Public;
return(false);
}
if (perm_list == null)
{
perm_list = db.SET_ROLE_ACTION.Include(a => a.GEN_CONTROLLER_ACTION)
.Where(a => a.ROLE_NO == role_no).ToList();
httpContext.Session["sess_PERMISSION_LIST"] = perm_list;
}
if ((perm_list == null) || (perm_list.Count == 0))
{
return(false);
}
else
{
SET_ROLE_ACTION action_allow = perm_list.Where(a =>
(a.GEN_CONTROLLER_ACTION.CONTROLLER_NAME.Trim().ToUpper() == controllerName.Trim().ToUpper()) &&
(a.GEN_CONTROLLER_ACTION.ACTION_NAME.Trim().ToUpper() == actionName.Trim().ToUpper())
/*&& (a.IS_ALLOWED == 1)*/).FirstOrDefault();
if (action_allow != null)
{
return(true);
}
}
}
return(base.AuthorizeCore(httpContext));
}
}
