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 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 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 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_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 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 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 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 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 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_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 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(); }
// 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_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 void delete_CONTRACT(int id) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@id", SqlDbType.Int, 100); param[0].Value = id; dal.executeCommand("delete_contract", param); dal.close(); }
public void GetAttend(int id, DateTime d, DateTime date) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@id", SqlDbType.Int, 100); param[0].Value = id; param[1] = new SqlParameter("@dateattend", SqlDbType.DateTime, 100); param[1].Value = d; param[2] = new SqlParameter("@dateoftoday", SqlDbType.DateTime, 100); param[2].Value = date; dal.executeCommand("AddAttend", param); dal.close(); }
public void Update_groups_analysis(string group_name, int analysis_id) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@group_name", SqlDbType.NVarChar, 100); param[0].Value = group_name; param[1] = new SqlParameter("@analysis_id", SqlDbType.Int); param[1].Value = analysis_id; dal.executeCommand("Update_groups_analysis", param); dal.close(); }
public void add_reservation_analysis(int reservation_id, string name_en) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[2]; 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; dal.executeCommand("add_reservation_analysis", param); dal.close(); }
public void Add_group(string group_name, int analysis_num) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@group_name", SqlDbType.NVarChar, 100); param[0].Value = group_name; param[1] = new SqlParameter("@analysis_num", SqlDbType.Int); param[1].Value = analysis_num; dal.executeCommand("Add_group", param); dal.close(); }
public void GetDimisal(int id, DateTime d)//,DateTime att) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@id", SqlDbType.Int, 100); param[0].Value = id; param[1] = new SqlParameter("@datedimisal", SqlDbType.DateTime, 100); param[1].Value = d; // param[2] = new SqlParameter("@attend", SqlDbType.DateTime, 100); //param[2].Value = att; dal.executeCommand("adddimisal", param); dal.close(); }
// UPDATE USER public void UpDate_User(int id, string name, string password, string address, int phone, int idnumber, DateTime birth, string email, string job, int wages, string notes) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[11]; param[0] = new SqlParameter("@UserId", SqlDbType.NVarChar, 100); param[0].Value = id; param[1] = new SqlParameter("@UserName", SqlDbType.NVarChar, 100); param[1].Value = name; param[2] = new SqlParameter("@Password", SqlDbType.NVarChar, 100); param[2].Value = password; param[3] = new SqlParameter("@UserAddress", SqlDbType.NVarChar, 100); param[3].Value = address; param[4] = new SqlParameter("@UserPhone", SqlDbType.NVarChar, 50); param[4].Value = phone; param[5] = new SqlParameter("@IdNumber", SqlDbType.NVarChar, 100); param[5].Value = idnumber; param[6] = new SqlParameter("@DateOfBirth", SqlDbType.NVarChar, 100); param[6].Value = birth; param[7] = new SqlParameter("@UserEmai", SqlDbType.NVarChar, 100); param[7].Value = email; param[8] = new SqlParameter("@Job", SqlDbType.NVarChar, 100); param[8].Value = job; param[9] = new SqlParameter("@WorkerWages", SqlDbType.Int, 50); param[9].Value = wages; param[10] = new SqlParameter("@notes", SqlDbType.NVarChar, 100); param[10].Value = notes; dal.executeCommand("UpDateSupp", param); dal.close(); }
//***************************************اضافة****************************** public void Add_patient(string pat_name, int pat_age, string unit, string pat_gender, string pat_stu, string pat_email, string pat_address, string pat_phone, string con_name) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[9]; param[0] = new SqlParameter("@pat_name", SqlDbType.NVarChar, 100); param[0].Value = pat_name; param[1] = new SqlParameter("@pat_age", SqlDbType.NVarChar, 100); param[1].Value = pat_age; param[2] = new SqlParameter("@unit", SqlDbType.NVarChar, 50); param[2].Value = unit; param[3] = new SqlParameter("@pat_gender", SqlDbType.VarChar, 100); param[3].Value = pat_gender; param[4] = new SqlParameter("@pat_stu", SqlDbType.VarChar, 100); param[4].Value = @pat_stu; param[5] = new SqlParameter("@pat_email", SqlDbType.VarChar, 100); param[5].Value = pat_email; param[6] = new SqlParameter("@pat_address", SqlDbType.VarChar, 100); param[6].Value = pat_address; param[7] = new SqlParameter("@pat_phone", SqlDbType.VarChar, 100); param[7].Value = pat_phone; param[8] = new SqlParameter("@con_name", SqlDbType.NVarChar, 100); param[8].Value = con_name; dal.executeCommand("Add_patient", param); dal.close(); }