private void init_fitment()
{
fitment = new Fitment();
Make make = new Make();
string[] values = lines[i].Split('|');
for (int j = 0; j < values.Count(); j++)
{
if (headers[j] == "Make")
{
make.make1 = values[j];
}
else if (headers[j] == "Model")
{
make.model = values[j];
}
else if (headers[j] == "ourMake")
{
make.our_make = values[j];
}
else if (headers[j] == "ourMake")
{
make.our_make = values[j];
}
else if (headers[j] == "ourModel")
{
make.our_model = values[j];
}
else if (headers[j] == "_BodyTypeName_")
{
make.body_type_name = values[j];
}
else if (headers[j] == "_MfrBodyCodeName_")
{
make.mf_body_code_name = values[j];
}
else if (headers[j] == "ourBodyTypeName")
{
make.our_body_type_name = values[j];
}
else
{
try
{
fitment.init_fitment(headers[j], values[j]);
}
catch { }
}
}
using (var db = new ProductDBEntitie())
{
try
{
var make_ = (from c in db.Make
where c.make1 == make.make1 && c.model == make.model && c.our_make == make.our_make && c.body_type_name == make.body_type_name
select c).ToList();
if (make_.Count() == 0)
{
db.Make.Add(make);
db.SaveChanges();
fitment.id_make = make.id;
fitment.Make = make;
}
else
{
fitment.id_make = make_.First().id;
fitment.Make = make_.First();
}
}
catch { }
fitment.Product = (from c in db.Product where c.sku == fitment.sku select c).FirstOrDefault();
try
{
BrandName brand = fitment.BrandName;
fitment.BrandName = null;
Make m = fitment.Make;
fitment.Make = null;
db.Fitment.Add(fitment);
db.SaveChanges();
fitment.Make = m;
fitment.BrandName = brand;
}
catch (Exception e) {
}
}
}
