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 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.ExcuteCommand("SP_DeleteProduct", 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 void DELETE_EMPLOYEE(string id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] DeleteUserParam = new SqlParameter[1];
DeleteUserParam[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
DeleteUserParam[0].Value = id;
DAL.ExecuteCommand("DELETE_EMPLOYEE", DeleteUserParam);
DAL.Close();
}
public void SupprimerExamen(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("SupprimerExamen", param);
dal.Close();
}
public DataTable GET_ALL_CATEGORIES() // no enteres any parameters becouse we need every parameters.
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("AllCategory", null);
DAL.Close();
return(Dt);
}
public void DELETE_DEPARTMENT(int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] DeleteUserParam = new SqlParameter[1];
DeleteUserParam[0] = new SqlParameter("@ID", SqlDbType.Int);
DeleteUserParam[0].Value = id;
DAL.ExecuteCommand("DELETE_DEPARTMENT", DeleteUserParam);
DAL.Close();
}
public DataTable GET_ALL_CATEGORIES()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
DataTable Dt = new DataTable();
Dt = DAL.selectdata("GET_ALL_CATEGORIES", null);
DAL.Close();
return(Dt);
}
public void DELETE_USER(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("DELETE_USER", param);
DAL.Close();
}
public DataTable GET_ALL_COMPANY() // 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_ItemsCompany", null);
DAL.Close();
return(Dt);
}
public void DELETE_Suppliers(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_Suppliers", param);
DAL.Close();
}
public void SupprimerStagiair(int id)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", SqlDbType.VarChar, 10);
param[0].Value = id;
dal.ExecuteCommand("SupprimerStagiaire", param);
dal.Close();
}
public void INSERT_JOB_TIT(string jobTit)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] InsertUserParam = new SqlParameter[1];
InsertUserParam[0] = new SqlParameter("@jobTit", SqlDbType.VarChar, 50);
InsertUserParam[0].Value = jobTit;
DAL.ExecuteCommand("INSERT_JOB_TIT", InsertUserParam);
DAL.Close();
}
public DataTable tot_cost(DateTime date)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@visit_date", SqlDbType.Date);
param[0].Value = date;
DAL.Open();
DataTable dt = DAL.SelectData("tot_cost", param);
DAL.Close();
return(dt);
}
public DataTable get_month(DateTime date)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@visit_date", SqlDbType.DateTime);
param[0].Value = date;
DAL.Open();
DataTable dt = DAL.SelectData("patients_per_month", param);
DAL.Close();
return(dt);
}
public DataTable searchpatient(string name)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@name", SqlDbType.NVarChar);
param[0].Value = name;
DAL.Open();
DataTable dt = DAL.SelectData("get_patient_by_name", param);
DAL.Close();
return(dt);
}
public void DELETE_CATEGORY(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("DELETE_CATEGORY", param);
DAL.Close();
}
public DataTable MAX_R_ORDER_ID()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("MaxID_ReturnItem", null);
DAL.Close();
return(Dt);
}
public DataTable GET_R_order() // 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_ReturnItem", null);
DAL.Close();
return(Dt);
}
public void update_warehouse(string warehouse_name)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@warehouse_name", SqlDbType.VarChar, 50);
param[0].Value = warehouse_name;
dal.ExecuteCommand("update_warehouse", param);
dal.Close();
}
//Get Picture of product
public DataTable GetPicture(string ID)
{
DAL.DataAccessLayer Con = new DAL.DataAccessLayer();
DataTable DT = new DataTable();
Con.Open();
SqlParameter[] Param = new SqlParameter[1];
Param[0] = new SqlParameter("@ID", SqlDbType.VarChar);
Param[0].Value = ID;
DT = Con.SelectData("GetPicture", Param);
return(DT);
}
public void add_patient_treats(int pid, int tid)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@pid", SqlDbType.Int);
param[0].Value = pid;
param[1] = new SqlParameter("@tid", SqlDbType.Int);
param[1].Value = tid;
DAL.Open();
DAL.excutedata("insert_into_patient_treat", param);
DAL.Close();
}
public DataTable get_reversnum(DateTime visitdate)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@visit_date", SqlDbType.DateTime);
param[0].Value = visitdate;
DAL.Open();
DataTable dt = DAL.SelectData("get_reservnum", param);
DAL.Close();
return(dt);
}
public void deletestudent(string STUDENT_ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Student_ID", SqlDbType.VarChar, 50);
param[0].Value = STUDENT_ID;
DAL.ExecuteCommand("deletestudent", param);
DAL.Close();
}
public DataTable SearchUser(string Search)
{
SqlParameter[] Param = new SqlParameter[1];
Param[0] = new SqlParameter("@Search", SqlDbType.VarChar, 50);
Param[0].Value = Search;
Con.Open();
DataTable DT = new DataTable();
DT = Con.SelectData("SearchUser", Param);
Con.Close();
return(DT);
}
public DataTable gettreaname(int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@pid", SqlDbType.Int);
param[0].Value = id;
DAL.Open();
DataTable dt = DAL.SelectData("get_treat_to_rosheta", param);
DAL.Close();
return(dt);
}
public DataTable get_patient_history(int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@pid", SqlDbType.Int);
param[0].Value = id;
DAL.Open();
DataTable dt = DAL.SelectData("get_patient_report", param);
DAL.Close();
return(dt);
}
public DataTable delete_user(int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", SqlDbType.Int);
param[0].Value = id;
DAL.Open();
DataTable dt = DAL.SelectData("delete_user", param);
DAL.Close();
return(dt);
}
public void Update_Member_Status(int ID, string Status)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@Status", SqlDbType.NVarChar, 50);
param[1].Value = Status;
DAL.ExecuteCommand("ChangeMemberStatus", param);
DAL.Close();
}
public DataTable Admins_Search(String TxtSearch)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@TxtSearch", SqlDbType.NVarChar, 50);
param[0].Value = TxtSearch;
DAL.Open();
DataTable dt = new DataTable();
dt = DAL.SelectData("Admins_Search", param);
return(dt);
}
public void delete_bank(string bank_name)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@bank_name", SqlDbType.VarChar, 50);
param[0].Value = bank_name;
dal.ExecuteCommand("delete_bank", param);
dal.Close();
}
//public void inserttable(string name1, string nation1, string register_year1, string grad_year1, string sum_mark1, string aver1, string result1, string note1 )
//{ // @name1 nvarchar(50),
// //@nation1 nvarchar(50),
// //@register_year1 nvarchar(50),
// //@grad_year1 nvarchar(50),
// //@sum_mark1 nvarchar(50),
// //@aver1 nvarchar(50),
// //@result1 nvarchar(50),
// //@note1 nvarchar(50)
// DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
// DAL.Open();
// SqlParameter[] param = new SqlParameter[8];
// param[0] = new SqlParameter("name1", SqlDbType.NVarChar, 50);
// param[0].Value = name1;
// param[1] = new SqlParameter("nation1", SqlDbType.NVarChar, 50);
//param[1].Value = nation1;
// param[2] = new SqlParameter("register_year1", SqlDbType.NVarChar, 50);
// param[2].Value = register_year1;
// param[3] = new SqlParameter("grad_year1", SqlDbType.NVarChar, 50);
//param[3].Value = grad_year1;
//param[4] = new SqlParameter("sum_mark1", SqlDbType.NVarChar, 50);
//param[4].Value = sum_mark1;
//param[5] = new SqlParameter("aver1", SqlDbType.NVarChar, 50);
//param[5].Value = aver1;
// param[6] = new SqlParameter("result1", SqlDbType.NVarChar, 50);
// param[6].Value = result1;
//param[7] = new SqlParameter("note1", SqlDbType.NVarChar, 50);
// param[7].Value = note1;
// DAL.ExecuteCommand("inserttable", param);
// DAL.Close();
//}
public void ADD_MINUTESss3(string MINUTES_ID, string STUDY_YEAR, String DAY, String MINUTES_HISTORY, string COLLEG_NOTE, string DEPARTMENT, string REQUEST, string STUDENT_NAME, string UNIVERSITY_BASED, string UNIVERSITY, string STUDY, String NOTES, string SPECIALIZATION, String MINUTES_DECISION)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[14];
param[0] = new SqlParameter("MINUTES_ID", SqlDbType.NVarChar, 50);
param[0].Value = MINUTES_ID;
param[1] = new SqlParameter("STUDY_YEAR", SqlDbType.NVarChar, 50);
param[1].Value = STUDY_YEAR;
param[2] = new SqlParameter("DAY", SqlDbType.NVarChar, 50);
param[2].Value = DAY;
param[3] = new SqlParameter("MINUTES_HISTORY", SqlDbType.NVarChar, 50);
param[3].Value = MINUTES_HISTORY;
param[4] = new SqlParameter("COLLEG_NOTE", SqlDbType.NVarChar, 50);
param[4].Value = COLLEG_NOTE;
param[5] = new SqlParameter("DEPARTMENT", SqlDbType.NVarChar, 50);
param[5].Value = DEPARTMENT;
param[6] = new SqlParameter("REQUEST", SqlDbType.NVarChar, 50);
param[6].Value = REQUEST;
param[7] = new SqlParameter("STUDENT_NAME", SqlDbType.NVarChar, 50);
param[7].Value = STUDENT_NAME;
param[8] = new SqlParameter("UNIVERSITY_BASED", SqlDbType.NVarChar, 50);
param[8].Value = UNIVERSITY_BASED;
param[9] = new SqlParameter("UNIVERSITY", SqlDbType.NVarChar, 50);
param[9].Value = UNIVERSITY;
param[10] = new SqlParameter("STUDY", SqlDbType.NVarChar, 50);
param[10].Value = STUDY;
param[11] = new SqlParameter("NOTES", SqlDbType.NVarChar);
param[11].Value = NOTES;
param[12] = new SqlParameter("SPECIALIZATION", SqlDbType.NVarChar, 50);
param[12].Value = SPECIALIZATION;
param[13] = new SqlParameter("MINUTES_DECISION", SqlDbType.NVarChar);
param[13].Value = MINUTES_DECISION;
DAL.ExecuteCommand("ADD_MINUTESss3", param);
DAL.Close();
}
