public void UpdateUsers(string Name, int User_id, string NameSystem, string Shift, string Number_Type_Of_Job, string Phone, string Email, string Sex, string Note1)
{
DAL.DataAccessLayer Dal = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[9];
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("@Number_Type_Of_Job", SqlDbType.NVarChar, 5);
param[3].Value = Number_Type_Of_Job;
param[4] = new SqlParameter("@Phone", SqlDbType.NVarChar, 50);
param[4].Value = Phone;
param[5] = new SqlParameter("@Email", SqlDbType.Text);
param[5].Value = Email;
param[6] = new SqlParameter("@Sex", SqlDbType.NVarChar, 10);
param[6].Value = Sex;
param[7] = new SqlParameter("@Note1", SqlDbType.Text);
param[7].Value = Note1;
param[8] = new SqlParameter("@NameSystem", SqlDbType.Text);
param[8].Value = NameSystem;
Dal.CheckIsOpen();
Dal.ExecuteCommand("UpdateUsers", 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 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();
}
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();
}