//
// GET: /OfflineExpenseCheck/
public ActionResult Index()
{
SearchOfflineExpense dcrSearch = (Session["SearchOfflineExpense"] == null) ? new SearchOfflineExpense()
: (SearchOfflineExpense)Session["SearchOfflineExpense"];
ViewBag.dcrSearch = dcrSearch;
ViewBag.ZonalUsers = db.SEC_USERS.Where(u => u.GEN_USER_TYPES.SHORT_NAME == "ZM");
ViewBag.fromDate = DateTime.Now.ToString("yyyy-MM-dd");
ViewBag.toDate = DateTime.Now.AddDays(60).ToString("yyyy-MM-dd");
ViewBag.trnasType = db.SET_TRANSPORT_TYPE.ToList();
ViewBag.verify_status = new SelectList(db.GEN_APPROVE_TYPE, "APPROVE_TYPE_NO", "APPROVE_TYPE");
ViewBag.ddldivision = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME");
ViewBag.Search_User = new SelectList(db.SEC_USERS_GET_RPT_ZONAL(decimal.Parse(Session["sess_USER_NO"].ToString()),
null, null, null).ToList(), "USER_NO", "USER_FULL_NAME");
//error in this
IList <TRN_EXPENSE_APPROVAL_GET_Result> tmp = db.TRN_EXPENSE_APPROVAL_GET(
null, //user
decimal.Parse(Session["sess_USER_NO"].ToString()), //parent
null, //division
null, //zilla
null, //thana
DateTime.Now, //date from
DateTime.Now, //date to
0,
0, null).ToList();
ViewBag.expenses = tmp;
decimal?dcr_count = db.TRN_EXPENSE_VERIFY_COUNT(decimal.Parse(Session["sess_USER_NO"].ToString())).FirstOrDefault().CNT;
ViewBag.dcr_count = dcr_count;
return(View());
}
//
// GET: /OfflineEntryMonitor/
//public Tuple<SearchOfflineEntry, IQueryable<TRN_DCR>> setSearch(IQueryable<TRN_DCR> dcrs, SearchOfflineEntry dcrSearch, bool search)
//{
// dcrSearch = (dcrSearch.dirty) ? dcrSearch : new SearchOfflineEntry();
// if (!string.IsNullOrEmpty(Request.QueryString["USER_NO"]) || search)
// {
// dcrSearch.USER_NO = (!search) ? decimal.Parse(Request.QueryString["USER_NO"].ToString()) : dcrSearch.USER_NO;
// if (!string.IsNullOrEmpty(dcrSearch.USER_NO.ToString()))
// dcrs = dcrs.Where(s => s.USER_NO == dcrSearch.USER_NO);
// }
// else
// dcrSearch.USER_NO = null;
// if (!string.IsNullOrEmpty(Request.QueryString["DateFrom"]) || search)
// {
// dcrSearch.dateOffFrom = (!search) ? DateTime.Parse(Request.QueryString["DateFrom"]) : dcrSearch.dateOffFrom;
// if (dcrSearch.dateOffFrom != null)
// dcrs = dcrs.Where(s => s.TRN_DCR_DATE > dcrSearch.dateOffFrom);
// }
// else
// dcrSearch.dateOffFrom = null;
// if (!string.IsNullOrEmpty(Request.QueryString["DateTo"]) || search)
// {
// dcrSearch.dateOffTo = (!search) ? DateTime.Parse(Request.QueryString["DateTo"]) : dcrSearch.dateOffTo;
// if (dcrSearch.dateOffTo != null)
// dcrs = dcrs.Where(s => s.TRN_DCR_DATE < dcrSearch.dateOffTo);
// }
// else
// dcrSearch.dateOffTo = null;
// if (!string.IsNullOrEmpty(Request.QueryString["dcrType"]) || search)
// {
// dcrSearch.dcrType = (!search) ? decimal.Parse( Request.QueryString["dcrType"]) : dcrSearch.dcrType;
// if (!string.IsNullOrEmpty(dcrSearch.dcrType.ToString()))
// dcrs = dcrs.Where(s => s.DCR_TYPE_NO== dcrSearch.dcrType);
// }
// else
// dcrSearch.dcrType = null;
// if (!string.IsNullOrEmpty(Request.QueryString["verify"]) || search)
// {
// dcrSearch.verify = (!search) ? decimal.Parse(Request.QueryString["verify"]) : dcrSearch.verify;
// if (!string.IsNullOrEmpty(dcrSearch.verify.ToString()))
// dcrs = dcrs.Where(s => s.APPROVE_TYPE_NO == dcrSearch.verify);
// }
// else
// dcrSearch.verify = null;
// dcrSearch.dirty = true;
// return new Tuple<SearchOfflineEntry, IQueryable<TRN_DCR>>(dcrSearch, dcrs);
//}
public ActionResult Index()
{
/**
* viewbag config for searching only
* */
ViewBag.ZonalUsers = db.SEC_USERS.Where(u => u.GEN_USER_TYPES.SHORT_NAME == "ZM");
ViewBag.fromDate = DateTime.Now.ToString("yyyy-MM-dd");
ViewBag.toDate = DateTime.Now.AddDays(60).ToString("yyyy-MM-dd");
SearchOfflineEntry dcrSearch = (Session["SearchOfflineEntry"] == null) ? new SearchOfflineEntry()
: (SearchOfflineEntry)Session["SearchOfflineEntry"];
Session["DCRSearch"] = dcrSearch;
ViewBag.dcrSearch = dcrSearch;
ViewBag.dcrType = new SelectList(db.GEN_DCR_TYPE, "DCR_TYPE_NO", "DCR_TYPE");
ViewBag.verify_status = new SelectList(db.GEN_APPROVE_TYPE, "APPROVE_TYPE_NO", "APPROVE_TYPE");
ViewBag.ddldivision = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME");
ViewBag.zmusers = new SelectList(db.SEC_USERS_GET_RPT_ZONAL(decimal.Parse(Session["sess_USER_NO"].ToString()), null, null, null).ToList(),
"USER_NO", "USER_FULL_NAME");
ViewBag.trnasType = db.SET_TRANSPORT_TYPE.ToList();
/**
* proc call to get all unverified data
* */
List <TRN_DCR_OFF_VERIFY_GET_Result> dcr_List = db.TRN_DCR_OFF_VERIFY_GET(dcrSearch.dcrType, //dcr type
null, //user no
decimal.Parse(Session["sess_USER_NO"].ToString()),
null, //division
null, //zilla
null, //thana
DateTime.Now, //date to
DateTime.Now, //date from
0).ToList();
ViewBag.dcr_List = dcr_List;
decimal?dcr_count = db.TRN_DCR_OFF_VERIFY_COUNT(decimal.Parse(Session["sess_USER_NO"].ToString())).FirstOrDefault();
ViewBag.dcr_count = dcr_count;
return(View());
}
public ActionResult Reset()
{
ObjectResult <DOWNLOAD_RESET_ZONAL_GET_Result> zonals = null;
UpDownSearchModel model = null;
decimal?USER_NO = decimal.Parse(Session["sess_USER_NO"].ToString());
ViewBag.Search_Division = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME");
ViewBag.Search_User = new SelectList(db.SEC_USERS_GET_RPT_ZONAL(USER_NO, null, null, null).ToList(),
"USER_NO", "USER_FULL_NAME");
if (Request.QueryString.HasKeys())
{
model = new UpDownSearchModel();
if (!string.IsNullOrEmpty(Request.QueryString["Search_Division"]) &&
decimal.Parse(Request.QueryString["Search_Division"]) != 0)
{
model.Search_Division = decimal.Parse(Request.QueryString["Search_Division"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Zilla"]) &&
decimal.Parse(Request.QueryString["Search_Zilla"]) != 0)
{
model.Search_Zilla = decimal.Parse(Request.QueryString["Search_Zilla"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Thana"]) &&
decimal.Parse(Request.QueryString["Search_Thana"]) != 0)
{
model.Search_Thana = decimal.Parse(Request.QueryString["Search_Thana"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_User"]) &&
decimal.Parse(Request.QueryString["Search_User"]) != 0)
{
model.Search_User = decimal.Parse(Request.QueryString["Search_User"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_To"]))
{
model.Search_To = DateTime.Parse(Request.QueryString["Search_To"]);
}
zonals = db.DOWNLOAD_RESET_ZONAL_GET(USER_NO, model.Search_User, model.Search_Division,
model.Search_Zilla, model.Search_Thana);
}
ViewBag.Search_Model = model;
return(View(zonals));
}
public ActionResult Index()
{
ViewBag.ZonalUsers = db.SEC_USERS.Where(u => u.GEN_USER_TYPES.SHORT_NAME == "ZM");
ViewBag.fromDate = DateTime.Now.ToString("yyyy-MM-dd");
ViewBag.toDate = DateTime.Now.AddDays(60).ToString("yyyy-MM-dd");
ViewBag.trnasType = db.SET_TRANSPORT_TYPE.ToList();
ViewBag.verify_status = new SelectList(db.GEN_APPROVE_TYPE, "APPROVE_TYPE_NO", "APPROVE_TYPE");
ViewBag.ddldivision = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME");
ViewBag.zmusers = new SelectList(db.SEC_USERS_GET_RPT_ZONAL(decimal.Parse(Session["sess_USER_NO"].ToString()),
null, null, null).ToList(), "USER_NO", "USER_FULL_NAME");
IList <TRN_GET_ALL_COST_Result> result = db.TRN_GET_ALL_COST(null, decimal.Parse(Session["sess_USER_NO"].ToString()),//parent
null, null, null, DateTime.Today, DateTime.Today).ToList();
ViewBag.result = result;
return(View());
}
public ActionResult CostAmmendment()
{
SearchDCRCostApproval dcrSearch = (Session["SearchDCRCostApproval"] == null) ? new SearchDCRCostApproval()
: (SearchDCRCostApproval)Session["SearchDCRCostApproval"];
ViewBag.dcrSearch = dcrSearch;
ViewBag.ZonalUsers = db.SEC_USERS.Where(u => u.GEN_USER_TYPES.SHORT_NAME == "ZM");
ViewBag.fromDate = DateTime.Now.ToString("yyyy-MM-dd");
ViewBag.toDate = DateTime.Now.ToString("yyyy-MM-dd");
ViewBag.trnasType = db.SET_TRANSPORT_TYPE.ToList();
ViewBag.verify_status = new SelectList(db.GEN_APPROVE_TYPE, "APPROVE_TYPE_NO", "APPROVE_TYPE");
ViewBag.ddldivision = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME");
ViewBag.zmusers = new SelectList(db.SEC_USERS_GET_RPT_ZONAL(decimal.Parse(Session["sess_USER_NO"].ToString()),
null, null, null).ToList(), "USER_NO", "USER_FULL_NAME");
//error in this
IList <TRN_EXPENSE_APPROVAL_GET_Result> tmp = db.TRN_EXPENSE_APPROVAL_GET(
null, //user
decimal.Parse(Session["sess_USER_NO"].ToString()), //parent
null, //division
null, //zilla
null, //thana
DateTime.Now, //date from
DateTime.Now, //date to
0, 1, null).ToList();
ViewBag.expenses = tmp;
List <TRN_DCR_APPROVAL_GET_Result> dcr_List = db.TRN_DCR_APPROVAL_GET(dcrSearch.dcrType, //dcr type
null, //user no
decimal.Parse(Session["sess_USER_NO"].ToString()),
null, //division
null, //zilla
null, //thana
DateTime.Now, //date to
DateTime.Now, //date from
0, null).ToList();
ViewBag.dcr_List = dcr_List;
decimal?dcr_count = db.TRN_DCR_APPROVAL_COUNT(decimal.Parse(Session["sess_USER_NO"].ToString())).FirstOrDefault();
ViewBag.dcr_count = dcr_count;
return(View());
}
public ActionResult DcrPublish()
{
DcrPublishSearchModel searchModel = new DcrPublishSearchModel();
DcrPublishViewModel dcrPublishModel = new DcrPublishViewModel();
decimal?USER_NO = Session["sess_USER_NO"] as decimal?;
ViewBag.Search_Division = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME");
ViewBag.Search_User = new SelectList(db.SEC_USERS_GET_RPT_ZONAL(USER_NO,
null, null, null).ToList(), "USER_NO", "USER_FULL_NAME");
bool Is_ZonalOrAgent = (bool)Session["sess_Is_ZonalOrAgent"];
ViewBag.Is_ZonalOrAgent = Is_ZonalOrAgent;
string Search_User = Request.QueryString["Search_User"];
if (string.IsNullOrEmpty(Search_User))
{
Search_User = Request.QueryString["USER_NO"];
}
if (Is_ZonalOrAgent)
{
Search_User = Session["sess_USER_NO"].ToString();
}
if (!string.IsNullOrEmpty(Request.QueryString["Search"]))
{
searchModel.Search_User = decimal.Parse(Search_User);
ViewBag.Search_User = new SelectList(db.SEC_USERS_GET_RPT_ZONAL(decimal.Parse(Session["sess_USER_NO"].ToString()),
null, null, null).ToList(), "USER_NO", "USER_FULL_NAME", searchModel.Search_User);
SEC_USERS user = db.SEC_USERS.Single(u => u.USER_NO == searchModel.Search_User);
if (!string.IsNullOrEmpty(Request.QueryString["Search_Date_From"]))
{
searchModel.Search_Date_From = DateTime.Parse(Request.QueryString["Search_Date_From"]);
}
else
{
DateTime now = DateTime.Now;
DateTime FirstDayOfMonth = new DateTime(now.Year, now.Month, 1);
searchModel.Search_Date_From = FirstDayOfMonth;
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Date_To"]))
{
searchModel.Search_Date_To = DateTime.Parse(Request.QueryString["Search_Date_To"]);
}
else
{
searchModel.Search_Date_To = DateTime.Now;
}
List <DCR_PUB_EXP_GET_Result> expense =
db.DCR_PUB_EXP_GET(searchModel.Search_User, null,
searchModel.Search_Date_From, searchModel.Search_Date_To, 0).ToList();
List <DCR_PUB_SPECIMEN_GET_Result> specimen =
db.DCR_PUB_SPECIMEN_GET(searchModel.Search_User, null,
searchModel.Search_Date_From, searchModel.Search_Date_To, 0).ToList();
dcrPublishModel.expenses = new DcrExpenseModel();
dcrPublishModel.expenses.user = user;
dcrPublishModel.expenses.date = DateTime.Now;
dcrPublishModel.expenses.expense = expense;
dcrPublishModel.specimens = new DcrSpecimenModel();
dcrPublishModel.specimens.user = user;
dcrPublishModel.specimens.date = DateTime.Now;
dcrPublishModel.specimens.specimen = specimen;
if (!string.IsNullOrEmpty(Request.QueryString["Print"]))
{
string print = Request.QueryString["Print"];
dcrPublishModel.details = new List <DcrDetailsModel>();
if (print.Length > 0 && print == "Y")
{
dcrPublishModel.expenses.date = searchModel.Search_Date_From;
dcrPublishModel.specimens.date = searchModel.Search_Date_From;
for (DateTime?date = searchModel.Search_Date_From;
date <= searchModel.Search_Date_To; date = date.Value.AddDays(1))
{
DcrDetailsModel dcrDetails = new DcrDetailsModel();
List <DCR_PUB_DCR_DETAIL_GET_Result> detail =
db.DCR_PUB_DCR_DETAIL_GET(searchModel.Search_User, null, date, date, 0).ToList();
List <TRN_EXPENSE_APPROVAL_GET_Result> detailexpense =
db.TRN_EXPENSE_APPROVAL_GET(
searchModel.Search_User, decimal.Parse(Session["sess_USER_NO"].ToString()),//parent
null, null, null, date, date, 1, 1, null).ToList();
dcrDetails.date = date;
dcrDetails.expense = detailexpense;
dcrDetails.detail = detail;
dcrPublishModel.details.Add(dcrDetails);
}
}
ViewBag.Print = print;
return(PartialView("_DcrPublishPrint", dcrPublishModel));
}
ViewBag.Search_DcrPublish_Model = searchModel;
Session["sess_Search_DcrPublish_Model"] = searchModel;
return(View(dcrPublishModel));
}
return(View());
}