/// <summary> /// request the content the productQuality content /// </summary> /// <param name="mode">mode true = active / false = passive records</param> /// <returns>DataTable result of the collecting</returns> public DataTable getTableOfProductsPartTable(bool mode) { try { //modelQualities = new ProductsModelQualityTable(,); modelReadingInDatas = new ProductsModelReadIn(dbci, parent); prodPartList = modelReadingInDatas.getProductsPartList(mode); table = new DataTable(); table.Columns.Add("Terméknév", typeof(string)); //name, typeof(integer) table.Columns.Add("Mértékegység", typeof(string)); table.Columns.Add("Veszély", typeof(int)); table.Columns.Add("Beszállítója", typeof(string)); table.Columns.Add("Leírás", typeof(string)); //table.Columns.Add("Módosítás", typeof(string)); foreach (ProductQualityPart cont in prodPartList) { table.Rows.Add(cont.productName, cont.productQantUnit, cont.productDanger, cont.productSubcontr, cont.productDescr /*modelQualities.getWhoModifiedQuality(cont.productModifiedBy)*/); } return(table); } catch (ErrorServiceCreateDataTable) { errorHandle("Adattábla megalkotása sikertelen (CtrProdDT)"); return(null); } catch (Exception e) { errorHandle(e.Message); return(null); } }
/// <summary> /// reads in the production strippings /// </summary> /// <param name="mode">true = act / false = history</param> /// <returns>readed in datas</returns> public DataTable getTableOfProductsFullTable(bool mode) { modelReadingInDatas = new ProductsModelReadIn(dbci, parent); table = new DataTable(); table.Columns.Add("Terméknév", typeof(string)); //name, typeof(integer) table.Columns.Add("Kiszerelés", typeof(int)); table.Columns.Add("Mértékegység", typeof(string)); table.Columns.Add("Veszély", typeof(int)); table.Columns.Add("Termékkód", typeof(string)); table.Columns.Add("Helye", typeof(string)); table.Columns.Add("Mennyiség", typeof(int)); try { prodFullList = modelReadingInDatas.getProductsFullList(mode); foreach (ProductFullRow cont in prodFullList) { table.Rows.Add(cont.productName, cont.productStripping, cont.productQantUnit, cont.productDanger, cont.productBarcode, cont.productPlace, cont.productQuantity); } return(table); } catch (ErrorServiceCreateDataTable) { errorHandle("Adattábla megalkotása sikertelen (CtrProdQuantDT)"); return(null); } catch (Exception e) { errorHandle(e.Message); return(null); } }
/// <summary> /// reads in the production strippings /// </summary> /// <param name="mode">true = act / false = history</param> /// <returns>readed in datas</returns> public DataTable getTableOfProductsFullTable(bool mode) { modelReadingInDatas = new ProductsModelReadIn(dbci, parentMain); table = new DataTable(); table.Columns.Add("Srsz.", typeof(int)); table.Columns.Add("Terméknév", typeof(string)); //name, typeof(integer) table.Columns.Add("Kiszerelés", typeof(int)); table.Columns.Add("Mértékegység", typeof(string)); table.Columns.Add("Veszély", typeof(int)); table.Columns.Add("Termékkód", typeof(string)); table.Columns.Add("Helye", typeof(string)); table.Columns.Add("Mennyiség", typeof(int)); try { prodFullList = modelReadingInDatas.getProductsFullList(mode); foreach (ProductFullRow cont in prodFullList) { table.Rows.Add(cont.strippId, cont.productName, cont.productStripping, cont.productQantUnit, cont.productDanger, cont.productBarcode, cont.productPlace, cont.productQuantity); } return(table); } catch (ErrorServiceCreateDataList e) { throw new ErrorServiceProd(e.Message); } catch (Exception e) { throw new ErrorServiceProd("Ismeretlen hiba történt (ServProdQuantDT) " + e.Message); } }
/// <summary> /// request the content the productQuality content /// </summary> /// <param name="mode">mode true = active / false = passive records</param> /// <returns>DataTable result of the collecting</returns> public DataTable getTableOfProductsPartTable(bool mode) { try { //modelQualities = new ProductsModelQualityTable(,); modelReadingInDatas = new ProductsModelReadIn(dbci, parentMain); prodPartList = modelReadingInDatas.getProductsPartList(mode); table = new DataTable(); table.Columns.Add("Srsz.", typeof(int)); table.Columns.Add("Terméknév", typeof(string)); //name, typeof(integer) table.Columns.Add("Mértékegység", typeof(string)); table.Columns.Add("Veszély", typeof(int)); table.Columns.Add("Beszállítója", typeof(string)); table.Columns.Add("Leírás", typeof(string)); //table.Columns.Add("Módosítás", typeof(string)); foreach (ProductQualityPart cont in prodPartList) { table.Rows.Add(cont.productQualId, cont.productName, cont.productQantUnit, cont.productDanger, cont.productSubcontr, cont.productDescr /*modelQualities.getWhoModifiedQuality(cont.productModifiedBy)*/); } return(table); } catch (ErrorServiceCreateDataList e) { throw new ErrorServiceProd(e.Message); } catch (Exception e) { throw new ErrorServiceProd("Ismertlen hiba történt (ServProdDT) " + e.Message); } }
/// <summary> /// gets the username, who deleted a specific record in the 'raktmennyiseg' table /// </summary> /// <param name="indexOfRecord">the index of the record</param> /// <returns>full name of a user</returns> public string getWhoModifiedTheQuantityRecord(int indexOfRecord) { try { modelReadingInDatas = new ProductsModelReadIn(dbci, parentMain); return(modelReadingInDatas.getWhoModifiedRecord(indexOfRecord)); } catch (ErrorServiceWhoModified e) { throw new ErrorServiceProd(e.Message); } }
/// <summary> /// gets the username, who deleted a specific record in the 'raktminoseg' table /// </summary> /// <param name="indexOfRecord">the index of the record</param> /// <returns>full name of a user</returns> public string getWhoModifiedTheRecord(int indexOfRecord) { try { modelReadingInDatas = new ProductsModelReadIn(dbci, parent); return(modelReadingInDatas.getWhoModifiedRecord(indexOfRecord)); } catch (ErrorServiceWhoModified e) { errorHandle(e.Message); return(null); } }
public List <string> getListOfSubcontr() { modelReadingInDatas = new ProductsModelReadIn(dbci, parent); return(modelReadingInDatas.getSubcontrList()); }