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