protected void Create_Table() { //thead = new data_table("main", "main_id", "type", "operator", "inspect_dt", "product", "program", "result"); lbase = new data_table("lbase", "head_id", "inspect_id", "inspect", "insp_count", "samp_count", "standard_id", "standard", "bith_date", "b_operator", "seq", "base_id", "curr"); //--------VMI-------------- vmi = new data_table("vmi", "base_id", "vmi_id", "position_txt", "position", "qty", "judg_txt", "judgment"); t_vmi = new data_table("t_vmi", "base_id", "vmi_id", "position_txt", "position", "qty", "judg_txt", "judgment"); shape = new data_table("shape", "vmi_id", "shape_txt", "shape", "seq"); t_shape = new data_table("stemp", "shape_txt", "shape"); //---------------------- t_ft = new data_table("t_ft", "base_id", "ft_id", "prod_index", "insp_time"); ft = new data_table("ft", "base_id", "ft_id", "prod_index", "insp_time"); t_S5 = new data_table("t_S5", "ft_id", "test", "test_id", "ts_standard", "ts_standard_id", "ft_qty", "ft_jdug", "ft_jdug_id", "s1", "s2", "s3", "s4", "s5"); ft_S5 = new data_table("ft_S5", "ft_id", "test", "test_id", "ts_standard", "ts_standard_id", "ft_qty", "ft_jdug", "ft_jdug_id", "s1", "s2", "s3", "s4", "s5"); S5 = new data_table("S5", "ft_id", "test", "test_id", "ts_standard", "ts_standard_id", "ft_qty", "ft_jdug", "ft_jdug_id", "s1", "s2", "s3", "s4", "s5"); }
public string insertFromCsv(string fileName) { string[] strArray; string firstLine = string.Empty; Regex r = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"); StreamReader sr = new StreamReader(fileName); string headerline = sr.ReadLine(); firstLine = sr.ReadLine(); strArray = r.Split(firstLine); area newArea = new area(); measure newMeasure = new measure(); industry newIndustry = new industry(); series newSeries = new series(); newArea.areaID = strArray[2]; newArea.areaName = strArray[1]; newMeasure.measureID = strArray[4]; newMeasure.measureName = strArray[3]; newIndustry.industryID = strArray[6]; newIndustry.industryName = strArray[5]; newSeries.areaID = newArea.areaID; newSeries.measureID = newMeasure.measureID; newSeries.industryID = newIndustry.industryID; newSeries.seriesID = newArea.areaID + strArray[0]; newSeries.beginYear = "NA"; newSeries.beginPeriod = "NA"; newSeries.endYear = "NA"; newSeries.endPeriod = "NA"; newSeries.blsTable = strArray[0]; db.areas.Add(newArea); db.industries.Add(newIndustry); db.measures.Add(newMeasure); db.series.Add(newSeries); db.SaveChanges(); //start reading from 2nd line in CSV foreach (var line in File.ReadAllLines(fileName, Encoding.GetEncoding(1250)).Skip(1)) { strArray = r.Split(line); //assign split string to variables data_table newData = new data_table(); int year = Convert.ToInt32(strArray[7]); long value = Convert.ToInt64(strArray[8]); newData.seriesID = newSeries.seriesID; newData.period = "NA"; newData.year = year; newData.value = value; db.data_table.Add(newData); db.SaveChanges(); } return("Updated Database"); }