// 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 DataTable ShowAll()
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
dt = Dal.ExecutQuery("ShowClothes", null);
Dal.Close();
return(dt);
}
/// <summary>
/// /////////////////////////////////////
/// </summary>
/// <param name="id"></param>
///
public DataTable SearchCust(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("SearchCust", 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 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);
}
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();
}
// these parameter willbe snet to te stored proc in the databse
public DataTable Login(String id, String pass)
{
// 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();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 20);
param[0].Value = id;
param[1] = new SqlParameter("@pasword", SqlDbType.VarChar, 20);
param[1].Value = pass;
Dal.Open();
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("logIn", param);
Dal.Close();
return(dt);
}
