public void ADD_SHOP_DETAILS(string ID_PRODUCT, int ID_shop, double QTE, string PRICE, string AMOUNT, string TOTAL_AMOUNT, Double DISCOUNT)
{
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_shop", SqlDbType.Int);
param[1].Value = ID_shop;
param[2] = new SqlParameter("@QTE", SqlDbType.Float);
param[2].Value = QTE;
param[3] = new SqlParameter("@PRICE", SqlDbType.VarChar, 50);
param[3].Value = PRICE;
param[4] = new SqlParameter("@AMOUNT", SqlDbType.VarChar, 50);
param[4].Value = AMOUNT;
param[5] = new SqlParameter("@TOTAL_AMOUNT", SqlDbType.VarChar, 50);
param[5].Value = TOTAL_AMOUNT;
param[6] = new SqlParameter("@DISCOUNT", SqlDbType.Float);
param[6].Value = DISCOUNT;
DAL.executecommand("ADD_SHOP_DETAILS", param);
DAL.close();
}
public void UPDATE_PRODUCT(int ID_CAT, string ID_PRODUCT, string LABEL_PRODUCT, string QTE, string PRICE, byte[] IMG, string criterion)
{
DAL.dataAccessLayer DAL = new DAL.dataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("ID_CAT", SqlDbType.Int);
param[0].Value = ID_CAT;
param[1] = new SqlParameter("ID_PRODUCT", SqlDbType.NVarChar, 50);
param[1].Value = ID_PRODUCT;
param[2] = new SqlParameter("Label", SqlDbType.NVarChar, 50);
param[2].Value = LABEL_PRODUCT;
param[3] = new SqlParameter("QTE", SqlDbType.NVarChar, 50);
param[3].Value = QTE;
param[4] = new SqlParameter("PRICE", SqlDbType.NVarChar, 50);
param[4].Value = PRICE;
param[5] = new SqlParameter("@IMG", SqlDbType.Image);
param[5].Value = IMG;
param[6] = new SqlParameter("@criterion", SqlDbType.NVarChar, 50);
param[6].Value = criterion;
DAL.executecommand("UPDATE_PRODUCT", param);
DAL.close();
}
public void UPDATE_TRADER(string FIRST_NAME, string LAST_NAME, string TEL, string EMAIL, byte[] IMG, 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("@IMG", SqlDbType.Image);
param[4].Value = IMG;
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("UPDATE_TRADER", param);
DAL.close();
}
public void add_customer(string FIRST_NAME, string LAST_NAME, string TEL, string EMAIL, byte[] IMG, string criterion)
{
DAL.dataAccessLayer DAL = new DAL.dataAccessLayer();
DAL.open();
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("@TEL", SqlDbType.VarChar, 15);
param[2].Value = TEL;
param[3] = new SqlParameter("@EMAIL", SqlDbType.VarChar, 25);
param[3].Value = EMAIL;
param[4] = new SqlParameter("@IMG", SqlDbType.Image);
param[4].Value = IMG;
param[5] = new SqlParameter("@criterion", SqlDbType.VarChar, 50);
param[5].Value = criterion;
DAL.executecommand("add_customer", param);
DAL.close();
}
public DataTable GET_ALL_TRADERS()
{
DAL.dataAccessLayer DAL = new DAL.dataAccessLayer();
DataTable DT = new DataTable();
DT = DAL.selectdata("GET_ALL_TRADERS", null);
DAL.close();
return(DT);
}
public DataTable GET_LAST_SHOP_FOR_PRINT()
{
DAL.dataAccessLayer DAL = new DAL.dataAccessLayer();
DataTable DT = new DataTable();
DT = DAL.selectdata("GET_LAST_SHOP_FOR_PRINT", null);
DAL.close();
return(DT);
}
public DataTable GET_LAST_ORDER_ID()
{
DAL.dataAccessLayer DAL = new DAL.dataAccessLayer();
DataTable DT = new DataTable();
DT = DAL.selectdata("GET_LAST_ORDER_ID", 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 SEARCH_TRADERS(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_TRADERS", param);
DAL.close();
return(DT);
}
public DataTable VERIFYPRODUCTID(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("VERIFYPRODUCTID", 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 void DELETE_TRADERS(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_TRADERS", param);
DAL.close();
}
public DataTable GET_SHOP_DETAILS(int ID_SHOP)
{
DAL.dataAccessLayer DAL = new DAL.dataAccessLayer();
DataTable DT = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID_SHOP", SqlDbType.Int);
param[0].Value = ID_SHOP;
DT = DAL.selectdata("GET_SHOP_DETAILS", param);
DAL.close();
return(DT);
}
public DataTable SEARCHSHOP(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("SEARCHSHOP", param);
DAL.close();
return(DT);
}
public DataTable VERIFYQUANTITY(string ID_PRODUCT, double 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.Float);
param[1].Value = QTY_ENTERED;
DT = DAL.selectdata("VERIFYQUANTITY", 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.open();
DataTable DT = new DataTable();
DT = DAL.selectdata("sp_login", param);
return(DT);
}
public void EDITUSER(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("EDITUSER", param);
DAL.close();
}
public void ADD_SHOP(int ID_SHOP, DateTime DATE_ORDER, int TRADER_ID, string DESCRIPTION_ORDER, string PAYMAN)
{
DAL.dataAccessLayer DAL = new DAL.dataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@ID_SHOP", SqlDbType.Int);
param[0].Value = ID_SHOP;
param[1] = new SqlParameter("@DATE_ORDER", SqlDbType.DateTime);
param[1].Value = DATE_ORDER;
param[2] = new SqlParameter("@TRADER_ID", SqlDbType.Int);
param[2].Value = TRADER_ID;
param[3] = new SqlParameter("@DESCRIPTION_ORDER", SqlDbType.VarChar, 250);
param[3].Value = DESCRIPTION_ORDER;
param[4] = new SqlParameter("@PAYMAN", SqlDbType.VarChar, 75);
param[4].Value = PAYMAN;
DAL.executecommand("ADD_SHOP", param);
DAL.close();
}
