public ActionResult ExpenseReport() { int paymentType = (int)PaymentTypes.Expense; ViewData.Model = MasterModels.GetPaymentList(paymentType); return(View()); }
public ActionResult ExpenseReport(string searchText) { int paymentType = (int)PaymentTypes.Expense; if (Request.IsAjaxRequest()) { return(PartialView("PaymentListUserControl", MasterModels.GetPaymentList(paymentType))); } return(View()); }
public ActionResult ExpenseList(FormCollection form) { DateTime fromDate = DateTime.Now; DateTime toDate = DateTime.Now; if (form["DateFrom"] != null) { fromDate = Convert.ToDateTime(form["DateFrom"].ToString()); } if (form["ToDate"] != null) { toDate = Convert.ToDateTime(form["ToDate"].ToString()); } ViewData["FromDate"] = fromDate.ToString("MM/dd/yyyy"); ViewData["ToDate"] = toDate.ToString("MM/dd/yyyy"); int paymentType = (int)PaymentTypes.Expense; List <vw_PaymentLists> payments = new List <vw_PaymentLists>(); if (Session["ClientId"] != null) { payments = MasterModels.GetPaymentList((int)Session["ClientId"], paymentType, fromDate, toDate); } else { if (Roles.IsUserInRole("SuperAdmin")) { return(RedirectToAction("List", "Client")); } } //if (Request.IsAjaxRequest()) //{ // return PartialView("PaymentListUserControl", payments); //} ViewData.Model = payments; return(View()); }
public ActionResult AccountSummary(FormCollection form) { DateTime fromDate = DateTime.Now; DateTime toDate = DateTime.Now; if (!string.IsNullOrEmpty(form["DateFrom"])) { fromDate = Convert.ToDateTime(form["DateFrom"].ToString()); } if (!string.IsNullOrEmpty(form["ToDate"])) { toDate = Convert.ToDateTime(form["ToDate"].ToString()); } ViewData["FromDate"] = fromDate.ToString("MM/dd/yyyy"); ViewData["ToDate"] = toDate.ToString("MM/dd/yyyy"); int paymentType = (int)PaymentTypes.Expense; int branchId = 0; if (form["ddlBranch"] != null && !string.IsNullOrEmpty(form["ddlBranch"])) { branchId = Convert.ToInt32(form["ddlBranch"].ToString()); } if (Session["ClientId"] != null) { List <vw_PaymentList> expenseList = new List <vw_PaymentList>(); List <vw_PaymentList> incomeList = new List <vw_PaymentList>(); List <vw_FeeCollections> feeColList = new List <vw_FeeCollections>(); if (Roles.IsUserInRole("CenterManager")) { if (Session["BranchId"] != null) { expenseList = MasterModels.GetPaymentList((int)Session["ClientId"], (int)Session["BranchId"], paymentType, fromDate, toDate, true); incomeList = MasterModels.GetPaymentList((int)Session["ClientId"], (int)Session["BranchId"], (int)PaymentTypes.Income, fromDate, toDate, true); feeColList = StudentModels.GetFeeCollections(fromDate, toDate, (int)Session["ClientId"], (int)Session["BranchId"], null, null, true); } else { return(RedirectToAction("LogOff", "Account")); } } else { ViewData["Branches"] = Utilities.GetBranchNameList((int)Session["ClientId"]); if (branchId > 0) { ViewData["SelectedBranch"] = branchId; expenseList = MasterModels.GetPaymentList((int)Session["ClientId"], branchId, paymentType, fromDate, toDate); incomeList = MasterModels.GetPaymentList((int)Session["ClientId"], branchId, (int)PaymentTypes.Income, fromDate, toDate); feeColList = StudentModels.GetFeeCollections(fromDate, toDate, (int)Session["ClientId"], branchId, null, null); } else { expenseList = MasterModels.GetPaymentList((int)Session["ClientId"], paymentType, fromDate, toDate); incomeList = MasterModels.GetPaymentList((int)Session["ClientId"], (int)PaymentTypes.Income, fromDate, toDate); feeColList = StudentModels.GetFeeCollections(fromDate, toDate, (int)Session["ClientId"], null, null, null); } } //Creating ExpenseSummaryHeadWise List <MasterModels.ExpenseSummaryGroupByHeads> expSummaryHeadWise = new List <MasterModels.ExpenseSummaryGroupByHeads>(); var e = from pl in expenseList group pl by new { pl.ExpenseHeadId, pl.ExpenseHeadName } into pls select new Vedanta.Models.MasterModels.ExpenseSummaryGroupByHeads { ExpenseHeadId = pls.Key.ExpenseHeadId, ExpenseHead = pls.Key.ExpenseHeadName, Amount = pls.Sum(p => p.Amounts) }; expSummaryHeadWise = e.ToList(); //Creating incomeummaryHeadWise List <MasterModels.ExpenseSummaryGroupByHeads> incSummaryHeadWise = new List <MasterModels.ExpenseSummaryGroupByHeads>(); var i = from pl in incomeList group pl by new { pl.ExpenseHeadId, pl.ExpenseHeadName } into pls select new Vedanta.Models.MasterModels.ExpenseSummaryGroupByHeads { ExpenseHeadId = pls.Key.ExpenseHeadId, ExpenseHead = pls.Key.ExpenseHeadName, Amount = pls.Sum(p => p.Amounts) }; incSummaryHeadWise = i.ToList(); //creating FeeCollections List <MasterModels.ExpenseSummaryGroupByHeads> feeCollectionSummaryHeadWise = new List <MasterModels.ExpenseSummaryGroupByHeads>(); var fees = from pl in feeColList group pl by new { pl.PaymentHeadId, pl.PaymentHead } into pls select new Vedanta.Models.MasterModels.ExpenseSummaryGroupByHeads { ExpenseHeadId = pls.Key.PaymentHeadId, ExpenseHead = pls.Key.PaymentHead, Amount = pls.Sum(p => p.TotalReceived ?? 0) }; feeCollectionSummaryHeadWise = fees.ToList(); ViewData["expSummary"] = expSummaryHeadWise; ViewData["incSummary"] = incSummaryHeadWise; ViewData["CollectionSummary"] = feeCollectionSummaryHeadWise; } else { if (Roles.IsUserInRole("SuperAdmin")) { return(RedirectToAction("List", "Client")); } } return(View()); }
public ActionResult ExpenseReport(string Submit, FormCollection form) { DateTime fromDate = DateTime.Now; DateTime toDate = DateTime.Now; if (!string.IsNullOrEmpty(form["DateFrom"])) { fromDate = Convert.ToDateTime(form["DateFrom"].ToString()); } if (!string.IsNullOrEmpty(form["ToDate"])) { toDate = Convert.ToDateTime(form["ToDate"].ToString()); } ViewData["FromDate"] = fromDate.ToString("MM/dd/yyyy"); ViewData["ToDate"] = toDate.ToString("MM/dd/yyyy"); int branchId = 0; if (form["ddlBranch"] != null && !string.IsNullOrEmpty(form["ddlBranch"])) { branchId = Convert.ToInt32(form["ddlBranch"].ToString()); } int paymentType = (int)PaymentTypes.Expense; List <vw_PaymentList> payments = new List <vw_PaymentList>(); if (Session["ClientId"] != null) { switch (Submit.ToLower()) { case "search": if (Roles.IsUserInRole("CenterManager")) { if (Session["BranchId"] != null) { payments = MasterModels.GetPaymentList((int)Session["ClientId"], (int)Session["BranchId"], paymentType, fromDate, toDate, true); } else { return(RedirectToAction("LogOff", "Account")); } } else { if (branchId > 0) { ViewData["SelectedBranch"] = branchId; payments = MasterModels.GetPaymentList((int)Session["ClientId"], branchId, paymentType, fromDate, toDate); } else { payments = MasterModels.GetPaymentList((int)Session["ClientId"], paymentType, fromDate, toDate); } ViewData["Branches"] = Utilities.GetBranchNameList((int)Session["ClientId"]); } break; case "advance search": string strExpenseHead = form["txtexpHead"]; string strPaidTo = form["txtpaidTo"]; string strNarration = form["txtNarration"]; string strRemarks = form["txtRemarks"]; DateTime fromAdvSearchDate = DateTime.Now; DateTime toAdvSearchDate = DateTime.Now; if (!string.IsNullOrEmpty(form["txtAdSearchDateFrom"])) { fromAdvSearchDate = Convert.ToDateTime(form["txtAdSearchDateFrom"].ToString()); } if (!string.IsNullOrEmpty(form["txtAdSearchDateTo"])) { toAdvSearchDate = Convert.ToDateTime(form["txtAdSearchDateTo"].ToString()); } if (Roles.IsUserInRole("CenterManager")) { if (Session["BranchId"] != null) { payments = MasterModels.SearchPaymentList((int)Session["ClientId"], (int)Session["BranchId"], paymentType, fromAdvSearchDate, toAdvSearchDate, strExpenseHead, strPaidTo, strNarration, strRemarks, true); } else { return(RedirectToAction("LogOff", "Account")); } } else { if (branchId > 0) { ViewData["SelectedBranch"] = branchId; payments = MasterModels.SearchPaymentList((int)Session["ClientId"], (int)Session["BranchId"], paymentType, fromAdvSearchDate, toAdvSearchDate, strExpenseHead, strPaidTo, strNarration, strRemarks); } else { payments = MasterModels.SearchPaymentList((int)Session["ClientId"], paymentType, fromAdvSearchDate, toAdvSearchDate, strExpenseHead, strPaidTo, strNarration, strRemarks); } ViewData["Branches"] = Utilities.GetBranchNameList((int)Session["ClientId"]); } break; } ViewData.Model = payments; } else { if (Roles.IsUserInRole("SuperAdmin")) { return(RedirectToAction("List", "Client")); } } //if (Request.IsAjaxRequest()) //{ // return PartialView("PaymentListUserControl", payments); //} return(View()); }
public ActionResult Expense(string Submit, FormCollection form, Payments expense) { int paymentType = (int)PaymentTypes.Expense; if (Session["ClientId"] != null) { ViewData["ExpenseHeads"] = Utilities.GetExpenseHeadNameList((int)Session["ClientId"], paymentType); if (!Roles.IsUserInRole("CenterManager")) { if (Session["RegionId"] != null) { ViewData["Branches"] = Utilities.GetBranchNameList((int)Session["ClientId"], (int)Session["RegionId"]); } else { ViewData["Branches"] = Utilities.GetBranchNameList((int)Session["ClientId"]); } } else { if (Session["BranchId"] != null) { expense.BranchId = (int)Session["BranchId"]; ViewData["Branches"] = null;// Utilities.GetBlankBranchNameList(); } else { return(RedirectToAction("LogOff", "Account")); } } ViewData["PaymentModes"] = Utilities.GetPaymentModesNameList(); //ViewData["Branchs"] = Utilities.GetBranchNameList(); if (!string.IsNullOrEmpty(Submit)) { string submitButton = string.Empty; submitButton = Submit; switch (submitButton.ToLower()) { case "save expense": if (!ModelState.IsValid) { ApplicationMessages msg = new ApplicationMessages("Missing entries. Please check and try again.", MessageType.Error); ViewData["Message"] = msg; return(View()); } if (expense.Date != null && expense.Amounts > 0) { int result = MasterModels.CreatePayment(expense); if (result > 0) { // ViewData["ExpenseList"] = MasterModels.GetPaymentList((int)Session["ClientId"], paymentType).OrderByDescending(pl => pl.Id).Take(10).ToList(); ApplicationMessages msg = new ApplicationMessages("Expense Record Added successfully.", MessageType.Success); ViewData["Message"] = msg; } if (result == -1) { // ViewData["ExpenseList"] = MasterModels.GetPaymentList((int)Session["ClientId"], paymentType).OrderByDescending(pl => pl.Id).Take(10).ToList(); ApplicationMessages msg = new ApplicationMessages("Voucher Number and Date already found for expense, please modify and try again", MessageType.Information); ViewData["Message"] = msg; } if (result == 0) { ApplicationMessages msg = new ApplicationMessages("failed to add expense, please try again", MessageType.Information); ViewData["Message"] = msg; } if (!Roles.IsUserInRole("CenterManager")) { ViewData["ExpenseList"] = MasterModels.GetPaymentList((int)Session["ClientId"], paymentType).OrderByDescending(pl => pl.Id).Take(10).ToList(); } else { if (Session["BranchId"] != null) { ViewData["ExpenseList"] = MasterModels.GetPaymentList((int)Session["ClientId"], (int)Session["BranchId"], paymentType, true).OrderByDescending(pl => pl.Id).Take(10).ToList(); } else { RedirectToAction("LogOff", "Account"); } } } else { ApplicationMessages msg = new ApplicationMessages("Missing entries. Please check and try again.", MessageType.Error); ViewData["Message"] = msg; return(View()); } break; case "search..": ViewData["ExpenseList"] = null; if (!string.IsNullOrEmpty(form["txtDateFrom"]) && !string.IsNullOrEmpty(form["txtDateTo"])) { DateTime fromDate = DateTime.MinValue; if (!DateTime.TryParse(form["txtDateFrom"], out fromDate)) { fromDate = DateTime.MinValue; } DateTime toDate = DateTime.MinValue; if (!DateTime.TryParse(form["txtDateTo"], out toDate)) { toDate = DateTime.MinValue; } if (fromDate.Date != DateTime.MinValue.Date) { if (!Roles.IsUserInRole("CenterManager")) { ViewData["ExpenseList"] = MasterModels.GetPaymentList((int)Session["ClientId"], paymentType, fromDate, toDate); } else { if (Session["BranchId"] != null) { ViewData["ExpenseList"] = MasterModels.GetPaymentList((int)Session["ClientId"], (int)Session["BranchId"], paymentType, fromDate, toDate, true); } else { RedirectToAction("LogOff", "Account"); } } ViewData["SearchedDateFrom"] = form["txtDateFrom"]; ViewData["SearchedDateTo"] = form["txtDateTo"]; } } else { ApplicationMessages msg = new ApplicationMessages("Missing entries. Please check and try again.", MessageType.Error); ViewData["Message"] = msg; return(View()); } break; } } } else { if (Roles.IsUserInRole("SuperAdmin")) { return(RedirectToAction("List", "Client")); } } return(View()); }