public JsonResult AddMachineGroupRelation(int groupID, string[] arrEquip) { var result = false; var overallResult = false; foreach (var equip in arrEquip) { result = EquipmentGroupModels.AddMachineGroupRelation(groupID, Convert.ToInt32(equip)); if (result == true) { overallResult = true; } } return(Json(overallResult.ToString(), JsonRequestBehavior.AllowGet)); }
public JsonResult GetAssignedMachine(int groupID) { var result = EquipmentGroupModels.GetAssignedMachine(groupID); string json = ""; try { //serialize the object so that javascript can read the data json = JsonConvert.SerializeObject(result); } catch { json = ""; } return(Json(json, JsonRequestBehavior.AllowGet)); }
public JsonResult GetEquipmentGroupList() { //create a dictionary that will contain the column + datafied config for the grid Dictionary <string, object> result_config = new Dictionary <string, object>(); //get columns Dictionary <string, string> columns = EquipmentGroupModels.GetCols(); //check for filters string where = ""; Dictionary <string, string> filters = new Dictionary <string, string>(); if (Request["filterscount"] != null && Int32.Parse(Request["filterscount"]) > 0) { for (int i = 0; i < Int32.Parse(Request["filterscount"]); i++) { filters.Add("filtervalue" + i, Request["filtervalue" + i]); filters.Add("filtercondition" + i, Request["filtercondition" + i]); filters.Add("filterdatafield" + i, Request["filterdatafield" + i]); filters.Add("filteroperator" + i, Request["filteroperator" + i]); } where = custom_helper.FormatFilterConditions(filters, Int32.Parse(Request["filterscount"]), columns); } //check for sorting ops string sorting = ""; if (Request["sortdatafield"] != null) { sorting = Request["sortdatafield"].ToString() + " " + Request["sortorder"].ToString().ToUpper(); } //determine if cols_only if (Request["cols_only"] != null && bool.Parse(Request["cols_only"]) == true) { //get total row count int totalRows = EquipmentGroupModels.GetCount(where, ((Request["searchStr"] == null) ? "" : Request["searchStr"].ToString())); //prepare column config var cols = new List <string>(); foreach (var item in columns) { cols.Add(item.Value); } Dictionary <string, object> cols_arr = custom_helper.PrepareStaticColumns(cols); result_config.Add("column_config", custom_helper.PrepareColumns(cols_arr)); result_config.Add("TotalRows", totalRows); } else { //pagination initialization int pagenum = Request["pagenum"] == null ? 0 : Int32.Parse(Request["pagenum"].ToString()); int pagesize = Request["pagesize"] == null ? 0 : Int32.Parse(Request["pagesize"].ToString()); int start = pagenum * pagesize; //get data DataTable transactions = new DataTable(); if (Request["showAll"] != null && bool.Parse(Request["showAll"]) == true) { transactions = EquipmentGroupModels.GetData(0, 0, where, sorting, ((Request["searchStr"] == null) ? "" : Request["searchStr"].ToString())); } else { transactions = EquipmentGroupModels.GetData(start, pagesize, where, sorting, ((Request["searchStr"] == null) ? "" : Request["searchStr"].ToString())); } //convert data into json object var data = custom_helper.DataTableToJson(transactions); result_config.Add("data", data); //prepare column config var cols = new List <string>(); foreach (DataColumn column in transactions.Columns) { cols.Add(column.ColumnName); } Dictionary <string, object> cols_arr = custom_helper.PrepareStaticColumns(cols); result_config.Add("column_config", custom_helper.PrepareColumns(cols_arr)); result_config.Add("TotalRows", EquipmentGroupModels.GetCount(where, ((Request["searchStr"] == null) ? "" : Request["searchStr"].ToString()))); } string temp = Request["searchStr"]; response.Add("success", true); response.Add("error", false); response.Add("message", result_config); return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteMachineGroupRelation(string ID) { var result = EquipmentGroupModels.DeleteMachineGroupRelation(ID); return(Json(result.ToString(), JsonRequestBehavior.AllowGet)); }
public JsonResult CheckIfMachineExist(int groupID, int equipID) { var result = EquipmentGroupModels.isMachineInGroup(groupID, equipID); return(Json(result.ToString(), JsonRequestBehavior.AllowGet)); }
public JsonResult UpdateMachineGroup(string id, string name, bool isEnabled) { var result = EquipmentGroupModels.UpdateMachineGroup(id, name, isEnabled); return(Json(result.ToString(), JsonRequestBehavior.AllowGet)); }
public JsonResult AddMachineGroup(string name, bool IsEnabled) { var result = EquipmentGroupModels.AddMachineGroup(name, IsEnabled); return(Json(result.ToString(), JsonRequestBehavior.AllowGet)); }
public JsonResult CheckEquipmentGroupForUpdate(string name, int ID) { var result = EquipmentGroupModels.CheckGroupForUpdate(name, ID); return(Json(result.ToString(), JsonRequestBehavior.AllowGet)); }
public JsonResult CheckEquipmentGroup(string name) { var result = EquipmentGroupModels.CheckGroup(name); return(Json(result.ToString(), JsonRequestBehavior.AllowGet)); }