public void InsertFollow_up(int FollowUpID, int NoFile, string Date, string Result, string Treatment, int Patient_id, int User_id, string Note1) { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[8]; param[0] = new SqlParameter("@Result", SqlDbType.Text); param[0].Value = Result; param[1] = new SqlParameter("@Patient_id", SqlDbType.Int); param[1].Value = Patient_id; param[2] = new SqlParameter("@Treatment", SqlDbType.Text); param[2].Value = Treatment; param[3] = new SqlParameter("@User_id", SqlDbType.Int); param[3].Value = User_id; param[4] = new SqlParameter("@Note1", SqlDbType.Text); param[4].Value = Note1; param[5] = new SqlParameter("@Date", SqlDbType.NVarChar, 30); param[5].Value = Date; param[6] = new SqlParameter("@FollowUpID", SqlDbType.Int); param[6].Value = FollowUpID; param[7] = new SqlParameter("@NoFile", SqlDbType.Int); param[7].Value = NoFile; Dal.CheckIsOpen(); Dal.ExecuteCommand("InsertFollow_up", param); Dal.CheckIsClosed(); }
public void UpdateClinic(string Name, int Clinic_id, string Shift, int User_id, string Note1, string Note2) { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@Name", SqlDbType.NChar, 50); param[0].Value = Name; param[1] = new SqlParameter("@Clinic_id", SqlDbType.Int); param[1].Value = Clinic_id; param[2] = new SqlParameter("@Shift", SqlDbType.NChar, 20); param[2].Value = Shift; param[3] = new SqlParameter("@User_id", SqlDbType.Int); param[3].Value = User_id; param[4] = new SqlParameter("@Note1", SqlDbType.Text); param[4].Value = Note1; param[5] = new SqlParameter("@Note2", SqlDbType.Text); param[5].Value = Note2; Dal.CheckIsOpen(); Dal.ExecuteCommand("UpdateClinic", param); Dal.CheckIsClosed(); }
public void UpdatePrivm(int UserID, int ScreenID, Boolean view, Boolean add, Boolean update, Boolean print) { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@UserID", SqlDbType.Int); param[0].Value = UserID; param[1] = new SqlParameter("@ScreenID", SqlDbType.Int); param[1].Value = ScreenID; param[2] = new SqlParameter("@View", SqlDbType.Bit); param[2].Value = view; param[3] = new SqlParameter("@Add", SqlDbType.Bit); param[3].Value = add; param[4] = new SqlParameter("@Update", SqlDbType.Bit); param[4].Value = update; param[5] = new SqlParameter("@Print", SqlDbType.Bit); param[5].Value = print; Dal.CheckIsOpen(); Dal.ExecuteCommand("UpdatePriv", param); Dal.CheckIsClosed(); }
public void UpdateLocal_Narcosis(int NoFile, string BP, string Viral_Marks_and_HIV, string CBC, string BS, int Surgery_id, string Note1) { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@BP", SqlDbType.Text); param[0].Value = BP; param[1] = new SqlParameter("@Viral_Marks_and_HIV", SqlDbType.Text); param[1].Value = Viral_Marks_and_HIV; param[2] = new SqlParameter("@Surgery_id", SqlDbType.Int); param[2].Value = Surgery_id; param[3] = new SqlParameter("@Note1", SqlDbType.Text); param[3].Value = Note1; param[4] = new SqlParameter("@NoFile", SqlDbType.Int); param[4].Value = NoFile; param[5] = new SqlParameter("@CBC", SqlDbType.Text); param[5].Value = CBC; param[6] = new SqlParameter("@BS", SqlDbType.Text); param[6].Value = BS; Dal.CheckIsOpen(); Dal.ExecuteCommand("UpdateLocal_Narcosis", param); Dal.CheckIsClosed(); }
/* @Post_Oper_FollowID int, * @Surgery_id int, * @Patient_id int, * @NoFile int, */ public void InsertPost_Operative_Follow_up(int Post_Oper_FollowID, int Surgery_id, int NoFile, string VA, string PH, string Date, string Astigmatism, string Corneal_Cause, string Corneal_Opacity, string C_Odema, string Retinal_Disease, string Glaucoma, string Others, int Patient_id, int User_id, string Note1) { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[16]; param[0] = new SqlParameter("@VA", SqlDbType.Text); param[0].Value = VA; param[1] = new SqlParameter("@Date", SqlDbType.NVarChar, 30); param[1].Value = Date; param[2] = new SqlParameter("@PH", SqlDbType.Text); param[2].Value = PH; param[3] = new SqlParameter("@Astigmatism", SqlDbType.Text); param[3].Value = Astigmatism; param[4] = new SqlParameter("@Corneal_Cause", SqlDbType.Text); param[4].Value = Corneal_Cause; param[5] = new SqlParameter("@Corneal_Opacity", SqlDbType.Text); param[5].Value = Corneal_Opacity; param[6] = new SqlParameter("@C_Odema", SqlDbType.Text); param[6].Value = C_Odema; param[7] = new SqlParameter("@Retinal_Disease", SqlDbType.Text); param[7].Value = Retinal_Disease; param[8] = new SqlParameter("@Glaucoma", SqlDbType.Text); param[8].Value = Glaucoma; param[9] = new SqlParameter("@Others", SqlDbType.Text); param[9].Value = Others; param[10] = new SqlParameter("@Patient_id", SqlDbType.Int); param[10].Value = Patient_id; param[11] = new SqlParameter("@User_id", SqlDbType.Int); param[11].Value = User_id; param[12] = new SqlParameter("@Note1", SqlDbType.Text); param[12].Value = Note1; param[13] = new SqlParameter("@Post_Oper_FollowID", SqlDbType.Int); param[13].Value = Post_Oper_FollowID; param[14] = new SqlParameter("@Surgery_id", SqlDbType.Int); param[14].Value = Surgery_id; param[15] = new SqlParameter("@NoFile", SqlDbType.Int); param[15].Value = NoFile; Dal.CheckIsOpen(); Dal.ExecuteCommand("InsertPost_Operative_Follow_up", param); Dal.CheckIsClosed(); }
public DataTable SeletAllcLocal_Narcosis() { DataTable dt = new DataTable(); DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); Dal.CheckIsOpen(); dt = Dal.SelectDataWithQuery("SeletAllcLocal_Narcosis"); Dal.CheckIsClosed(); return(dt); }
public DataTable SelectAllChecked_Patient() { DataTable dt = new DataTable(); DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); Dal.CheckIsOpen(); dt = Dal.SelectDataWithQuery("SelectAllChecked_Patient"); Dal.CheckIsClosed(); return(dt); }
public DataTable SelectAllRoutine_Check() { DataTable dt = new DataTable(); DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); Dal.CheckIsOpen(); dt = Dal.SelectDataWithQuery("SelectAllRoutine_Check"); Dal.CheckIsClosed(); return(dt); }
public DataTable Select_All_Post_Operative_Follow_up() { DataTable dt = new DataTable(); DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); Dal.CheckIsOpen(); dt = Dal.SelectDataWithQuery("Select_All_Post_Operative_Follow_up"); Dal.CheckIsClosed(); return(dt); }
public DataTable selectList() { DataTable dt = new DataTable(); DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); Dal.CheckIsOpen(); dt = Dal.SelectDataWithQuery("selectList"); Dal.CheckIsClosed(); return(dt); }
public int Get_max_id_Surgery() { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); int id; Dal.CheckIsOpen(); dt = Dal.SelectDataWithQuery("Get_max_id_Surgery"); Dal.CheckIsClosed(); id = Convert.ToInt32(dt.Rows[0][0]); return(id); }
public int Git_Max_id_For_Checked_Patient() { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); int id; Dal.CheckIsOpen(); dt = Dal.SelectDataWithQuery("Git_Max_id_For_Checked_Patient"); Dal.CheckIsClosed(); id = Convert.ToInt32(dt.Rows[0][0]); return(id); }
public int Git_Max_id_For_Post_Operative_Follow_up() { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); int id; Dal.CheckIsOpen(); dt = Dal.SelectDataWithQuery("Git_Max_id_For_Post_Operative_Follow_up"); Dal.CheckIsClosed(); id = Convert.ToInt32(dt.Rows[0][0]); return(id); }
public void UpdateGlobal_Narcosis(int NoFile, string Urea_and_creation, string BT_and_CT, string Liver_functor_test, string ECG, string C_X_ray, string Medical, string ENT_Dr, string pediatric, string CBC, string BS, int Surgery_id, string Note1) { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[13]; param[0] = new SqlParameter("@Urea_and_creation", SqlDbType.Text); param[0].Value = Urea_and_creation; param[1] = new SqlParameter("@BT_and_CT", SqlDbType.Text); param[1].Value = BT_and_CT; param[2] = new SqlParameter("@Liver_functor_test", SqlDbType.Text); param[2].Value = Liver_functor_test; param[3] = new SqlParameter("@ECG", SqlDbType.Text); param[3].Value = ECG; param[4] = new SqlParameter("@C_X_ray", SqlDbType.Text); param[4].Value = C_X_ray; param[5] = new SqlParameter("@Medical", SqlDbType.Text); param[5].Value = Medical; param[6] = new SqlParameter("@ENT_Dr", SqlDbType.Text); param[6].Value = ENT_Dr; param[7] = new SqlParameter("@pediatric", SqlDbType.Text); param[7].Value = pediatric; param[8] = new SqlParameter("@Surgery_id", SqlDbType.Int); param[8].Value = Surgery_id; param[9] = new SqlParameter("@Note1", SqlDbType.Text); param[9].Value = Note1; param[10] = new SqlParameter("@NoFile", SqlDbType.Int); param[10].Value = NoFile; param[11] = new SqlParameter("@CBC", SqlDbType.Text); param[11].Value = CBC; param[12] = new SqlParameter("@BS", SqlDbType.Text); param[12].Value = BS; Dal.CheckIsOpen(); Dal.ExecuteCommand("UpdateGlobal_Narcosis", param); Dal.CheckIsClosed(); }
public DataTable SelectChecked_Patient(int id) { DataTable dt = new DataTable(); DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@id", SqlDbType.Int); param[0].Value = id; Dal.CheckIsOpen(); dt = Dal.SelectData("SelecChecked_Patient", param); Dal.CheckIsClosed(); return(dt); }
public DataTable SelecUsers(string data) { DataTable dt = new DataTable(); DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@data", SqlDbType.NVarChar, 50); param[0].Value = data; Dal.CheckIsOpen(); dt = Dal.SelectData("SelecUsers", param); Dal.CheckIsClosed(); return(dt); }
public DataTable SelectPriv(int idList, int userid) { DataTable dt = new DataTable(); DAL.DataAccessLayer Dal = new DAL.DataAccessLayer( ); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@idList", SqlDbType.Int); param[0].Value = idList; param[1] = new SqlParameter("@userid", SqlDbType.Int); param[1].Value = userid; Dal.CheckIsOpen(); dt = Dal.SelectData("SelectPriv", param); Dal.CheckIsClosed(); return(dt); }
public void InsertUsers(string Name, int User_id, string NameSystem, string Shift, string Pass, string Number_Type_Of_Job, string Phone, string Email, string Sex, string Note1) { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[10]; param[0] = new SqlParameter("@Name", SqlDbType.NVarChar, 100); param[0].Value = Name; param[1] = new SqlParameter("@User_id", SqlDbType.Int); param[1].Value = User_id; param[2] = new SqlParameter("@Shift", SqlDbType.NVarChar, 20); param[2].Value = Shift; param[3] = new SqlParameter("@Pass", SqlDbType.NVarChar, 100); param[3].Value = Pass; param[4] = new SqlParameter("@Number_Type_Of_Job", SqlDbType.NVarChar, 5); param[4].Value = Number_Type_Of_Job; param[5] = new SqlParameter("@Phone", SqlDbType.NVarChar, 50); param[5].Value = Phone; param[6] = new SqlParameter("@Email", SqlDbType.Text); param[6].Value = Email; param[7] = new SqlParameter("@Sex", SqlDbType.NVarChar, 10); param[7].Value = Sex; param[8] = new SqlParameter("@Note1", SqlDbType.Text); param[8].Value = Note1; param[9] = new SqlParameter("@NameSystem", SqlDbType.Text); param[9].Value = NameSystem; Dal.CheckIsOpen(); Dal.ExecuteCommand("InsertUsers", param); Dal.CheckIsClosed(); }
public void UpdateChecked_Patient(int Checked_PatientID, int NoFile, string Present_Complaint, string Previous_Ocular_History, string Using_any_Medicine, string Any_Sensitivity, string Ocular_motility, string Slit_lamp_Examination, string Eyelids, string Cornea, string AC, string Lens, string Vitreous, string Fundus, string Gonioscopy, string UltraSound, string Treatment, char L_or_R_Eye, int Patient_id, int User_id, string Note1, string Note2) { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[22]; param[0] = new SqlParameter("@Present_Complaint", SqlDbType.Text); param[0].Value = Present_Complaint; param[1] = new SqlParameter("@Previous_Ocular_History", SqlDbType.Text); param[1].Value = Previous_Ocular_History; param[2] = new SqlParameter("@Using_any_Medicine", SqlDbType.Text); param[2].Value = Using_any_Medicine; param[3] = new SqlParameter("@Any_Sensitivity", SqlDbType.Text); param[3].Value = Any_Sensitivity; param[4] = new SqlParameter("@Ocular_motility", SqlDbType.Text); param[4].Value = Ocular_motility; param[5] = new SqlParameter("@Slit_lamp_Examination", SqlDbType.Text); param[5].Value = Slit_lamp_Examination; param[6] = new SqlParameter("@Eyelids", SqlDbType.Text); param[6].Value = Eyelids; param[7] = new SqlParameter("@Cornea", SqlDbType.Text); param[7].Value = Cornea; param[8] = new SqlParameter("@AC", SqlDbType.Text); param[8].Value = AC; param[9] = new SqlParameter("@Lens", SqlDbType.Text); param[9].Value = Lens; param[10] = new SqlParameter("@Vitreous", SqlDbType.Text); param[10].Value = Vitreous; param[11] = new SqlParameter("@Fundus", SqlDbType.Text); param[11].Value = Fundus; param[12] = new SqlParameter("@Gonioscopy", SqlDbType.Text); param[12].Value = Gonioscopy; param[13] = new SqlParameter("@UltraSound", SqlDbType.Text); param[13].Value = UltraSound; param[14] = new SqlParameter("@Treatment", SqlDbType.Text); param[14].Value = Treatment; param[15] = new SqlParameter("@L_or_R_Eye", SqlDbType.Char, 1); param[15].Value = L_or_R_Eye; param[16] = new SqlParameter("@Patient_id", SqlDbType.Int); param[16].Value = Patient_id; param[17] = new SqlParameter("@User_id", SqlDbType.Int); param[17].Value = User_id; param[18] = new SqlParameter("@Note1", SqlDbType.Text); param[18].Value = Note1; param[19] = new SqlParameter("@Note2", SqlDbType.Text); param[19].Value = Note2; param[20] = new SqlParameter("@NoFile", SqlDbType.Int); param[20].Value = NoFile; param[21] = new SqlParameter("@Checked_PatientID", SqlDbType.Int); param[21].Value = Checked_PatientID; Dal.CheckIsOpen(); Dal.ExecuteCommand("UpdateChecked_Patient", param); Dal.CheckIsClosed(); }
public void UpdateRoutine_Check(int RoutineCheckID, string OD_or_OS, string VA, string With_Glasses, string PH, string IOP, int User_id, int Patient_id, string Shp, string Cyl, string Axis, string ShpAuto, string CylAuto, string AxisAuto, string D_or_N, string Note1, int NoFile) { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[17]; param[0] = new SqlParameter("@OD_or_OS", SqlDbType.Text); param[0].Value = OD_or_OS; param[1] = new SqlParameter("@VA", SqlDbType.Text); param[1].Value = VA; param[2] = new SqlParameter("@PH", SqlDbType.Text); param[2].Value = PH; param[3] = new SqlParameter("@With_Glasses", SqlDbType.Text); param[3].Value = With_Glasses; param[4] = new SqlParameter("@IOP", SqlDbType.Text); param[4].Value = IOP; param[5] = new SqlParameter("@User_id", SqlDbType.Int); param[5].Value = User_id; param[6] = new SqlParameter("@Patient_id", SqlDbType.Int); param[6].Value = Patient_id; param[7] = new SqlParameter("@Shp", SqlDbType.Text); param[7].Value = Shp; param[8] = new SqlParameter("@Cyl", SqlDbType.Text); param[8].Value = Cyl; param[9] = new SqlParameter("@Axis", SqlDbType.Text); param[9].Value = Axis; param[10] = new SqlParameter("@D_or_N", SqlDbType.Text); param[10].Value = D_or_N; param[11] = new SqlParameter("@Note1", SqlDbType.Text); param[11].Value = Note1; param[12] = new SqlParameter("@NoFile", SqlDbType.Int); param[12].Value = NoFile; param[13] = new SqlParameter("@RoutineCheckID", SqlDbType.Int); param[13].Value = RoutineCheckID; param[14] = new SqlParameter("@AxisAuto", SqlDbType.Text); param[14].Value = AxisAuto; param[15] = new SqlParameter("@CylAuto", SqlDbType.Text); param[15].Value = CylAuto; param[16] = new SqlParameter("@ShpAuto", SqlDbType.Text); param[16].Value = ShpAuto; Dal.CheckIsOpen(); Dal.ExecuteCommand("UpdateRoutine_Check", param); Dal.CheckIsClosed(); }
public void UpdateSurgery(string Name, int Surgery_id, int NoFile, string Date, string Place, string Type, char L_or_R_Eye, string Admit_For, string Narcosis, string Treatment, int Patient_id, int User_id, string Axial_Length, string IoI_Power, string Blood_Pressure, string Blood_Sugar, string Assistant) { DAL.DataAccessLayer Dal = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[17]; param[0] = new SqlParameter("@Name", SqlDbType.NVarChar, 50); param[0].Value = Name; param[1] = new SqlParameter("@Surgery_id", SqlDbType.Int); param[1].Value = Surgery_id; param[2] = new SqlParameter("@Place", SqlDbType.Text); param[2].Value = Place; param[3] = new SqlParameter("@Type", SqlDbType.Text); param[3].Value = Type; param[4] = new SqlParameter("@L_or_R_Eye", SqlDbType.Char, 1); param[4].Value = L_or_R_Eye; param[5] = new SqlParameter("@Admit_For", SqlDbType.Text); param[5].Value = Admit_For; param[6] = new SqlParameter("@Narcosis", SqlDbType.Text); param[6].Value = Narcosis; param[7] = new SqlParameter("@Treatment", SqlDbType.Text); param[7].Value = Treatment; param[8] = new SqlParameter("@Patient_id", SqlDbType.Int); param[8].Value = Patient_id; param[9] = new SqlParameter("@User_id", SqlDbType.Int); param[9].Value = User_id; param[10] = new SqlParameter("@Note1", SqlDbType.Text); param[10].Value = Assistant; param[11] = new SqlParameter("@Axial_Length", SqlDbType.Text); param[11].Value = Axial_Length; param[12] = new SqlParameter("@IoI_Power", SqlDbType.Text); param[12].Value = IoI_Power; param[13] = new SqlParameter("@Blood_Pressure", SqlDbType.Text); param[13].Value = Blood_Pressure; param[14] = new SqlParameter("@Blood_Sugar", SqlDbType.Text); param[14].Value = Blood_Sugar; param[15] = new SqlParameter("@NoFile", SqlDbType.Int); param[15].Value = NoFile; param[16] = new SqlParameter("@Date", SqlDbType.NVarChar, 30); param[16].Value = Date; Dal.CheckIsOpen(); Dal.ExecuteCommand("UpdateSurgery", param); Dal.CheckIsClosed(); }