public void TestNextNumber()
{
double NextBatch = JDE.GetNextBatchNumber();
double NextDocument = JDE.GetDocumentNumbers(10);
NextBatch = JDE.GetNextBatchNumber();
NextDocument = JDE.GetDocumentNumbers(1);
}
/// <summary>
/// Convert a csv object into a concept object
/// </summary>
/// <param name="csv"></param>
/// <returns></returns>
public static Concept CSVtoConcept(ConceptCSV csv)
{
Concept con = new Concept();
ConceptLine entry;
int linenumber;
DataRow r1;
List <DataRow> rows = new List <DataRow>();
double document = JDE.GetDocumentNumbers(csv.DT.Rows.Count); // reserve a set of document numbers
PopulateConceptHeader(ref con, csv);
// Get a list of unique store numbers
List <string> stores = csv.DT.AsEnumerable().Select(n => n.Field <string>("STORE NUMBER")).Distinct().ToList();
// Loop through that customer and add all of that customer's lines to the datatable
foreach (string store in stores)
{
rows = csv.DT.AsEnumerable().Where(n => store == n.Field <string>("STORE NUMBER")).ToList();
linenumber = 1; // Start at linenumber 1
foreach (DataRow r in rows)
{
entry = PopulateConceptLine(document,
r["STORE NUMBER"].ToString(),
linenumber, // Line #
r["PART NUMBER"].ToString(), // The part number
Double.Parse(r["ORDER QTY"].ToString()),
CommonFunctions.DateStringToJulian(r["REQ'D SHIP DATE"].ToString()),
con);
con.OrderDetails.Add(entry);
linenumber++;
}
// Now add the freight line for this customer
r1 = rows[0]; // get the first row
entry = PopulateConceptLine(document,
r1["STORE NUMBER"].ToString(),
linenumber, // Line #2 is the freight line
"9227", // The freight part number
1, // Qty of 1
CommonFunctions.DateStringToJulian(r1["REQ'D SHIP DATE"].ToString()),
con);
con.OrderDetails.Add(entry);
document++;
}
return(con);
} // CSVtoConcept