public void UPDATE_PRODUCT(int ID_cat, string Label_product, string ID_product,
int Qte, string Price, byte[] img)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@ID_CAT", SqlDbType.Int);
param[0].Value = ID_cat;
param[1] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 30);
param[1].Value = ID_product;
param[2] = new SqlParameter("@Label", SqlDbType.VarChar, 30);
param[2].Value = Label_product;
param[3] = new SqlParameter("@Qte", SqlDbType.Int);
param[3].Value = Qte;
param[4] = new SqlParameter("@PRICE", SqlDbType.VarChar, 50);
param[4].Value = Price;
param[5] = new SqlParameter("@Img", SqlDbType.Image);
param[5].Value = img;
DAL.ExecuteCommand("UPDATE_PRODUCT", param);
DAL.close();
}
public void ADD_ORDER(int ID_ORDER, DateTime DATE_ORDER, int CUSTOMER_ID,
string DESCRIPTION_ORDER, string SALESMAN)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@ID_ORDER", SqlDbType.Int);
param[0].Value = ID_ORDER;
param[1] = new SqlParameter("@DATE_ORDER", SqlDbType.DateTime);
param[1].Value = DATE_ORDER;
param[2] = new SqlParameter("@CUSTOMER_ID", SqlDbType.Int);
param[2].Value = CUSTOMER_ID;
param[3] = new SqlParameter("@DESCRIPTION_ORDER", SqlDbType.VarChar, 250);
param[3].Value = DESCRIPTION_ORDER;
param[4] = new SqlParameter("@SALESMAN", SqlDbType.VarChar, 50);
param[4].Value = SALESMAN;
DAL.ExecuteCommand("ADD_ORDER", param);
DAL.close();
}
public void ADD_ORDER_DETAILS(string ID_PRODUCT, int ID_ORDER, int QTE,
string PRICE, double DISCOUNT, string AMOUNT, string TOTAL_AMOUNT)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 30);
param[0].Value = ID_PRODUCT;
param[1] = new SqlParameter("@ID_ORDER", SqlDbType.Int);
param[1].Value = ID_ORDER;
param[2] = new SqlParameter("@QTE", SqlDbType.Int);
param[2].Value = QTE;
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 = AMOUNT;
param[6] = new SqlParameter("@TOTAL_AMOUNT", SqlDbType.VarChar, 50);
param[6].Value = TOTAL_AMOUNT;
DAL.ExecuteCommand("ADD_ORDER_DETAILS", param);
DAL.close();
}
public void EDIT_CUSTOMER(string First_Name, string Last_Name, string Tel,
string Email, byte[] Picture, string Criterion, int ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[7];
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("@Tel", SqlDbType.NChar, 15);
param[2].Value = Tel;
param[3] = new SqlParameter("@Email", SqlDbType.VarChar, 25);
param[3].Value = Email;
param[4] = new SqlParameter("@Picture", SqlDbType.Image);
param[4].Value = Picture;
param[5] = new SqlParameter("@Criterion", SqlDbType.VarChar, 50);
param[5].Value = Criterion;
param[6] = new SqlParameter("@ID", SqlDbType.Int);
param[6].Value = ID;
DAL.ExecuteCommand("EDIT_CUSTOMER", param);
DAL.close();
}
public DataTable GET_ALL_PRODUCTS()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GET_ALL_PRODUCTS", null);
DAL.close();
return(Dt);
}
public DataTable GET_ALL_CATEGORIES()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("get_cat", null);
DAL.close();
return(Dt);
}
public DataTable GET_LAST_ORDER_FOR_PRINT()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GET_LAST_ORDER_FOR_PRINT", null);
DAL.close();
return(Dt);
}
public void DeleteProduct(string ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
DAL.ExecuteCommand("DeleteProduct", param);
DAL.close();
}
public DataTable SearchProduct(string ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
Dt = DAL.SelectData("SearchProduct", param);
DAL.close();
return(Dt);
}
public DataTable GET_IMAGE_PRODUCT(string ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
Dt = DAL.SelectData("GET_IMAGE_PRODUCT", param);
DAL.close();
return(Dt);
}
public DataTable Search_Customer(string Criterion)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] Param = new SqlParameter[1];
Param[0] = new SqlParameter("@Criterion", SqlDbType.VarChar, 50);
Param[0].Value = Criterion;
Dt = DAL.SelectData("Search_Customer", Param);
DAL.close();
return(Dt);
}
public void DELETE_CUSTOMER(int ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
DAL.ExecuteCommand("DELETE_CUSTOMER", param);
DAL.close();
}
public DataTable get_order(int ID_ORDER)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID_ORDER", SqlDbType.Int);
param[0].Value = ID_ORDER;
Dt = DAL.SelectData("get_order", param);
DAL.close();
return(Dt);
}
public DataTable LOGIN(string ID, string PWD)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
param[1] = new SqlParameter("@PWD", SqlDbType.VarChar, 50);
param[1].Value = PWD;
DAL.close();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("SP_LOGIN", param);
return(Dt);
}
public DataTable VerifyQty(string ID_PRODUCT, int Qty_Entered)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 30);
param[0].Value = ID_PRODUCT;
param[1] = new SqlParameter("@Qty_Entered", SqlDbType.Int);
param[1].Value = Qty_Entered;
Dt = DAL.SelectData("VerifyQty", param);
DAL.close();
return(Dt);
}
public void EDIT_USER(string ID, string FullName, string PWD,
string UserType)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
param[1] = new SqlParameter("@FullName", SqlDbType.VarChar, 50);
param[1].Value = FullName;
param[2] = new SqlParameter("@PWD", SqlDbType.VarChar, 50);
param[2].Value = PWD;
param[3] = new SqlParameter("@UserType", SqlDbType.VarChar, 50);
param[3].Value = UserType;
DAL.ExecuteCommand("EDIT_USER", param);
DAL.close();
}
