protected void InsertProduct(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtProductNumber.Text))
{
decimal wholesalePrice = 0.0m;
decimal retailPrice = 0.0m;
decimal.TryParse(txtWholesalePrice.Text, out wholesalePrice);
decimal.TryParse(txtRetailPrice.Text, out retailPrice);
int quantity = 0;
int.TryParse(txtQuantity.Text, out quantity);
int category = 0;
int.TryParse(ddlCategory.SelectedValue, out category);
Product product = new Product()
{
ProductNumber = txtProductNumber.Text,
Category = category,
Description = txtDescription.Text,
WholesalePrice = wholesalePrice,
RetailPrice = retailPrice,
Quantity = quantity,
Active = chkActive.Checked
};
Product.Insert(product);
ClearForm();
LoadProducts();
}
}
public static DataSet GetPriceHistory(Product item)
{
return DB.ExecuteStoredProcedure("sp_Product_GetPriceHistory"
, new SqlParameter("ProductNumber", item.ProductNumber)
);
}
public static void Update(Product item)
{
try
{
using (var ctx = new tIMSdbEntities())
{
// update product
var product = ctx.Products.First(i => i.ProductNumber == item.ProductNumber);
product.Description = item.Description;
product.Active = item.Active;
product.Category = item.Category;
// insert new price
var price = new Prices
{
ProductNumber = item.ProductNumber,
Wholesale = item.WholesalePrice,
Retail = item.RetailPrice,
Datetime = DateTime.Now
};
ctx.AddToPrices(price);
// insert new quantity
var quantity = new Quantities
{
ProductNumber = item.ProductNumber,
Count = item.Quantity,
Datetime = DateTime.Now
};
ctx.Quantities.AddObject(quantity);
ctx.SaveChanges();
}
}
catch(Exception ex)
{
}
}
public static void Insert(Product item)
{
try
{
DB.ExecuteStoredProcedure("sp_Product_Insert"
, new SqlParameter("ProductNumber", item.ProductNumber)
, new SqlParameter("Category", item.Category)
, new SqlParameter("Active", item.Active)
, new SqlParameter("WholesalePrice", item.WholesalePrice)
, new SqlParameter("RetailPrice", item.RetailPrice)
, new SqlParameter("Description", item.Description)
, new SqlParameter("Quantity", item.Quantity)
);
}
catch (Exception ex)
{
string e = ex.ToString();
}
}
