//InSertAllOrderDetail private int InSertAllOrder(DataTable tb_order) { int result = 0; foreach (DataRow datarow in tb_order.Rows) { if (datarow[0].ToString() != "") { EC_tb_Order ec_tb_order = new EC_tb_Order(); ec_tb_order.OrderID = Convert.ToInt32(datarow[0].ToString()); ec_tb_order.CustomerID = Convert.ToInt32(datarow[1].ToString()); ec_tb_order.CustomerName = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[2].ToString()); ec_tb_order.Quatity = Convert.ToInt32(datarow[3].ToString()); ec_tb_order.OrderDate = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[4].ToString()); ec_tb_order.SalesPersonID = Convert.ToInt32(datarow[5].ToString()); ec_tb_order.SalesPersonName = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[6].ToString()); ec_tb_order.PaymentID = Convert.ToInt32(datarow[7].ToString()); ec_tb_order.PaymentName = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[8].ToString()); ec_tb_order.DiscountType = Convert.ToInt32(datarow[9].ToString()); ec_tb_order.Discount = Convert.ToDecimal(datarow[10].ToString()); ec_tb_order.TotalDiscount = Convert.ToDecimal(datarow[11].ToString()); ec_tb_order.TotalTax = Convert.ToDecimal(datarow[12].ToString()); ec_tb_order.TotalAmount = Convert.ToDecimal(datarow[13].ToString()); if (bus_tb_order.InsertOrder(ec_tb_order, StaticClass.GeneralClass.flag_database_type_general) == 1) { result++; } } } return(result); }
//muiBtnOK_Click private void muiBtnOK_Click(object sender, RoutedEventArgs e) { if (StaticClass.GeneralClass.list_ec_tb_order_general.Count == 0) { tblNotification.Text = FindResource("select_least_order").ToString(); } else { if (thread_delete != null && thread_delete.ThreadState == ThreadState.Running) { } else { thread_delete = new Thread(() => { try { int result_order = 0; int result_orderdetail = 0; for (int i = 0; i < StaticClass.GeneralClass.list_ec_tb_order_general.Count; i++) { EC_tb_Order ec_tb_order = new EC_tb_Order(); ec_tb_order.OrderID = StaticClass.GeneralClass.list_ec_tb_order_general[i].OrderID; if (bus_tb_order.DeleteOrder(ec_tb_order) == 1) { result_order++; if (bus_tb_orderdetail.DeleteAllOrderDetail("WHERE [OrderID]=" + StaticClass.GeneralClass.list_ec_tb_order_general[i].OrderID) > 0) { result_orderdetail++; } } } if (result_order == result_orderdetail) { StaticClass.GeneralClass.flag_check_delete_order_orderdetail = true; StaticClass.GeneralClass.list_ec_tb_order_general.Clear(); if (btndelete_delegate != null) { btndelete_delegate(true); this.Dispatcher.Invoke((Action)(() => { this.Close(); })); } } else { this.tblNotification.Dispatcher.Invoke((Action)(() => { this.tblNotification.Text = FindResource("error_delete").ToString(); })); } } catch (Exception ex) { this.tblNotification.Dispatcher.Invoke((Action)(() => { this.tblNotification.Text = ex.Message; })); } }); thread_delete.Start(); } } }
//updater Order public int UpdateOrder(EC_tb_Order ec_tb_ord, bool data_type) { string sql = ""; if (!data_type) { sql = "UPDATE [tb_Order] SET [CustomerID] = " + ec_tb_ord.CustomerID + ", [CustomerName] = '" + ec_tb_ord.CustomerName + "',[Quantity] =" + ec_tb_ord.Quatity + ",[OrderDate] ='" + ec_tb_ord.OrderDate + "', [SalespersonID] = " + ec_tb_ord.SalesPersonID + ", [SalespersonName] ='" + ec_tb_ord.SalesPersonName + "', [PaymentID] = " + ec_tb_ord.PaymentID + ", [PaymentName] = '" + ec_tb_ord.PaymentName + "',[DiscountType]=" + ec_tb_ord.DiscountType + ",[Discount] = " + ec_tb_ord.Discount.ToString(new CultureInfo("en-US")) + ",[TotalDiscount]=" + ec_tb_ord.TotalDiscount.ToString(new CultureInfo("en-US")) + ",[TotalTax] = " + ec_tb_ord.TotalTax.ToString(new CultureInfo("en-US")) + ",[TotalAmount] = " + ec_tb_ord.TotalAmount.ToString(new CultureInfo("en-US")) + " WHERE [OrderID] = " + ec_tb_ord.OrderID; } else { sql = "UPDATE [tb_Order] SET [CustomerID] = " + ec_tb_ord.CustomerID + ", [CustomerName] = N'" + ec_tb_ord.CustomerName + "', [Quantity] = " + ec_tb_ord.Quatity + ", [OrderDate] = N'" + ec_tb_ord.OrderDate + "', [SalespersonID] = " + ec_tb_ord.SalesPersonID + ", [SalespersonName] = N'" + ec_tb_ord.SalesPersonName + "', [PaymentID] = " + ec_tb_ord.PaymentID + ", [PaymentName] = N'" + ec_tb_ord.PaymentName + "', [DiscountType] = " + ec_tb_ord.DiscountType + ", [Discount] = " + ec_tb_ord.Discount.ToString(new CultureInfo("en-US")) + ", [TotalDiscount] = " + ec_tb_ord.TotalDiscount.ToString(new CultureInfo("en-US")) + ", [TotalTax] = " + ec_tb_ord.TotalTax.ToString(new CultureInfo("en-US")) + ",[TotalAmount] = " + ec_tb_ord.TotalAmount.ToString(new CultureInfo("en-US")) + " WHERE [OrderID] = " + ec_tb_ord.OrderID; } return(ConnectionDB.ExecuteNonQuery(sql)); }
//insert Order public int InsertOrder(EC_tb_Order ec_tb_ord, bool data_type) { string sql = ""; if (!data_type) { sql = "INSERT INTO [tb_Order]([CustomerID],[CustomerName],[Quantity],[OrderDate],[SalespersonID],[SalespersonName],[PaymentID],[PaymentName],[DiscountType],[Discount],[TotalDiscount],[TotalTax],[TotalAmount]) VALUES(" + ec_tb_ord.CustomerID + ",'" + ec_tb_ord.CustomerName + "'," + ec_tb_ord.Quatity + ",'" + ec_tb_ord.OrderDate + "'," + ec_tb_ord.SalesPersonID + ",'" + ec_tb_ord.SalesPersonName + "'," + ec_tb_ord.PaymentID + ",'" + ec_tb_ord.PaymentName + "'," + ec_tb_ord.DiscountType + "," + ec_tb_ord.Discount.ToString(new CultureInfo("en-US")) + "," + ec_tb_ord.TotalDiscount.ToString(new CultureInfo("en-US")) + "," + ec_tb_ord.TotalTax.ToString(new CultureInfo("en-US")) + "," + ec_tb_ord.TotalAmount.ToString(new CultureInfo("en-US")) + ")"; } else { sql = "INSERT INTO [tb_Order]([CustomerID],[CustomerName],[Quantity],[OrderDate],[SalespersonID],[SalespersonName],[PaymentID],[PaymentName],[DiscountType],[Discount],[TotalDiscount],[TotalTax],[TotalAmount]) VALUES(" + ec_tb_ord.CustomerID + ", N'" + ec_tb_ord.CustomerName + "', " + ec_tb_ord.Quatity + ", N'" + ec_tb_ord.OrderDate + "', " + ec_tb_ord.SalesPersonID + ", N'" + ec_tb_ord.SalesPersonName + "', " + ec_tb_ord.PaymentID + ", N'" + ec_tb_ord.PaymentName + "', " + ec_tb_ord.DiscountType + ", " + ec_tb_ord.Discount.ToString(new CultureInfo("en-US")) + ", " + ec_tb_ord.TotalDiscount.ToString(new CultureInfo("en-US")) + ", " + ec_tb_ord.TotalTax.ToString(new CultureInfo("en-US")) + "," + ec_tb_ord.TotalAmount.ToString(new CultureInfo("en-US")) + ")"; } 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 void GetOrders(int be_limit, int af_limit, string _con1, string _con2) { if (thread_order != null && thread_order.ThreadState == ThreadState.Running) { } else { thread_order = new Thread(() => { try { list_ec_tb_order.Clear(); this.Dispatcher.Invoke((Action)(() => { this.chkAll.IsChecked = false; this.mpr.Visibility = System.Windows.Visibility.Visible; this.mpr.IsActive = true; this.dtgOrders.Visibility = System.Windows.Visibility.Hidden; dtgOrders.Items.Refresh(); })); dt_orders.Clear(); int no = paging_number_previous - 1; using (dt_orders = bus_tb_order.GetOrderFollowPaging(be_limit, af_limit, _con1, _con2, StaticClass.GeneralClass.flag_database_type_general)) { foreach (DataRow dr in dt_orders.Rows) { _orderDate = string.Format(@"{0:" + StaticClass.GeneralClass.dateFromatSettings[StaticClass.GeneralClass.app_settings["dateFormat"]].ToString() + _orderTime + "}", Convert.ToDateTime(dr["OrderDate"].ToString())); no++; EC_tb_Order ec_tb_order = new EC_tb_Order(); ec_tb_order.No = no; ec_tb_order.OrderID = Convert.ToInt32(dr["OrderID"].ToString()); ec_tb_order.CustomerID = Convert.ToInt32(dr["CustomerID"].ToString()); ec_tb_order.CustomerName = dr["CustomerName"].ToString(); ec_tb_order.Quatity = Convert.ToInt32(dr["Quantity"].ToString()); ec_tb_order.OrderDate = _orderDate; //dr["OrderDate"].ToString(); ec_tb_order.SalesPersonID = Convert.ToInt32(dr["SalespersonID"].ToString()); ec_tb_order.SalesPersonName = dr["SalespersonName"].ToString(); ec_tb_order.PaymentID = Convert.ToInt32(dr["PaymentID"].ToString()); ec_tb_order.PaymentName = dr["PaymentName"].ToString(); ec_tb_order.DiscountType = Convert.ToInt32(dr["DiscountType"].ToString()); if (ec_tb_order.DiscountType == 1) { ec_tb_order.DisAmount = ""; ec_tb_order.DisPercent = "%"; } else { ec_tb_order.DisAmount = StaticClass.GeneralClass.currency_setting_general; ec_tb_order.DisPercent = ""; } ec_tb_order.Discount = Convert.ToDecimal(dr["Discount"].ToString()); ec_tb_order.StrDiscount = StaticClass.GeneralClass.GetNumFormatDisplay(ec_tb_order.Discount); ec_tb_order.TotalDiscount = Convert.ToDecimal(string.IsNullOrEmpty(dr["TotalDiscount"].ToString()) ? "0" : dr["TotalDiscount"].ToString()); ec_tb_order.StrTotalDiscount = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(ec_tb_order.TotalDiscount); ec_tb_order.TotalTax = Convert.ToDecimal(dr["TotalTax"].ToString()); ec_tb_order.StrTotalTax = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(ec_tb_order.TotalTax); ec_tb_order.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString()); ec_tb_order.StrTotalAmount = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(ec_tb_order.TotalAmount); ec_tb_order.ImageSource = @"pack://application:,,,/Resources/ViewDetails.png"; ec_tb_order.CheckDel = false; ec_tb_order.Currency = StaticClass.GeneralClass.currency_setting_general; list_ec_tb_order.Add(ec_tb_order); } } this.Dispatcher.Invoke((Action)(() => { tblTotal.Text = FindResource("total").ToString() + "(" + list_ec_tb_order.Count.ToString() + ")"; dtgOrders.Items.Refresh(); })); Thread.Sleep(500); this.Dispatcher.Invoke((Action)(() => { this.mpr.Visibility = System.Windows.Visibility.Hidden; this.mpr.IsActive = false; this.dtgOrders.Visibility = System.Windows.Visibility.Visible; })); //data statistic DataStatistic(); //set condition report order if (StaticClass.GeneralClass.flag_database_type_general == false) { StaticClass.GeneralClass.condition_report_order = "select * from [tb_Order] " + _con1 + " limit " + be_limit + ", " + af_limit; } else { StaticClass.GeneralClass.condition_report_order = "select top(" + af_limit + ") * from [tb_Order] where [OrderID] not in (select top(" + be_limit + ") [OrderID] from [tb_Order] " + _con1 + ") " + _con2; } } catch (Exception ex) { this.Dispatcher.Invoke((Action)(() => { ModernDialog md = new ModernDialog(); md.CloseButton.Content = FindResource("close").ToString(); md.Title = FindResource("notification").ToString(); md.Content = ex.Message; md.ShowDialog(); })); } }); thread_order.Start(); } }
//delete Order public int DeleteOrder(EC_tb_Order ec_tb_ord) { string sql = "DELETE FROM [tb_Order] WHERE [OrderID]=" + ec_tb_ord.OrderID; return(ConnectionDB.ExecuteNonQuery(sql)); }
//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; } } }
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 Order public int DeleteOrder(EC_tb_Order ec_tb_ord) { return(sql_tb_ord.DeleteOrder(ec_tb_ord)); }
//update Order public int UpdateOrder(EC_tb_Order ec_tb_ord, bool data_type) { return(sql_tb_ord.UpdateOrder(ec_tb_ord, data_type)); }
//insert Order public int InsertOrder(EC_tb_Order ec_tb_ord, bool data_type) { return(sql_tb_ord.InsertOrder(ec_tb_ord, data_type)); }