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 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 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 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();
}
