public ActionResult GetDailyForDatatable() { using (var context = new ApplicationDbContext()) { var dailyies = context.Daily.OrderByDescending(d => d.Date).ToList(); List <DailyViewModel> dailyViewModelList = new List <DailyViewModel>(); IEnumerable <DailyViewModel> dailyViewModelEnu; foreach (var daily in dailyies) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; List <DailyItemViewModel> dailyItemViewModelList = new List <DailyItemViewModel>(); foreach (var item in daily.DailyItems) { DailyItemViewModel dailyItemViewModel = new DailyItemViewModel(); dailyItemViewModel.Id = item.Id; dailyItemViewModel.Name = item.StoreProduct.Product.Name; dailyItemViewModel.Quantity = item.Quantity; dailyItemViewModel.MRPPerUnit = item.MRPPerUnit; dailyItemViewModel.ItemAmount = item.ItemAmount; dailyItemViewModelList.Add(dailyItemViewModel); } viewModel.DailyItemViewModels = dailyItemViewModelList; dailyViewModelList.Add(viewModel); } dailyViewModelEnu = dailyViewModelList; var result = new { iTotalRecords = dailyies.Count, iTotalDisplayRecords = dailyies.Count, aaData = dailyViewModelList }; return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Daily daily = _dbContext.Daily.Find(id); if (daily == null) { return(HttpNotFound()); } DailyViewModel viewModel = new DailyViewModel() { Head = daily.HeadName, Id = daily.Id, Invoice = daily.Invoice, Date = daily.Date, ContactId = daily.ContactId, CustomerName = daily.Contact.FullName, ParticularId = daily.ParticularId, Particular = daily.Particular.Name, Total = daily.DailyTotal, Due = daily.Due, Note = daily.Note, // Net = daily.Net }; List <DailyItemViewModel> dailyItemViewModelList = new List <DailyItemViewModel>(); foreach (var item in daily.DailyItems) { DailyItemViewModel dailyItemViewModel = new DailyItemViewModel() { Id = item.Id, BatchId = item.StoreProduct.BatchId, BatchName = item.StoreProduct.Batch.Name, AutoGenerateName = item.StoreProduct.Product.AutoGenerateName, StoreProductId = item.StoreProductId, MRPPerUnit = item.MRPPerUnit, Quantity = item.Quantity, ItemAmount = item.ItemAmount }; dailyItemViewModelList.Add(dailyItemViewModel); } viewModel.DailyItemViewModels = dailyItemViewModelList; ViewBag.BatchId = new SelectList(_dbContext.Batch, "Id", "Name"); ViewBag.Memberships = new SelectList(_dbContext.Memberships, "Id", "MembershipName"); viewModel.Head = daily.HeadName; if (viewModel.Head == "Service") { viewModel.X = 1; } else if (viewModel.Head == "Sales") { viewModel.X = 2; } else if (viewModel.Head == "Expense") { viewModel.X = 3; } else { viewModel.X = 4; } viewModel.GetHeadList = viewModel.getList(); return(View(viewModel)); }