public DdtDoctor GetById(string id)
{
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = String.Format("SELECT r_object_id, dss_middle_name, dss_first_name, r_modify_date, r_creation_date, dss_last_name FROM ddt_doctor WHERE r_object_id = '{0}'", id);
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
DdtDoctor obj = new DdtDoctor();
obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.MiddleName = reader.IsDBNull(1) ? null : reader.GetString(1);
obj.FirstName = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.ModifyDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.CreationDate = reader.IsDBNull(4) ? DateTime.MinValue : reader.GetDateTime(4);
obj.LastName = reader.IsDBNull(5) ? null : reader.GetString(5);
return(obj);
}
}
}
return(null);
}
public IList <DdtDoctor> GetAll()
{
IList <DdtDoctor> list = new List <DdtDoctor>();
using (dynamic connection = connectionFactory.GetConnection())
{
String sql = "SELECT r_object_id, dss_middle_name, dss_first_name, r_modify_date, r_creation_date, dss_last_name FROM ddt_doctor";
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, connection);
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DdtDoctor obj = new DdtDoctor();
obj.ObjectId = reader.IsDBNull(0) ? null : reader.GetString(0);
obj.MiddleName = reader.IsDBNull(1) ? null : reader.GetString(1);
obj.FirstName = reader.IsDBNull(2) ? null : reader.GetString(2);
obj.ModifyDate = reader.IsDBNull(3) ? DateTime.MinValue : reader.GetDateTime(3);
obj.CreationDate = reader.IsDBNull(4) ? DateTime.MinValue : reader.GetDateTime(4);
obj.LastName = reader.IsDBNull(5) ? null : reader.GetString(5);
list.Add(obj);
}
}
}
return(list);
}
public string Save(DdtDoctor obj)
{
using (dynamic connection = connectionFactory.GetConnection())
{
if (GetById(obj.ObjectId) != null)
{
string sql = "UPDATE ddt_doctor SET " +
"dss_last_name = @LastName, " +
"dss_first_name = @FirstName, " +
"dss_middle_name = @MiddleName " +
"WHERE r_object_id = @ObjectId";
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
using (Npgsql.NpgsqlCommand cmd = new Npgsql.NpgsqlCommand(sql, connection))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@LastName", obj.LastName);
cmd.Parameters.AddWithValue("@FirstName", obj.FirstName);
cmd.Parameters.AddWithValue("@MiddleName", obj.MiddleName);
cmd.Parameters.AddWithValue("@ObjectId", obj.ObjectId);
cmd.ExecuteNonQuery();
}
return(obj.ObjectId);
}
else
{
string sql = "INSERT INTO ddt_doctor(dss_last_name,dss_first_name,dss_middle_name) " +
"VALUES(@LastName,@FirstName,@MiddleName) RETURNING r_object_id";
Logger.Debug(CultureInfo.CurrentCulture, "SQL: {0}", sql);
using (Npgsql.NpgsqlCommand cmd = new Npgsql.NpgsqlCommand(sql, connection))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@LastName", obj.LastName);
cmd.Parameters.AddWithValue("@FirstName", obj.FirstName);
cmd.Parameters.AddWithValue("@MiddleName", obj.MiddleName);
return((string)cmd.ExecuteScalar());
}
}
}
}
