public static List <StgOrdersCSV> FilterDataFromSTG(List <StgOrdersCSV> listSTG, DataTable daSTG) { try { StgOrdersCSV obj = new StgOrdersCSV(); foreach (var row in daSTG.AsEnumerable()) { var item = listSTG.FirstOrDefault(x => x.StrCustOrdNumber == (String)row["Customer Order Number"].ToString() && x.StrItemId == (String)row["Item"].ToString()); //TextHelper.WriteLine("SQL : [Order Number: " + (String)row["Customer Order Number"].ToString()); //TextHelper.WriteLine("List : [PO: " + item.StrCustPO + ", Item: " + item.StrItemId); //TextHelper.WriteLine("SQL : [PO: " + (String)row["PO Number"].ToString() + ", Item: " + (String)row["Item"].ToString()); if (item.StrCustPO == (String)row["PO Number"].ToString() && item.StrItemId == (String)row["Item"].ToString()) { listSTG.Remove(item); //TextHelper.WriteLine("Remove"); } } TextHelper.WriteLine("Object Remove Finished, FilterDataFromSTG"); } catch (Exception e) { TextHelper.WriteLine("Error in FilterDataFromSTG"); TextHelper.WriteLine(e.Message); return(null); } return(listSTG); }
public static List <StgOrdersCSV> AddSTGVendorNumberDatatoObjects(List <StgOrdersCSV> listSTG, DataTable daGP, String Identifier) { try { StgOrdersCSV obj = new StgOrdersCSV(); if (Identifier == "BBBVendorNumber") { foreach (var row in daGP.AsEnumerable()) { listSTG.Where(o => o.StrItemId == (String)row["Item"].ToString()).ToList().ForEach(o => o.StrBBBVendorNumber = (String)row["Vendor Number"].ToString()); listSTG.Where(o => o.StrItemId == (String)row["Item"].ToString()).ToList() .ForEach(o => { if (o.StrRetailerID.Trim() == "BBBCAN") { o.StrRetailerID = o.StrBBBVendorNumber + "CAN"; } else { o.StrRetailerID = o.StrBBBVendorNumber; } }); } } if (Identifier != "BBBVendorNumber") { //Nothing to Change } } catch (Exception e) { TextHelper.WriteLine("Error in AddGPDatatoObjects: " + e.Message); return(null); } return(listSTG); }