public int GetCaretakerOCR(long caretaker_id)
{
caretaker caretaker = new caretaker();
int ocr_number = 0;
using (MySqlConnection con = new MySqlConnection(constr))
{
string query = "SELECT ocr_number FROM caretaker WHERE caretaker_id = @caretaker_id";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Connection = con;
cmd.Parameters.AddWithValue("@caretaker_id", caretaker_id);
con.Open();
using (MySqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
ocr_number = Convert.ToInt32(sdr["ocr_number"]);
}
}
con.Close();
}
}
return(ocr_number);
}
public caretaker CheckIfOCRIsInUse(int ocr_number)
{
caretaker caretaker = new caretaker();
using (MySqlConnection con = new MySqlConnection(constr))
{
string query = "SELECT * FROM caretaker WHERE ocr_number = @ocr_number";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Connection = con;
cmd.Parameters.AddWithValue("@ocr_number", ocr_number);
con.Open();
using (MySqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
caretaker.caretaker_id = Convert.ToInt32(sdr["caretaker_id"]);
}
}
con.Close();
}
}
return(caretaker);
}
