public ActionResult Index(VIEW_DCR_SHEET_Search obj)
{
SEC_USERS_LOGIN_Result1 user = Session["sess_sec_users"] as SEC_USERS_LOGIN_Result1;
if ((user != null) && (user.USER_TYPE_NO == (decimal)UserType.Zonal_Manager))
{
obj.USER_NO = user.USER_NO;
}
SEC_USERS_ZM_LOGIN_GET_Result user_result = db.SEC_USERS_ZM_LOGIN_GET(null, null, obj.USER_NO, null).FirstOrDefault();
List <TRN_DCR_SHEET_SUM_Result> dcr_sum_result = db.TRN_DCR_SHEET_SUM(obj.USER_NO, obj.TRN_DCR_DATE).ToList();
foreach (var dcr in dcr_sum_result)
{
dcr.TRN_DCR_SHEET_DET_List = db.TRN_DCR_SHEET_DET(dcr.DCR_NO).ToList();
}
List <TRN_EXPENSE_SUM_Result> exp_result = db.TRN_EXPENSE_SUM(obj.USER_NO, obj.TRN_DCR_DATE).ToList();
bool Is_ZonalOrAgent = (bool)Session["sess_Is_ZonalOrAgent"];
ViewBag.Is_ZonalOrAgent = Is_ZonalOrAgent;
ViewBag.TRN_DCR_DATE = obj.TRN_DCR_DATE;
ViewBag.user_result = user_result;
ViewBag.dcr_sum_result = dcr_sum_result;
ViewBag.exp_result = exp_result;
return(View("DcrSheet"));
}
private void GetLoggedInInfo()
{
this.sess_sec_users = Session["sess_sec_users"] as SEC_USERS_LOGIN_Result1;
this.sess_LOGON_NO = Session["sess_LOGON_NO"] as decimal?;
this.sess_USER_NO = Session["sess_USER_NO"] as decimal?;
this.sess_entry_user_name = sess_sec_users.USER_NAME;
}
public ActionResult GetZonalManagerForm()
{
ViewBag.Zonal_Dept = new SelectList(db.SET_DEPARTMENT, "DEPT_NO", "DEPT_NAME");
ViewBag.Zonal_Desig = new SelectList(db.SET_DESIGNATION, "DESIG_NO", "DESIG_NAME");
ViewBag.Division_No = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME");
ViewBag.Zilla_No = new SelectList(db.SET_ZILLA.Where(z => z.ZILLA_NO < 0),
"ZILLA_NO", "ZILLA_NAME");
ViewBag.Zonal_Thana = new SelectList(db.SET_THANA.Where(t => t.THANA_NO < 0),
"THANA_NO", "THANA_NAME");
SEC_USERS_LOGIN_Result1 user = Session["sess_sec_users"] as SEC_USERS_LOGIN_Result1;
ViewBag.Zonal_Parent_No = user.USER_NO;
return(PartialView("_GetZonalManagerPartial"));
}
public ActionResult ChangePassword(ChangePasswordViewModel model)
{
decimal?USER_NO = Session["sess_USER_NO"] as decimal?;
decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?;
SEC_USERS_LOGIN_Result1 user = Session["sess_sec_users"] as SEC_USERS_LOGIN_Result1;
if (user.USER_NO > 0 && model.OLD_PASS == user.USER_PWD && model.NEW_PASS == model.RE_NEW_PASS)
{
/*
* db.SEC_USERS_UPDATE(user.USER_MOBILE, user.USER_ADDR, user.USER_EMAIL, user.USER_NAME,
* model.NEW_PASS, user.USER_PARENT_NO, user.IS_ACTIVE, user.ACTIVE_FROM, user.ACTIVE_TO,
* user.USER_NO, USER_NO, LOGON_NO, user.USER_TYPE_NO, user.DEPT_NO, user.DESIG_NO,
* user.HR_EMP_ID, user.USER_FULL_NAME, user.USER_NICK_NAME, user.USER_CONTACT,
* user.COMP_NO, user.THANA_NO);
*/
db.SEC_USERS_CHANGE_PASSWORD(user.USER_NO, model.NEW_PASS, USER_NO, LOGON_NO);
}
return(View());
}
public ActionResult Details(int id)
{
this.GetLoggedInInfo();
decimal?DCR_NO = (decimal)id;
VIEW_TRN_DCR_APPROVE_GET_Result2 dcr = db.VIEW_TRN_DCR_APPROVE_GET(DCR_NO, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, this.sess_USER_NO, null).FirstOrDefault();
if (dcr != null)
{
dcr.VIEW_TRN_DCR_DET_APRROVE_GET_Result = db.VIEW_TRN_DCR_DET_APRROVE_GET(null, DCR_NO, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null).ToList();
ViewBag.APPROVE_TRANS_TYPE_NO = new SelectList(db.SET_TRANSPORT_TYPE, "TRANS_TYPE_NO", "TRANS_TYPE_NAME");
ViewBag.APPROVE_TYPE_NO = new SelectList(db.GEN_APPROVE_TYPE, "APPROVE_TYPE_NO", "APPROVE_TYPE", dcr.APPROVE_TYPE_NO);
ViewBag.REASON_NO = new SelectList(db.SET_REASON, "REASON_NO", "REASON_NAME", dcr.REASON_NO);
}
SEC_USERS_LOGIN_Result1 user = Session["sess_sec_users"] as SEC_USERS_LOGIN_Result1;
ViewBag.USER_TYPE_NO = user.USER_TYPE_NO;
return(View(dcr));
}
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));
}
public JsonResult getDCRDetailsEditable(decimal dcrNo)
{
TRN_DCR dcr = db.TRN_DCR.Where(x => x.DCR_NO == dcrNo).First();
string tmp = "";
if (dcr.IS_REF_ZM.HasValue)
{
if (dcr.IS_REF_ZM == 1)
{
tmp += "<b>Ref</b></td><td>" + dcr.REF_ZM_MOBILE;
}
}
string ret = @"<table class='table table-responsive' style='width:95%;margin-left:auto;'><tbody>
<tr><td><b>Work Type</b></td><td>" + dcr.GEN_DCR_TYPE.DCR_TYPE + "</td><td></td></tr>" +
"<tr><td><b>ZM</b></td><td>" + dcr.SEC_USERS.USER_FULL_NAME + "(" + dcr.SEC_USERS.USER_MOBILE + ")" + "</td><td>" + tmp + "</td><td></td></tr>" +
"<tr><td><b>Date</b></td><td>" + dcr.TRN_DCR_DATE.ToString("yyyy-MM-dd") + "</td><td></td></tr>" +
"<tr><td><b>Start Location</b></td><td>" + dcr.WORK_AREA_FROM_NAME + "</td><td><b>End Location</b></td><td>" + dcr.WORK_AREA_TO_NAME + "</td></tr>" +
"<tr><td><b>Start Time</b></td><td>" + DateTime.Parse(dcr.TIME_FROM.ToString()).ToShortTimeString() + "</td><td><b>End Location</b></td><td>" + DateTime.Parse(dcr.TIME_TO.ToString()).ToShortTimeString() + "</td></tr>" +
"<tr><td><b>Transport</b></b></td><td>" + dcr.SET_TRANSPORT_TYPE.TRANS_TYPE_NAME + "</td><td><b>Cost/Fare</b></td><td>" + dcr.FARE_AMT.ToString() + "</td></tr>" +
"<tr><td><b>Institute</b></td><td>" + ((dcr.SET_INSTITUTE != null) ? dcr.SET_INSTITUTE.INSTITUTE_NAME : "") +
"</td><td></td></tr></tbody></table><br/>";
ret += "<table class=\"table table-responsive\" style=\"width:95%;margin-left:auto;\">";
IList <TRN_DCR_DET> dcr_dets = db.TRN_DCR_DET.Where(x => x.DCR_NO == dcrNo).ToList();
if (dcr_dets.Count != 0)
{
switch (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE)
{
case "TC":
ret += "<tr><th>Contact No</th><th>Type</th></tr>";
foreach (TRN_DCR_DET dts in dcr_dets)
{
ret += "<tr><td>" + dts.TEACHER_MOBILE + "</td><td>" + "Teacher" + "</td></tr>";
}
break;
case "LC":
ret += "<tr><th>Contact No</th><th>Type</th></tr>";
foreach (TRN_DCR_DET dts in dcr_dets)
{
bool is_teacher = true;
if (dts.IS_FOR_CLIENT != null)
{
if (dts.IS_FOR_CLIENT == 1)
{
is_teacher = false;
}
}
ret += "<tr><td>" + ((!is_teacher) ? dts.CLIENT_MOBILE : dts.TEACHER_MOBILE) + "</td><td>" + ((!is_teacher) ? "Client" : "Teacher") + "</td></tr>";
}
break;
case "CSR":
case "SD":
SEC_USERS_LOGIN_Result1 usertp = (SEC_USERS_LOGIN_Result1)Session["sess_sec_users"];
decimal tmpdet = decimal.Parse(usertp.USER_TYPE_NO.ToString());
GEN_USER_TYPES gentype = db.GEN_USER_TYPES.Single(x => x.USER_TYPE_NO == tmpdet);
ret += "<tr><th>Item</th><th>Qty</th><th>Contact</th><th>On Behalf?</th><th>On Behalf Mobile No</th><th></th></tr>";
dcr_dets = dcr_dets.OrderByDescending(x => x.SET_SPECIMEN.SPECIMEN_NAME).Reverse().ToList();
foreach (TRN_DCR_DET dts in dcr_dets)
{
bool is_behalf = true;
if (dts.IS_ON_BEHALF != null)
{
if (dts.IS_ON_BEHALF != 1)
{
is_behalf = false;
}
}
ret += "<tr><td>" + dts.SET_SPECIMEN.SPECIMEN_NAME + "</td><td>" +
((gentype.IS_ADMIN == 1) ? "<input id='txtsdup" + dts.DCR_DET_NO + "' type='text' class='form-control input-small' value='" + dts.APPROVE_SPECIMEN_QTY + "'></input>" : dts.APPROVE_SPECIMEN_QTY.ToString()) +
"</td><td>" + dts.TEACHER_MOBILE + "</td><td>" + ((is_behalf) ? "Yes" : "No") + "</td><td>" +
((is_behalf) ? dts.BEHALF_MOBILE : "-") + "</td><td>" +
((gentype.IS_ADMIN == 1) ? "<button class='btn btn-warning btn-small btnupdate' attr='" + dts.DCR_DET_NO + "' onclick='changeSDonApprove($(this));'>Edit</button>" : "") + "</td></tr>";
}
break;
case "MP":
ret += "<tr><th>Item</th><th>Whom</th><th>Qty</th><th>Contact</th><th>On Behalf?</th><th>On Behalf Mobile No</th></tr>";
dcr_dets = dcr_dets.OrderByDescending(x => x.SET_PROMO_ITEM.PROMO_ITEM_NAME).Reverse().ToList();
foreach (TRN_DCR_DET dts in dcr_dets)
{
bool is_behalf = true;
if (dts.IS_ON_BEHALF != null)
{
if (dts.IS_ON_BEHALF != 1)
{
is_behalf = false;
}
}
ret += "<tr><td>" + dts.SET_PROMO_ITEM.PROMO_ITEM_NAME + "</td><td>" + ((dts.IS_FOR_TEACHER == 1) ? "Teacher" : "Client") + "</td><td>" +
dts.PROMO_ITEM_QTY + "</td><td>" + ((dts.IS_FOR_TEACHER == 1) ? dts.TEACHER_MOBILE : dts.CLIENT_MOBILE) +
"</td><td>" + ((is_behalf) ? "Yes" : "No") + "</td><td>" +
((is_behalf) ? dts.BEHALF_MOBILE : "") + "</td></tr>";
}
break;
default:
ret += "";
break;
}
}
ret += "</table>";
return(Json(new { html = ret }, JsonRequestBehavior.AllowGet));
}
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));
}
}
