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