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