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);
}
}
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 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 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 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 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 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 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 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 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);
}
}
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);
}
}
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);
}
}
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);
}
}
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 addNewEmployee(String emp)
{
if (emp == "Doctor")
{
try
{
String query = "insert into doctor values('" + dataInfo[0] + "','" + dataInfo[1] + "','" + Convert.ToInt32(dataInfo[2]) + "','" +
dataInfo[3] + "','" + dataInfo[4] + "','" + dataInfo[5] + "','" + dataInfo[6] + "','" + Convert.ToInt32(dataInfo[7]) + "','" + dataInfo[8] + "','" + dataInfo[9] + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
else if (emp == "Receptionist")
{
try
{
String query = "insert into receptionist values('" + dataInfo[0] + "','" + dataInfo[1] + "','" + Convert.ToInt32(dataInfo[2]) + "','" +
dataInfo[3] + "','" + dataInfo[4] + "','" + dataInfo[5] + "','" + dataInfo[6] + "','" + Convert.ToInt32(dataInfo[7]) + "','" + dataInfo[8] + "','" + dataInfo[9] + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
else if (emp == "Nurse")
{
try
{
String query = "insert into nurse values('" + dataInfo[0] + "','" + dataInfo[1] + "','" + Convert.ToInt32(dataInfo[2]) + "','" +
dataInfo[3] + "','" + dataInfo[4] + "','" + dataInfo[5] + "','" + dataInfo[6] + "','" + Convert.ToInt32(dataInfo[7]) + "','" + dataInfo[8] + "','" + dataInfo[9] + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
else if (emp == "Stuff")
{
try
{
String query = "insert into stuff values('" + dataInfo[0] + "','" + dataInfo[1] + "','" + Convert.ToInt32(dataInfo[2]) + "','" +
dataInfo[3] + "','" + dataInfo[4] + "','" + dataInfo[5] + "','" + dataInfo[6] + "','" + Convert.ToInt32(dataInfo[7]) + "','" + dataInfo[8] + "','" + dataInfo[9] + "');";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (MySqlException e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
else
{
return(false);
}
}
public bool updateEmployee(String emp)
{
if (emp == "Doctor")
{
try
{
String query = "UPDATE doctor SET Doctor_ID='" + dataInfo[0] + "',Name='" + dataInfo[1] + "',Age='" + Convert.ToInt32(dataInfo[2]) + "',Gender='" +
dataInfo[3] + "',Department='" + dataInfo[4] + "',Qualification='" + dataInfo[5] + "',Experience='" + dataInfo[6] + "',Salary='" + Convert.ToInt32(dataInfo[7]) + "',Phone='" +
dataInfo[8] + "',Address='" + dataInfo[9] + "' WHERE Doctor_ID='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
else if (emp == "Receptionist")
{
try
{
String query = "UPDATE receptionist SET Recep_ID='" + dataInfo[0] + "',Name='" + dataInfo[1] + "',Age='" + Convert.ToInt32(dataInfo[2]) + "',Gender='" +
dataInfo[3] + "',Department='" + dataInfo[4] + "',Qualification='" + dataInfo[5] + "',Experience='" + dataInfo[6] + "',Salary='" + Convert.ToInt32(dataInfo[7]) + "',Phone='" +
dataInfo[8] + "',Address='" + dataInfo[9] + "' WHERE Recep_ID='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
else if (emp == "Nurse")
{
try
{
String query = "UPDATE nurse SET Nurse_ID='" + dataInfo[0] + "',Name='" + dataInfo[1] + "',Age='" + Convert.ToInt32(dataInfo[2]) + "',Gender='" +
dataInfo[3] + "',Department='" + dataInfo[4] + "',Qualification='" + dataInfo[5] + "',Experience='" + dataInfo[6] + "',Salary='" + Convert.ToInt32(dataInfo[7]) + "',Phone='" +
dataInfo[8] + "',Address='" + dataInfo[9] + "' WHERE Nurse_ID='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
else if (emp == "Stuff")
{
try
{
String query = "UPDATE stuff SET Stuff_ID='" + dataInfo[0] + "',Name='" + dataInfo[1] + "',Age='" + Convert.ToInt32(dataInfo[2]) + "',Gender='" +
dataInfo[3] + "',Department='" + dataInfo[4] + "',Qualification='" + dataInfo[5] + "',Experience='" + dataInfo[6] + "',Salary='" + Convert.ToInt32(dataInfo[7]) + "',Phone='" +
dataInfo[8] + "',Address='" + dataInfo[9] + "' WHERE Stuff_ID='" + dataInfo[0] + "';";
DatabaseHelperClass ob = new DatabaseHelperClass();
ob.databaseConnect(query);
return(true);
}
catch (Exception e)
{
Console.Error.WriteLine(e.StackTrace);
return(false);
}
}
else
{
return(false);
}
}
