private static void AddAirsToSql(List <AirCompany> Tmp) { String SQLPL = @"Data Source=192.168.222.116\SQLEXPRESS;Initial Catalog=CFCStandaloneDB;User ID=manager;Password=manager "; //string pStr = @"TERM1\SQLEXPRESS"; var db = new CFCdbDataContext(SQLPL); foreach (AirCompany d in Tmp.Where(a => a.Id > 3)) { Tender oldtndr = db.Tender.FirstOrDefault(a => a.Number == 101); Tender tndr = new Tender(); foreach (PropertyInfo PI in tndr.GetType().GetProperties()) { object val = tndr.GetType().GetProperty(PI.Name).GetValue(oldtndr); tndr.GetType().GetProperty(PI.Name).SetValue(tndr, val); } tndr.Id = Guid.NewGuid(); tndr.Number = (int)d.Id + 100; tndr.Name = d.Name.Substring(0, Math.Min(d.Name.Length, 9)); db.Tender.InsertOnSubmit(tndr); db.SubmitChanges(); //tndr.FK_ReportAsTender = tndr.Id; //db.SubmitChanges(); } }
public static void AddToSql(List <Dish> Tmp) { String SQLPL = @"Data Source=192.168.0.101\SQLEXPRESS;Initial Catalog=CFCStandaloneDB;User ID=manager;Password=manager "; //string pStr = @"TERM1\SQLEXPRESS"; var db = new CFCdbDataContext(SQLPL); foreach (Dish d in Tmp) { Category cat = db.Category.Where(a => a.Number == 2).First(); /* * Category SaleCat = GetCat(d.SaleCat); * if (SaleCat == null) * { * MessageBox.Show("Error SaleCat" + d.Id); * } * Category GenCat = GetCat(d.GeneralCat); * if (GenCat == null) * { * MessageBox.Show("Error GenCat" + d.Id); * } */ Item OldIt = db.Item.Where(a => a.Number == 1).First(); Item it = new Item(); foreach (PropertyInfo PI in it.GetType().GetProperties()) { /* * if (PI.Name == "FK_SalesCategory") * { * continue; * } * if (PI.Name == "Category") * { * continue; * } * if (PI.Name == "CategoryItem") * { * continue; * } */ object val = it.GetType().GetProperty(PI.Name).GetValue(OldIt); it.GetType().GetProperty(PI.Name).SetValue(it, val); } it.Id = Guid.NewGuid(); it.Number = (int)d.Barcode; it.DefaultPrice = 0; d.Name = d.Name.Substring(4); if (d.Name.Length > 25) { d.Name = d.Name.Substring(0, 25); } it.LongName = d.Name; it.ShortName = d.Name.Substring(0, Math.Min(d.Name.Length, 14)); //it.FK_SalesCategory = SaleCat.Id; it.ChitName = d.Name.Substring(0, Math.Min(d.Name.Length, 14)); if (d.EnglishName.Length > 25) { d.EnglishName = d.EnglishName.Substring(0, 25); } it.LongNameAlternate = d.EnglishName; db.Item.InsertOnSubmit(it); db.SubmitChanges(); /* * CategoryItem CI = new CategoryItem(); * CI.Id = Guid.NewGuid(); * //CI.Item = it; * //CI.Category = GenCat; * CI.FK_CategoryId = GenCat.Id; * CI.FK_ItemId = it.Id; * CI.FK_Owner = OldIt.FK_Owner; * * * db.CategoryItem.InsertOnSubmit(CI); * db.SubmitChanges(); */ } }