public JsonResult GetLocationDetails(Int64 id)
{
MTSHRDataLayer.AssignAsset data_location_details = new MTSHRDataLayer.AssignAsset();
List <SelectListItem> locationDetailList = new List <SelectListItem>();
try
{
var LocationDetail = data_location_details.GetLocationDetails(id);
locationDetailList.Add(new SelectListItem()
{
Value = "", Text = "---- Select Location Details----"
});
for (int i = 0; i < LocationDetail.Rows.Count; i++)
{
locationDetailList.Add(new SelectListItem()
{
Value = LocationDetail.Rows[i]["PLACE_ID"].ToString(), Text = LocationDetail.Rows[i]["PLACE_NAME"].ToString()
});
}
}
catch (Exception exec)
{
BaseExceptionHandler.HandleException(ref exec);
}
ViewBag.LocationDetails = locationDetailList;
return(Json(new { success = true, LocationDetailList = JsonConvert.SerializeObject(locationDetailList) }, JsonRequestBehavior.AllowGet));
}
public JsonResult Add(AssignAsset assign)
{
MTSHRDataLayer.AssignAsset data_main = new MTSHRDataLayer.AssignAsset();
int result = data_main.AddAssetAssignment(assign.AssetTypeId, assign.AssetNameId, assign.ItemCode
, assign.EmployeeId, assign.DepartmentId, assign.LocationId
, assign.LocationDetails, assign.ActionDate, assign.Notes, assign.AssignTypeId);
// , assign.LocationDetails,test, assign.Notes, assign.AssignTypeId);
return(Json(new { success = result }, JsonRequestBehavior.AllowGet));
}
public List <SelectListItem> GetActiveEmployees()
{
MTSHRDataLayer.AssignAsset data_doc = new MTSHRDataLayer.AssignAsset();
var Employees = data_doc.GetActiveEmployees();
List <SelectListItem> empList = new List <SelectListItem>();
empList.Add(new SelectListItem()
{
Value = "", Text = "---- Select Employee ----"
});
for (int i = 0; i < Employees.Tables[0].Rows.Count; i++)
{
empList.Add(new SelectListItem()
{
Value = Employees.Tables[0].Rows[i]["id"].ToString(), Text = Employees.Tables[0].Rows[i]["EmployeeName"].ToString()
});
}
return(empList);
}
public List <SelectListItem> GetDepartment()
{
MTSHRDataLayer.AssignAsset data_doc = new MTSHRDataLayer.AssignAsset();
var Departments = data_doc.GetDepartments();
List <SelectListItem> departmentList = new List <SelectListItem>();
departmentList.Add(new SelectListItem()
{
Value = "", Text = "----Select Department----"
});
for (int i = 0; i < Departments.Tables[0].Rows.Count; i++)
{
departmentList.Add(new SelectListItem()
{
Value = Departments.Tables[0].Rows[i]["id"].ToString(), Text = Departments.Tables[0].Rows[i]["Department"].ToString()
});
}
return(departmentList);
}
public List <SelectListItem> GetLocation()
{
MTSHRDataLayer.AssignAsset data_doc = new MTSHRDataLayer.AssignAsset();
var Location = data_doc.GetLocations();
List <SelectListItem> locationList = new List <SelectListItem>();
locationList.Add(new SelectListItem()
{
Value = "", Text = "----Select Location----"
});
for (int i = 0; i < Location.Tables[0].Rows.Count; i++)
{
locationList.Add(new SelectListItem()
{
Value = Location.Tables[0].Rows[i]["LocationId"].ToString(), Text = Location.Tables[0].Rows[i]["LocationName"].ToString()
});
}
return(locationList);
}
public JsonResult GetDescription(string Id)
{
MTSHRDataLayer.AssignAsset data_doc = new MTSHRDataLayer.AssignAsset();
return(Json(JsonConvert.SerializeObject(data_doc.GetDescription(Id)), JsonRequestBehavior.AllowGet));
}
public JsonResult GetLastAssignedEmployee(string Id)
{
MTSHRDataLayer.AssignAsset data_doc = new MTSHRDataLayer.AssignAsset();
return(Json(JsonConvert.SerializeObject(data_doc.GetCurrentlyAssignedEmployee(Id)), JsonRequestBehavior.AllowGet));
}
