//InSertAllOrderDetail
private int InSertAllOrderDetail(DataTable tb_orderdetail)
{
int result = 0;
foreach (DataRow datarow in tb_orderdetail.Rows)
{
if (datarow[0].ToString() != "")
{
EC_tb_OrderDetail ec_tb_orderdetail = new EC_tb_OrderDetail();
ec_tb_orderdetail.ID = Convert.ToInt32(datarow[0].ToString());
ec_tb_orderdetail.CategoryID = Convert.ToInt32(datarow[1].ToString());
ec_tb_orderdetail.CategoryName = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[2].ToString());
ec_tb_orderdetail.ProductID = Convert.ToInt32(datarow[3].ToString());
ec_tb_orderdetail.ProductName = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[4].ToString());
ec_tb_orderdetail.Cost = Convert.ToDecimal(datarow[5].ToString());
ec_tb_orderdetail.Price = Convert.ToDecimal(datarow[6].ToString());
ec_tb_orderdetail.Qty = Convert.ToInt32(datarow[7].ToString());
ec_tb_orderdetail.Tax = Convert.ToDecimal(datarow[8].ToString());
ec_tb_orderdetail.DiscountType = Convert.ToInt32(datarow[9].ToString());
ec_tb_orderdetail.Discount = Convert.ToDecimal(datarow[10].ToString());
ec_tb_orderdetail.TotalDiscount = Convert.ToDecimal(datarow[11].ToString());
ec_tb_orderdetail.Total = Convert.ToDecimal(datarow[12].ToString());
ec_tb_orderdetail.OrderID = Convert.ToInt32(datarow[13].ToString());
if (bus_tb_orderdetail.InsertOrderDetail(ec_tb_orderdetail, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
result++;
}
}
}
return(result);
}
//update OrderDetail
public int UpdateOrderDetail(EC_tb_OrderDetail ec_tb_od, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_OrderDetail] SET [CategoryID] = " + ec_tb_od.CategoryID + ",[CategoryName]='" + ec_tb_od.CategoryName + "',[ProductID] = " + ec_tb_od.ProductID + ",[ProductName]='" + ec_tb_od.ProductName + "', [Cost] = " + ec_tb_od.Cost.ToString(new CultureInfo("en-US")) + ", [Price] = " + ec_tb_od.Price.ToString(new CultureInfo("en-US")) +
",[Qty] =" + ec_tb_od.Qty + ",[Tax] =" + ec_tb_od.Tax.ToString(new CultureInfo("en-US")) + ",[Discount] =" + ec_tb_od.Discount.ToString(new CultureInfo("en-US")) + ",[TotalDiscount]=" + ec_tb_od.TotalDiscount.ToString(new CultureInfo("en-US")) + ",[Total] =" + ec_tb_od.Total.ToString(new CultureInfo("en-US")) + ",[OrderID] =" + ec_tb_od.OrderID + " WHERE [ID]=" + ec_tb_od.ID;
}
else
{
sql = "UPDATE [tb_OrderDetail] SET [CategoryID] = " + ec_tb_od.CategoryID + ",[CategoryName]= N'" + ec_tb_od.CategoryName + "',[ProductID] = " + ec_tb_od.ProductID + ",[ProductName]= N'" + ec_tb_od.ProductName + "', [Cost] = " + ec_tb_od.Cost.ToString(new CultureInfo("en-US")) + ", [Price] = " + ec_tb_od.Price.ToString(new CultureInfo("en-US")) +
",[Qty] =" + ec_tb_od.Qty + ",[Tax] =" + ec_tb_od.Tax.ToString(new CultureInfo("en-US")) + ",[Discount] =" + ec_tb_od.Discount.ToString(new CultureInfo("en-US")) + ",[TotalDiscount]=" + ec_tb_od.TotalDiscount.ToString(new CultureInfo("en-US")) + ",[Total] =" + ec_tb_od.Total.ToString(new CultureInfo("en-US")) + ",[OrderID] =" + ec_tb_od.OrderID + " WHERE [ID]=" + ec_tb_od.ID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert OrderDetail
public int InsertOrderDetail(EC_tb_OrderDetail ec_tb_od, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_OrderDetail]([CategoryID],[CategoryName],[ProductID],[ProductName],[Cost],[Price],[Qty],[Tax],[DiscountType],[Discount],[TotalDiscount],[Total],[OrderID]) VALUES(" +
ec_tb_od.CategoryID + ",'" + ec_tb_od.CategoryName + "'," + ec_tb_od.ProductID + ",'" + ec_tb_od.ProductName + "'," + ec_tb_od.Cost.ToString(new CultureInfo("en-US")) + ", " + ec_tb_od.Price.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.Qty + "," + ec_tb_od.Tax.ToString(new CultureInfo("en-US")) +
"," + ec_tb_od.DiscountType + "," + ec_tb_od.Discount.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.TotalDiscount.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.Total.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.OrderID + ")";
}
else
{
sql = "INSERT INTO [tb_OrderDetail]([CategoryID],[CategoryName],[ProductID],[ProductName],[Cost],[Price],[Qty],[Tax],[DiscountType],[Discount],[TotalDiscount],[Total],[OrderID]) VALUES(" +
ec_tb_od.CategoryID + ", N'" + ec_tb_od.CategoryName + "', " + ec_tb_od.ProductID + ", N'" + ec_tb_od.ProductName + "', " + ec_tb_od.Cost.ToString(new CultureInfo("en-US")) + ", " + ec_tb_od.Price.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.Qty + "," + ec_tb_od.Tax.ToString(new CultureInfo("en-US")) +
"," + ec_tb_od.DiscountType + "," + ec_tb_od.Discount.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.TotalDiscount.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.Total.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.OrderID + ")";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
private List <EC_tb_OrderDetail> GetOrderDetail(int orderid)
{
try
{
list_ec_tb_orderdetail.Clear();
dtgOrderDetail.Items.Refresh();
dt_tb_orderdetail.Clear();
int no = 0;
dt_tb_orderdetail = bus_tb_orderdetail.GetOrderDetail("WHERE OrderID = " + orderid);
foreach (DataRow datarow in dt_tb_orderdetail.Rows)
{
no++;
EC_tb_OrderDetail ec_tb_orderdetail = new EC_tb_OrderDetail();
ec_tb_orderdetail.No = no;
ec_tb_orderdetail.OrderID = Convert.ToInt32(datarow["OrderID"].ToString());
ec_tb_orderdetail.CategoryID = Convert.ToInt32(datarow["CategoryID"].ToString());
ec_tb_orderdetail.CategoryName = datarow["CategoryName"].ToString().Trim();
ec_tb_orderdetail.ProductID = Convert.ToInt32(datarow["ProductID"].ToString());
ec_tb_orderdetail.ProductName = datarow["ProductName"].ToString().Trim();
ec_tb_orderdetail.Cost = Convert.ToDecimal(datarow["Cost"].ToString());
ec_tb_orderdetail.StrCost = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(ec_tb_orderdetail.Cost);
ec_tb_orderdetail.Price = Convert.ToDecimal(datarow["Price"].ToString());
ec_tb_orderdetail.StrPrice = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(ec_tb_orderdetail.Price);
ec_tb_orderdetail.Qty = Convert.ToInt32(datarow["Qty"].ToString());
ec_tb_orderdetail.Tax = Convert.ToDecimal(datarow["Tax"].ToString());
ec_tb_orderdetail.StrTax = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(ec_tb_orderdetail.Tax);
ec_tb_orderdetail.DiscountType = Convert.ToInt32(datarow["DiscountType"].ToString());
if (ec_tb_orderdetail.DiscountType == 1)
{
ec_tb_orderdetail.DisAmount = "";
ec_tb_orderdetail.DisPercent = "%";
}
else
{
ec_tb_orderdetail.DisAmount = StaticClass.GeneralClass.currency_setting_general;
ec_tb_orderdetail.DisPercent = "";
}
ec_tb_orderdetail.Discount = Convert.ToDecimal(datarow["Discount"].ToString());
ec_tb_orderdetail.StrDiscount = StaticClass.GeneralClass.GetNumFormatDisplay(ec_tb_orderdetail.Discount);
ec_tb_orderdetail.TotalDiscount = Convert.ToDecimal(string.IsNullOrEmpty(datarow["TotalDiscount"].ToString()) ? "0" : datarow["TotalDiscount"].ToString());
ec_tb_orderdetail.StrTotalDiscount = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(ec_tb_orderdetail.TotalDiscount);
ec_tb_orderdetail.Total = Convert.ToDecimal(datarow["Total"].ToString()) + Convert.ToDecimal(datarow["Tax"].ToString());
ec_tb_orderdetail.StrTotal = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(ec_tb_orderdetail.Total);
ec_tb_orderdetail.CheckDel = false;
ec_tb_orderdetail.Currency = StaticClass.GeneralClass.currency_setting_general;
list_ec_tb_orderdetail.Add(ec_tb_orderdetail);
}
tblTotal.Text = FindResource("total").ToString() + "(" + list_ec_tb_orderdetail.Count.ToString() + ")";
dtgOrderDetail.Items.Refresh();
}
catch (Exception ex)
{
Pages.Notification page = new Pages.Notification();
page.tblNotification.Text = ex.Message;
page.ShowDialog();
}
return(list_ec_tb_orderdetail);
}
//muiBtnOK_Click
private void muiBtnOK_Click(object sender, RoutedEventArgs e)
{
if (StaticClass.GeneralClass.list_ec_tb_orderdetail_general.Count == 0)
{
tblNotification.Text = FindResource("select_least_order_detail").ToString();
return;
}
else
{
try
{
int orderdetail_qty_root = bus_tb_orderdetail.GetOrderDetail("WHERE [OrderID] = " + StaticClass.GeneralClass.orderdetailid_general).Rows.Count;
int result = 0;
for (int i = 0; i < StaticClass.GeneralClass.list_ec_tb_orderdetail_general.Count; i++)
{
EC_tb_OrderDetail ec_tb_orderdetail = new EC_tb_OrderDetail();
ec_tb_orderdetail.OrderID = StaticClass.GeneralClass.list_ec_tb_orderdetail_general[i].OrderID;
ec_tb_orderdetail.ProductID = StaticClass.GeneralClass.list_ec_tb_orderdetail_general[i].ProductID;
//ec_tb_orderdetail.InputID = StaticClass.GeneralClass.list_ec_tb_orderdetail_general[i].InputID;
if (bus_tb_orderdetail.DeleteOrderDetail(ec_tb_orderdetail) == 1)
{
result++;
}
}
if (result == orderdetail_qty_root)
{
EC_tb_Order ec_tb_order = new EC_tb_Order();
ec_tb_order.OrderID = StaticClass.GeneralClass.orderdetailid_general;
if (bus_tb_order.DeleteOrder(ec_tb_order) == 1)
{
}
else
{
tblNotification.Text = FindResource("cannot_delete_order").ToString();
return;
}
}
//update table order
if ((result > 0) && (result < orderdetail_qty_root))
{
DataTable dt_tb_order = bus_tb_order.GetOrder("WHERE [OrderID] = " + StaticClass.GeneralClass.orderdetailid_general);
DataTable dt_tb_orderdetail = bus_tb_orderdetail.GetOrderDetail("WHERE [OrderID] = " + StaticClass.GeneralClass.orderdetailid_general);
int quantity = 0;
decimal total_tax = 0;
decimal total = 0;
decimal total_discount = 0;
decimal total_amount = 0;
foreach (DataRow datarow in dt_tb_orderdetail.Rows)
{
quantity += Convert.ToInt32(datarow["Qty"].ToString());
total_tax += Convert.ToDecimal(datarow["Tax"].ToString());
total += Convert.ToDecimal(datarow["Total"].ToString());
}
if (Convert.ToInt32(dt_tb_order.Rows[0]["DiscountType"].ToString()) == 1)
{
total_discount = Convert.ToDecimal(dt_tb_order.Rows[0]["Discount"].ToString()) * total / 100;
}
else
{
total_discount = Convert.ToDecimal(dt_tb_order.Rows[0]["Discount"].ToString());
}
total_amount = total - total_discount + total_tax;
EC_tb_Order ec_tb_order = new EC_tb_Order();
ec_tb_order.OrderID = Convert.ToInt32(dt_tb_order.Rows[0]["OrderID"].ToString());
ec_tb_order.CustomerID = Convert.ToInt32(dt_tb_order.Rows[0]["CustomerID"].ToString());
ec_tb_order.CustomerName = dt_tb_order.Rows[0]["CustomerName"].ToString();
ec_tb_order.Quatity = quantity;
ec_tb_order.OrderDate = dt_tb_order.Rows[0]["OrderDate"].ToString();
ec_tb_order.SalesPersonID = Convert.ToInt32(dt_tb_order.Rows[0]["SalespersonID"].ToString());
ec_tb_order.SalesPersonName = dt_tb_order.Rows[0]["SalespersonName"].ToString();
ec_tb_order.PaymentID = Convert.ToInt32(dt_tb_order.Rows[0]["PaymentID"].ToString());
ec_tb_order.PaymentName = dt_tb_order.Rows[0]["PaymentName"].ToString();
ec_tb_order.DiscountType = Convert.ToInt32(dt_tb_order.Rows[0]["DiscountType"].ToString());
ec_tb_order.Discount = Convert.ToDecimal(dt_tb_order.Rows[0]["Discount"].ToString());
ec_tb_order.TotalDiscount = total_discount;
ec_tb_order.TotalTax = total_tax;
ec_tb_order.TotalAmount = total_amount;
bus_tb_order.UpdateOrder(ec_tb_order, StaticClass.GeneralClass.flag_database_type_general);
}
if (btndelete_delegate != null)
{
StaticClass.GeneralClass.flag_check_delete_order_orderdetail = true;
StaticClass.GeneralClass.list_ec_tb_orderdetail_general.Clear();
btndelete_delegate(true);
this.Close();
}
}
catch (Exception ex)
{
tblNotification.Text = ex.Message;
}
}
}
//delete OrderDetail
public int DeleteOrderDetail(EC_tb_OrderDetail ec_tb_od)
{
return(sql_tb_od.DeleteOrderDetail(ec_tb_od));
}
//update OrderDetail
public int UpdateOrderDetail(EC_tb_OrderDetail ec_tb_od, bool data_type)
{
return(sql_tb_od.UpdateOrderDetail(ec_tb_od, data_type));
}
//insert OrderDetail
public int InsertOrderDetail(EC_tb_OrderDetail ec_tb_od, bool data_type)
{
return(sql_tb_od.InsertOrderDetail(ec_tb_od, data_type));
}
//delete OrderDetail
public int DeleteOrderDetail(EC_tb_OrderDetail ec_tb_od)
{
string sql = "DELETE FROM [tb_OrderDetail] WHERE [OrderID]=" + ec_tb_od.OrderID + " AND [ProductID] = " + ec_tb_od.ProductID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
