public List <FutureBhavCopy> GetFutureBhavCopy(string filename) { List <FutureBhavCopy> masters = new List <FutureBhavCopy>(); using (StreamReader sr = new StreamReader(File.Open(filename, FileMode.Open))) { string line = sr.ReadLine(); while (line != null) { var data = line.Split(','); var obj = new FutureBhavCopy { INSTRUMENT = data[0], SYMBOL = data[1], EXPIRY_DT = DateTime.Parse(data[2]), STRIKE_PR = double.Parse(data[3]), OPTION_TYP = data[4], OPEN = double.Parse(data[5]), HIGH = double.Parse(data[6]), LOW = double.Parse(data[7]), CLOSE = double.Parse(data[8]), SETTLE_PR = double.Parse(data[9]), CONTRACTS = double.Parse(data[10]), VAL_INLAKH = double.Parse(data[11]), OPEN_INT = double.Parse(data[12]), CHG_IN_OI = double.Parse(data[13]), TIMESTAMP = DateTime.Parse(data[14]), Filler1 = data[15] }; masters.Add(obj); line = sr.ReadLine(); } } return(masters); }
public List <FutureBhavCopy> GetFutureBhavCopy(string filename) { List <FutureBhavCopy> masters = new List <FutureBhavCopy>(); try { using (StreamReader sr = new StreamReader(File.OpenRead(filename))) { string line1 = sr.ReadLine(); string line = sr.ReadLine(); while (line != null) { var data = line.Split(','); var obj = new FutureBhavCopy(); obj.INSTRUMENT = data[0]; obj.SYMBOL = data[1]; obj.EXPIRY_DT = DateTime.Parse(data[2]); obj.STRIKE_PR = Double.TryParse(data[3], out DEFAULTDOUBLE) ? DEFAULTDOUBLE : DEFAULTDOUBLE; obj.OPTION_TYP = data[4]; obj.OPEN = Double.TryParse(data[5], out DEFAULTDOUBLE) ? DEFAULTDOUBLE : DEFAULTDOUBLE; obj.HIGH = Double.TryParse(data[6], out DEFAULTDOUBLE) ? DEFAULTDOUBLE : DEFAULTDOUBLE; obj.LOW = Double.TryParse(data[7], out DEFAULTDOUBLE) ? DEFAULTDOUBLE : DEFAULTDOUBLE; obj.CLOSE = Double.TryParse(data[8], out DEFAULTDOUBLE) ? DEFAULTDOUBLE : DEFAULTDOUBLE; obj.SETTLE_PR = Double.TryParse(data[9], out DEFAULTDOUBLE) ? DEFAULTDOUBLE : DEFAULTDOUBLE; obj.CONTRACTS = Double.TryParse(data[10], out DEFAULTDOUBLE) ? DEFAULTDOUBLE : DEFAULTDOUBLE; obj.VAL_INLAKH = Double.TryParse(data[11], out DEFAULTDOUBLE) ? DEFAULTDOUBLE : DEFAULTDOUBLE; obj.OPEN_INT = Double.TryParse(data[12], out DEFAULTDOUBLE) ? DEFAULTDOUBLE : DEFAULTDOUBLE; obj.CHG_IN_OI = Double.TryParse(data[13], out DEFAULTDOUBLE) ? DEFAULTDOUBLE : DEFAULTDOUBLE; obj.TIMESTAMP = DateTime.Parse(data[14]); obj.Filler1 = data[15]; masters.Add(obj); line = sr.ReadLine(); } } } catch (Exception ex) { Debug.WriteLine("Exception : " + ex.Message); } return(masters); }