public JsonResult AssetName(Int64 Id)
{
MTSHRDataLayer.AssetMaintenanceDetails data_asset_name = new MTSHRDataLayer.AssetMaintenanceDetails();
List <SelectListItem> Assetnamelist = new List <SelectListItem>();
try
{
var Assetname = data_asset_name.GetSpecificAsset(Id);
Assetnamelist.Add(new SelectListItem()
{
Value = "", Text = "---- Select Category----"
});
for (int i = 0; i < Assetname.Rows.Count; i++)
{
Assetnamelist.Add(new SelectListItem()
{
Value = Assetname.Rows[i]["Id"].ToString(), Text = Assetname.Rows[i]["AssetName"].ToString()
});
}
}
catch (Exception exec)
{
BaseExceptionHandler.HandleException(ref exec);
}
ViewBag.Assetname = Assetnamelist;
return(Json(new { success = true, AssetList = JsonConvert.SerializeObject(Assetnamelist) }, JsonRequestBehavior.AllowGet));
}
public JsonResult Add(AssetMaintenanceDetails maintenance)
{
MTSHRDataLayer.AssetMaintenanceDetails data_main = new MTSHRDataLayer.AssetMaintenanceDetails();
int result = data_main.Create(maintenance.AssetTypeId, maintenance.AssetName, maintenance.Dateofpurchase, maintenance.Vendor, maintenance.Maintenance_Carried_out, maintenance.Cost, maintenance.Notes,maintenance.Item);
return Json(new { success = result }, JsonRequestBehavior.AllowGet);
}
//public JsonResult GetItemCode(Int64 id)
//{
// MTSHRDataLayer.AssignAsset data_item_code = new MTSHRDataLayer.AssignAsset();
// List<SelectListItem> itemCodeList = new List<SelectListItem>();
// try
// {
// var ItemCode = data_item_code.GetItemCode(id);
// itemCodeList.Add(new SelectListItem() { Value = "", Text = "---- Select Item Code----" });
// for (int i = 0; i < ItemCode.Rows.Count; i++)
// {
// itemCodeList.Add(new SelectListItem() { Value = ItemCode.Rows[i]["IDENTIFICATION_CODE"].ToString(), Text = ItemCode.Rows[i]["IDENTIFICATION_CODE"].ToString() });
// }
// }
// catch (Exception exec)
// {
// BaseExceptionHandler.HandleException(ref exec);
// }
// ViewBag.ItemCode = itemCodeList;
// return Json(new { success = true, ItemCodeList = JsonConvert.SerializeObject(itemCodeList) }, JsonRequestBehavior.AllowGet);
//}
public JsonResult GetItemCode(Int64 Assettypeid, Int64 Assetnameid)
{
MTSHRDataLayer.AssetMaintenanceDetails data_item = new MTSHRDataLayer.AssetMaintenanceDetails();
List <SelectListItem> itemCodeList = new List <SelectListItem>();
try
{
var item = data_item.GetItem(Assettypeid, Assetnameid);
itemCodeList.Add(new SelectListItem()
{
Value = "", Text = "--Select Item--"
});
for (int i = 0; i < item.Rows.Count; i++)
{
itemCodeList.Add(new SelectListItem()
{
Value = item.Rows[i]["ID"].ToString(), Text = item.Rows[i]["Item"].ToString()
});
}
}
catch (Exception exec)
{
BaseExceptionHandler.HandleException(ref exec);
}
ViewBag.ItemCode = itemCodeList;
return(Json(new { success = true, ItemCodeList = JsonConvert.SerializeObject(itemCodeList) }, JsonRequestBehavior.AllowGet));
}
public JsonResult Read()
{
MTSHRDataLayer.AssetMaintenanceDetails Maintenance = new MTSHRDataLayer.AssetMaintenanceDetails();
return Json(JsonConvert.SerializeObject(Maintenance.Read()), JsonRequestBehavior.AllowGet);
}