示例#1
0
        public CustomersOrdersDetail[] GetOrderDetailData() //פונקציה לאחסון  פירוט הזמנה של לקוח
        {
            DataSet   ds          = new DataSet();
            ArrayList OrderDetail = new ArrayList();
            string    cmdStr      = "SELECT * FROM   [CustomersOrdersDetail]";

            using (OleDbCommand command = new OleDbCommand(cmdStr))
            {
                ds = GetMultiplyQuery(command);
            }
            DataTable dt = new DataTable();

            try
            {
                dt = ds.Tables[0];
            }
            catch { }
            foreach (DataRow tType in dt.Rows)
            {
                CustomersOrdersDetail CusOrder = new CustomersOrdersDetail();
                CusOrder.CustomerOrder_ID                 = int.Parse(tType[0].ToString());
                CusOrder.CustomerOrder_ClientID           = int.Parse(tType[1].ToString());
                CusOrder.CustomerOrder_ClientName         = tType[2].ToString();
                CusOrder.CustomerOrder_ProductID          = int.Parse(tType[3].ToString());
                CusOrder.CustomerOrder_ProductDescription = tType[4].ToString();
                CusOrder.CustomerOrder_Quantity           = int.Parse(tType[5].ToString());
                CusOrder.CustomerOrder_ProductReceived    = bool.Parse(tType[6].ToString());


                OrderDetail.Add(CusOrder);
            }
            return((CustomersOrdersDetail[])OrderDetail.ToArray(typeof(CustomersOrdersDetail)));
        }
示例#2
0
        public void UpdateOrderReceivedInCustomersOrdersDetail(CustomersOrdersDetail cusorderdet)//פונקציה שמעדכנת שהלקוח קיבל את הזמנתו בטבלת הזמנות מפורטות
        {
            string cmdStr = "UPDATE CustomersOrdersDetail SET ProductReceived=@ProductReceived WHERE OrderID=" + cusorderdet.CustomerOrder_ID + "AND ProductID=" + cusorderdet.CustomerOrder_ProductID;

            using (OleDbCommand command = new OleDbCommand(cmdStr))
            {
                command.Parameters.AddWithValue("@ProductReceived", cusorderdet.CustomerOrder_ProductReceived);
                base.ExecuteSimpleQuery(command);
            }
        }
示例#3
0
        public void UpdateCustomerNameInCustomersOrdersDetail(Customers cus, CustomersOrdersDetail cusorder)//פונקציה לעדכון שם של  לקוח בטבלת  הזמנות  מפורטות במידה והלקוח שינה את שמו
        {
            string cmdStr = "UPDATE CustomersOrdersDetail SET CustomerName =" + cusorder.CustomerOrder_ClientName + " WHERE CustomerID=" + cus.Customer_ID;

            using (OleDbCommand command = new OleDbCommand(cmdStr))
            {
                command.Parameters.AddWithValue("@First_Name", cusorder.CustomerOrder_ClientName);
                base.ExecuteSimpleQuery(command);
            }
        }
示例#4
0
        public void SubProductStock(Products product, CustomersOrdersDetail c)//פונקציה להורדת מלאי של מוצר ספציפי  לאחר ביצוע הזמנה
        {
            string cmdStr = "UPDATE Products SET In_Stock=" + product.Product_Stock + " WHERE Product_ID=" + c.CustomerOrder_ProductID;

            using (OleDbCommand command = new OleDbCommand(cmdStr))
            {
                command.Parameters.AddWithValue("@Stock", product.Product_Stock);
                base.ExecuteSimpleQuery(command);
            }
        }
示例#5
0
        public void AddCustomerOrderDetail(CustomersOrdersDetail CusOrder)//  פונקציה להוספת הזמנה למאגר ההזמנות המפורט
        {
            string cmdStr = "INSERT INTO CustomersOrdersDetail (OrderID,CustomerID,CustomerName,ProductID,ProductDescription,Quantity) VALUES (@OrderID,@CustomerID,@CustomerName,@ProductID,@ProductDescription,@Quantity)";

            using (OleDbCommand command = new OleDbCommand(cmdStr))
            {
                command.Parameters.AddWithValue("@OrderID", CusOrder.CustomerOrder_ID);
                command.Parameters.AddWithValue("@CustomerID", CusOrder.CustomerOrder_ClientID);
                command.Parameters.AddWithValue("@CustomerName", CusOrder.CustomerOrder_ClientName);
                command.Parameters.AddWithValue("@ProductID", CusOrder.CustomerOrder_ProductID);
                command.Parameters.AddWithValue("@ProductDescription", CusOrder.CustomerOrder_ProductDescription);
                command.Parameters.AddWithValue("@Quantity", CusOrder.CustomerOrder_Quantity);
                base.ExecuteSimpleQuery(command);
            }
        }
示例#6
0
        public void RemoveCustomersOrderDetail(CustomersOrdersDetail CusOrderDet)//פונקציה למחיקת פרטי הזמנה בטבלת  הזמנות מפורטות
        {
            string cmdStr = "DELETE  FROM CustomersOrdersDetail WHERE OrderID = @OrderID";

            using (OleDbCommand command = new OleDbCommand(cmdStr))
            {
                command.Parameters.AddWithValue("@OrderID", CusOrderDet.CustomerOrder_ID);
                command.Parameters.AddWithValue("@CustomerID", CusOrderDet.CustomerOrder_ClientID);
                command.Parameters.AddWithValue("@CustomerName", CusOrderDet.CustomerOrder_ClientName);
                command.Parameters.AddWithValue("@ProductID", CusOrderDet.CustomerOrder_ProductID);
                command.Parameters.AddWithValue("@ProductDescription", CusOrderDet.CustomerOrder_ProductDescription);
                command.Parameters.AddWithValue("@Quantity", CusOrderDet.CustomerOrder_Quantity);

                base.ExecuteSimpleQuery(command);
            }
        }