private void insert(int id,int i)
{
try
{
using (DataContext dc = new DataContext())
{
Product p = new Product();
int randomNumber = random.Next(1, 503);
int pid = Engine.ProductIdList[randomNumber];
var p_bd = dc.Products.Where(t => t.ProductID.Equals(pid)).FirstOrDefault();
p.Name = string.Concat("BG-", id.ToString(), "i-", i.ToString(), "id-" + id).ToString();
p.ProductLine = p_bd.ProductLine;
p.ProductModelID = p_bd.ProductModelID ;
p.ProductNumber = string.Concat("BG-", id.ToString(),"i-",i.ToString(),"id-" + id).ToString();
p.ListPrice = p_bd.ListPrice;
p.ReorderPoint = Convert.ToInt16(i);
p.StandardCost = Convert.ToInt16(i);
p.StandardCost = Convert.ToDecimal(1.23 * id * i);
p.DaysToManufacture = i+1;
p.SellEndDate = null;
p.DiscontinuedDate = null;
p.SellStartDate = System.DateTime.Now;
p.ModifiedDate = System.DateTime.Now;
p.ProductSubcategoryID = p_bd.ProductSubcategoryID;
p.ReorderPoint = p_bd.ReorderPoint;
p.Style = p_bd.Style;
p.Size = p_bd.Size;
p.SizeUnitMeasureCode = p_bd.SizeUnitMeasureCode;
p.Weight = p_bd.Weight;
p.rowguid = Guid.NewGuid();
p.SafetyStockLevel = p_bd.SafetyStockLevel;
dc.Products.InsertOnSubmit(p);
dc.SubmitChanges();
}
}
catch (Exception ex)
{
_Timer.Stop();
this.Stop();
return;
}
}
partial void DeleteProduct(Product instance);
partial void UpdateProduct(Product instance);
partial void InsertProduct(Product instance);
