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