protected void Button1_Click(object sender, EventArgs e)
{
EROR_LABEL.Text = "";
string user_id = Text_UserID.Text;
string user_birth = Text_UserBirth.Text;
string user_phone = Text_UserPhone.Text;
string user_name = Text_UserName.Text;
string user_surname = Text_UserSurname.Text;
string user_father_name = Text_UserFaterName.Text;
string user_sec_num = Text_UserNumber.Text;
string system_sec_num = ViewState["sec_num"] as string;
string result = null;
OracleDB db = new OracleDB("Ata");
db.openConnection();
string sql = "SELECT CHECK_PATIENT_INFO('" + user_id + "','" + user_birth + "','" + user_name + "','" + user_surname + "','" + user_father_name + "') FROM DUAL";
OracleDataReader reader = db.getDataFromDB(sql);
while (reader.Read())
{
result = reader.GetString(0);
}
if (result.Equals("TRUE") && user_sec_num.Equals(system_sec_num))
{
db.closeConnection();
Response.Redirect("~/Reservation_Screen.aspx?id=" + user_id + "&birth=" + user_birth + "&phone="
+ user_phone + "&name=" + user_name + "&surname=" + user_surname + "&father_name=" + user_father_name);
}
else
{
EROR_LABEL.Text = "CHECK YOUR INFORMATION !";
ViewState["sec_num"] = SECURITY_number.Text;
db.closeConnection();
}
}
protected void Btn_Add_Doctor_Click(object sender, EventArgs e)
{
Lbl_Doctor_Error.Text = "";
string doc_name = Txt_Doctor_Name.Text;
string doc_surname = Txt_Doctor_Surname.Text;
string doc_title = Txt_Doctor_Title.Text;
string sql = "SELECT ADD_DOCTOR('" + doc_name + "','" + doc_surname + "','" + doc_title + "') FROM DUAL";
string inserted = null;
OracleDB db = new OracleDB("Ata");
db.openConnection();
OracleDataReader reader = db.getDataFromDB(sql);
while (reader.Read())
{
inserted = reader.GetString(0);
}
if (inserted.Equals("TRUE"))
{
Lbl_Doctor_Error.Text = "DOCTOR INSERTED REFRESH TABLE";
}
else
{
Lbl_Doctor_Error.Text = "DOCTOR NOT INSERTED CHECK INFO";
}
db.closeConnection();
}
private bool check_Information()
{
bool found = false;
string user_id = text_UserID.Text;
string user_password = text_Password.Text;
/*SQL code part for check info */
string sql = "SELECT TO_CHAR(COUNT(*)) FROM ADMİN WHERE ID='" + user_id + "' AND PASSWORD='******'";
string exist = null;
OracleDB db = new OracleDB("Ata");
db.openConnection();
OracleDataReader reader = db.getDataFromDB(sql);
while (reader.Read())
{
exist = reader.GetString(0);
}
if (exist.Equals("1"))
{
admin_id = user_id;
found = true;
}
db.closeConnection();
return(found);
}
private void getOracle(string pol_name)
{
string doc_id = get_Doc_id(pol_name);
string sql = "SELECT NAME,SURNAME FROM DOCTOR WHERE ID='" + doc_id + "'";
string d_name = null, d_surname = null;
OracleDataReader reader = db.getDataFromDB(sql);
while (reader.Read())
{
d_name = reader.GetString(0);
d_surname = reader.GetString(1);
}
doctor_name = d_name + " " + d_surname;
string result = null;
sql = "SELECT CREATE_PDP_FUNC('" + doc_id + "','" + pol_name + "','" + id + "') FROM DUAL";
OracleDataReader reader1 = db.getDataFromDB(sql);
while (reader1.Read())
{
result = reader1.GetString(0);
}
if (result.Equals("TRUE"))
{
sql = "SELECT CREATE_RESERVATION_FUNC('" + id + "') FROM DUAL";
OracleDataReader reader2 = db.getDataFromDB(sql);
while (reader2.Read())
{
result = reader2.GetString(0);
}
if (result.Equals("TRUE"))
{
db.closeConnection();
send_Info(pol_name);
}
else
{
Error_Label.Text = "Could not take reservation !";
}
}
else
{
Error_Label.Text = "Could not take reservation !";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
OracleDB db = new OracleDB("Ata");
db.openConnection();
string[] array = new string[pdp_table_names.Length];
string sql = "SELECT * FROM PDP_VIEW ";
OracleDataReader reader = db.getDataFromDB(sql);
while (reader.Read())
{
array[0] = reader.GetString(0);
array[1] = reader.GetString(1);
array[2] = reader.GetString(2);
array[3] = reader.GetString(3);
fillTable(PDP_table, array);
}
db.closeConnection();
}
protected void Button3_Click(object sender, EventArgs e)
{
OracleDB db = new OracleDB("Ata");
db.openConnection();
string[] array = new string[reservation_table_names.Length];
string sql = "SELECT * FROM RESERVATION_VIEW ";
OracleDataReader reader = db.getDataFromDB(sql);
while (reader.Read())
{
array[0] = reader.GetString(0);
array[1] = reader.GetOracleTimeStamp(1).ToString();
array[2] = reader.GetString(2);
array[3] = reader.GetString(3);
array[4] = reader.GetString(4);
fillTable(Reservation_Table, array);
}
db.closeConnection();
}
protected void Button4_Click(object sender, EventArgs e)
{
Lbl_System.Text = "";
OracleDB db = new OracleDB("Ata");
db.openConnection();
string reset = null;
string sql = "SELECT RESET_SYSTEM() FROM DUAL";
OracleDataReader reader = db.getDataFromDB(sql);
while (reader.Read())
{
reset = reader.GetString(0);
}
if (reset.Equals("TRUE"))
{
Lbl_System.Text = "System Tables cleared";
sql = "SELECT SET_SYSTEM('" + admin_id + "') FROM DUAL";
OracleDataReader reader1 = db.getDataFromDB(sql);
while (reader1.Read())
{
reset = reader1.GetString(0);
}
if (reset.Equals("TRUE"))
{
Lbl_System.Text = "System resetted completly";
}
else
{
Lbl_System.Text = "System parameters not resetted";
}
}
else
{
Lbl_System.Text = "System tables not cleared";
}
db.closeConnection();
}