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