public void update_product_INFO(int ID_PORDUCT, int store_ID, string PRODUCT_NAME, int categore_ID, int Ptype_ID, decimal buy_price, decimal sellS_price, decimal sellP_price, decimal min_price, int min_qty, int qty)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("@PRODUCT_NAME", SqlDbType.VarChar, 50);
param[0].Value = PRODUCT_NAME;
param[1] = new SqlParameter("@QTE_IN_STOCK", SqlDbType.Int);
param[1].Value = qty;
param[2] = new SqlParameter("@buy_PRICE", SqlDbType.Money);
param[2].Value = buy_price;
param[3] = new SqlParameter("@SARALABIE_SECTORS", SqlDbType.Money);
param[3].Value = sellP_price;
param[4] = new SqlParameter("@SARALABIE_SENTENCE", SqlDbType.Money);
param[4].Value = sellS_price;
param[5] = new SqlParameter("@MINI_PRICE_TO_BUY", SqlDbType.Money);
param[5].Value = min_qty;
param[6] = new SqlParameter("@MINI_QTY", SqlDbType.Int);
param[6].Value = min_qty;
param[7] = new SqlParameter("@ID_CAT", SqlDbType.Int);
param[7].Value = categore_ID;
param[8] = new SqlParameter("@STORE_ID", SqlDbType.Int);
param[8].Value = store_ID;
param[9] = new SqlParameter("@ID_PORDUCT", SqlDbType.Int);
param[9].Value = ID_PORDUCT;
param[10] = new SqlParameter("@Ptype_ID", SqlDbType.Int);
param[10].Value = Ptype_ID;
DAL.Excutecommand("update_product_INFO", param);
DAL.close();
}
public void DELETE_PinCOM_OrderDetails(int ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID_PinCOM_OrderDetails", SqlDbType.Int);
param[0].Value = ID;
DAL.Excutecommand("Delete_PinCOM_OrderDetails", param);
DAL.close();
}
public void DELETE_user(int ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID_user", SqlDbType.Int);
param[0].Value = ID;
DAL.Excutecommand("DELETE_user", param);
DAL.close();
}
public void Delete_Payedmoney_com(int ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID_Payedmoney_COM", SqlDbType.Int);
param[0].Value = ID;
DAL.Excutecommand("Delete_Payedmoney_com", param);
DAL.close();
}
public void save_OverAlltotalORDER(int ORDER_ID, decimal OverAlltotalORDER)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ORDER_ID", SqlDbType.Int);
param[0].Value = ORDER_ID;
param[1] = new SqlParameter("@OverAlltotalORDER", SqlDbType.Money);
param[1].Value = OverAlltotalORDER;
DAL.Excutecommand("save_OverAlltotalORDER", param);
}
public void ADD_PhoneNote(string NAME, string Phone)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@name", SqlDbType.VarChar, 50);
param[0].Value = NAME;
param[1] = new SqlParameter("@phone", SqlDbType.VarChar, 50);
param[1].Value = Phone;
DAL.Excutecommand("NInsertNewPhonenote", param);
DAL.close();
}
public void Update_MProduct_QTY(int Product_ID, int product_QTY, int type)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Product_ID", SqlDbType.Int);
param[0].Value = Product_ID;
param[1] = new SqlParameter("@Old_QTY", SqlDbType.Int);
param[1].Value = product_QTY;
param[2] = new SqlParameter("@type", SqlDbType.Int);
param[2].Value = type;
DAL.Excutecommand("update_QTY", param);
DAL.close();
}
public void Update_BProduct_QTY(int Product_ID, int Oldproduct_QTY, int Newproduct_QTY)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Product_ID", SqlDbType.Int);
param[0].Value = Product_ID;
param[1] = new SqlParameter("@Old_QTY", SqlDbType.Int);
param[1].Value = Oldproduct_QTY;
param[2] = new SqlParameter("@New_QTY", SqlDbType.Int);
param[2].Value = Newproduct_QTY;
DAL.Excutecommand("updateQTY", param);
DAL.close();
}
public void ADD_COM(string Customer_NAME, string Address, string Phone)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Com_NAME", SqlDbType.VarChar, 50);
param[0].Value = Customer_NAME;
param[1] = new SqlParameter("@Com_Address", SqlDbType.VarChar, 50);
param[1].Value = Address;
param[2] = new SqlParameter("@Com_Phone", SqlDbType.VarChar, 50);
param[2].Value = Phone;
DAL.Excutecommand("NInsertNewCOM", param);
DAL.close();
}
public void update_RemainMoney_Customer_INFO(int Customer_ID, int order_ID, decimal Remain_money)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Customer_ID", SqlDbType.Int);
param[0].Value = Customer_ID;
param[1] = new SqlParameter("@Remain_money", SqlDbType.Decimal);
param[1].Value = Remain_money;
param[2] = new SqlParameter("@order_ID", SqlDbType.Int);
param[2].Value = order_ID;
DAL.Excutecommand("Update_RemainmoneyCustomer", param);
DAL.close();
}
public void update_Phonenote_INFO(int ID, string NAME, string Phone)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@name", SqlDbType.VarChar, 50);
param[1].Value = NAME;
param[2] = new SqlParameter("@phone", SqlDbType.VarChar, 50);
param[2].Value = Phone;
DAL.Excutecommand("update_PhoneNote_INFO", param);
DAL.close();
}
public void ADD_COM_Order(DateTime Date_Order, int Customer_ID, int Order_Type, int user_typeID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@Date_Order", SqlDbType.DateTime);
param[0].Value = Date_Order;
param[1] = new SqlParameter("@Customer_ID ", SqlDbType.Int);
param[1].Value = Customer_ID;
param[2] = new SqlParameter("@Order_Type", SqlDbType.Int);
param[2].Value = Order_Type;
param[3] = new SqlParameter("@user_TypeID", SqlDbType.Int);
param[3].Value = user_typeID;
DAL.Excutecommand("insert_COM_Order", param);
DAL.close();
}
public void Add_Paymoney_INFO(string name, string pay_discription, decimal amount, DateTime date)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@name", SqlDbType.VarChar, 50);
param[0].Value = name;
param[1] = new SqlParameter("@pay_discription", SqlDbType.VarChar, 50);
param[1].Value = pay_discription;
param[2] = new SqlParameter("@amount", SqlDbType.Decimal);
param[2].Value = amount;
param[3] = new SqlParameter("@date", SqlDbType.DateTime);
param[3].Value = date;
DAL.Excutecommand("NInsertPayMoney_INFO", param);
DAL.close();
}
public void update_COM_INFO(int ID_Customer, string Customer_NAME, string Address, string Phone)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@ID_COM", SqlDbType.Int);
param[0].Value = ID_Customer;
param[1] = new SqlParameter("@COM_NAME", SqlDbType.VarChar, 50);
param[1].Value = Customer_NAME;
param[2] = new SqlParameter("@Address", SqlDbType.VarChar, 50);
param[2].Value = Address;
param[3] = new SqlParameter("@Phone", SqlDbType.VarChar, 50);
param[3].Value = Phone;
DAL.Excutecommand("update_COM_INFO", param);
DAL.close();
}
public void ADD_Payedmoney_COM(int COM_ID, decimal COM_payedmoney, DateTime date, int order_ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@COM_ID", SqlDbType.Int);
param[0].Value = COM_ID;
param[1] = new SqlParameter("@COM_payedmoney", SqlDbType.Decimal);
param[1].Value = COM_payedmoney;
param[2] = new SqlParameter("@date", SqlDbType.DateTime);
param[2].Value = date;
param[3] = new SqlParameter("@order_ID", SqlDbType.Int);
param[3].Value = order_ID;
DAL.Excutecommand("NInsertNew_Payedmoney_COM", param);
DAL.close();
}
public void Add_moneySaver_Payed_INFO(int payedMoney_ID, int savemoneytype_ID, int usertyep_ID, DateTime date, int ordersavemoney_ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@savemoneytype_ID", SqlDbType.Int);
param[0].Value = savemoneytype_ID;
param[1] = new SqlParameter("@usertyep_ID", SqlDbType.Int);
param[1].Value = usertyep_ID;
param[2] = new SqlParameter("@payedMoney_ID", SqlDbType.Int);
param[2].Value = payedMoney_ID;
param[3] = new SqlParameter("@date", SqlDbType.DateTime);
param[3].Value = date;
param[4] = new SqlParameter("@ordersavemoney_type", SqlDbType.Int);
param[4].Value = ordersavemoney_ID;
DAL.Excutecommand("NInsertNewMoney_Payed_saver", param);
DAL.close();
}
public void update_Payedmoney_COM_INFO(int ID, int Customer_ID, decimal payedmoney, DateTime date, int order_ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@com_ID", SqlDbType.Int);
param[1].Value = Customer_ID;
param[2] = new SqlParameter("@payed_money", SqlDbType.Decimal);
param[2].Value = payedmoney;
param[3] = new SqlParameter("@date", SqlDbType.DateTime);
param[3].Value = date;
param[4] = new SqlParameter("@order_ID", SqlDbType.Int);
param[4].Value = order_ID;
DAL.Excutecommand("update_payedmoneyCOM_INFO", param);
DAL.close();
}
public void Update_COM_OrderDetails(int Order_type, int Product_ID, int ORDER_COM_ID, int product_QTY, decimal total_PProduct)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@Order_type", SqlDbType.Int);
param[0].Value = Order_type;
param[1] = new SqlParameter("@Product_ID", SqlDbType.Int);
param[1].Value = Product_ID;
param[2] = new SqlParameter("@ORDER_COM_ID", SqlDbType.Int);
param[2].Value = ORDER_COM_ID;
param[3] = new SqlParameter("@product_QTY", SqlDbType.Int);
param[3].Value = product_QTY;
param[4] = new SqlParameter("@total_PProduct", SqlDbType.Decimal);
param[4].Value = total_PProduct;
DAL.Excutecommand("Update_COMOrderDetail", param);
DAL.close();
}
public void Add_moneySaver_Customer_INFO(int payedMoney_customer, int savemoneytype_ID, int usertyep_ID, DateTime date, int order_ID, int ordersavemoney_ID, decimal amount)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@payedMoney_customer", SqlDbType.Int);
param[0].Value = payedMoney_customer;
param[1] = new SqlParameter("@savemoneytype_ID", SqlDbType.Int);
param[1].Value = savemoneytype_ID;
param[2] = new SqlParameter("@usertyep_ID", SqlDbType.Int);
param[2].Value = usertyep_ID;
param[3] = new SqlParameter("@date", SqlDbType.DateTime);
param[3].Value = date;
param[4] = new SqlParameter("@order_ID", SqlDbType.Int);
param[4].Value = order_ID;
param[5] = new SqlParameter("@Ordersavemony_type_ID", SqlDbType.Int);
param[5].Value = ordersavemoney_ID;
param[6] = new SqlParameter("@amount", SqlDbType.Decimal);
param[6].Value = amount;
DAL.Excutecommand("NInsertNewMoney_CUSTOMER_saver", param);
DAL.close();
}
