public void add_result(int reservation_id, string name_en, string result, string normal, string comment, string other)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@reservation_id", SqlDbType.Int);
param[0].Value = reservation_id;
param[1] = new SqlParameter("@name_en", SqlDbType.NVarChar, 100);
param[1].Value = name_en;
param[2] = new SqlParameter("@result", SqlDbType.NVarChar, 100);
param[2].Value = result;
param[3] = new SqlParameter("@normal", SqlDbType.NVarChar, 100);
param[3].Value = normal;
param[4] = new SqlParameter("@comment", SqlDbType.NVarChar, 100);
param[4].Value = comment;
param[5] = new SqlParameter("@other", SqlDbType.NVarChar, 100);
param[5].Value = other;
dal.executeCommand("add_result", param);
dal.close();
}
//***********************************تعديل *********************************
public void edit_patient(string pat_name, string pat_phone, string pat_address, int pat_age, string unit, string pat_emile, int id)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@name", SqlDbType.NVarChar, 100);
param[0].Value = pat_name;
param[1] = new SqlParameter("@phone", SqlDbType.NVarChar, 100);
param[1].Value = pat_phone;
param[2] = new SqlParameter("@address", SqlDbType.NVarChar, 100);
param[2].Value = pat_address;
param[3] = new SqlParameter("@age", SqlDbType.Int);
param[3].Value = pat_age;
param[4] = new SqlParameter("@unit", SqlDbType.NVarChar, 50);
param[4].Value = unit;
param[5] = new SqlParameter("@email", SqlDbType.NVarChar, 100);
param[5].Value = pat_emile;
param[6] = new SqlParameter("@id", SqlDbType.Int, 100);
param[6].Value = id;
dal.executeCommand("edit_patient", param);
dal.close();
}
//***********************************تعديل ********************************
public void UpDate_CONTRACT(string con_name, string con_specialization, string con_add, string con_phone, string con_mail,
string con_dis, int id)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@contractor_name", SqlDbType.NVarChar, 100);
param[0].Value = con_name;
param[1] = new SqlParameter("@con_specialization", SqlDbType.NVarChar, 100);
param[1].Value = con_specialization;
param[2] = new SqlParameter("@contractor_address", SqlDbType.NVarChar, 100);
param[2].Value = con_add;
param[3] = new SqlParameter("@contractor_phone", SqlDbType.VarChar, 50);
param[3].Value = con_phone;
param[4] = new SqlParameter("@contractor_email", SqlDbType.NVarChar, 50);
param[4].Value = con_mail;
param[5] = new SqlParameter("@con_discount", SqlDbType.VarChar, 50);
param[5].Value = con_dis;
param[6] = new SqlParameter("@contractor_id", SqlDbType.Int);
param[6].Value = id;
dal.executeCommand("UpDate_CONTRACT", param);
dal.close();
}
public void add_reservation(string reservation_date, int patient_id, string doctor_name, double price, double discount, double total, double paid, double rest)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@reservation_date", SqlDbType.Date);
param[0].Value = reservation_date;
param[1] = new SqlParameter("@patient_id", SqlDbType.Int);
param[1].Value = patient_id;
param[2] = new SqlParameter("@doctor_name", SqlDbType.NVarChar, 100);
param[2].Value = doctor_name;
param[3] = new SqlParameter("@price", SqlDbType.Float);
param[3].Value = price;
param[4] = new SqlParameter("@discount", SqlDbType.Float);
param[4].Value = discount;
param[5] = new SqlParameter("@total", SqlDbType.Float);
param[5].Value = total;
param[6] = new SqlParameter("@paid", SqlDbType.Float);
param[6].Value = paid;
param[7] = new SqlParameter("@rest", SqlDbType.Float);
param[7].Value = rest;
dal.executeCommand("add_reservation", param);
dal.close();
}
public void Add_analysis(string name_en, string analysis_price, string how_to_analysis, string analysis_time, string result, string notes)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@name_en", SqlDbType.NVarChar, 100);
param[0].Value = name_en;
param[1] = new SqlParameter("@analysis_price", SqlDbType.VarChar, 50);
param[1].Value = analysis_price;
param[2] = new SqlParameter("@how_to_analysis", SqlDbType.NVarChar, 100);
param[2].Value = how_to_analysis;
param[3] = new SqlParameter("@analysis_time", SqlDbType.NVarChar, 100);
param[3].Value = analysis_time;
param[4] = new SqlParameter("@result", SqlDbType.NVarChar, 100);
param[4].Value = result;
param[5] = new SqlParameter("@notes", SqlDbType.NVarChar, 200);
param[5].Value = notes;
dal.executeCommand("Add_analysis", param);
dal.close();
}
public void Update_ExLab(int ExLid, string Exlname, string ExLaddress, string ExLphone, string ExLemail, string ExLdiscount)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@EXLid", SqlDbType.Int);
param[0].Value = ExLid;
param[1] = new SqlParameter("@EXLname", SqlDbType.NVarChar, 100);
param[1].Value = Exlname;
param[2] = new SqlParameter("@EXLaddress", SqlDbType.NVarChar, 100);
param[2].Value = ExLaddress;
param[3] = new SqlParameter("@EXLphone", SqlDbType.VarChar, 50);
param[3].Value = ExLphone;
param[4] = new SqlParameter("@EXLemail", SqlDbType.NVarChar, 100);
param[4].Value = ExLemail;
param[5] = new SqlParameter("@EXLdiscount", SqlDbType.VarChar, 50);
param[5].Value = ExLdiscount;
dal.executeCommand("UpdatingExLab", param);
dal.close();
}
public void UpDate_Supplier(int id, string name, string specialization, string address, string phone, string email)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@supp_id", SqlDbType.Int);
param[0].Value = id;
param[1] = new SqlParameter("@supp_name", SqlDbType.NVarChar, 100);
param[1].Value = name;
param[2] = new SqlParameter("@supp_specialization", SqlDbType.NVarChar, 100);
param[2].Value = specialization;
param[3] = new SqlParameter("@supp_address", SqlDbType.NVarChar, 100);
param[3].Value = address;
param[4] = new SqlParameter("@supp_phone", SqlDbType.NVarChar, 50);
param[4].Value = phone;
param[5] = new SqlParameter("supp_email", SqlDbType.NVarChar, 100);
param[5].Value = email;
dal.executeCommand("UpDateSupp", param);
dal.close();
}
public void Update_Doctor(int Did, string Dname, string Dspecialization, string Daddress, string Dphone, string Demail, string Ddiscount)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@Did", SqlDbType.Int);
param[0].Value = Did;
param[1] = new SqlParameter("@Dname", SqlDbType.NVarChar, 100);
param[1].Value = Dname;
param[2] = new SqlParameter("@Dspecialization", SqlDbType.NVarChar, 100);
param[2].Value = Dspecialization;
param[3] = new SqlParameter("@Daddress", SqlDbType.NVarChar, 100);
param[3].Value = Daddress;
param[4] = new SqlParameter("@Dphone", SqlDbType.VarChar, 50);
param[4].Value = Dphone;
param[5] = new SqlParameter("@Demail", SqlDbType.VarChar, 50);
param[5].Value = Demail;
param[6] = new SqlParameter("@Ddiscount", SqlDbType.VarChar, 50);
param[6].Value = Ddiscount;
dal.executeCommand("UpdatingDoctor", param);
dal.close();
}
public void Add_normal(string name_en, int age_from, string unit_from, int age_to, string unit_to, string gender, string normal, string normal_unit)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@name_en", SqlDbType.NVarChar, 100);
param[0].Value = name_en;
param[1] = new SqlParameter("@age_from", SqlDbType.Int);
param[1].Value = age_from;
param[2] = new SqlParameter("@unit_from", SqlDbType.NVarChar, 100);
param[2].Value = unit_from;
param[3] = new SqlParameter("@age_to", SqlDbType.Int);
param[3].Value = age_to;
param[4] = new SqlParameter("@unit_to", SqlDbType.NVarChar, 100);
param[4].Value = unit_to;
param[5] = new SqlParameter("@gender", SqlDbType.NVarChar, 50);
param[5].Value = gender;
param[6] = new SqlParameter("@normal", SqlDbType.NVarChar, 50);
param[6].Value = normal;
param[7] = new SqlParameter("@normal_unit", SqlDbType.NVarChar, 50);
param[7].Value = normal_unit;
dal.executeCommand("Add_normal", param);
dal.close();
}
//********************عرض كل التعاقدات ***********************************
public DataTable GET_ALL_CONTRACT()
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
dt = dal.SelectData("GetContractors", null);
dal.close();
return(dt);
}
//****************AnalysisPrice*****************************
public DataTable GetAnalysisPrice()
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
dt = dal.SelectData("GetAnalysisPrice", null);
dal.close();
return(dt);
}
public DataTable Get_All_Supplier()
{
DAL.DBL dl = new DAL.DBL();
DataTable dt = new DataTable();
dt = dl.SelectData("SelectSup", null);
dl.close();
return(dt);
}
//********************عرض***********************
public DataTable GET_ALL_PATIENT()
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
dt = dal.SelectData("GetAllPatients1", null);
dal.close();
return(dt);
}
public DataTable Get_All_USER()
{
DAL.DBL dl = new DAL.DBL();
DataTable dt = new DataTable();
dt = dl.SelectData("SelectUser", null);
dl.close();
return(dt);
}
public DataTable Get_All_EXLab()
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
dt = dal.SelectData("GetAllLab", null);
dal.close();
return(dt);
}
public DataTable Get_All_Doctors()
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
dt = dal.SelectData("GetAllDoctors", null);
dal.close();
return(dt);
}
//********************عرض***********************
public DataTable GET_List_PATIENT()
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
dt = dal.SelectData("get_list_patient", null);
dal.close();
return(dt);
}
// DELETE USER
public void Delete_User(int id)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@UserId", SqlDbType.Int);
param[0].Value = id;
dal.executeCommand("DeleteUser", param);
dal.close();
}
public void Delete_analysis(int analysis_id)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@analysis_id", SqlDbType.Int);
param[0].Value = analysis_id;
dal.executeCommand("Delete_analysis", param);
dal.close();
}
public void Delete_group(int group_id)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@group_id", SqlDbType.Int);
param[0].Value = group_id;
dal.executeCommand("Delete_group", param);
dal.close();
}
public DataTable Get_all_groups()
{
DAL.DBL dal = new DAL.DBL();
dal.open();
DataTable dt = new DataTable();
dt = dal.SelectData("Get_all_groups", null);
dal.close();
return(dt);
}
public DataTable GetAllNormals()
{
DAL.DBL dal = new DAL.DBL();
dal.open();
DataTable dt = new DataTable();
dt = dal.SelectData("GetAllNormals", null);
dal.close();
return(dt);
}
public void Delete_Doctor(int ID)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Did", SqlDbType.Int);
param[0].Value = ID;
dal.executeCommand("DeleteDoctor", param);
dal.close();
}
public void Delete_normal(int normal_id)
{
DAL.DBL dal = new DAL.DBL();
dal.open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@normal_id", SqlDbType.Int);
param[0].Value = normal_id;
dal.executeCommand("Delete_normal", param);
dal.close();
}
public DataTable SearchDoctorBySpecialization(string specialization)
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Dspecialization", SqlDbType.NVarChar, 100);
param[0].Value = specialization;
dt = dal.SelectData("SearchDoctorBySpecialization", param);
dal.close();
return(dt);
}
public DataTable SearchDoctorByName(string name)
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Dname", SqlDbType.NVarChar, 100);
param[0].Value = name;
dt = dal.SelectData("SearchDoctorByName", param);
dal.close();
return(dt);
}
//****************************************************************************************
//For Ex_Lab:
//**********************عرض كل المعامل الخارجية *************************
public DataTable Get_All_EXLab(int sign)
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@sign", SqlDbType.Int);
param[0].Value = sign;
dt = dal.SelectData("GetAllLab", param);
dal.close();
return(dt);
}
//*************************البحث ******************************
public DataTable SEARCH_PATIENT(string name)
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@name", SqlDbType.NVarChar, 100);
param[0].Value = name;
dt = dal.SelectData("SearchPatient", param);
dal.close();
return(dt);
}
public DataTable Attendance(string id)
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", SqlDbType.NVarChar, 100);
param[0].Value = id;
dt = dal.SelectData("SearchAttendance", param);
dal.close();
return(dt);
}
public DataTable Search_normal(string name_en)
{
DAL.DBL dal = new DAL.DBL();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@name_en", SqlDbType.NVarChar, 100);
param[0].Value = name_en;
dt = dal.SelectData("Search_normal", param);
dal.close();
return(dt);
}
