// add new patient
#region add_patient
public bool insertdata
(string id, string name, string gender, string birth_date,
string status, string reg_date, string address, string phone1,
string phone2, string email)
{
asd : try
{
SqlParameter[] param = new SqlParameter[13];
param[0] = new SqlParameter("stype", SqlDbType.VarChar, 20);
param[0].Value = "patient";
param[1] = new SqlParameter("sid", SqlDbType.VarChar, 20);
param[1].Value = id;
param[2] = new SqlParameter("sname", SqlDbType.VarChar, 50);
param[2].Value = name;
param[3] = new SqlParameter("sgender", SqlDbType.VarChar, 10);
param[3].Value = gender;
param[4] = new SqlParameter("sbirth_date", SqlDbType.Date);
param[4].Value = birth_date;
param[5] = new SqlParameter("sstatus", SqlDbType.VarChar, 10);
param[5].Value = status;
param[6] = new SqlParameter("sreg_date", SqlDbType.Date);
param[6].Value = reg_date;
param[7] = new SqlParameter("saddress", SqlDbType.VarChar, 100);
param[7].Value = address;
param[8] = new SqlParameter("sphone1", SqlDbType.VarChar, 20);
param[8].Value = phone1;
param[9] = new SqlParameter("sphone2", SqlDbType.VarChar, 20);
param[9].Value = phone2;
param[10] = new SqlParameter("semail", SqlDbType.VarChar, 20);
param[10].Value = email;
param[11] = new SqlParameter("sposition", SqlDbType.VarChar, 10);
param[11].Value = DBNull.Value;
param[12] = new SqlParameter("snat_id", SqlDbType.VarChar, 14);
param[12].Value = DBNull.Value;
exp_num = con.Exacute_procdure("sp_add", param);
if (exp_num == 1)
{
return(true);
}
else
{
if (exp_num == 1062)
{
id = increasekey(id);
goto asd;
}
MessageBox.Show(exp_num.ToString());
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
/* public DataTable select_visit()
* {
* dt = new DataTable();
* param = new SqlParameter[16];
* param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
* param[0].Value = "select";
* param[1] = new SqlParameter("@visit_id", SqlDbType.NVarChar, 25);
* param[1].Value = "";
* param[2] = new SqlParameter("@entry_date", SqlDbType.DateTime);
* param[2].Value = "";
* param[3] = new SqlParameter("@entry_time", SqlDbType.DateTime);
* param[3].Value ="";
* param[4] = new SqlParameter("@entry_state", SqlDbType.NVarChar,100);
* param[4].Value = "patient";
* param[5] = new SqlParameter("@exit_date", SqlDbType.DateTime);
* param[5].Value = "patient";
* param[6] = new SqlParameter("@exit_Status", SqlDbType.NVarChar, 100);
* param[6].Value = 10;
* param[7] = new SqlParameter("@Initial_diagnosis", SqlDbType.NVarChar, 100);
* param[7].Value = "";
* param[8] = new SqlParameter("@Final_diagnosis", SqlDbType.NVarChar,100);
* param[8].Value = "patient";
* param[9] = new SqlParameter("@recommendation", SqlDbType.NVarChar, 1000);
* param[9].Value = "patient";
* param[10] = new SqlParameter("@send_side_name", SqlDbType.NVarChar, 50);
* param[10].Value = "patient";
* param[11] = new SqlParameter("@Visit_type", SqlDbType.NVarChar, 50);
* param[11].Value = "patient";
* param[12] = new SqlParameter("@Visit_state", SqlDbType.Bit);
* param[12].Value = 10;
* param[13] = new SqlParameter("@entry_doc_id", SqlDbType.NVarChar, 25);
* param[13].Value = "patient";
* param[14] = new SqlParameter("@entry_emp_id", SqlDbType.NVarChar, 25);
* param[14].Value = "patient";
* param[15] = new SqlParameter("@pat_id", SqlDbType.NVarChar, 25);
* param[15].Value = "patient";
*
* dt = con.ReadData("sp_visit", param);
* return dt;
* }
*/
// add new visit
#region add_visit
public bool insertdata
(string visit_id, string entry_date, string entry_time,
string Initial_diagnos, string send_side_name, string Visit_type
, string entry_doc_name, string entry_empUser_id, string pat_id, string pat_name)
{
try
{
param = new SqlParameter[10];
param[0] = new SqlParameter("@visit_id", SqlDbType.NVarChar, 25);
param[0].Value = visit_id;
param[1] = new SqlParameter("@entry_date", SqlDbType.Date);
// entry_date = entry_date.ToString("yyyy-MM-dd");
param[1].Value = entry_date;
param[2] = new SqlParameter("@entry_time", SqlDbType.NVarChar, 20);
param[2].Value = entry_time;
param[3] = new SqlParameter("@Initial_diagnosis", SqlDbType.NVarChar, 100);
param[3].Value = Initial_diagnos;
param[4] = new SqlParameter("@send_side_name", SqlDbType.NVarChar, 50);
param[4].Value = send_side_name;
param[5] = new SqlParameter("@Visit_type", SqlDbType.NVarChar, 50);
param[5].Value = Visit_type;
param[6] = new SqlParameter("@entry_empUser_id", SqlDbType.NVarChar, 25);
param[6].Value = entry_empUser_id;
param[7] = new SqlParameter("@pat_id", SqlDbType.NVarChar, 25);
param[7].Value = pat_id;
param[8] = new SqlParameter("@pat_name", SqlDbType.NVarChar, 100);
param[8].Value = pat_name;
param[9] = new SqlParameter("@entry_doc_name", SqlDbType.NVarChar, 50);
param[9].Value = entry_doc_name;
//////////////////////////////////
int exp_num;
exp_num = con.Exacute_procdure("insert_visit", param);
if ((exp_num == 1))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
public bool updatedata
(string type, string dep_id, string dep_name, string dep_location, string notes)
{
try
{
int exp_num;
con = new Connection();
param = new SqlParameter[5];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = type;
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = dep_id;
param[2] = new SqlParameter("@name", SqlDbType.NVarChar, 100);
param[2].Value = dep_name;
param[3] = new SqlParameter("@location", SqlDbType.NVarChar, 100);
param[3].Value = dep_location;
param[4] = new SqlParameter("note", SqlDbType.NVarChar, 255);
param[4].Value = notes;
exp_num = con.Exacute_procdure("sp_department", param);
if (exp_num == 1)
{
return(true);
}
else
{
MessageBox.Show(exp_num.ToString());
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
public bool updatedata(string type, string id, string user_name, string password, string emp_id)
{
try
{
int exp_num;
con = new Connection();
param = new SqlParameter[5];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = type;
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = id;
param[2] = new SqlParameter("@user_name", SqlDbType.NVarChar, 50);
param[2].Value = user_name;
param[3] = new SqlParameter("@password", SqlDbType.NVarChar, 50);
param[3].Value = password;
param[4] = new SqlParameter("@emp_id", SqlDbType.NVarChar, 25);
param[4].Value = emp_id;
exp_num = con.Exacute_procdure("sp_users", param);
if (exp_num == 1)
{
return(true);
}
else
{
MessageBox.Show(exp_num.ToString());
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
public bool insertdata
(string type, string id, string user_name, string password, string emp_id)
{
asd : try
{
int exp_num;
con = new Connection();
param = new SqlParameter[5];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = type;
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = id;
param[2] = new SqlParameter("@user_name", SqlDbType.NVarChar, 50);
param[2].Value = user_name;
param[3] = new SqlParameter("@password", SqlDbType.NVarChar, 50);
param[3].Value = password;
param[4] = new SqlParameter("@emp_id", SqlDbType.NVarChar, 25);
param[4].Value = emp_id;
exp_num = con.Exacute_procdure("sp_users", param);
if (exp_num == 1)
{
return(true);
}
else
{
if (exp_num == 1062)
{
id = cls_validate.increasekey(id, 5);
goto asd;
}
else if (exp_num == 2627)
{
MessageBox.Show("اسم المستخدم موجود مسبقا الرجاءادخال اسم مستخدم جديد");
}
//MessageBox.Show(exp_num.ToString());
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
public bool delete_patient(string type, string dep_id)
{
try
{
int exp_num;
con = new Connection();
param = new SqlParameter[5];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = type;
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = dep_id;
param[2] = new SqlParameter("@name", SqlDbType.NVarChar, 100);
param[2].Value = "";
param[3] = new SqlParameter("@location", SqlDbType.NVarChar, 100);
param[3].Value = "";
param[4] = new SqlParameter("note", SqlDbType.NVarChar, 255);
param[4].Value = "";
exp_num = con.Exacute_procdure("sp_department", param);
if (exp_num == 1)
{
return(true);
}
else if (exp_num == 547)
{
MessageBox.Show("عفوا لا يمكن حذف هذا القسم لانه مرتبط ببيانات اخرى داخل النظام ", "تنبيه ", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
else
{
MessageBox.Show(exp_num.ToString());
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
// add new patient
#region add_patient
public bool insertdata
(string type, string id, string name, string address, string phone,
string status, string age, string job, string nationality,
string address_woking, string card_id, string card_realease_place,
string married_duration, string husband_name, string husband_identity,
string patient_Relative_name, string patient_Relative_state,
string patient_Relative_job, string patient_Relative_address,
string patient_Relative_identity, string patient_Relative_phone,
string date_Regist, string user_id)
{
try
{
param = new SqlParameter[23];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = type;
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = id;
param[2] = new SqlParameter("@Name", SqlDbType.NVarChar, 100);
param[2].Value = name;
param[3] = new SqlParameter("@address", SqlDbType.NVarChar, 100);
param[3].Value = address;
param[4] = new SqlParameter("@phone", SqlDbType.NVarChar, 14);
param[4].Value = phone;
param[5] = new SqlParameter("@status", SqlDbType.NVarChar, 14);
param[5].Value = status;
param[6] = new SqlParameter("@age", SqlDbType.Int);
param[6].Value = int.Parse(age);
param[7] = new SqlParameter("@job", SqlDbType.NVarChar, 50);
param[7].Value = job;
param[8] = new SqlParameter("@nationality", SqlDbType.NVarChar, 14);
param[8].Value = nationality;
param[9] = new SqlParameter("@address_working", SqlDbType.NVarChar, 100);
param[9].Value = address_woking;
param[10] = new SqlParameter("@card_id", SqlDbType.NVarChar, 14);
param[10].Value = card_id;
param[11] = new SqlParameter("@card_realease_place", SqlDbType.NVarChar, 14);
param[11].Value = card_realease_place;
param[12] = new SqlParameter("@married_duration", SqlDbType.Int);
param[12].Value = int.Parse(married_duration);
param[13] = new SqlParameter("@husband_name", SqlDbType.NVarChar, 100);
param[13].Value = husband_name;
param[14] = new SqlParameter("@husband_identity", SqlDbType.NVarChar, 14);
param[14].Value = husband_identity;
param[15] = new SqlParameter("@patient_Relative_name", SqlDbType.NVarChar, 100);
param[15].Value = patient_Relative_name;
param[16] = new SqlParameter("@patient_Relative_identity", SqlDbType.NVarChar, 14);
param[16].Value = patient_Relative_identity;
param[17] = new SqlParameter("@patient_Relative_state", SqlDbType.NVarChar, 50);
param[17].Value = patient_Relative_state;
param[18] = new SqlParameter("@patient_Relative_phone", SqlDbType.NVarChar, 14);
param[18].Value = patient_Relative_phone;
param[19] = new SqlParameter("@patient_Relative_address", SqlDbType.NVarChar, 100);
param[19].Value = patient_Relative_address;
param[20] = new SqlParameter("@patient_Relative_job", SqlDbType.NVarChar, 50);
param[20].Value = patient_Relative_job;
param[21] = new SqlParameter("@reg_date", SqlDbType.Date);
param[21].Value = date_Regist;
param[22] = new SqlParameter("@user_id", SqlDbType.NVarChar, 50);
param[22].Value = user_id;
/////////////////////////////////////
con.Exacute_procdure("sp_patient", param);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
public bool insertdata
(string type, string id, string name, string address, string phone,
string status, string email, string gender, string birth_date,
string religion, string birth_place, string nationality,
string card_id, string card_realease_place, string card_realease_date,
string qualification, string qualification_date,
string years_of_experience, string experience,
string prevoius_jobs, string hiring_date,
string total_salary, string career_level
, string career_name, string dep_code, string Emp_Type, string blood_type)
{
try
{
con = new Connection();
param = new SqlParameter[27];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = type;
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = id;
param[2] = new SqlParameter("@Name", SqlDbType.NVarChar, 100);
param[2].Value = name;
param[3] = new SqlParameter("@addreess", SqlDbType.NVarChar, 100);
param[3].Value = address;
param[4] = new SqlParameter("@phone", SqlDbType.NVarChar, 14);
param[4].Value = phone;
param[5] = new SqlParameter("@status", SqlDbType.NVarChar, 14);
param[5].Value = status;
param[6] = new SqlParameter("@email", SqlDbType.NVarChar, 100);
param[6].Value = email;
param[7] = new SqlParameter("@gender", SqlDbType.NVarChar, 14);
param[7].Value = gender;
param[8] = new SqlParameter("@birth_date", SqlDbType.Date);
param[8].Value = birth_date;
param[9] = new SqlParameter("@religion", SqlDbType.NVarChar, 14);
param[9].Value = religion;;
param[10] = new SqlParameter("@birth_place", SqlDbType.NVarChar, 100);
param[10].Value = birth_place;
param[11] = new SqlParameter("@nationality", SqlDbType.NVarChar, 14);
param[11].Value = nationality;
param[12] = new SqlParameter("@card_id", SqlDbType.NVarChar, 14);
param[12].Value = card_id;
param[13] = new SqlParameter("@card_realease_place", SqlDbType.NVarChar, 14);
param[13].Value = card_realease_place;;
param[14] = new SqlParameter("@card_realease_date", SqlDbType.Date);
param[14].Value = card_realease_date;;
param[15] = new SqlParameter("@qualification", SqlDbType.NVarChar, 100);
param[15].Value = qualification;;
param[16] = new SqlParameter("@qualification_date", SqlDbType.Date);
param[16].Value = qualification_date;;
param[17] = new SqlParameter("@years_of_experience", SqlDbType.Int);
param[17].Value = years_of_experience;;
param[18] = new SqlParameter("@experience", SqlDbType.NVarChar, 100);
param[18].Value = experience;;
param[19] = new SqlParameter("@prevoius_jobs", SqlDbType.NVarChar, 100);
param[19].Value = prevoius_jobs;
param[20] = new SqlParameter("@hiring_date", SqlDbType.Date);
param[20].Value = hiring_date;;
param[21] = new SqlParameter("@total_salary", SqlDbType.Float);
param[21].Value = float.Parse(total_salary);
param[22] = new SqlParameter("@career_level", SqlDbType.NVarChar, 50);
param[22].Value = career_level;
param[23] = new SqlParameter("@career_name", SqlDbType.NVarChar, 50);
param[23].Value = career_name;
param[24] = new SqlParameter("@dep_code", SqlDbType.NVarChar, 25);
param[24].Value = dep_code;
param[25] = new SqlParameter("@Emp_Type", SqlDbType.NVarChar, 25);
param[25].Value = Emp_Type;
param[26] = new SqlParameter("@blood_type", SqlDbType.NVarChar, 25);
param[26].Value = blood_type;
/////////////////////////////////////
con.Exacute_procdure("sp_employee", param);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
public bool deletedata
(string type, string id)
{
try
{
con = new Connection();
param = new SqlParameter[27];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = type;
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = id;
param[2] = new SqlParameter("@Name", SqlDbType.NVarChar, 100);
param[2].Value = DBNull.Value;
param[3] = new SqlParameter("@addreess", SqlDbType.NVarChar, 100);
param[3].Value = DBNull.Value;
param[4] = new SqlParameter("@phone", SqlDbType.NVarChar, 14);
param[4].Value = DBNull.Value;;
param[5] = new SqlParameter("@status", SqlDbType.NVarChar, 14);
param[5].Value = DBNull.Value;;
param[6] = new SqlParameter("@email", SqlDbType.NVarChar, 100);
param[6].Value = DBNull.Value;
param[7] = new SqlParameter("@gender", SqlDbType.NVarChar, 14);
param[7].Value = DBNull.Value;
param[8] = new SqlParameter("@birth_date", SqlDbType.Date);
param[8].Value = DBNull.Value;;
param[9] = new SqlParameter("@religion", SqlDbType.NVarChar, 14);
param[9].Value = DBNull.Value;;
param[10] = new SqlParameter("@birth_place", SqlDbType.NVarChar, 100);
param[10].Value = DBNull.Value;;
param[11] = new SqlParameter("@nationality", SqlDbType.NVarChar, 14);
param[11].Value = DBNull.Value;;
param[12] = new SqlParameter("@card_id", SqlDbType.NVarChar, 14);
param[12].Value = DBNull.Value;
param[13] = new SqlParameter("@card_realease_place", SqlDbType.NVarChar, 14);
param[13].Value = DBNull.Value;;
param[14] = new SqlParameter("@card_realease_date", SqlDbType.Date);
param[14].Value = DBNull.Value;;
param[15] = new SqlParameter("@qualification", SqlDbType.NVarChar, 100);
param[15].Value = DBNull.Value;;
param[16] = new SqlParameter("@qualification_date", SqlDbType.Date);
param[16].Value = DBNull.Value;;
param[17] = new SqlParameter("@years_of_experience", SqlDbType.Int);
param[17].Value = DBNull.Value;;
param[18] = new SqlParameter("@experience", SqlDbType.NVarChar, 100);
param[18].Value = DBNull.Value;;
param[19] = new SqlParameter("@prevoius_jobs", SqlDbType.NVarChar, 100);
param[19].Value = DBNull.Value;
param[20] = new SqlParameter("@hiring_date", SqlDbType.Date);
param[20].Value = DBNull.Value;;
param[21] = new SqlParameter("@total_salary", SqlDbType.Float);
param[21].Value = DBNull.Value;
param[22] = new SqlParameter("@career_level", SqlDbType.NVarChar, 50);
param[22].Value = DBNull.Value;
param[23] = new SqlParameter("@career_name", SqlDbType.NVarChar, 50);
param[23].Value = DBNull.Value;
param[24] = new SqlParameter("@dep_code", SqlDbType.NVarChar, 25);
param[24].Value = DBNull.Value;
param[25] = new SqlParameter("@Emp_Type", SqlDbType.NVarChar, 25);
param[25].Value = DBNull.Value;
param[26] = new SqlParameter("@blood_type", SqlDbType.NVarChar, 25);
param[26].Value = DBNull.Value;
/////////////////////////////////////
con.Exacute_procdure("sp_employee", param);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
// add new patient
#region add_patient
public bool insertdata
(string type, string patient_id, string patient_name, string age,
string identity_type, string identity_side, string nationality, string marital_status,
string job, string phone, string address_of_patient, string address_working, string husband_name,
string husband_identity, string married_duration, string patient_Relative_name, string patient_Relative_state, string patient_Relative_job,
string patient_Relative_address, string patient_Relative_identity, string patient_Relative_phone, string date_Regist)
{
try
{
param = new SqlParameter[22];
param[0] = new SqlParameter("type", SqlDbType.VarChar, 20);
param[0].Value = type;
param[1] = new SqlParameter("patient_id", SqlDbType.VarChar, 20);
param[1].Value = patient_id;
param[2] = new SqlParameter("patient_name", SqlDbType.VarChar, 70);
param[2].Value = patient_name;
param[3] = new SqlParameter("age", SqlDbType.Int);
param[3].Value = age;
param[4] = new SqlParameter("identity_type", SqlDbType.VarChar, 14);
param[4].Value = identity_type;
param[5] = new SqlParameter("identity_side", SqlDbType.VarChar, 20);
param[5].Value = identity_side;
param[6] = new SqlParameter("nationality", SqlDbType.VarChar, 40);
param[6].Value = nationality;
param[7] = new SqlParameter("marital_status", SqlDbType.VarChar, 40);
param[7].Value = marital_status;
param[8] = new SqlParameter("job", SqlDbType.VarChar, 40);
param[8].Value = job;
param[9] = new SqlParameter("phone", SqlDbType.VarChar, 11);
param[9].Value = phone;
param[10] = new SqlParameter("address_of_patient", SqlDbType.VarChar, 40);
param[10].Value = address_of_patient;
param[11] = new SqlParameter("address_working", SqlDbType.VarChar, 40);
param[11].Value = address_working;
param[12] = new SqlParameter("husband_name", SqlDbType.VarChar, 50);
param[12].Value = husband_name;
param[13] = new SqlParameter("husband_identity", SqlDbType.VarChar, 14);
param[13].Value = husband_identity;
param[14] = new SqlParameter("married_duration", SqlDbType.VarChar, 40);
param[14].Value = married_duration;
param[15] = new SqlParameter("patient_Relative_name", SqlDbType.VarChar, 50);
param[15].Value = patient_Relative_name;
param[16] = new SqlParameter("patient_Relative_state", SqlDbType.VarChar, 14);
param[16].Value = patient_Relative_state;
param[17] = new SqlParameter("patient_Relative_job", SqlDbType.VarChar, 40);
param[17].Value = patient_Relative_job;
param[18] = new SqlParameter("patient_Relative_address", SqlDbType.VarChar, 70);
param[18].Value = patient_Relative_address;
param[19] = new SqlParameter("patient_Relative_identity", SqlDbType.VarChar, 14);
param[19].Value = patient_Relative_identity;
param[20] = new SqlParameter("patient_Relative_phone", SqlDbType.VarChar, 11);
param[20].Value = patient_Relative_phone;
param[21] = new SqlParameter("date_Regist", SqlDbType.VarChar, 225);
param[21].Value = date_Regist;
/////////////////////////////////////
con.Exacute_procdure("sp_patient", param);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
