//tested
#region gives data at Modify ordering datas - strippings
/// <summary>
/// collect the stripping pool of chosen product
/// </summary>
/// <param name="prodId"></param>
/// <returns></returns>
public List <string> getThePoolOfStrippings(int prodId)
{
List <string> listStripName = new List <string>();
try
{
modellerRead = new OrderingModellerReadIn(dbci, parentMainWin);
stripList = modellerRead.getStripPoolOfOrderingChoose(prodId.ToString());
if (stripList.Count == 0)
{
listStripName.Add("Nincs kiszerelés");
return(listStripName);
}
foreach (OrderingStrippingToChoose row in stripList)
{
listStripName.Add(row.termekkiszerel.ToString());
}
}
catch (ErrorServiceGetTheStripPool e)
{
throw new ErrorServiceOrdering(e.Message);
}
catch (Exception e)
{
throw new ErrorServiceOrdering("Ismeretlen hiba történt (ServOrdStripCollect) " + e.Message);
}
return(listStripName);
}
/// <summary>
/// construct the DataTable of Cancelled orderings
/// </summary>
/// <returns>DataTable of CancelledOrderings</returns>
public DataTable getCancelledOrdersDataTable()
{
DataTable table = new DataTable();
table.Columns.Add("Srsz.", typeof(int));
table.Columns.Add("Terméknév", typeof(string));
table.Columns.Add("Kiszerelés", typeof(string));
table.Columns.Add("Menyyiség", typeof(int));
table.Columns.Add("Beszállító", typeof(string));
table.Columns.Add("Bejegyzés", typeof(DateTime));
table.Columns.Add("Törölve", typeof(string));
for (int i = 0; i < 7; i++)
{
table.Columns[i].ReadOnly = true;
}
try
{
modellerRead = new OrderingModellerReadIn(dbci, parentMainWin);
cancelledList = modellerRead.getListOfCancelledOrderings();
foreach (OrderingCancelled rec in cancelledList)
{
table.Rows.Add(rec.beszerId, rec.termekNev, rec.termekKiszer, rec.beszerzMennyis, rec.termekBeszall,
rec.beszerzDatum, rec.beszerzLemond);
}
}
catch (ErrorServiceCreateDataList e)
{
throw new ErrorServiceOrdering(e.Message);
}
catch (Exception e)
{
throw new ErrorServiceOrdering("Adattábla alkotásánál ismeretlen hiba történt (ServOrdCanc) " + e.Message);
}
return(table);
}
//tested
#region gives data at Modify ordering datas - products
/// <summary>
/// collects the pool of productions
/// </summary>
/// <returns>the list of product names</returns>
public List <string> getThePoolOfProductions_ProdSubcontrKeys()
{
List <string> listProdName = new List <string>();
try
{
modellerRead = new OrderingModellerReadIn(dbci, parentMainWin);
prodList = modellerRead.getProdPoolOfOrderingChoose();
foreach (OrderingProdToChoose row in prodList)
{
listProdName.Add(row.termekNev + "_" + row.beszallitoId);
}
}
catch (ErrorServiceGetTheProdPool e)
{
throw new ErrorServiceOrdering(e.Message);
}
catch (Exception e)
{
throw new ErrorServiceOrdering("Isermetlen hiba történt (ServOrdProdCollect) " + e.Message);
}
return(listProdName);
}
