public void Ajouter_Groupe(int id, string groupe, int filiere, int effectife, string annee, string Niveau)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.Open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = id;
param[1] = new SqlParameter("@Groupe", SqlDbType.VarChar, 10);
param[1].Value = groupe;
param[2] = new SqlParameter("@Filiere", SqlDbType.Int);
param[2].Value = filiere;
param[3] = new SqlParameter("@Effectife", SqlDbType.Int);
param[3].Value = effectife;
param[4] = new SqlParameter("@Annee", SqlDbType.VarChar, 10);
param[4].Value = annee;
param[5] = new SqlParameter("@Niveau", SqlDbType.VarChar, 10);
param[5].Value = Niveau;
dal.ExecuteCommand("Ajouter_Groupe", param);
dal.Close();
}
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, int CUSTOMER_ID,
DateTime DATE_ORDER, float DIISCOUNT, string TOTAL_AMOUNT,
string TOTAL_PAYMENT, string AMOUNT_DUE, string SALESMAN, string Notes)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[9];
param[0] = new SqlParameter("@ID_ORDER", SqlDbType.Int);
param[0].Value = ID_ORDER;
param[1] = new SqlParameter("@CUSTOMER_ID", SqlDbType.Int);
param[1].Value = CUSTOMER_ID;
param[2] = new SqlParameter("@DATE_ORDER", SqlDbType.DateTime);
param[2].Value = DATE_ORDER;
param[3] = new SqlParameter("@DIISCOUNT", SqlDbType.Float);
param[3].Value = DIISCOUNT;
param[4] = new SqlParameter("@TOTAL_AMOUNT", SqlDbType.VarChar, 50);
param[4].Value = TOTAL_AMOUNT;
param[5] = new SqlParameter("@SALESMAN", SqlDbType.VarChar, 75);
param[5].Value = SALESMAN;
param[6] = new SqlParameter("@Notes", SqlDbType.NText);
param[6].Value = Notes;
param[7] = new SqlParameter("@TOTAL_PAYMENT", SqlDbType.VarChar, 50);
param[7].Value = TOTAL_PAYMENT;
param[8] = new SqlParameter("@AMOUNT_DUE", SqlDbType.VarChar, 50);
param[8].Value = AMOUNT_DUE;
DAL.ExecuteCommand("ADD_ORDER", param);
DAL.Close();
}
public void ADD_ORDER2(int ID_ORDER,
DateTime DATE_ORDER, double TOTAL_PAYMENT, double AMOUNT_DUE, string SALESMAN, string Notes)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[6];
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("@SALESMAN", SqlDbType.VarChar, 75);
param[2].Value = SALESMAN;
param[3] = new SqlParameter("@Notes", SqlDbType.NText);
param[3].Value = Notes;
param[4] = new SqlParameter("@TOTAL_PAYMENT", SqlDbType.Money);
param[4].Value = TOTAL_PAYMENT;
param[5] = new SqlParameter("@AMOUNT_DUE", SqlDbType.Money);
param[5].Value = AMOUNT_DUE;
DAL.ExecuteCommand("ADD_ORDER2", param);
DAL.Close();
}
public void EDIT_Inventory_Transactions(int ID, int Transaction_Type, DateTime Transaction_Created_Date,
string ID_PRODUCT, int QTE, int Purchase_Order_ID, int ID_ORDER, string Criterion)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@Transaction_Type", SqlDbType.Int);
param[1].Value = Transaction_Type;
param[2] = new SqlParameter("@Transaction_Created_Date", SqlDbType.DateTime);
param[2].Value = Transaction_Created_Date;
param[3] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 30);
param[3].Value = ID_PRODUCT;
param[4] = new SqlParameter("@QTE", SqlDbType.Int);
param[4].Value = QTE;
param[5] = new SqlParameter("@Purchase_Order_ID", SqlDbType.Int);
param[5].Value = Purchase_Order_ID;
param[6] = new SqlParameter("@ID_ORDER", SqlDbType.Int);
param[6].Value = ID_ORDER;
param[7] = new SqlParameter("@Criterion", SqlDbType.VarChar, 25);
param[7].Value = Criterion;
DAL.ExecuteCommand("EDIT_Inventory_Transactions", param);
DAL.Close();
}
public void ADD_CUSTOMER(string First_Name, string Last_Name, string Tel,
string Email, byte[] Picture, 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.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;
DAL.ExecuteCommand("ADD_CUSTOMER", param);
DAL.Close();
}
public void ADD_CUSTOMER(string Company, string First_Name, string Last_Name,
string Email, string Mobile, string Address, string Notes)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@Company", SqlDbType.NVarChar, 50);
param[0].Value = Company;
param[1] = new SqlParameter("@First_Name", SqlDbType.NVarChar, 50);
param[1].Value = First_Name;
param[2] = new SqlParameter("@Last_Name", SqlDbType.NVarChar, 50);
param[2].Value = Last_Name;
param[3] = new SqlParameter("@Email_Address", SqlDbType.NVarChar, 50);
param[3].Value = Email;
param[4] = new SqlParameter("@Mobile_Phone", SqlDbType.NVarChar, 25);
param[4].Value = Mobile;
param[5] = new SqlParameter("@Address", SqlDbType.NText);
param[5].Value = Address;
param[6] = new SqlParameter("@Notes", SqlDbType.NText);
param[6].Value = Notes;
DAL.ExecuteCommand("ADD_CUSTOMER", param);
DAL.Close();
}
public void EDIT_Purchase_DETAILS(int ID_ORDER, string ID_PRODUCT,
int QTE, string PRICE, string AMOUNT,
int Inventory_ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@ID_ORDER", SqlDbType.Int);
param[0].Value = ID_ORDER;
param[1] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 30);
param[1].Value = ID_PRODUCT;
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("@AMOUNT", SqlDbType.VarChar, 50);
param[4].Value = AMOUNT;
param[5] = new SqlParameter("@Inventory_ID", SqlDbType.Int);
param[5].Value = Inventory_ID;
DAL.ExecuteCommand("EDIT_Purchase_DETAILS", param);
DAL.Close();
}
public void ADD_PROUDCT(int ID_CAT, string ID_PRODUCT, string LABEL_PRODUCT, int QTE_IN_STOCK, string PRICE, byte[] IMAGE_PRODUCT)
{
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.NVarChar,50);
param[1].Value = ID_PRODUCT;
param[2] = new SqlParameter("@LABEL_PRODUCT", SqlDbType.NVarChar,50);
param[2].Value = LABEL_PRODUCT;
param[3] = new SqlParameter("@QTE_IN_STOCK", SqlDbType.Int);
param[3].Value = QTE_IN_STOCK;
param[4] = new SqlParameter("@PRICE", SqlDbType.NVarChar,50);
param[4].Value = PRICE;
param[5] = new SqlParameter("@IMAGE_PRODUCT", SqlDbType.Image);
param[5].Value = IMAGE_PRODUCT;
DAL.ExecuteCommand("ADD_PROUDCT", param);
DAL.Close();
}
public void ADD_Purchase_Order_Details(int ID_ORDER, string ID_PRODUCT,
int QTE, string PRICE, string TOTAL_AMOUNT, DateTime Date_Received, int Inventory_ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@ID_ORDER", SqlDbType.Int);
param[0].Value = ID_ORDER;
param[1] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 30);
param[1].Value = ID_PRODUCT;
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("@TOTAL_AMOUNT", SqlDbType.VarChar, 50);
param[4].Value = TOTAL_AMOUNT;
param[5] = new SqlParameter("@Date_Received", SqlDbType.DateTime);
param[5].Value = Date_Received;
// param[6] = new SqlParameter("@Posted_To_Inventory", SqlDbType.Bit);
// param[6].Value = Posted_To_Inventory;
param[6] = new SqlParameter("@Inventory_ID", SqlDbType.Int);
param[6].Value = Inventory_ID;
DAL.ExecuteCommand("ADD_Purchase_Order_Details", param);
DAL.Close();
}
public void UPDATE_CUSTOMER(string fname, string lname,
string tel, string email, int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] parm = new SqlParameter[5];
parm[0] = new SqlParameter("@F_NAME", SqlDbType.NVarChar, 50);
parm[0].Value = fname;
parm[1] = new SqlParameter("@L_NAME", SqlDbType.NVarChar, 50);
parm[1].Value = lname;
parm[2] = new SqlParameter("@PHONE", SqlDbType.NVarChar, 50);
parm[2].Value = tel;
parm[3] = new SqlParameter("@EMAIL", SqlDbType.NVarChar, 50);
parm[3].Value = email;
parm[4] = new SqlParameter("@ID", SqlDbType.Int);
parm[4].Value = id;
DAL.ExecuteCommand("UPDATE_CUSTOMER", parm);
DAL.close();
}
public void EDIT_COSTOMERS(string First_Name, string Last_Name, string Tel, string Email, byte[] Picture, int ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@First_Name", SqlDbType.VarChar, 50);
param[0].Value = First_Name;
param[1] = new SqlParameter("@Last_Name", SqlDbType.VarChar, 50);
param[1].Value = Last_Name;
param[2] = new SqlParameter("@Tel", SqlDbType.NChar, 20);
param[2].Value = Tel;
param[3] = new SqlParameter("@Email", SqlDbType.VarChar, 50);
param[3].Value = Email;
param[4] = new SqlParameter("@Picture", SqlDbType.Image);
param[4].Value = Picture;
param[5] = new SqlParameter("@ID", SqlDbType.Int);
param[5].Value = ID;
DAL.ExecuteCommand("EDIT_COSTOMERS ", param);
}
public void ADD_TAKSET(int id, string rece_price, string total_in_cash, string RABHH, string day, string monthly_price, string mo, string ye)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] parm = new SqlParameter[8];
parm[0] = new SqlParameter("@ID_CUST", SqlDbType.Int);
parm[0].Value = id;
parm[1] = new SqlParameter("@REC_PRICE", SqlDbType.NVarChar, 50);
parm[1].Value = rece_price;
parm[2] = new SqlParameter("@TOTAL_IN_CASH", SqlDbType.NVarChar, 50);
parm[2].Value = total_in_cash;
parm[3] = new SqlParameter("@RABHH", SqlDbType.NVarChar, 50);
parm[3].Value = RABHH;
parm[4] = new SqlParameter("@day", SqlDbType.NVarChar, 50);
parm[4].Value = day;
parm[5] = new SqlParameter("@monthly_price", SqlDbType.NVarChar, 50);
parm[5].Value = monthly_price;
parm[6] = new SqlParameter("@MONTH", SqlDbType.NVarChar, 50);
parm[6].Value = mo;
parm[7] = new SqlParameter("@YEAR", SqlDbType.NVarChar, 50);
parm[7].Value = ye;
DAL.ExecuteCommand("ADD_TAKSET", parm);
DAL.close();
}
public void ADD_ORDER_DETAILS(string IDPRODUCT, int ID_order, int QNT, string PRICE, float @DESCOUNT, 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, 50);
param[0].Value = IDPRODUCT;
param[1] = new SqlParameter("@ID_ORDER", SqlDbType.Int);
param[1].Value = ID_order;
param[2] = new SqlParameter("@QNT", SqlDbType.Int);
param[2].Value = QNT;
param[3] = new SqlParameter("@PRICE", SqlDbType.VarChar, 50);
param[3].Value = PRICE;
param[4] = new SqlParameter("@DESCOUNT", SqlDbType.Float);
param[4].Value = DESCOUNT;
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 ADD_ORDER(int ID_order, DateTime DATE_ORDER, int CUSTOMER, string DESCRIPTION_ORDER, string SALES_MAN)
{
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", SqlDbType.Int);
param[2].Value = CUSTOMER;
param[3] = new SqlParameter("@DESCRIPTION_ORDER", SqlDbType.VarChar, 250);
param[3].Value = DESCRIPTION_ORDER;
param[4] = new SqlParameter("@SALES_MAN", SqlDbType.VarChar, 250);
param[4].Value = SALES_MAN;
DAL.ExecuteCommand("ADD_ORDER", param);
DAL.Close();
}
/* @Post_Oper_FollowID int,
* @Surgery_id int,
* @Patient_id int,
* @NoFile int,
*/
public void InsertPost_Operative_Follow_up(int Post_Oper_FollowID, int Surgery_id, int NoFile, string VA, string PH, string Date, string Astigmatism, string Corneal_Cause, string Corneal_Opacity, string C_Odema, string Retinal_Disease, string Glaucoma, string Others, int Patient_id, int User_id, string Note1)
{
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[16];
param[0] = new SqlParameter("@VA", SqlDbType.Text);
param[0].Value = VA;
param[1] = new SqlParameter("@Date", SqlDbType.NVarChar, 30);
param[1].Value = Date;
param[2] = new SqlParameter("@PH", SqlDbType.Text);
param[2].Value = PH;
param[3] = new SqlParameter("@Astigmatism", SqlDbType.Text);
param[3].Value = Astigmatism;
param[4] = new SqlParameter("@Corneal_Cause", SqlDbType.Text);
param[4].Value = Corneal_Cause;
param[5] = new SqlParameter("@Corneal_Opacity", SqlDbType.Text);
param[5].Value = Corneal_Opacity;
param[6] = new SqlParameter("@C_Odema", SqlDbType.Text);
param[6].Value = C_Odema;
param[7] = new SqlParameter("@Retinal_Disease", SqlDbType.Text);
param[7].Value = Retinal_Disease;
param[8] = new SqlParameter("@Glaucoma", SqlDbType.Text);
param[8].Value = Glaucoma;
param[9] = new SqlParameter("@Others", SqlDbType.Text);
param[9].Value = Others;
param[10] = new SqlParameter("@Patient_id", SqlDbType.Int);
param[10].Value = Patient_id;
param[11] = new SqlParameter("@User_id", SqlDbType.Int);
param[11].Value = User_id;
param[12] = new SqlParameter("@Note1", SqlDbType.Text);
param[12].Value = Note1;
param[13] = new SqlParameter("@Post_Oper_FollowID", SqlDbType.Int);
param[13].Value = Post_Oper_FollowID;
param[14] = new SqlParameter("@Surgery_id", SqlDbType.Int);
param[14].Value = Surgery_id;
param[15] = new SqlParameter("@NoFile", SqlDbType.Int);
param[15].Value = NoFile;
Dal.CheckIsOpen();
Dal.ExecuteCommand("InsertPost_Operative_Follow_up", param);
Dal.CheckIsClosed();
}
public void Update_Visits(int id_Chronic, string Name)
{
Dal.Open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID_chronic", SqlDbType.Int);
param[0].Value = id_Chronic;
param[1] = new SqlParameter("@Name_Chronic", SqlDbType.NVarChar, 200);
param[1].Value = Name;
Dal.ExecuteCommand("Update_chronic", param);
Dal.Close();
}
public void delete_SurgeryPrices(int SurgeryPrice_id)
{
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
SqlParameter[] pr = new SqlParameter[1];
pr[0] = new SqlParameter("@SurgeryPrice_id", SqlDbType.Int);
pr[0].Value = SurgeryPrice_id;
Dal.ExecuteCommand("delete_SurgeryPrices", pr);
}
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);
}
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);
}
public DataTable search_SurgeryPrices(int SurgeryPrice_id)
{
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
SqlParameter[] pr = new SqlParameter[1];
pr[0] = new SqlParameter("@SurgeryPrice_id", SqlDbType.Int);
pr[0].Value = SurgeryPrice_id;
Dal.ExecuteCommand("search_SurgeryPrices", pr);
return(dt);
}
public void DELETE_DEVICE(int r_id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_R_ID", r_id);
DAL.ExecuteCommand("DELETE_DEVICE", param);
DAL.CloseConnection();
}
public void update_category(string cate_name, string cate_description, string sell_price, string discount, string less_price
, string classification, string barcode, string cate_code, string another_cate_code, string less_quantity, byte[] cate_image,
string no_quantity, string fast_cate, string unused, string unit)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.Open();
SqlParameter[] param = new SqlParameter[15];
param[0] = new SqlParameter("@cate_name", SqlDbType.VarChar, 50);
param[0].Value = cate_name;
param[1] = new SqlParameter("@cate_description", SqlDbType.Text);
param[1].Value = cate_description;
param[2] = new SqlParameter("@sell_price", SqlDbType.VarChar, 30);
param[2].Value = sell_price;
param[3] = new SqlParameter("@discount", SqlDbType.NChar, 10);
param[3].Value = discount;
param[4] = new SqlParameter("@less_price", SqlDbType.VarChar, 30);
param[4].Value = less_price;
param[5] = new SqlParameter("@classification", SqlDbType.VarChar, 30);
param[5].Value = classification;
param[6] = new SqlParameter("@barcode", SqlDbType.Text);
param[6].Value = barcode;
param[7] = new SqlParameter("@cate_code", SqlDbType.Text);
param[7].Value = cate_code;
param[8] = new SqlParameter("@another_cate_code", SqlDbType.Text);
param[8].Value = another_cate_code;
param[9] = new SqlParameter("@less_quantity", SqlDbType.NChar, 10);
param[9].Value = less_quantity;
param[10] = new SqlParameter("@cate_image", SqlDbType.Image, 5000);
param[10].Value = cate_image;
param[11] = new SqlParameter("@no_quantity", SqlDbType.NChar, 10);
param[11].Value = no_quantity;
param[12] = new SqlParameter("@fast_cate", SqlDbType.NChar, 10);
param[12].Value = fast_cate;
param[13] = new SqlParameter("@unused", SqlDbType.NChar, 10);
param[13].Value = unused;
param[14] = new SqlParameter("@unit", SqlDbType.NChar, 10);
param[14].Value = unit;
dal.ExecuteCommand("update_category", param);
dal.Close();
}
public void DLT_ORDER_MONEY(int ID_MONEY)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.ConOpen();
SqlParameter[] PARAM = new SqlParameter[1];
PARAM[0] = new SqlParameter("@ID_MONEY", SqlDbType.Int);
PARAM[0].Value = ID_MONEY;
dal.ExecuteCommand("DLT_ORDER_MONEY", PARAM);
dal.ConClose();
}
public void AddClient(int ID_Customer, string First_Name, string Second_Name, int Telephone,
string Email, byte[] Pic)
{
SqlParameter[] Param = new SqlParameter[6];
Param[0] = new SqlParameter("@ID_Customer", SqlDbType.Int);
Param[0].Value = ID_Customer;
Param[1] = new SqlParameter("@First_Name", SqlDbType.VarChar);
Param[1].Value = First_Name;
Param[2] = new SqlParameter("@Second_Name", SqlDbType.VarChar);
Param[2].Value = Second_Name;
Param[3] = new SqlParameter("@Telephone", SqlDbType.NChar);
Param[3].Value = Telephone;
Param[4] = new SqlParameter("@Email", SqlDbType.VarChar);
Param[4].Value = Email;
Param[5] = new SqlParameter("@Image_Customer", SqlDbType.Image);
Param[5].Value = Pic;
Conn.ExecuteCommand("AddClient", Param);
}
public void BLOCKUSR(int USR_ID)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.ConOpen();
SqlParameter[] PARAM = new SqlParameter[1];
PARAM[0] = new SqlParameter("@USR_ID", SqlDbType.Int);
PARAM[0].Value = USR_ID;
dal.ExecuteCommand("BLOCKUSR", PARAM);
dal.ConClose();
}
public void DeleteMember(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("DeleteMember", param);
DAL.Close();
}
public void DLT_PAID_SPENT_DOCS(int ID)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.ConOpen();
SqlParameter[] PARAM = new SqlParameter[1];
PARAM[0] = new SqlParameter("@ID", SqlDbType.Int);
PARAM[0].Value = ID;
dal.ExecuteCommand("DLT_PAID_SPENT_DOCS", PARAM);
dal.ConClose();
}
public void user_author(bool del)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("del", SqlDbType.NVarChar, 50);
param[0].Value = del;
DAL.ExecuteCommand("user_author", param);
DAL.Close();
}
public void DELETE_EMPLOYEE_DOC(string id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] DeleteDocParam = new SqlParameter[1];
DeleteDocParam[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
DeleteDocParam[0].Value = id;
DAL.ExecuteCommand("DELETE_EMPLOYEE_DOC", DeleteDocParam);
DAL.Close();
}
//Method To Delete new product
public void DeleteProduct(string ID)
{
DAL.DataAccessLayer Con = new DAL.DataAccessLayer();
Con.Open();
SqlParameter[] Param = new SqlParameter[1];
Param[0] = new SqlParameter("@ID", SqlDbType.VarChar);
Param[0].Value = ID;
Con.ExecuteCommand("DeleteProduct", Param);
Con.Close();
}
public void DELETE_PRODUCT(string ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50);
param[0].Value = ID;
DAL.ExecuteCommand("DELETE_PRODUCT", param);
DAL.Close();
}
