public static bool InsertIntoProduct(ProductCouponTable product)
{
var db = GetDbInstance();
var pd = new Product()
{
ProductID = DateTime.Now.ToString("yyyyMMddhhmmss"),
Shelf = product.Shelf,
ProductName = product.ProductName,
Price = product.Price
};
db.Product.InsertOnSubmit(pd);
try
{
db.SubmitChanges();
}
catch (Exception error)
{
return(false);
}
var Coupons = product.PCoupon.Split('\n');
for (int i = 0; i < Coupons.Length; i++)
{
if (Coupons[i].Length > 10)
{
var cp = new Coupon()
{
ProductID = DateTime.Now.ToString("yyyyMMddhhmmss"),
CouponID = DateTime.Now.ToString("yyyyMMddhhmmss") + "-" + i,
Discount = product.Discount,
EndTime = product.EndTime,
StartTime = product.StartTime,
PCoupon = Coupons[i],
Valid = product.Valid
};
db.Coupon.InsertOnSubmit(cp);
}
}
try
{
db.SubmitChanges();
}
catch (Exception error)
{
return(false);
}
return(true);
}
public bool PostProductInfo(ProductCouponTable product)
{
var result = CouponDB.InsertIntoProduct(product);
if (result)
{
return(true);
}
else
{
return(false);
}
}
