public ActionResult ListActive()
{
GetData();
IEnumerable <income> IncomeList;
IncomeList = IncomeRepository.GetIncomeByStatus("Inactive");
ViewBag.RecordCount = IncomeList.Count();
foreach (var i in IncomeList)
{
i.bankaccount = BankAccountRepository.GetBankAccountByID(i.bankAccountID);
i.subcategory = SubCategoryRepository.GetBySubCategoryID(i.subCategoryID);
}
decimal cash = (decimal)IncomeList.Sum(e => e.CashAmount);
ViewBag.TotalCash = cash;
decimal check = (decimal)IncomeList.Sum(e => e.CheckAmount);
ViewBag.TotalCheck = check;
decimal coin = (decimal)IncomeList.Sum(e => e.CoinAmount);
ViewBag.TotalCoin = coin;
ViewBag.TotalAmount = cash + check + coin;
return(PartialView(IncomeList));
}
public ActionResult IncomeReport(string date_from, string date_to)
{
List <IncomeList> IncList = new List <IncomeList>();
Property p = new Property();
DataSet ds = new DataSet();
p.OnTable = "GetIncomeRecord";
p.Condition1 = date_from;
p.Condition2 = date_to;
ds = dl.GetIncomeReport_sp(p);
try
{
foreach (DataRow item in ds.Tables[0].Rows)
{
IncomeList m = new IncomeList();
m.Id = item["Id"].ToString();
m.Name = item["Name"].ToString();
m.InvoiceNo = item["InvoiceNo"].ToString();
m.HeadId = item["HeadId"].ToString();
m.HeadName = item["HeadName"].ToString();
m.Date = item["Date"].ToString();
m.Amount = item["Amount"].ToString();
//m.ReceiverName = item["ReceiverName"].ToString();
//m.IsActive = item["IsActive"].ToString();
IncList.Add(m);
}
ViewBag.IncList = IncList;
}
catch (Exception ex)
{
}
return(View());
}
public void DeleteIncome()
{
Income itemToDelete;
//1. Get Account from DB
using (var ctx = new EntitySaveItContext())
{
itemToDelete =
ctx.Incomes.FirstOrDefault(s => s.Id == SelectedIncome.Id);
}
//Create new context for disconnected scenario
using (var newContext = new EntitySaveItContext())
{
newContext.Entry(itemToDelete).State = System.Data.Entity.EntityState.Deleted;
try
{
newContext.SaveChanges();
// remove the item to be deleted from the list
IncomeList.Remove(SelectedIncome);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
}
public IncomeController(User user)
{
if (user == null)
{
throw new ArgumentNullException("Имя пользователя не может быть пустым!", nameof(user));
}
this.user = user;
Incomes = GetAllIncomes();
IncomeList = GetIncomeList();
}
public void AddTest()
{
var userName = Guid.NewGuid().ToString();
var incomeName = Guid.NewGuid().ToString();
var rnd = new Random();
var userController = new UserController(userName);
var incomeController = new IncomeController(userController.CurrentUser);
var cost = new IncomeList(incomeName, rnd.Next(100, 500));
incomeController.Add(cost, rnd.Next(100, 500));
Assert.AreEqual(cost.Name, incomeController.Incomes.First().Name);
}
private async Task <IncomeList> GetIncomeList(string id)
{
List <IncomeModel> dbRec = new List <IncomeModel>();
var record = await _context.Income.Where(a => a.UserId == id).SingleOrDefaultAsync();
//var incomeBayanihan = new IncomeModel
//{
// IncomeType = "Bayanihan",
// Description = "Bayanihan Income",
// TotalAmount = record.BayanihanIncome,
// NetIncome = record.NetIncome
//};
var incomeBinary = new IncomeModel
{
IncomeType = "Incentives",
Description = "Incentives Income",
TotalAmount = record.DirectReferralIncome,
NetIncome = record.NetIncome
};
//var incomeUnilevel = new IncomeModel
//{
// IncomeType = "Unilevel",
// Description = "Unilevel Income",
// TotalAmount = record.UnilevelIncome,
// NetIncome = record.NetIncome
//};
var incomeGeneology = new IncomeModel
{
IncomeType = "Pairing Bonus",
Description = "Pairing Bonus Income",
TotalAmount = record.GeneologyIncome,
NetIncome = record.NetIncome
};
//dbRec.Add(incomeBayanihan);
dbRec.Add(incomeBinary);
//dbRec.Add(incomeUnilevel);
dbRec.Add(incomeGeneology);
IncomeList incomeList = new IncomeList
{
Records = dbRec
};
return(incomeList);
}
public ActionResult IncomeList()
{
List <IncomeList> CategoryList = new List <IncomeList>();
Property p = new Property();
DataSet ds = new DataSet();
p.OnTable = "FetchIncomeList";
ds = dl.FetchIncomeList_sp(p);
List <SelectListItem> Categoryinventory = new List <SelectListItem>();
Categoryinventory.Add(new SelectListItem {
Text = "Select", Value = ""
});
foreach (DataRow dr in ds.Tables[1].Rows)
{
Categoryinventory.Add(new SelectListItem {
Text = dr["HeadName"].ToString(), Value = dr["HeadId"].ToString()
});
}
ViewBag.Categoryinventory = new SelectList(Categoryinventory, "Value", "Text");
try
{
foreach (DataRow item in ds.Tables[0].Rows)
{
IncomeList m = new IncomeList();
m.Id = item["Id"].ToString();
m.HeadId = item["HeadId"].ToString();
m.HeadName = item["HeadName"].ToString();
m.Name = item["Name"].ToString();
m.InvoiceNo = item["InvoiceNo"].ToString();
m.Date = item["Date"].ToString();
m.Amount = item["Amount"].ToString();
m.Attachment = item["Attachment"].ToString();
m.Description = item["Description"].ToString();
m.IsActive = item["IsActive"].ToString();
CategoryList.Add(m);
}
ViewBag.CategoryList = CategoryList;
}
catch (Exception e)
{
}
return(View());
}
public ActionResult List(DateTime bDate, DateTime eDate, string code = "", int codeID = 0, string ReportType = "")
{
ViewBag.ReportType = ReportType;
IEnumerable <income> IncomeList;
if (code == "BankAccountSearch")
{
IncomeList = IncomeRepository.GetIncomeByBankAccount(codeID, bDate.Date, eDate.Date);
}
else if (code == "CategorySearch")
{
IncomeList = IncomeRepository.GetIncomeByCategory(codeID, bDate.Date, eDate.Date);
}
else if (code == "DateRangeSearch")
{
IncomeList = IncomeRepository.GetIncomeByDateRange(bDate.Date, eDate.Date);
}
else
{
IncomeList = IncomeRepository.GetIncomeByStatus("Inactive").OrderByDescending(e => e.IncomeDate);
}
ViewBag.RecordCount = IncomeList.Count();
foreach (var i in IncomeList)
{
i.bankaccount = BankAccountRepository.GetBankAccountByID(i.bankAccountID);
i.subcategory = SubCategoryRepository.GetBySubCategoryID(i.subCategoryID);
}
decimal cash = (decimal)IncomeList.Sum(e => e.CashAmount);
ViewBag.TotalCash = cash;
decimal check = (decimal)IncomeList.Sum(e => e.CheckAmount);
ViewBag.TotalCheck = check;
decimal coin = (decimal)IncomeList.Sum(e => e.CoinAmount);
ViewBag.TotalCoin = coin;
ViewBag.TotalAmount = cash + check + coin;
// GetData();
return(PartialView(IncomeList.OrderByDescending(e => e.IncomeDate)));
}
public ActionResult Create()
{
GetData();
IEnumerable <income> IncomeList;
IncomeList = IncomeRepository.GetIncomeByStatus("Inactive");
ViewBag.RecordCount = IncomeList.Count();
foreach (var i in IncomeList)
{
i.bankaccount = BankAccountRepository.GetBankAccountByID(i.bankAccountID);
i.subcategory = SubCategoryRepository.GetBySubCategoryID(i.subCategoryID);
if (i.CashAmount != null)
{
i.TotalIncome += (decimal)i.CashAmount;
}
if (i.CheckAmount != null)
{
i.TotalIncome += (decimal)i.CheckAmount;
}
if (i.CoinAmount != null)
{
i.TotalIncome += (decimal)i.CoinAmount;
}
}
decimal cash = (decimal)IncomeList.Sum(e => e.CashAmount);
ViewBag.TotalCash = cash;
decimal check = (decimal)IncomeList.Sum(e => e.CheckAmount);
ViewBag.TotalCheck = check;
decimal coin = (decimal)IncomeList.Sum(e => e.CoinAmount);
ViewBag.TotalCoin = coin;
ViewBag.TotalAmount = cash + check + coin;
ViewBag.IncomeList = IncomeList;
return(PartialView(new income {
DateEntered = System.DateTime.Today, EnteredBy = User.Identity.Name.ToString(), Status = "Inactive"
}));
}
private void DrawContent(FormType formType)
{
IncomeList incomeList = null;
OutcomeList outcomeList = null;
DomesticList domesticList = null;
try
{
if (formType.Equals(FormType.IncomeList))
{
if (contentList.ContainsKey(FormType.IncomeList))
{
mainTabCtl.SelectedTabPage = contentList.Single(t => t.Key.Equals(FormType.IncomeList)).Value;
return;
}
else
{
incomeList = new IncomeList(Tool.xmlStr, dbName, year);
incomeList.Dock = DockStyle.Fill;
XtraTabPage contentTab = new XtraTabPage();
contentTab.Text = incomeList.FormCaption;
contentTab.Controls.Add(incomeList);
mainTabCtl.TabPages.Add(contentTab);
mainTabCtl.SelectedTabPage = contentTab;
contentList.Add(FormType.IncomeList, contentTab);
}
}
else if (formType.Equals(FormType.OutcomeList))
{
if (contentList.ContainsKey(FormType.OutcomeList))
{
mainTabCtl.SelectedTabPage = contentList.Single(t => t.Key.Equals(FormType.OutcomeList)).Value;
return;
}
else
{
outcomeList = new OutcomeList(Tool.xmlStr, dbName, year);
outcomeList.Dock = DockStyle.Fill;
XtraTabPage contentTab = new XtraTabPage();
contentTab.Text = outcomeList.FormCaption;
contentTab.Controls.Add(outcomeList);
mainTabCtl.TabPages.Add(contentTab);
mainTabCtl.SelectedTabPage = contentTab;
contentList.Add(FormType.OutcomeList, contentTab);
}
}
else
{
if (contentList.ContainsKey(FormType.DomesticList))
{
mainTabCtl.SelectedTabPage = contentList.Single(t => t.Key.Equals(FormType.DomesticList)).Value;
return;
}
else
{
domesticList = new DomesticList(Tool.xmlStr, dbName, year);
domesticList.Dock = DockStyle.Fill;
XtraTabPage contentTab = new XtraTabPage();
contentTab.Text = domesticList.FormCaption;
contentTab.Controls.Add(domesticList);
mainTabCtl.TabPages.Add(contentTab);
mainTabCtl.SelectedTabPage = contentTab;
contentList.Add(FormType.DomesticList, contentTab);
}
}
}
catch (MofException ex)
{
System.Diagnostics.Debug.WriteLine("Шинэ content-tab үүсгэж чадсангүй: " + ex.Message);
Tool.ShowError(ex.Message, ex.InnerException.Message);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Шинэ content-tab үүсгэж чадсангүй: " + ex.Message);
Tool.ShowError("Шинэ content-tab үүсгэж чадсангүй: ", ex.Message);
}
finally { incomeList = null; outcomeList = null; }
}
public ActionResult IncomeList(IncomeList c, List <HttpPostedFileBase> Attachment)
{
string fileLocation = "";
string ItemUploadFolderPath = "~/DataImages/";
try
{
try
{
if (Attachment.Count > 0)
{
foreach (HttpPostedFileBase file in Attachment)
{
try
{
if (file.ContentLength == 0)
{
continue;
}
if (file.ContentLength > 0)
{
fileLocation = HelperFunctions.renameUploadFile(file, ItemUploadFolderPath);
if (fileLocation == "")
{
fileLocation = "";
}
}
}
catch (Exception ex)
{
}
if (fileLocation == "" || fileLocation == null)
{
c.Attachment = c.Attachment;
}
else
{
c.Attachment = fileLocation;
}
}
}
}
catch (Exception ex)
{
}
}
catch (Exception ex)
{
}
try
{
if (dl.InsertIncomeList_Sp(c) > 0)
{
TempData["MSG"] = "Income List Added Successfully";
}
}
catch (Exception ex)
{
TempData["MSG"] = "Something went wrong.";
return(Redirect("/Finance/IncomeList"));
}
TempData["MSG"] = "Income List Added Successfully.";
return(Redirect("/Finance/IncomeList"));
}
