public IActionResult Table(string tablename, int fieldsnumber)
{
Models.TableModel tableModel = new Models.TableModel
{
Name = tablename,
NumberOfAttributes = fieldsnumber
};
return(View(tableModel));
}
public async Task <IActionResult> CreatedTable(string tablename, int fieldsnumber)
{
Models.TableModel tableModel = new Models.TableModel
{
Name = tablename,
NumberOfAttributes = fieldsnumber
};
List <String> valuesToInsert = new List <String>();
List <Models.Attribute> listValues = new List <Models.Attribute>();
for (int i = 0; i < fieldsnumber; i++)
{
var field = new Models.Attribute
{
Name = Request.Form[String.Format("{0} {1}", "fieldName", i)],
Type = Request.Form[String.Format("{0} {1}", "fieldType", i)]
};
listValues.Add(field);
valuesToInsert.Add(Request.Form[field.Name]);
}
tableModel.Attributes = listValues;
WebServiceSoapClient.EndpointConfiguration endpointConfiguration = WebServiceSoapClient.EndpointConfiguration.WebServiceSoap;
var client = new WebServiceSoapClient(endpointConfiguration);
if (valuesToInsert[0] != null)
{
var arrString = new ArrayOfString();
arrString.AddRange(valuesToInsert);
var tmp = await client.AddToTableInBDAsync(tableModel.ConvertToServiceModel(), arrString);
if (tmp.Body.AddToTableInBDResult)
{
return(View(tableModel));
}
return(View("Error"));
}
else
{
var tmp = await client.CreateTableInBDAsync(tableModel.ConvertToServiceModel());
if (tmp.Body.CreateTableInBDResult)
{
return(View(tableModel));
}
return(View("Error"));
}
}
//
// GET: /Home/Details/5
public ActionResult Detail(int id, string orderBy = "ID", string sort = "DESC", int pageIndex = 1)
{
int pageSize = 20;
var tabInfo = repository.GetTableInfo(id);
string orderInfo = "";
if (string.IsNullOrEmpty(orderBy) || string.IsNullOrEmpty(sort))
{
orderInfo = "ID DESC";
}
else
{
orderInfo = string.Format("{0} {1}", orderBy, sort);
}
var pagerInfo = ERP.DAL.SqlHelper.GetPagerData(tabInfo.Name, tabInfo.GetColumnSql(), null, orderInfo, pageIndex, pageSize);
TableDataInfo info = new TableDataInfo();
info.TableData = pagerInfo.PagerData;
info.TableInfo = tabInfo;
PagedList <DataRow> arts = new PagedList <DataRow>(pagerInfo.PagerData.Select(), pageIndex, pageSize, pagerInfo.RecordCount);
Models.TableModel model = new Models.TableModel();
var requestInfo = new Models.RequestInfo();
requestInfo.OrderBy = orderBy;
requestInfo.Sort = sort;
requestInfo.PageIndex = pageIndex;
model.PagedList = arts;
model.TableInfo = info;
model.RequestInfo = requestInfo;
return(View(model));
}
public IActionResult AddTableEntries(string tablename,
int fieldsnumber,
List <Models.Attribute> attributes)
{
Models.TableModel tableModel = new Models.TableModel();
tableModel.Name = tablename;
tableModel.NumberOfAttributes = fieldsnumber;
List <Models.Attribute> listValues = new List <Models.Attribute>();
for (int i = 0; i < fieldsnumber; i++)
{
var field = new Models.Attribute();
field.Name = Request.Form[String.Format("{0} {1}", "fieldName", i)];
field.Type = Request.Form[String.Format("{0} {1}", "fieldType", i)];
listValues.Add(field);
}
tableModel.Attributes = listValues;
return(View(tableModel));
}
