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