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