public Domain.Soft.patients GetId(Int32 id)
{
Domain.Soft.patients result = new Domain.Soft.patients();
string sql = "SELECT id, history, identification, first_name, last_name, genre, civil_status, blood_type, date_birth, city_birth, url FROM patients WHERE id = @id";
using (DbCommand cmd = Connection.DataBase.GetSqlStringCommand(sql))
{
Connection.DataBase.AddInParameter(cmd, "@id", DbType.Int32, id);
using (IDataReader dr = Connection.DataBase.ExecuteReader(cmd))
{
if (dr.Read())
{
result.id = Convert.ToInt32(dr["id"]);
result.history = Convert.ToString(dr["history"]);
result.identification = Convert.ToString(dr["identification"]);
result.first_name = Convert.ToString(dr["first_name"]);
result.last_name = Convert.ToString(dr["last_name"]);
result.genre = Convert.ToString(dr["genre"]);
result.civil_status = Convert.ToString(dr["civil_status"]);
result.blood_type = Convert.ToString(dr["blood_type"]);
if (dr["date_birth"].ToString() != "")
{
result.date_birth = Convert.ToDateTime(dr["date_birth"]);
}
result.city_birth = Convert.ToString(dr["city_birth"]);
result.url = Convert.ToString(dr["url"]);
}
}
}
return(result);
}
public List <Domain.Soft.patients> Get()
{
List <Domain.Soft.patients> result = new List <Domain.Soft.patients>();
string sql = "SELECT id, history, identification, first_name, last_name, genre, civil_status, blood_type, date_birth, city_birth, url FROM patients";
using (DbCommand cmd = Connection.DataBase.GetSqlStringCommand(sql))
{
using (IDataReader dr = Connection.DataBase.ExecuteReader(cmd))
{
while (dr.Read())
{
var spe = new Domain.Soft.patients();
spe.id = Convert.ToInt32(dr["id"]);
spe.history = Convert.ToString(dr["history"]);
spe.identification = Convert.ToString(dr["identification"]);
spe.first_name = Convert.ToString(dr["first_name"]);
spe.last_name = Convert.ToString(dr["last_name"]);
spe.genre = Convert.ToString(dr["genre"]);
spe.civil_status = Convert.ToString(dr["civil_status"]);
spe.blood_type = Convert.ToString(dr["blood_type"]);
if (dr["date_birth"].ToString() != "")
{
spe.date_birth = Convert.ToDateTime(dr["date_birth"]);
}
spe.city_birth = Convert.ToString(dr["city_birth"]);
spe.url = Convert.ToString(dr["url"]);
result.Add(spe);
}
}
}
return(result);
}
public bool Save(Domain.Soft.patients pat)
{
bool result = false;
Infraestructura.Soft.Repository.RepositoryPatients ss = new Infraestructura.Soft.Repository.RepositoryPatients();
result = ss.Save(pat);
return(result);
}
public bool Save(Domain.Soft.patients pac)
{
bool result = false;
string sql = @"BEGIN
IF NOT EXISTS(SELECT 1 FROM patients WHERE id = @id)
BEGIN
INSERT INTO patients
(
id
,history
,identification
,first_name
,last_name
,genre
,civil_status
,blood_type
,date_birth
,city_birth
,url
)
VALUES
(
@id
,@history
,@identification
,@first_name
,@last_name
,@genre
,@civil_status
,@blood_type
,@date_birth
,@city_birth
,@url
);
END
ELSE
BEGIN
UPDATE patients SET
history = @history
,identification = @identification
,first_name = @first_name
,last_name = @last_name
,genre = @genre
,civil_status = @civil_status
,blood_type = @blood_type
,date_birth = @date_birth
,city_birth = @city_birth
,url = @url
WHERE id = @id;
END
END";
using (DbCommand cmd = Connection.DataBase.GetSqlStringCommand(sql))
{
Connection.DataBase.AddInParameter(cmd, "@id", DbType.Int32, pac.id);
Connection.DataBase.AddInParameter(cmd, "@history", DbType.String, pac.history);
Connection.DataBase.AddInParameter(cmd, "@identification", DbType.String, pac.identification);
Connection.DataBase.AddInParameter(cmd, "@first_name", DbType.String, pac.first_name);
Connection.DataBase.AddInParameter(cmd, "@last_name", DbType.String, pac.last_name);
Connection.DataBase.AddInParameter(cmd, "@genre", DbType.String, pac.genre);
Connection.DataBase.AddInParameter(cmd, "@civil_status", DbType.String, pac.civil_status);
Connection.DataBase.AddInParameter(cmd, "@blood_type", DbType.String, pac.blood_type);
Connection.DataBase.AddInParameter(cmd, "@date_birth", DbType.DateTime, pac.date_birth);
Connection.DataBase.AddInParameter(cmd, "@city_birth", DbType.String, pac.city_birth);
Connection.DataBase.AddInParameter(cmd, "@url", DbType.String, pac.url);
var i = Connection.DataBase.ExecuteNonQuery(cmd);
result = i > 0;
}
return(result);
}
