public Policlinic GetPoliclinicById(int policlinicId)
{
try
{
var query = "SELECT * FROM \"PoliclinicTable\" WHERE \"PoliclinicId\" = @PoliclinicId";
var parameters = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@PoliclinicId", policlinicId)
};
var results = PostgreSQLHelper_Policlinic.ExecuteParamerizedSelectCommand(query, CommandType.Text,
parameters.ToArray());
if (results.Rows.Count == 0)
{
return(null);
}
return(new Policlinic()
{
PoliclinicId = results.Rows[0].Field <int>("PoliclinicId"),
Title = results.Rows[0].Field <string>("Title"),
Region = GetRegionById(results.Rows[0].Field <int>("RegionId"))
});
}
catch (Exception exception)
{
return(new Policlinic());
}
}
public int AddSpecialization(Specialization specialization)
{
try
{
var query = "INSERT INTO \"SpecializationTable\" VALUES(default, @Name) RETURNING \"SpecializationId\"";
var parameters = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@Name", specialization.Name)
};
var results = PostgreSQLHelper_Policlinic.ExecuteParamerizedSelectCommand(query, CommandType.Text,
parameters.ToArray());
return(results.Rows.Count > 0 ? int.Parse(results.Rows[0][0].ToString()) : -1);
}
catch (Exception exception)
{
return(-1);
}
}
public int IsPatientExists(Patient patient)
{
try
{
var query = "SELECT \"PatientId\" FROM \"PatientTable\" WHERE \"Name\" = @Name AND \"LastName\" = @LastName AND \"Patronymic\" = @Patronymic AND \"BirthDay\" = @BirthDay AND \"Address\" = @Address";
var parameters = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@Name", patient.FirstName),
new NpgsqlParameter("@LastName", patient.LastName),
new NpgsqlParameter("@Patronymic", patient.Patronymic),
new NpgsqlParameter("@BirthDay", patient.Birthday),
new NpgsqlParameter("@Address", patient.Address)
};
var results = PostgreSQLHelper_Policlinic.ExecuteParamerizedSelectCommand(query, CommandType.Text,
parameters.ToArray());
return(results.Rows.Count != 0 ? results.Rows[0].Field <int>("PatientId") : -1);
}
catch (Exception exception)
{
return(-1);
}
}