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