public void EDIT_CUSTOMER(string First_Name, string Last_Name, string Tel, string Email, byte[] Picture, string Criterion, int ID)
{
Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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 void UPDATE_PRODUCT(int ID_Cat, string label_product, string ID_product, int Qte, string Price, byte[] img)
{
Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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 DataTable GET_LAST_ORDER_ID()
{
Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_DAL_.DataAccessLayer();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GET_LAST_ORDER_ID", null);
DAL.close();
return(Dt);
}
public DataTable GET_ALL_CUSTOMERS()
{
Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_DAL_.DataAccessLayer();
DAL.open();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GET_ALL_CUSTOMERS", null);
DAL.close();
return(Dt);
}
public void DELETE_CUSTOMER(int ID)
{
Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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 void DeleteProduct(string ID)
{
Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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 VerifyProductID(string ID)
{
Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_DAL_.DataAccessLayer();
DAL.open();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
Dt = DAL.SelectData("VerifyProductID", param);
DAL.close();
return(Dt);
}
public DataTable Search_Customer(string Criterion)
{
Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_DAL_.DataAccessLayer();
DAL.open();
DataTable Dt = new DataTable();
SqlParameter[] param;
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 DataTable LOGIN(string ID, string PWD)
{
Data_Access_Layer_DAL_.DataAccessLayer DAL = new Data_Access_Layer_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.open();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("SP_LOGIN", param);
DAL.close();
return(Dt);
}