// 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();
}
/// <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);
}
// 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 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);
}
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);
}
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 DataTable getAllSubb()
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
dt = Dal.ExecutQuery("getAllSubb", null);
return(dt);
}
//ادارة البضائع
public DataTable ShowAll()
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
dt = Dal.ExecutQuery("ShowClothes", null);
Dal.Close();
return(dt);
}
public DataTable ShowAllGetMoney()
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
dt = Dal.ExecutQuery("ShowAllGetMoney", null);
return(dt);
}
public DataTable GetLastorderIdForPrint()
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
dt = Dal.ExecutQuery("GetLastorderId", null);
return(dt);
}
///////////////////////////////////////
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 DataTable GetConId()
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
dt = Dal.ExecutQuery("GetLastItemId", null);
return(dt);
}
/////////////////////////////////
public DataTable ShowAll()
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
dt = Dal.ExecutQuery("getAllCust", null);
return(dt);
}
public DataTable GetProfitPeforeUpdating(int order_id)
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@order_id", SqlDbType.Int);
param[0].Value = order_id;
dt = Dal.ExecutQuery("GetProfitPeforeUpdating", param);
return(dt);
}
/// <summary>
/// /////////////////////////////////////////////
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable Get_image(string id)
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", SqlDbType.VarChar, 50);
param[0].Value = id;
dt = Dal.ExecutQuery("Get_image", param);
Dal.Close();
return(dt);
}
// thsi is for checing hte primary key
public DataTable VertifyCloth(String id)
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id_item", SqlDbType.VarChar, 30);
param[0].Value = id;
dt = Dal.ExecutQuery("VertifyItemId", param);
Dal.Close();
return(dt);
}
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);
}
/// <summary>
/// /////////////////////////////////////
/// </summary>
/// <param name="id"></param>
///
public DataTable SearchSubb(String id)
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", SqlDbType.VarChar, 50);
param[0].Value = id;
dt = Dal.ExecutQuery("SearchSubb", param);
return(dt);
}
/////////////////////////////////////
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 DataTable SubbliersFetch()
{
// this method is for calling the stored procedure
// ths equals the callable ststment java Video 89
// every data base has its own language to store stored procedure
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
// this will pass the name of the procedure
// and the method will deal with the prcedure
// the load of the sql statment will be dine in the server
dt = Dal.ExecutQuery("SubbliersFetch", null);
Dal.Close();
return(dt);
}
/// <summary>
/// //////////////// GEt Order Details for Update
/// </summary>
/// <param name="order_id"></param>
/// <returns></returns>
public DataTable GetDetailsByOrderID(int order_id)
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@order_Id", SqlDbType.Int);
param[0].Value = order_id;
dt = Dal.ExecutQuery("GetDetailsByOrderID", param);
return(dt);
}
////////////////////////
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);
}
//////////////////////
/// <summary>
/// هذه الدالة تتحقق من الكمية وان لاتتعدر الكمية
/// </summary>
/// <param name="id"></param>
/// <param name="qty"></param>
/// <returns></returns>
public DataTable VerifyQty(String id, int qty)
{
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 = id;
param[1] = new SqlParameter("@Qty_entered", SqlDbType.Int);
param[1].Value = qty;
dt = Dal.ExecutQuery("VerifyQty", param);
return(dt);
}
public byte[] Get_images(string id)
{
DAL.DataAccesssLayer dal = new DAL.DataAccesssLayer();
String qu = " select * from Items where Item_id=" + id + ";";
dal.Open();
SqlDataReader dr = dal.Execut(qu);
// dal.Close();
dr.Read();
byte[] buteimg = null;
buteimg = (byte[])dr["Item_image"];
// MemoryStream ms = new MemoryStream(buteimg);
return(buteimg);
}
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();
}
//
public DataTable GetQtyBeforeDelete(string item_id, int order_id)
{
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("@order_id", SqlDbType.Int);
param[1].Value = order_id;
dt = Dal.ExecutQuery("GetQtyBeforeDelete", param);
return(dt);
}
/// <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);
}
