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