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");
}
