public ActionResult Select() { string mode = Request.QueryString["Grid-mode"]; if (!string.IsNullOrEmpty(mode)) { return(this.RedirectToAction("Create")); } else { List <AssetVM> viewModels = new List <AssetVM>(); AssetBAL balObject = new AssetBAL(); IQueryable <Entities.Asset> entites = balObject.GetAll(SessionHelper.SchoolId); foreach (Entities.Asset entity in entites) { AssetVM viewModel = new AssetVM(); viewModel.SrNo = entity.SrNo; viewModel.AssetName = entity.AssetName; viewModel.TypeofAsset = entity.TypeofAsset; viewModel.Quantity = entity.Quantity; viewModel.PricePerItem = entity.PricePerItem; viewModel.Total = entity.Total; viewModel.PurchaseDate = entity.PurchaseDate; viewModel.Condition = entity.Condition; viewModel.AssesmentYear = entity.AssesmentYear; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; viewModels.Add(viewModel); } return(View(new GridModel <AssetVM> { Data = viewModels })); } }
public ActionResult Edit(AssetVM viewModel) { try { // TODO: Add update logic here if (ModelState.IsValid) { Entities.Asset entity = new Entities.Asset(); entity.SrNo = viewModel.SrNo; entity.AssetName = viewModel.AssetName; entity.TypeofAsset = viewModel.TypeofAsset; entity.Quantity = viewModel.Quantity; entity.PricePerItem = viewModel.PricePerItem; entity.Total = viewModel.Total; entity.PurchaseDate = viewModel.PurchaseDate; entity.Condition = viewModel.Condition; entity.AssesmentYear = viewModel.AssesmentYear; entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; AssetBAL balObject = new AssetBAL(); balObject.Edit(entity); TempData["Message"] = "Asset entry updated successfully !!!"; } else { TempData["Error"] = "Some problem while updating asset entry !!!"; } } catch { TempData["Error"] = "Some problem while updating asset entry !!!"; } return(View(viewModel)); }
// // GET: /SysAdmin/Asset/ public ActionResult Index() { List <AssetVM> viewModels = new List <AssetVM>(); AssetBAL balObject = new AssetBAL(); IQueryable <Entities.Asset> entites = balObject.GetAll(SessionHelper.SchoolId); foreach (Entities.Asset entity in entites) { AssetVM viewModel = new AssetVM(); viewModel.SrNo = entity.SrNo; viewModel.AssetName = entity.AssetName; viewModel.TypeofAsset = entity.TypeofAsset; viewModel.Quantity = entity.Quantity; viewModel.PricePerItem = entity.PricePerItem; viewModel.Total = entity.Total; viewModel.PurchaseDate = entity.PurchaseDate; viewModel.Condition = entity.Condition; viewModel.AssesmentYear = entity.AssesmentYear; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; viewModels.Add(viewModel); } return(View(new GridModel <AssetVM> { Data = viewModels })); }
private DataSet AssetReport(DateTime fromDate, DateTime toDate) { DataSet ds = new DataSet(); ds.DataSetName = "DataSourceForReport"; DataTable dt = new DataTable("AssetDetails"); dt.TableName = "AssetDetails"; dt.Columns.Add(new DataColumn("SrNo", typeof(int))); dt.Columns.Add(new DataColumn("AssetName", typeof(string))); dt.Columns.Add(new DataColumn("Quantity", typeof(decimal))); dt.Columns.Add(new DataColumn("Total", typeof(decimal))); dt.Columns.Add(new DataColumn("Remark", typeof(string))); dt.Columns.Add(new DataColumn("PurchaseDate", typeof(DateTime))); AssetBAL balObject = new AssetBAL(); IQueryable <Entities.Asset> entites = balObject.GetAll(SessionHelper.SchoolId); if (entites != null && entites.Count() > 0) { foreach (Entities.Asset entity in entites) { DataRow dr = dt.NewRow(); dr["SrNo"] = entity.SrNo; dr["AssetName"] = entity.AssetName; dr["Quantity"] = entity.Quantity; dr["Total"] = entity.Total; dr["Remark"] = entity.Remark; dr["PurchaseDate"] = entity.PurchaseDate; reportName = "_"; dt.Rows.Add(dr); } } ds.Tables.Add(getSchoolDetails()); ds.Tables.Add(dt); return(ds); }
public ActionResult Edit(int id) { AssetVM viewModel = new AssetVM(); AssetBAL balObject = new AssetBAL(); IQueryable <Entities.Asset> entites = balObject.FindBy(a => a.SrNo == id); if (entites != null && entites.Count() > 0) { Entities.Asset entity = entites.FirstOrDefault(); viewModel.SrNo = entity.SrNo; viewModel.AssetName = entity.AssetName; viewModel.TypeofAsset = entity.TypeofAsset; viewModel.Quantity = entity.Quantity; viewModel.PricePerItem = entity.PricePerItem; viewModel.Total = entity.Total; viewModel.PurchaseDate = entity.PurchaseDate; viewModel.Condition = entity.Condition; viewModel.AssesmentYear = entity.AssesmentYear; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; } return(View(viewModel)); }