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 DataTable GET_ALL_PRODUCTS() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("GET_ALL_PRODUCTS",null); DAL.Close(); return Dt; }
public DataTable GetAllProducts() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable dt = new DataTable(); dt = DAL.SelectData("SP_GetAllProducts", null); DAL.Close(); return(dt); }
public DataTable get_last_order_forprint() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("get_last_order_forprint", null); DAL.Close(); return(Dt); }
//عرض public DataTable GetAllStd() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable dt = new DataTable(); dt = DAL.SelectData("GetAllStd", null); DAL.Close(); return(dt); }
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(); }
public void DELETE_JOB(int JobId) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] DeleteUserParam = new SqlParameter[1]; DeleteUserParam[0] = new SqlParameter("@jobId", SqlDbType.Int); DeleteUserParam[0].Value = JobId; DAL.ExecuteCommand("DELETE_JOB", DeleteUserParam); DAL.Close(); }
public DataTable getpatientidarchif() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable dt = DAL.SelectData("get_pid_from_archif", null); DAL.Close(); return(dt); }
public void DeleteCAR(int 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.ExecuteDml("DeleteCAR", param); DAL.Close(); }
public DataTable GET_ALL_QNAT() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable dt = new DataTable(); dt = DAL.SelectData("GET_ALL_QNAT", null); DAL.Close(); return(dt); }
public void ADD_QNAT(string qnat_descr) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@qnat_descr", SqlDbType.VarChar, 200); param[0].Value = qnat_descr; DAL.ExecuteCommand("ADD_QNAT", param); DAL.Close(); }
public DataTable GET_LAST_ORDER_ID_For_Print() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable dt = new DataTable(); dt = DAL.selectdata("GET_LAST_ORDER_ID_for_print", null); DAL.Close(); return(dt); }
public void ADD_DEPT(string dept_name) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@dept_name", SqlDbType.VarChar, 200); param[0].Value = dept_name; DAL.ExecuteCommand("ADD_DEPT", param); DAL.Close(); }
public DataTable all_lev() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable dt = new DataTable(); dt = DAL.SelectData("all_lev", null); DAL.Close(); return(dt); }
public DataTable get_All_Mgcat() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("get_All_Mgcat", null); DAL.Close(); return(Dt); }
public DataTable select_customer() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable dt = new DataTable(); dt = DAL.selectdata("get_customer", null); DAL.Close(); return(dt); }
public DataTable getAlldealers() { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); Dal.Open(); DataTable dt = new DataTable(); dt = Dal.SelectData("getAlldealers", 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 GET_ALL_PRODUCTS() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable Dt = new DataTable(); Dt = DAL.selectdata("GET_ALL_PRODUCTS", null); DAL.Close(); return(Dt); }
//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 DeleteDonation(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("DeleteDonation", param); DAL.Close(); }
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 DataTable getusers() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable dt = new DataTable(); dt = DAL.SelectData("getusers", null); DAL.Close(); return(dt); }
public DataTable GET_ALL_USERS() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable UsersTable = new DataTable(); UsersTable = DAL.SelectData("GET_USERS_TABLE", null); DAL.Close(); return(UsersTable); }
public DataTable GET_ALL_CATEGORIES() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable Dt = new DataTable(); DataTable Dt1 = new DataTable(); Dt = DAL.SelectData("GET_ALL_CATEGORIES", null); DAL.Close(); return(Dt); }
public void DELETE_Purchase_Order(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_Purchase_Order", param); DAL.Close(); }
public DataTable GET_ALL_Attend() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("GetAttend", null); DAL.Close(); return(Dt); }
public void Del_Customer(int cus_id) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@cus_id", SqlDbType.Int); param[0].Value = cus_id; DAL.ExecuteDml("Del_Customer", param); DAL.Close(); }
public DataTable GET_IMAGE_PRODUCT(string ID) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DataTable Dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50); param[0].Value = ID; Dt = DAL.SelectData("GET_IMAGE_PRODUCT", param); DAL.Close(); return Dt; }
public void Add_Users(string Name, string password, string User_Type) { Dal.Open(); SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@Name", SqlDbType.NVarChar, 50); param[0].Value = Name; param[1] = new SqlParameter("@Password", SqlDbType.NVarChar, 50); param[1].Value = password; param[2] = new SqlParameter("@User_Type", SqlDbType.NVarChar, 50); param[2].Value = User_Type; Dal.ExecuteCommand("Add_Users", param); Dal.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(); }
public DataTable GET_last_ORDER() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("GET_last_ORDER", null); DAL.Close(); return(Dt); }
public DataTable GET_LAST_PURCHASE_ID() // no enteres any parameters becouse we need every parameters. { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("MaxPurchaseID", null); DAL.Close(); return(Dt); }
public DataTable GET_ALL_CUSTOMERS() // no enteres any parameters becouse we need every parameters. { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); DataTable Dt = new DataTable(); Dt = DAL.SelectData("GetAll_Customers", null); 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.NVarChar, 50); param[0].Value = ID; param[1] = new SqlParameter("@PWD", SqlDbType.NVarChar, 50); param[1].Value = PWD; DataTable Dt = new DataTable(); Dt = DAL.SelectData("SP_LOGIN", param); DAL.Close(); return Dt; }