public static List <RecCSV> LoadCSVFromFile(string FilePath) { List <RecCSV> LRC = File.ReadAllLines(FilePath) .Skip(1) .Select(v => RecCSV.FromCsv(v)) .ToList(); return(LRC); }
internal static RecCSV FromCsv(string csvLine) { RecCSV rc = new RecCSV(); string[] values = csvLine.Split(','); rc.MatId = Convert.ToInt32(values[0]); rc.Direction = values[1].Trim(); rc.TrnQTY = Convert.ToDecimal(values[2]); rc.UOM = values[3].Trim(); rc.Error = ""; return(rc); }
public static List <Transaction> LoadCSV2Transaction(string FilePath) { List <Transaction> LTs = new List <Transaction>(); List <RecCSV> LRC = File.ReadAllLines(FilePath) .Skip(1) .Select(v => RecCSV.FromCsv(v)) .ToList(); if (LRC != null) { LRC.ForEach(x => LTs.Add(x.Convet2Transaction())); } var Batch1 = UTILS.GetBatch1(DateTime.Now); LTs.ForEach(x => x.Batch1 = Batch1); LTs.ForEach(x => x.Status = "פעיל"); return(LTs); }