public IActionResult AssignToProcedure([FromBody] RoomAssignmentModel data)
{
try
{
Db.Connection.Open();
var cmd = Db.Connection.CreateCommand() as MySqlCommand;
cmd.CommandText = string.Format(@"SELECT * FROM patalpos_uzimtumas where patalpa_id = {0}", data.RoomId);
var res = cmd.ExecuteReader().Read();
Db.Connection.Close();
if (res)
{
return(StatusCode(500, "Patalpos priskirti nepavyko patikrinkite kas ją naudoja."));
}
else
{
Db.Connection.Open();
cmd.CommandText = (string.Format(@"INSERT INTO patalpos_uzimtumas(patalpa_id, nuo, iki) VALUES ({0}, '{1}', '{2}')", data.RoomId, data.From.Date, data.To.Date));
cmd.ExecuteNonQuery();
Db.Connection.Close();
Db.Connection.Open();
cmd.CommandText = string.Format(@"UPDATE proceduros_tipas SET patalpa_id = CONCAT('{0}', ';') WHERE id = {1}", data.RoomId, data.ProcType);
cmd.ExecuteNonQuery();
Db.Connection.Close();
}
return(Ok());
}
catch (Exception e)
{
return(StatusCode(500, "Patalpos priskirti nepavyko patikrinkite kas ją naudoja."));
}
}
public IActionResult AssignToDoctor([FromBody] RoomAssignmentModel data)
//public IActionResult AssignToDoctor([FromRoute] int id, [FromBody] int tabNum, [FromBody] DateTime from, [FromBody] DateTime to)
{
try
{
Db.Connection.Open();
var cmd = Db.Connection.CreateCommand() as MySqlCommand;
cmd.CommandText = string.Format(@"SELECT * FROM patalpos_uzimtumas where patalpa_id = {0}", data.RoomId);
var res = cmd.ExecuteReader().Read();
Db.Connection.Close();
if (res)
{
return(StatusCode(500, "Patalpos priskirti nepavyko patikrinkite kas ją naudoja."));
}
else
{
Db.Connection.Open();
cmd.CommandText = (string.Format(@"UPDATE personalo_darbuotojai SET fk_PATALPAnr = {0} WHERE tabelio_numeris = {1}", data.RoomId, data.TabNum));
cmd.ExecuteNonQuery();
cmd.CommandText = (string.Format(@"INSERT INTO patalpos_uzimtumas (patalpa_id, nuo, iki) VALUES ({0}, '{1}', '{2}')", data.RoomId, data.From.Date, data.To.Date));
cmd.ExecuteNonQuery();
Db.Connection.Close();
}
return(Ok());
}
catch (Exception e)
{
return(StatusCode(500, "Patalpos priskirti nepavyko patikrinkite kas ją naudoja."));
}
}
public IActionResult AssignToPatient([FromBody] RoomAssignmentModel data)
{
try
{
Db.Connection.Open();
var cmd = Db.Connection.CreateCommand() as MySqlCommand;
cmd.CommandText = string.Format(@"SELECT * FROM patalpos_uzimtumas where patalpa_id = {0} and pacientas_asmensk = {1}", data.RoomId, data.PatientCode);
var res = cmd.ExecuteReader().Read();
Db.Connection.Close();
Db.Connection.Open();
cmd.CommandText = string.Format(@"SELECT *
FROM patalpos_uzimtumas pu
JOIN patalpos p on pu.patalpa_id = p.nr
WHERE pu.pacientas_asmensk IS NOT NULL AND p.nr = {0}
GROUP BY pu.patalpa_id
HAVING COUNT(pu.patalpa_id) < p.vietu_sk", data.RoomId);
var res2 = cmd.ExecuteReader().Read();
Db.Connection.Close();
if (res || !res2)
{
return(StatusCode(500, "Patalpos priskirti nepavyko patikrinkite kas ją naudoja."));
}
else
{
Db.Connection.Open();
cmd.CommandText = string.Format(@"INSERT INTO patalpos_uzimtumas(patalpa_id, nuo, iki, pacientas_asmensk) VALUES ({0}, '{1}', '{2}', {3})", data.RoomId, data.From.Date, data.To.Date, data.PatientCode);
cmd.ExecuteNonQuery();
Db.Connection.Close();
Db.Connection.Open();
cmd.CommandText = string.Format(@"UPDATE pacientas SET fk_PATALPAid = {0} WHERE fk_ASMENINE_INFOasmens_kodas = {1}", data.RoomId, data.PatientCode);
cmd.ExecuteNonQuery();
Db.Connection.Close();
}
return(Ok());
}
catch (Exception e)
{
return(StatusCode(500, "Patalpos priskirti nepavyko patikrinkite kas ją naudoja."));
}
}
