private void button_update_Click(object sender, EventArgs e)
{
ArrayList updateInfo = new ArrayList();
updateInfo.Add(textBox_id.Text);
updateInfo.Add(textBox_name.Text);
updateInfo.Add(textBox_age.Text);
updateInfo.Add(comboBox_gender.Text);
updateInfo.Add(textBox_dept.Text);
updateInfo.Add(textBox_qual.Text);
updateInfo.Add(textBox_exp.Text);
updateInfo.Add(textBox_salary.Text);
updateInfo.Add(textBox_phone.Text);
updateInfo.Add(richTextBox_address.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(updateInfo);
if (ob.updateEmployee(employee))
{
MessageBox.Show("Updated");
}
else
{
MessageBox.Show("Error Update");
}
}
private void button_save_Click(object sender, EventArgs e)
{
ArrayList patientInfo = new ArrayList();
patientInfo.Add(textBox_appid.Text);
patientInfo.Add(textBox_name.Text);
patientInfo.Add(comboBox_gender.Text);
patientInfo.Add(textBox_age.Text);
patientInfo.Add(textBox_phone.Text);
patientInfo.Add(richTextBox_address.Text);
patientInfo.Add(textBox_disease.Text);
patientInfo.Add(textBox_doctorid.Text);
patientInfo.Add(textBox_docname.Text);
patientInfo.Add(textBox_roomnum.Text);
patientInfo.Add(dateTimePicker1.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(patientInfo);
if (ob.takeAppointment())
{
MessageBox.Show("Appointed");
}
else
{
MessageBox.Show("Error Taking Appointment");
}
}
public bool checkPassword(String password, int ID)
{
try
{
String query = "select Password from user WHERE User_ID =" + ID;
String MySqlConnStr = "server=localhost;port=3306;database=hospital_management;uid=root;password=''";
MySqlConnection databaseConnection = new MySqlConnection(MySqlConnStr);
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
commandDatabase.CommandTimeout = 60;
databaseConnection.Open();
DatabaseHelperClass ob = new DatabaseHelperClass();
MySqlDataReader myReader = commandDatabase.ExecuteReader();
myReader.Read();
//databaseConnection.Close();
if (String.Compare(myReader[0].ToString(), password) == 0)
{
return(true);
}
else
{
return(false);
}
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
private void button_update_Click(object sender, EventArgs e)
{
ArrayList patientInfo = new ArrayList();
patientInfo.Add(textBox_pid.Text);
patientInfo.Add(textBox_rid.Text);
patientInfo.Add(textBox_name.Text);
patientInfo.Add(textBox_gender.Text);
patientInfo.Add(textBox_age.Text);
patientInfo.Add(textBox_phone.Text);
patientInfo.Add(richTextBox_address.Text);
patientInfo.Add(textBox_disease.Text);
patientInfo.Add(textBox_status.Text);
patientInfo.Add(textBox_roomno.Text);
patientInfo.Add(textBox_checkin.Text);
patientInfo.Add(textBox_roomtype.Text);
patientInfo.Add(textBox_building.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(patientInfo);
if (ob.updateData())
{
MessageBox.Show("Updated");
}
else
{
MessageBox.Show("Error Update");
}
}
private void button_update_Click(object sender, EventArgs e)
{
ArrayList patientInfo = new ArrayList();
patientInfo.Add(textBox_appoid.Text);
patientInfo.Add(textBox_patientName.Text);
patientInfo.Add(textBox_gender.Text);
patientInfo.Add(textBox_age.Text);
patientInfo.Add(textBox_phone.Text);
patientInfo.Add(richTextBox_add.Text);
patientInfo.Add(textBox_disease.Text);
patientInfo.Add(textBox_docid.Text);
patientInfo.Add(textBox_docname.Text);
patientInfo.Add(textBox_roomno.Text);
patientInfo.Add(textBox_date.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(patientInfo);
if (ob.updateAppointmentData())
{
MessageBox.Show("Updated");
}
else
{
MessageBox.Show("Error Update");
}
}
private void button_update_Click(object sender, EventArgs e)
{
ArrayList updateInfo = new ArrayList();
updateInfo.Add(textBox_docid.Text);
updateInfo.Add(textBox_name.Text);
updateInfo.Add(comboBox_department.Text);
updateInfo.Add(textBox_spec.Text);
updateInfo.Add(textBox_roomno.Text);
updateInfo.Add(textBox_stime.Text);
updateInfo.Add(textBox_etime.Text);
updateInfo.Add(textBox_days.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(updateInfo);
if (ob.updateSchedule())
{
MessageBox.Show("Updated");
}
else
{
MessageBox.Show("Error Update");
}
}
private void button_update_Click(object sender, EventArgs e)
{
ArrayList roomList = new ArrayList();
roomList.Add(textBox_roomno.Text);
roomList.Add(textBox_roomtype.Text);
roomList.Add(textBox_numbed.Text);
roomList.Add(textBox_status.Text);
roomList.Add(textBox_price.Text);
roomList.Add(textBox_building.Text);
roomList.Add(textBox_floorno.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(roomList);
if (ob.updateRoom())
{
MessageBox.Show("Updated");
}
else
{
MessageBox.Show("Error Update");
}
}
private void button_add_Click(object sender, EventArgs e)
{
ArrayList userInfo = new ArrayList();
String pass = textBox_password.Text;
String conPass = textBox_confirm.Text;
if (String.IsNullOrEmpty(textBox_name.Text) || String.IsNullOrEmpty(textBox_uname.Text) || String.IsNullOrEmpty(textBox_password.Text) ||
String.IsNullOrEmpty(textBox_confirm.Text) || String.IsNullOrEmpty(textBox_position.Text))
{
MessageBox.Show("Fill up all data");
}
else
{
DatabaseHelperClass ob1 = new DatabaseHelperClass();
String username = textBox_uname.Text;
if (ob1.checkUserExist(username))
{
if (String.Compare(pass, conPass) == 0)
{
userInfo.Add(textBox_uname.Text);
userInfo.Add(pass);
userInfo.Add(textBox_position.Text);
userInfo.Add(textBox_name.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(userInfo);
if (ob.addNewUser())
{
MessageBox.Show("User Added");
}
else
{
MessageBox.Show("Error Adding User");
}
}
else
{
MessageBox.Show("Password Don't Matched");
}
}
else
{
MessageBox.Show("User already exist");
}
}
}
private void button_change_Click(object sender, EventArgs e)
{
ArrayList userInfo = new ArrayList();
String givenOldPass = textBox_oldpw.Text;
String givenNewPass = textBox_newpw.Text;
String givenConfPass = textBox_confirm.Text;
if (String.IsNullOrEmpty(textBox_oldpw.Text) || String.IsNullOrEmpty(textBox_newpw.Text) ||
String.IsNullOrEmpty(textBox_confirm.Text))
{
MessageBox.Show("Fill up all data");
}
else
{
DatabaseHelperClass ob1 = new DatabaseHelperClass();
if (ob1.checkPassword(givenOldPass, givenID))
{
if (String.Compare(givenNewPass, givenConfPass) == 0)
{
userInfo.Add(textBox_newpw.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(userInfo);
if (ob.changePassword(givenID))
{
MessageBox.Show("Password Changed");
}
else
{
MessageBox.Show("Error Changing Password");
}
}
else
{
MessageBox.Show("Password Doesn't Match");
}
}
else
{
MessageBox.Show("Wrong old password !");
}
}
}
public bool updateBloodData()
{
try
{
String query = "update bloodBank set Number_of_Bags='" + dataInfo[1] + "' where Blood_Type='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
public bool addReport()
{
try
{
String query = "insert into reports values('" + dataInfo[0] + "','" + Convert.ToInt32(dataInfo[1]) + "','" + Convert.ToInt32(dataInfo[2]) + "','" +
dataInfo[3] + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool takeAppointment()
{
try
{
String query = "insert into appointments values('" + dataInfo[0] + "','" + dataInfo[1] + "','" + dataInfo[2] + "','" +
Convert.ToInt32(dataInfo[3]) + "','" + dataInfo[4] + "','" + dataInfo[5] + "','" + dataInfo[6] + "','" + dataInfo[7] + "','" +
dataInfo[8] + "','" + dataInfo[9] + "','" + dataInfo[10] + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool updateReportsData()
{
try
{
String query = "update reports set PID='" + dataInfo[0] + "',No_of_Test_Request='" + Convert.ToInt32(dataInfo[1]) +
"',No_of_Test_Complete='" + Convert.ToInt32(dataInfo[2]) + "',Delivery_Date='" + dataInfo[3] + "' where PID='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
public bool addNewUser()
{
try
{
String query = "insert into user(Username,Password,Position,Name) values('" + dataInfo[0] + "','" + dataInfo[1] + "','" +
dataInfo[2] + "','" + dataInfo[3] + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
public bool changePassword(int ID)
{
try
{
String query = "UPDATE user SET Password ='******' WHERE User_ID='" + ID + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
databaseConnection.Close();
return(false);
}
}
public bool updateRoom()
{
try
{
String query = "UPDATE room SET Room_ID='" + dataInfo[0] + "',Room_Type='" + dataInfo[1] + "',No_of_Bed='" + Convert.ToInt32(dataInfo[2]) + "',Status='" +
dataInfo[3] + "',Price='" + Convert.ToInt32(dataInfo[4]) + "',Building='" + dataInfo[5] + "',Floor_No='" + Convert.ToInt32(dataInfo[6]) + "' WHERE Room_ID='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
public bool updateAppointmentData()
{
try
{
String query = "update appointments set Appointment_ID='" + dataInfo[0] + "',Name='" + dataInfo[1] + "',Gender='" +
dataInfo[2] + "',Age='" + dataInfo[3] + "',Phone='" + dataInfo[4] + "',Address='" + dataInfo[5] + "',Disease='" + dataInfo[6] + "',Doctor_ID='" +
dataInfo[7] + "',Doctor_Name='" + dataInfo[8] + "',Room_No='" + dataInfo[9] + "',Date='" + dataInfo[10] + "' where Appointment_ID='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
public bool updateData()
{
try
{
String query = "update patient set Pid='" + dataInfo[0] + "',Reg_ID='" + dataInfo[1] + "',Name='" + dataInfo[2] + "',Gender='" +
dataInfo[3] + "',Age='" + dataInfo[4] + "',Phone='" + dataInfo[5] + "',Address='" + dataInfo[6] + "',Disease='" + dataInfo[7] + "',Status='" +
dataInfo[8] + "',Room_ID='" + dataInfo[9] + "',Date='" + dataInfo[10] + "',Room_type='" + dataInfo[11] + "',Building='" + dataInfo[12] + "' where Pid='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
public bool updateTime()
{
try
{
String query = "update schedule set Employee_ID='" + dataInfo[0] + "',Name='" + dataInfo[1] +
"',Job_Title='" + dataInfo[2] + "',Start_Time='" + dataInfo[3] + "',End_Time='" + dataInfo[4] + "',Days='" + Convert.ToInt32(dataInfo[5]) + "' where Employee_ID='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
private void button_update_Click(object sender, EventArgs e)
{
ArrayList bloodInfo = new ArrayList();
bloodInfo.Add(label_bloodType.Text);
bloodInfo.Add(textBox_noOfBags.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(bloodInfo);
if (ob.updateBloodData())
{
MessageBox.Show("Updated");
showBloodList();
}
else
{
MessageBox.Show("Error Update");
}
}
public bool insertRoomInfo()
{
try
{
String query = "insert into room (Room_ID, Room_Type, No_of_Bed, Price, Building, Floor_No) values('" + dataInfo[0] + "','" +
dataInfo[1] + "','" + Convert.ToInt32(dataInfo[2]) + "','" + Convert.ToInt32(dataInfo[3]) + "','" + dataInfo[4] + "','" +
Convert.ToInt32(dataInfo[5]) + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
public bool addNewTime()
{
try
{
String query = "insert into schedule values('" + dataInfo[0] + "','" + dataInfo[1] + "','" + (dataInfo[2]) + "','" +
dataInfo[3] + "','" + dataInfo[4] + "','" + dataInfo[5] + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
private void button_submit_Click(object sender, EventArgs e)
{
ArrayList patientInfo = new ArrayList();
patientInfo.Add(textBox_billid.Text);
patientInfo.Add(textBox_pid.Text);
patientInfo.Add(textBox_datein.Text);
patientInfo.Add(textBox_dateout.Text);
patientInfo.Add(textBox_days.Text);
patientInfo.Add(textBox_roomtype.Text);
patientInfo.Add(textBox_unit.Text);
patientInfo.Add(textBox_service.Text);
patientInfo.Add(textBox_medCharge.Text);
patientInfo.Add(textBox_docCharge.Text);
patientInfo.Add(textBox_price.Text);
patientInfo.Add("Checked Out");
String bill = textBox_billid.Text;
String pid = textBox_pid.Text;
DatabaseHelperClass ob = new DatabaseHelperClass(patientInfo);
if (ob.checkBill(bill, pid))
{
if (ob.Checkout())
{
MessageBox.Show("Checked Out");
}
else
{
MessageBox.Show("Error Checking Out");
}
}
else
{
MessageBox.Show("Bill Or Patient ID Already Exist");
}
}
private void button_add_Click(object sender, EventArgs e)
{
try
{
ArrayList dataInfo = new ArrayList();
if (String.IsNullOrEmpty(textBox_docid.Text) || String.IsNullOrEmpty(textBox_name.Text) ||
String.IsNullOrEmpty(comboBox_department.Text) || String.IsNullOrEmpty(textBox_spec.Text) ||
String.IsNullOrEmpty(textBox_roomno.Text) || String.IsNullOrEmpty(textBox_stime.Text) ||
String.IsNullOrEmpty(textBox_etime.Text) || String.IsNullOrEmpty(textBox_days.Text))
{
MessageBox.Show("Fill up all data");
}
else
{
dataInfo.Add(textBox_docid.Text);
dataInfo.Add(textBox_name.Text);
dataInfo.Add(comboBox_department.Text);
dataInfo.Add(textBox_spec.Text);
dataInfo.Add(textBox_roomno.Text);
dataInfo.Add(textBox_stime.Text);
dataInfo.Add(textBox_etime.Text);
dataInfo.Add(textBox_days.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(dataInfo);
if (ob.addNewSchedule())
{
MessageBox.Show("Schedule Added");
}
else
{
MessageBox.Show("Error Adding Schedule");
}
}
}
catch (Exception exp)
{
MessageBox.Show("Exception");
}
}
public bool updateSchedule()
{
try
{
String query = "update doctor_schedule set Doctor_ID='" + dataInfo[0] + "',Name='" + dataInfo[1] + "',Department='" +
dataInfo[2] + "',Specialist='" + dataInfo[3] + "',Room_No='" + dataInfo[4] + "',Start_Time='" + dataInfo[5] + "',End_Time='" + dataInfo[6] + "',Days='" +
dataInfo[7] + "' where Doctor_ID='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
public bool addNewSalary()
{
try
{
String query = "insert into salary (Employee_ID,Name,Job_Title,Salary,Month,Date,Payment_status) values('" + dataInfo[0] + "','" + dataInfo[1] + "','" + (dataInfo[2]) + "','" +
dataInfo[3] + "','" + dataInfo[4] + "','" + dataInfo[5] + "','" + dataInfo[6] + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
private void button_add_Click(object sender, EventArgs e)
{
try
{
ArrayList dataInfo = new ArrayList();
if (String.IsNullOrEmpty(textBox_eid.Text) || String.IsNullOrEmpty(textBox_name.Text) ||
String.IsNullOrEmpty(comboBox_jobtitle.Text) || String.IsNullOrEmpty(textBox_salary.Text) ||
String.IsNullOrEmpty(textBox_month.Text) || String.IsNullOrEmpty(dateTimePicker1.Text) ||
String.IsNullOrEmpty(textBox_status.Text))
{
MessageBox.Show("Fill up all data");
}
else
{
dataInfo.Add(textBox_eid.Text);
dataInfo.Add(textBox_name.Text);
dataInfo.Add(comboBox_jobtitle.Text);
dataInfo.Add(textBox_salary.Text);
dataInfo.Add(textBox_month.Text);
dataInfo.Add(dateTimePicker1.Text);
dataInfo.Add(textBox_status.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(dataInfo);
if (ob.addNewSalary())
{
MessageBox.Show("Salary Added");
}
else
{
MessageBox.Show("Error Adding Salary");
}
}
}
catch (Exception exp)
{
MessageBox.Show("Exception");
}
}
public bool insertData()
{
String status = "Checked In";
try
{
String query = "insert into patient values('" + dataInfo[3] + "','" + dataInfo[0] + "','" + dataInfo[4] + "','" +
dataInfo[5] + "','" + Convert.ToString(dataInfo[6]) + "','" + dataInfo[7] + "','" + dataInfo[8] + "','" + dataInfo[9] + "','" +
dataInfo[10] + "','" + dataInfo[12] + "','" + dataInfo[1] + "','" + dataInfo[2] + "','" + dataInfo[11] + "','" + status + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
return(false);
}
}
private void button_add_Click(object sender, EventArgs e)
{
ArrayList patientInfo = new ArrayList();
patientInfo.Add(textBox_number.Text);
patientInfo.Add(dateTimePicker1.Text);
if (radioButton_normal.Checked)
{
patientInfo.Add("Normal");
}
else if (radioButton_medium.Checked)
{
patientInfo.Add("Medium");
}
else if (radioButton_vip.Checked)
{
patientInfo.Add("VIP");
}
patientInfo.Add(textBox_pid.Text);
patientInfo.Add(textBox_name.Text);
patientInfo.Add(comboBox_gender.Text);
patientInfo.Add(textBox_age.Text);
patientInfo.Add(textBox_phone.Text);
patientInfo.Add(richTextBox_address.Text);
patientInfo.Add(textBox_disease.Text);
patientInfo.Add(textBox_status.Text);
patientInfo.Add(comboBox_building.Text);
patientInfo.Add(textBox_roomno.Text);
DatabaseHelperClass ob = new DatabaseHelperClass(patientInfo);
if (ob.insertData())
{
MessageBox.Show("Patient Added");
}
else
{
MessageBox.Show("Error Adding Patient");
}
}
public bool Checkout()
{
try
{
String query = "insert into checkout values('" + dataInfo[0] + "','" + dataInfo[1] + "','" + dataInfo[2] + "','" +
dataInfo[3] + "','" + Convert.ToInt32(dataInfo[4]) + "','" + dataInfo[5] + "','" + Convert.ToInt32(dataInfo[6]) + "','" + Convert.ToInt32(dataInfo[7]) + "','" +
Convert.ToInt32(dataInfo[8]) + "','" + Convert.ToInt32(dataInfo[9]) + "','" + Convert.ToInt32(dataInfo[10]) + "');";
String query2 = "update patient set Check_Status='" + dataInfo[11] + "'where Pid ='" + dataInfo[1] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
ob.databaseConnect(query2);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
