public void UPDATE_PRODUCTS(int ID_cat, string label_product, string ID_product,
int Qte, string Price, byte[] img)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
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, 25);
param[1].Value = ID_product;
param[2] = new SqlParameter("@LABEL", SqlDbType.VarChar, 25);
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_PRODUCTS", param);
DAL.Close();
}
public void ADD_PRODUCT(int ID_CAT, string label_peoduct, string ID_product,
int Qte, string Price, byte[] img)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
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_BRODUCT", SqlDbType.VarChar, 30);
param[1].Value = ID_product;
param[2] = new SqlParameter("@LEBAL_PRODUCT", SqlDbType.VarChar, 30);
param[2].Value = label_peoduct;
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("ADD_PRODCUT", param);
DAL.close();
}
private void MessageList_Load(object sender, EventArgs e)
{
DAL.DataAccesLayer dal = new DAL.DataAccesLayer();
List <Entities.Message> messages = new List <Entities.Message>();
messages = dal.GetMessagesFromById(1);
dataGridView1.DataSource = messages;
}
public DataTable GET_ALL_PRODUCTS()
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GET_ALL_PRODUCTS", null);
DAL.Close();
return(Dt);
}
public DataTable GET_ALL_CUSTEMORS()
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DAL.Open();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GET_ALL_CUSTEMORS", null);
DAL.Close();
return(Dt);
}
public DataTable GET_LAST_ORDER_ID()
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DAL.Open();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GET_LAST_ORDER_ID", null);
DAL.Close();
return(Dt);
}
public DataTable GET_ALL_PRODUCTS()
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DataTable DT = new DataTable();
DT = DAL.SelectDate("GET_ALL_PRODUCTS", null);
DAL.close();
return(DT);
}
public void DeleteProduct(string ID)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
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 void DEL_CUSTOMER(int ID)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
DAL.ExecuteCommand("DEL_CUSTOMER", param);
DAL.Close();
}
public DataTable VerifyProductID1(string ID)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DataTable Dt = new DataTable();
SqlParameter[] Param = new SqlParameter[1];
Param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
Param[0].Value = ID;
Dt = DAL.SelectData("VerifyProductID1", Param);
DAL.Close();
return(Dt);
}
public DataTable GET_PRODUCT_IMAGE(string ID)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DataTable Dt = new DataTable();
SqlParameter[] Param = new SqlParameter[1];
Param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 25);
Param[0].Value = ID;
Dt = DAL.SelectData("GET_PRODUCT_IMAGE", Param);
DAL.Close();
return(Dt);
}
public DataTable SEARCH_CUSTOMER(string C)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DataTable Dt = new DataTable();
SqlParameter[] Param = new SqlParameter[1];
Param[0] = new SqlParameter("@c", SqlDbType.VarChar, 50);
Param[0].Value = C;
Dt = DAL.SelectData("SEARCH_CUSTOMER", Param);
DAL.Close();
return(Dt);
}
public DataTable Get_IMAGE_Product(string ID)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DataTable DT = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
DT = DAL.SelectDate("Get_IMAGE_Product", param);
DAL.close();
return(DT);
}
public DataTable LOGIN(string ID, string PWD)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
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);
}
public void ADD_CUSTOMER(string FIRST_NAME, string LAST_NAME,
string TEL)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[3];
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;
DAL.ExecuteCommand("ADD_CUSTOMER", param);
DAL.Close();
}
public DataTable LOGIN(string ID, string DWS)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
param[1] = new SqlParameter("@BWS", SqlDbType.VarChar, 50);
param[1].Value = DWS;
DataTable DT = new DataTable();
DT = DAL.SelectDate("SP_LOGIN", param);
DAL.close();
return(DT);
}
public void EDIT_CUSTOMER(string FIRST_NAME, string LAST_NAME,
string TEL, int ID)
{
DAL.DataAccesLayer DAL = new DAL.DataAccesLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[4];
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("@ID", SqlDbType.Int);
param[3].Value = ID;
DAL.ExecuteCommand("EDIT_CUSTOME", param);
DAL.Close();
}
public bool AddUser(string UserName, string Password, string FullName)
{
dal = new DAL.DataAccesLayer();
return(dal.AddUser(UserName, Password, FullName));
}
public User GetUser(int Id)
{
dal = new DAL.DataAccesLayer();
return(dal.GetUser(Id));
}
