internal void UpdateInventorySource(string serverId, string moduleId, string formId, string fieldId, string value, string inventoryId) { /*XElement service = Settings.Module(serverId, moduleId) * .Elements("form") * .Elements("field") * .Where(c => (string)c.Attribute("id") == fieldId).FirstOrDefault();*/ XElement service = Settings.Form(serverId, moduleId, formId) .Elements("field") .Where(c => (string)c.Attribute("id") == fieldId).FirstOrDefault(); //extract settings from Setting.xml string urlService = service.Parent.Parent.Parent.Attribute("url").Value.ToString(); bool suppressExceptions = bool.Parse(service.Element("actions").Element("parameters").Element("suppressExceptions").Value); string dataviewName = "gbz_get_order_request_item"; string delimitedParameterList = ":orderrequestid=;:orderrequestitemid=" + value; int offset = int.Parse(service.Element("actions").Element("parameters").Element("offset").Value); int limit = int.Parse(service.Element("actions").Element("parameters").Element("limit").Value); string options = service.Element("actions").Element("parameters").Element("options").Value; GGZoneModel ggZoneModel = new GGZoneModel(); //invoke model requesting the datatable DataSet ds = ggZoneModel.GetData(urlService, suppressExceptions, dataviewName, delimitedParameterList, offset, limit, options); ds.Tables[dataviewName].Rows[0]["inventory_id"] = inventoryId; ggZoneModel.SaveData(urlService, suppressExceptions, ds, options); }
internal List <InventoryItem> NewBox(string serverId, string moduleId, string formId, string fieldId, List <InventoryItem> insert, string box) { int nBracket = 0; int nIndex = 0; string colName = string.Empty; //read the project XElement service = Settings.Form(serverId, moduleId, formId) .Elements("field") .Where(c => (string)c.Attribute("id") == fieldId).FirstOrDefault(); //extract settings from Setting.xml string urlService = service.Parent.Parent.Parent.Attribute("url").Value.ToString(); string dataviewName = service.Element("actions").Element("parameters").Element("dataviewName").Value; bool suppressExceptions = bool.Parse(service.Element("actions").Element("parameters").Element("suppressExceptions").Value); int offset = int.Parse(service.Element("actions").Element("parameters").Element("offset").Value); int limit = int.Parse(service.Element("actions").Element("parameters").Element("limit").Value); string options = service.Element("actions").Element("parameters").Element("options").Value; //put the value in the delimitedParameterList string delimitedParams = service.Element("actions").Element("parameters").Element("delimitedParameterList").Value; Char separator = (char)Convert.ToInt32(service.Element("actions").Element("parameters").Element("separator").Value); string value = ""; foreach (var inventoryItem in insert) { if (/*updateValues.IsValid(inventoryItem) && */ inventoryItem.InventoryNumber != null) { if (value == "") { value = inventoryItem.InventoryNumber; } else { value += "','" + inventoryItem.InventoryNumber; } } } var arrValue = value.Split(separator); while ((nBracket = delimitedParams.IndexOf("{0}", nBracket)) != -1) { delimitedParams = delimitedParams.Remove(nBracket, 3).Insert(nBracket, arrValue[nIndex]); nBracket++; nIndex++; } GGZoneModel ggZoneModel = new GGZoneModel(); //invoke model requesting the datatable DataSet ds = ggZoneModel.GetData(urlService, suppressExceptions, dataviewName, delimitedParams, offset, limit, options); DataTable model = ds.Tables[dataviewName]; //string box = ""; var inventoryItems = new List <InventoryItem>(); var arrValue2 = box.ToUpper().Split(new char[] { '-' }); foreach (var inventoryItem in insert) { if (/*updateValues.IsValid(inventoryItem) && */ inventoryItem.InventoryNumber != null) { DataRow[] dr = model.Select("inventory_number = '" + inventoryItem.InventoryNumber + "'"); //parsing storage location //string val2 = inventoryItem.Box; //if (val2 != null) //{ //var arrValue2 = box.ToUpper().Split(new char[] { '-' }); dr[0]["storage_location_part1"] = arrValue2[0]; dr[0]["storage_location_part2"] = arrValue2[1]; dr[0]["storage_location_part3"] = arrValue2[2]; //} dr[0]["storage_location_part4"] = inventoryItem.EntryId;//insert.IndexOf(inventoryItem) + 1; inventoryItems.Add(inventoryItem); } } ggZoneModel.SaveData(urlService, suppressExceptions, ds, options); return(inventoryItems); }
public DataTable SaveData(string serverId, string moduleId, string formId, string fieldId, string value) { //string cropId = cropSelected; int nBracket = 0; int nIndex = 0; string colName = string.Empty; //read the project /*XElement service = Settings.CropInfo(cropId) * .Elements("modules") * .Elements("form") * .Elements("field") * .Where(c => (string)c.Attribute("id") == viewSelected).FirstOrDefault();*/ /*XElement service = Settings.Module(serverId, moduleId) * .Elements("form") * .Elements("field") * .Where(c => (string)c.Attribute("id") == fieldId).FirstOrDefault();*/ XElement service = Settings.Form(serverId, moduleId, formId) .Elements("field") .Where(c => (string)c.Attribute("id") == fieldId).FirstOrDefault(); //extract settings from Setting.xml string urlService = service.Parent.Parent.Parent.Attribute("url").Value.ToString(); string dataviewName = service.Element("actions").Element("parameters").Element("dataviewName").Value; bool suppressExceptions = bool.Parse(service.Element("actions").Element("parameters").Element("suppressExceptions").Value); int offset = int.Parse(service.Element("actions").Element("parameters").Element("offset").Value); int limit = int.Parse(service.Element("actions").Element("parameters").Element("limit").Value); string options = service.Element("actions").Element("parameters").Element("options").Value; //put the value in the delimitedParameterList string delimitedParams = service.Element("actions").Element("parameters").Element("delimitedParameterList").Value; Char separator = (char)Convert.ToInt32(service.Element("actions").Element("parameters").Element("separator").Value); var arrValue = value.Split(separator); while ((nBracket = delimitedParams.IndexOf("{0}", nBracket)) != -1) { delimitedParams = delimitedParams.Remove(nBracket, 3).Insert(nBracket, arrValue[nIndex]); nBracket++; nIndex++; } GGZoneModel ggZoneModel = new GGZoneModel(); //invoke model requesting the datatable DataSet oldds = ggZoneModel.GetData(urlService, suppressExceptions, dataviewName, delimitedParams, offset, limit, options); DataTable model = oldds.Tables[dataviewName]; var primaryKey = model.PrimaryKey[0].ColumnName; DataRow[] dr = model.Select(primaryKey + " = " + GridViewExtension.GetEditValue <dynamic>(primaryKey));// EditorExtension.GetValue<object>(primaryKey).ToString().Replace("\"", "")); foreach (DataColumn col in model.Columns) { if (!col.ReadOnly) { //dr[0][col.ColumnName] = GridViewExtension.GetEditValue<dynamic>(col.ColumnName); var val = GridViewExtension.GetEditValue <dynamic>(col.ColumnName); if (val != null) { dr[0][col.ColumnName] = val; } } } //parsing storage location string val2 = GridViewExtension.GetEditValue <dynamic>("storage_location"); //string val2 = EditorExtension.GetValue<object>("storage_location") as String; if (val2 != null) { //val2 = val2.Replace("\"", ""); var arrValue2 = val2.Split(new char[] { '-' }); dr[0]["storage_location_part1"] = arrValue2[0]; dr[0]["storage_location_part2"] = arrValue2[1]; dr[0]["storage_location_part3"] = arrValue2[2]; dr[0]["storage_location_part4"] = arrValue2[3]; } DataSet result = ggZoneModel.SaveData(urlService, suppressExceptions, oldds, options); /* * DataSet ds = ggZoneModel.GetData(urlService, suppressExceptions, dataviewName, delimitedParams, offset, limit, options); * //remove or add column * foreach (DataColumn col in ds.Tables[dataviewName].Columns) * { * if (col.ExtendedProperties["is_visible"].ToString() == "N") * { * col.ColumnMapping = MappingType.Hidden; * } * * XElement column = (from e in service.Element("actions").Elements("columns").Descendants("column") * where e.Value.Trim().ToUpper() == col.ColumnName.Trim().ToUpper() * select e).FirstOrDefault(); * * if (column != null) * { * //create extendproperties * if (column.Attribute("header") != null && bool.Parse(column.Attribute("header").Value)) * { * col.ExtendedProperties.Add("is_header", true); * } * if (column.Attribute("link") != null && bool.Parse(column.Attribute("link").Value)) * { * col.ExtendedProperties.Add("view_reference", column.Attribute("viewreference").Value); * col.ExtendedProperties.Add("col_reference", column.Attribute("colreference").Value); * } * } * } * * return ds.Tables[dataviewName]; */ return(result.Tables[dataviewName]); }