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);
}
public BrapiResponseBrGermplasmV2TO GetGermplasmDetails(string cropId, int germplasmDbId)
{
XElement service = Settings.Server(cropId);
//extract settings from Setting.xml
string crop = service.Attribute("name").Value.ToString();
GGZoneModel ggZoneModel = new GGZoneModel();
var result = ggZoneModel.GetGermplasmDetails(crop, germplasmDbId);
return(result);
}
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 GetData(string serverId, string moduleId, string formId, string fieldId, string value)
{
//string cropId = serverId;
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 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))
{
//moduleRef="Inventory" formRef="gbz_get_inventory" fieldRef="intrid" colRef="inventory_number_part1"
col.ExtendedProperties.Add("moduleRef", column.Attribute("moduleRef").Value);
col.ExtendedProperties.Add("formRef", column.Attribute("formRef").Value);
col.ExtendedProperties.Add("fieldRef", column.Attribute("fieldRef").Value);
col.ExtendedProperties.Add("colRef", column.Attribute("colRef").Value);
}
}
if (col.ColumnName == "storage_location")
{
col.ReadOnly = false;
}
}
if (service.Element("actions").Element("extendedProperties").Element("masterDetail") != null)
{
ds.Tables[dataviewName].ExtendedProperties.Add("masterDetail", true);
ds.Tables[dataviewName].ExtendedProperties.Add("actionName", service.Element("actions").Element("extendedProperties").Element("masterDetail").Attribute("actionName").Value);
ds.Tables[dataviewName].ExtendedProperties.Add("moduleRef", service.Element("actions").Element("extendedProperties").Element("masterDetail").Attribute("moduleRef").Value);
ds.Tables[dataviewName].ExtendedProperties.Add("formRef", service.Element("actions").Element("extendedProperties").Element("masterDetail").Attribute("formRef").Value);
ds.Tables[dataviewName].ExtendedProperties.Add("fieldRef", service.Element("actions").Element("extendedProperties").Element("masterDetail").Attribute("fieldRef").Value);
ds.Tables[dataviewName].ExtendedProperties.Add("colRef", service.Element("actions").Element("extendedProperties").Element("masterDetail").Attribute("colRef").Value);
}
return(ds.Tables[dataviewName]);
}
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]);
}
