/// <summary> /// ///////////////////////////////////// /// </summary> /// <returns></returns> public void updateSubblier(String first_name, String last_name, string phone, String address, double credit, int id) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@first_name", SqlDbType.VarChar, 25); param[0].Value = first_name; param[1] = new SqlParameter("@last_name", SqlDbType.VarChar, 25); param[1].Value = last_name; param[2] = new SqlParameter("@phone", SqlDbType.NChar, 15); param[2].Value = phone; param[3] = new SqlParameter("@address", SqlDbType.VarChar, 25); param[3].Value = address; param[4] = new SqlParameter("@credit", SqlDbType.Float); param[4].Value = credit; param[5] = new SqlParameter("@id", SqlDbType.Int); param[5].Value = id; Dal.ExecuteUpdate("updateSubb", param); }
////////////////////////////////////// public void OrderDetails(string item_id, int Order_id, int qty, string price, double disCount, string PriceAfterQ, string total) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@item_id", SqlDbType.VarChar, 30); param[0].Value = item_id; param[1] = new SqlParameter("@order_id", SqlDbType.Int); param[1].Value = Order_id; param[2] = new SqlParameter("@Quantity", SqlDbType.Int); param[2].Value = qty; param[3] = new SqlParameter("@Price", SqlDbType.VarChar, 50); param[3].Value = price; param[4] = new SqlParameter("@DisCount", SqlDbType.Float); param[4].Value = disCount; param[5] = new SqlParameter("@Amount", SqlDbType.VarChar, 50); param[5].Value = PriceAfterQ; param[6] = new SqlParameter("@Total", SqlDbType.VarChar, 50); param[6].Value = total; Dal.ExecuteUpdate("OrderDetails", param); }
// Update Order public void Update_Order(int id, DateTime date, String note, int cust_id, double total, double debt) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@order_id", SqlDbType.Int); param[0].Value = id; param[1] = new SqlParameter("@order_date", SqlDbType.DateTime); param[1].Value = date; param[2] = new SqlParameter("@note", SqlDbType.VarChar, 250); param[2].Value = note; param[3] = new SqlParameter("@cust_id", SqlDbType.Int); param[3].Value = cust_id; param[4] = new SqlParameter("@total", SqlDbType.Float); param[4].Value = total; param[5] = new SqlParameter("@debt", SqlDbType.Float); param[5].Value = debt; Dal.ExecuteUpdate("UpdateOrder", param); }
public void Add_Order(int id, String note, DateTime date, String salesMan, int cust_id, double total, double debt) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@orders_id", SqlDbType.Int); param[0].Value = id; param[1] = new SqlParameter("@order_date", SqlDbType.DateTime); param[1].Value = date; param[2] = new SqlParameter("@customer_id", SqlDbType.Int); param[2].Value = cust_id; param[3] = new SqlParameter("@notes", SqlDbType.VarChar, 250); param[3].Value = note; param[4] = new SqlParameter("@salesman", SqlDbType.VarChar, 75); param[4].Value = salesMan; param[5] = new SqlParameter("@total", SqlDbType.Float); param[5].Value = total; param[6] = new SqlParameter("@debt", SqlDbType.Float); param[6].Value = debt; Dal.ExecuteUpdate("Add_Oreder", param); }
public void UpdateDepit(DateTime date, double price, int cust_id, int order_id, string note, double PrevDebt) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@date", SqlDbType.DateTime); param[0].Value = date; param[1] = new SqlParameter("@price", SqlDbType.Float); param[1].Value = price; param[2] = new SqlParameter("@customer_id", SqlDbType.Int); param[2].Value = cust_id; param[3] = new SqlParameter("@order_id", SqlDbType.Int); param[3].Value = order_id; param[4] = new SqlParameter("@note", SqlDbType.VarChar, 150); param[4].Value = note; param[5] = new SqlParameter("@PrevDebt", SqlDbType.Float); param[5].Value = PrevDebt; Dal.ExecuteUpdate("UpdateDepit", param); }
// this method is for adding // the order of parameters should be the same as the stored proc inthe database public void Add_Cloth(int id_cat, String item_id, String item_label, int quanitity, String price, int sub_id, byte[] image) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); Dal.Open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@id_cat", SqlDbType.Int); param[0].Value = id_cat; param[1] = new SqlParameter("@item_id", SqlDbType.VarChar, 30); param[1].Value = item_id; param[2] = new SqlParameter("@item_label", SqlDbType.VarChar, 50); param[2].Value = item_label; param[3] = new SqlParameter("@quantity", SqlDbType.Int); param[3].Value = quanitity; param[4] = new SqlParameter("@price", SqlDbType.VarChar, 20); param[4].Value = price; param[5] = new SqlParameter("@sub_id", SqlDbType.Int); param[5].Value = sub_id; param[6] = new SqlParameter("@item_image", SqlDbType.Image); param[6].Value = image; Dal.ExecuteUpdate("ADD_Cloth", param); Dal.Close(); }
public void UpdateMoney(int id, DateTime date, double price, string note, double prevPrice, int cust_id) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@id", SqlDbType.Int); param[0].Value = id; param[1] = new SqlParameter("@date", SqlDbType.DateTime); param[1].Value = date; param[2] = new SqlParameter("@price", SqlDbType.Float); param[2].Value = price; param[3] = new SqlParameter("@note", SqlDbType.VarChar, 150); param[3].Value = note; param[4] = new SqlParameter("@prevPrice", SqlDbType.Float); param[4].Value = prevPrice; param[5] = new SqlParameter("@customer_id", SqlDbType.Int); param[5].Value = cust_id; Dal.ExecuteUpdate("UpdateMoney", param); }
/////////////////////////////////////// public void DeleteSubblier(int id) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@id", SqlDbType.Int); param[0].Value = id; Dal.ExecuteUpdate("DeleteSubb", param); }
public void Deleteuser(string id) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@id", SqlDbType.VarChar, 20); param[0].Value = id; Dal.ExecuteUpdate("deleteUser", param); }
///////////////////////////////////// public void DeleteOrder(int order_id) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@id", SqlDbType.Int); param[0].Value = order_id; Dal.ExecuteUpdate("DeleteOrder", param); }
//////////////////////// public void updateQtyBeforeDelete(string item_id, int qtyToUpdate) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@item_id", SqlDbType.VarChar, 30); param[0].Value = item_id; param[1] = new SqlParameter("@qty", SqlDbType.Int); param[1].Value = qtyToUpdate; Dal.ExecuteUpdate("updateQtyBeforeDelete", param); }
public void DeleteMoney(int id, int cust_id, double price) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@id", SqlDbType.Int); param[0].Value = id; param[1] = new SqlParameter("@cust_id", SqlDbType.Int); param[1].Value = cust_id; param[2] = new SqlParameter("@price", SqlDbType.Float); param[2].Value = price; Dal.ExecuteUpdate("DeleteMoney", param); }
public void DeleteClothes(String id, int qty, string price, int sub_id) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@id", SqlDbType.VarChar, 30); param[0].Value = id; param[1] = new SqlParameter("@qty", SqlDbType.Int); param[1].Value = qty; param[2] = new SqlParameter("@price", SqlDbType.VarChar, 20); param[2].Value = price; param[3] = new SqlParameter("@sub_id", SqlDbType.Int); param[3].Value = sub_id; Dal.ExecuteUpdate("DeleteClothes", param); Dal.Close(); }
/// <summary> /// /////اضافةكل ماتم تعديلة على الفواتير /// </summary> /// <param name="item_id"></param> /// <param name="Order_id"></param> /// <param name="qty"></param> /// <param name="price"></param> /// <param name="disCount"></param> /// <param name="PriceAfterQ"></param> /// <param name="total"></param> public void OrderDetailsLog(DateTime logDate, int Order_id, string item_id, int qty, string price, double disCount, string PriceAfterQ, string total, string notes) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[9]; param[0] = new SqlParameter("@LogDate", SqlDbType.DateTime); param[0].Value = logDate; param[1] = new SqlParameter("@order_id", SqlDbType.Int); param[1].Value = Order_id; param[2] = new SqlParameter("@item_id", SqlDbType.VarChar, 30); param[2].Value = item_id; param[3] = new SqlParameter("@Quantity", SqlDbType.Int); param[3].Value = qty; param[4] = new SqlParameter("@Price", SqlDbType.VarChar, 50); param[4].Value = price; param[5] = new SqlParameter("@DisCount", SqlDbType.Float); param[5].Value = disCount; param[6] = new SqlParameter("@Amount", SqlDbType.VarChar, 50); param[6].Value = PriceAfterQ; param[7] = new SqlParameter("@Total", SqlDbType.VarChar, 50); param[7].Value = total; param[8] = new SqlParameter("@note", SqlDbType.VarChar, 50); param[8].Value = notes; Dal.ExecuteUpdate("SaveBaseLog", param); }
public void Add_user(string id, String pwd, String type, string name) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@id", SqlDbType.VarChar, 20); param[0].Value = id; param[1] = new SqlParameter("@pwd", SqlDbType.VarChar, 20); param[1].Value = pwd; param[2] = new SqlParameter("@type", SqlDbType.VarChar, 20); param[2].Value = type; param[3] = new SqlParameter("@name", SqlDbType.VarChar, 50); param[3].Value = name; Dal.ExecuteUpdate("InsertUser", param); }
public void Add_Customer(String first_name, String last_name, string phone, String address, double debt) { DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer(); SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@first_name", SqlDbType.VarChar, 25); param[0].Value = first_name; param[1] = new SqlParameter("@last_name", SqlDbType.VarChar, 25); param[1].Value = last_name; param[2] = new SqlParameter("@phone", SqlDbType.NChar, 15); param[2].Value = phone; param[3] = new SqlParameter("@address", SqlDbType.VarChar, 25); param[3].Value = address; param[4] = new SqlParameter("@Debt", SqlDbType.Float); param[4].Value = debt; Dal.ExecuteUpdate("Add_Cust", param); }