/////////////////////////////////
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("getAllCust", null);
return(dt);
}
public DataTable GetLastorderIdForPrint()
{
DAL.DataAccesssLayer Dal = new DAL.DataAccesssLayer();
DataTable dt = new DataTable();
dt = Dal.ExecutQuery("GetLastorderId", null);
return(dt);
}
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("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);
}
/// <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);
}
// 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);
}
/// <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);
}
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>
/// //////////////// 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 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>
/// هذه الدالة تتحقق من الكمية وان لاتتعدر الكمية
/// </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 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);
}
// 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);
}
