public ActionResult Entry(AssetEntryVm assetEntryVm)
{
ViewBag.orglist = generalCategoryManager.GetAll();
ViewBag.assetlist = assetManager.GetSome(5);
var assetCodeCheck = assetManager.GetAll().Where(c => c.Code == assetEntryVm.Code).ToList();
if (!ModelState.IsValid)
{
return(View(assetEntryVm));
}
else if (assetCodeCheck.Count > 0)
{
ViewBag.msg = "Code Already Exist";
return(View(assetEntryVm));
}
else
{
var assetEntry = Mapper.Map <Asset>(assetEntryVm);
assetEntry.Registered = false;
assetEntry.Organization = Session["organizationName"].ToString();
assetManager.Add(assetEntry);
//var newAssetEntry = Mapper.Map<NewAsset>(assetEntryVm);
//newAssetManager.Add(newAssetEntry);
ModelState.Clear();
return(RedirectToAction("Entry", new { success = "true" }));
}
}
public ICollection <AssetEntryVm> GetAllAssetWithGeneral_Category_SubCategory_Brand_Product(string org)
{
var joinlist = from a in Context.Asset.Where(c => c.Registered == false && c.Organization == org)
join b in Context.Brand
on a.BrandId equals b.Id
join c in Context.Category
on b.CategoryId equals c.Id
join gc in Context.GeneralCategory
on c.GeneralCategoryId equals gc.Id
select new
{
id = a.Id,
code = a.Code,
serialno = a.SerialNo,
name = a.Name,
price = a.Price,
description = a.Description,
generalcategoyid = gc.Id,
generalcategory = gc.Name,
categoryid = c.Id,
category = c.Name,
brandid = b.Id,
brand = b.Name
};
ICollection <AssetEntryVm> list = new List <AssetEntryVm>();
foreach (var t in joinlist)
{
AssetEntryVm assetvm = new AssetEntryVm();
assetvm.Id = t.id;
assetvm.Code = t.code;
assetvm.SerialNo = t.serialno;
assetvm.Name = t.name;
assetvm.Price = t.price;
assetvm.Description = t.description;
assetvm.GeneralCategoryId = t.generalcategoyid;
assetvm.GeneralCategoryName = t.generalcategory;
assetvm.CategoryId = t.categoryid;
assetvm.CategoryName = t.category;
assetvm.BrandId = t.brandid;
assetvm.BrandName = t.brand;
list.Add(assetvm);
}
return(list.ToList());
}
public ICollection <AssetEntryVm> GetSome(int n)
{
var join = from a in Context.Asset.Where(c => c.Registered == false)
join b in Context.Brand
on a.BrandId equals b.Id
join c in Context.Category
on b.CategoryId equals c.Id
join gc in Context.GeneralCategory
on c.GeneralCategoryId equals gc.Id
select new
{
id = a.Id,
code = a.Code,
serialno = a.SerialNo,
name = a.Name,
price = a.Price,
description = a.Description,
generalcategory = gc.Name,
category = c.Name,
brand = b.Name,
};
var joinlist = join.Take(n).OrderByDescending(c => c.id).ToList();
ICollection <AssetEntryVm> list = new List <AssetEntryVm>();
foreach (var t in joinlist)
{
AssetEntryVm assetvm = new AssetEntryVm();
assetvm.Id = t.id;
assetvm.Code = t.code;
assetvm.SerialNo = t.serialno;
assetvm.Name = t.name;
assetvm.Price = t.price;
assetvm.Description = t.description;
assetvm.GeneralCategoryName = t.generalcategory;
assetvm.CategoryName = t.category;
assetvm.BrandName = t.brand;
list.Add(assetvm);
}
return(list.ToList());
}
