//insert Product
public int InsertProduct(EC_tb_Product ec_tb_pro, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_Product]([BarcodeID],[ShortName],[LongName],[Cost],[Price],[InventoryCount],[CategoryID],[Tax],[PathImage],[Capture],[Active],[Country],[Size_Weight]) VALUES('" +
ec_tb_pro.BarcodeID + "','" + ec_tb_pro.ShortName + "','" + ec_tb_pro.LongName + "'," + ec_tb_pro.Cost.ToString(new CultureInfo("en-US")) + "," + ec_tb_pro.Price.ToString(new CultureInfo("en-US")) + "," + ec_tb_pro.InventoryCount + "," + ec_tb_pro.CategoryID + "," +
ec_tb_pro.Tax + ",'" + ec_tb_pro.PathImage + "'," + ec_tb_pro.Capture + "," + ec_tb_pro.Active + ",'" + ec_tb_pro.Country + "','" + ec_tb_pro.SizeWeight + "')";
}
else
{
sql = "INSERT INTO [tb_Product]([BarcodeID],[ShortName],[LongName],[Cost],[Price],[InventoryCount],[CategoryID],[Tax],[PathImage],[Capture],[Active],[Country],[Size_Weight]) VALUES(N'" +
ec_tb_pro.BarcodeID + "', N'" + ec_tb_pro.ShortName + "', N'" + ec_tb_pro.LongName + "', " + ec_tb_pro.Cost.ToString(new CultureInfo("en-US")) + ", " + ec_tb_pro.Price.ToString(new CultureInfo("en-US")) + ", " + ec_tb_pro.InventoryCount + ", " + ec_tb_pro.CategoryID + "," +
ec_tb_pro.Tax + ", N'" + ec_tb_pro.PathImage + "', " + ec_tb_pro.Capture + "," + ec_tb_pro.Active + ", N'" + ec_tb_pro.Country + "', N'" + ec_tb_pro.SizeWeight + "')";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//update Product
public int UpdateProduct(EC_tb_Product ec_tb_pro, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_Product] SET [ShortName] = '" + ec_tb_pro.ShortName + "', [LongName] ='" + ec_tb_pro.LongName + "', [Cost] = " + ec_tb_pro.Cost.ToString(new CultureInfo("en-US")) + ", [Price] = " + ec_tb_pro.Price.ToString(new CultureInfo("en-US")) + ", [InventoryCount] = " + ec_tb_pro.InventoryCount +
",[CategoryID] =" + ec_tb_pro.CategoryID + ",[Tax] =" + ec_tb_pro.Tax + ",[PathImage] ='" + ec_tb_pro.PathImage + "', [Capture]=" + ec_tb_pro.Capture +
",[Active]=" + ec_tb_pro.Active + ",[BarcodeID]='" + ec_tb_pro.BarcodeID + "', [Country] = '" + ec_tb_pro.Country + "', [Size_Weight] = '" + ec_tb_pro.SizeWeight + "' WHERE ProductID = " + ec_tb_pro.ProductID;
}
else
{
sql = "UPDATE [tb_Product] SET [ShortName] = N'" + ec_tb_pro.ShortName + "', [LongName] = N'" + ec_tb_pro.LongName + "', [Cost] = " + ec_tb_pro.Cost.ToString(new CultureInfo("en-US")) + ", [Price] = " + ec_tb_pro.Price.ToString(new CultureInfo("en-US")) + ", [InventoryCount] = " + ec_tb_pro.InventoryCount +
",[CategoryID] =" + ec_tb_pro.CategoryID + ", [Tax] = " + ec_tb_pro.Tax + ",[PathImage] = N'" + ec_tb_pro.PathImage + "', [Capture]= " + ec_tb_pro.Capture +
", [Active]=" + ec_tb_pro.Active + ",[BarcodeID]= N'" + ec_tb_pro.BarcodeID + "', [Country] = N'" + ec_tb_pro.Country + "', [Size_Weight] = N'" + ec_tb_pro.SizeWeight + "' WHERE ProductID = " + ec_tb_pro.ProductID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//PayOrder
private bool PayOrder()
{
int quantity = StaticClass.GeneralClass.list_ec_tb_orderdetail_general.Count;
bool result = false;
if (quantity > 0)
{
//create Order
EC_tb_Order ec_tb_order = new EC_tb_Order();
ec_tb_order.CustomerID = StaticClass.GeneralClass.customerid_general;
ec_tb_order.CustomerName = StaticClass.GeneralClass.customername_general;
ec_tb_order.Quatity = quantity;
ec_tb_order.OrderDate = System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
ec_tb_order.SalesPersonID = StaticClass.GeneralClass.salespersonid_login_general;
ec_tb_order.SalesPersonName = StaticClass.GeneralClass.salespersonname_login_general;
this.Dispatcher.Invoke((Action)(() =>
{
ec_tb_order.PaymentID = list_ec_payment.Find(x => x.RdoCard.IsChecked.Value == true).PaymentID;
ec_tb_order.PaymentName = list_ec_payment.Find(x => x.RdoCard.IsChecked.Value == true).Card;
}));
ec_tb_order.DiscountType = StaticClass.GeneralClass.discounttype_general;
ec_tb_order.Discount = StaticClass.GeneralClass.discount_general;
ec_tb_order.TotalDiscount = StaticClass.GeneralClass.totaldiscount_general;
ec_tb_order.TotalTax = StaticClass.GeneralClass.totaltaxrate_general;
ec_tb_order.TotalAmount = total;
if (bus_tb_order.InsertOrder(ec_tb_order, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
int num_orderdetail_inserted = 0;
foreach (EC_tb_OrderDetail ec_tb_orderdetail in StaticClass.GeneralClass.list_ec_tb_orderdetail_general)
{
ec_tb_order.OrderID = bus_tb_order.GetMaxOrderID("");
ec_tb_orderdetail.OrderID = ec_tb_order.OrderID;
if (bus_tb_orderdetail.InsertOrderDetail(ec_tb_orderdetail, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
num_orderdetail_inserted++;
//update InventoryCount for Product
EC_tb_Product ec_tb_product = new EC_tb_Product();
ec_tb_product.ProductID = ec_tb_orderdetail.ProductID;
ec_tb_product.InventoryCount = ec_tb_orderdetail.Qty;
bus_tb_product.UpdateInventoryCount(ec_tb_product);
}
}
//if insert orderdetai success
if (num_orderdetail_inserted > 0)
{
result = true;
}
//if insert orderdetail failed
else
{
if (bus_tb_order.DeleteOrder(ec_tb_order) == 1)
{
result = false;
}
}
}
}
return(result);
}
private bool PayOrder()
{
int quantity = StaticClass.GeneralClass.list_ec_tb_orderdetail_general.Count;
bool result = false;
if (quantity > 0)
{
//create Order
EC_tb_Order ec_tb_order = new EC_tb_Order();
ec_tb_order.CustomerID = StaticClass.GeneralClass.customerid_general;
ec_tb_order.CustomerName = StaticClass.GeneralClass.customername_general;
ec_tb_order.Quatity = quantity;
ec_tb_order.OrderDate = System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt");
ec_tb_order.SalesPersonID = StaticClass.GeneralClass.salespersonid_login_general;
ec_tb_order.SalesPersonName = StaticClass.GeneralClass.salespersonname_login_general;
this.Dispatcher.Invoke((Action)(() =>
{
ShellOutModel shellPayMent = (ShellOutModel)lstShellOut.Items[0];
ec_tb_order.PaymentID = Convert.ToInt16(shellPayMent.PaymentId); //paymentid;
ec_tb_order.PaymentName = shellPayMent.PaymentName; //paymentname;
}));
ec_tb_order.DiscountType = StaticClass.GeneralClass.discounttype_general;
ec_tb_order.Discount = StaticClass.GeneralClass.discount_general;
ec_tb_order.TotalDiscount = StaticClass.GeneralClass.totaldiscount_general;
ec_tb_order.TotalTax = StaticClass.GeneralClass.totaltaxrate_general;
ec_tb_order.TotalAmount = total;
if (bus_tb_order.InsertOrder(ec_tb_order, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
int num_orderdetail_inserted = 0;
foreach (EC_tb_OrderDetail ec_tb_orderdetail in StaticClass.GeneralClass.list_ec_tb_orderdetail_general)
{
//ec_tb_orderdetail.ID = bus_tb_orderdetail.GetMaxID("") + 1;
ec_tb_order.OrderID = bus_tb_order.GetMaxOrderID("");
ec_tb_orderdetail.OrderID = ec_tb_order.OrderID;
if (bus_tb_orderdetail.InsertOrderDetail(ec_tb_orderdetail, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
num_orderdetail_inserted++;
//update InventoryCount for Product
EC_tb_Product ec_tb_product = new EC_tb_Product();
ec_tb_product.ProductID = ec_tb_orderdetail.ProductID;
ec_tb_product.InventoryCount = ec_tb_orderdetail.Qty;
bus_tb_product.UpdateInventoryCount(ec_tb_product);
ShellOutViewModel.eventSavePaymentOther(ec_tb_order.OrderID, null);
}
}
//if insert orderdetai success
if (num_orderdetail_inserted > 0)
{
result = true;
}
//if insert orderdetail failed
else
{
if (bus_tb_order.DeleteOrder(ec_tb_order) == 1)
{
result = false;
}
}
}
}
return(result);
}
//delete product from CategoryID
public int DeleteProductFromCategoryID(EC_tb_Product ec_tb_pro)
{
string sql = "DELETE FROM [tb_Product] WHERE [CategoryID]=" + ec_tb_pro.CategoryID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
//delete product
public int DeleteProduct(EC_tb_Product ec_tb_pro)
{
string sql = "DELETE FROM [tb_Product] WHERE ProductID=" + ec_tb_pro.ProductID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
//update InventoryCount
public int UpdateInventoryCount(EC_tb_Product ec_tb_product)
{
string sql = "Update [tb_Product] set [InventoryCount] = [InventoryCount] - " + ec_tb_product.InventoryCount + " where [ProductID] = " + ec_tb_product.ProductID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
//delete product from CategoryID
public int DeleteProductFromCategoryID(EC_tb_Product ec_tb_pro)
{
return(sql_tb_pro.DeleteProductFromCategoryID(ec_tb_pro));
}
//delete Product
public int DeleteProduct(EC_tb_Product ec_tb_pro)
{
return(sql_tb_pro.DeleteProduct(ec_tb_pro));
}
//update InventoryCount
public int UpdateInventoryCount(EC_tb_Product ec_tb_product)
{
return(sql_tb_pro.UpdateInventoryCount(ec_tb_product));
}
//update Product
public int UpdateProduct(EC_tb_Product ec_tb_pro, bool data_type)
{
return(sql_tb_pro.UpdateProduct(ec_tb_pro, data_type));
}
//insert Product
public int InsertProduct(EC_tb_Product ec_tb_pro, bool data_type)
{
return(sql_tb_pro.InsertProduct(ec_tb_pro, data_type));
}
