public void deleteProperty(PropertyInfo pInfo)
{
if (pInfo == null)
return;
if (!connect())
return;
String req;
req = "DELETE FROM PROPERTY WHERE ID = :value1";
NpgsqlCommand command = new NpgsqlCommand(req, connection);
try
{
command.Parameters.Add(new NpgsqlParameter("value1", NpgsqlTypes.NpgsqlDbType.Numeric));
command.Parameters["value1"].Value = pInfo.id;
command.ExecuteNonQuery();
}
catch (Exception ex)
{
HandleException(ex);
}
finally
{
disconnect();
}
}
public void editProperty(PropertyInfo pInfo)
{
if (pInfo == null)
return;
if (pInfo.name == null ||
pInfo.name.Length == 0)
throw new ArgumentNullException("pInfo.name", "name shoudn't be null or empty");
String req;
if (pInfo.id == 0)
{
req = "INSERT INTO PROPERTY (NAME, POLICE) VALUES (:value1, :value2)";
}
else
{
req = "UPDATE PROPERTY SET NAME = :value1, POLICE = :value2 WHERE ID = :value3";
}
if (!connect())
return;
NpgsqlCommand command = new NpgsqlCommand(req, connection);
try
{
command.Parameters.Add(new NpgsqlParameter("value1", NpgsqlTypes.NpgsqlDbType.Varchar));
command.Parameters["value1"].Value = pInfo.name;
command.Parameters.Add(new NpgsqlParameter("value2", NpgsqlTypes.NpgsqlDbType.Char));
command.Parameters["value2"].Value = booleanToDb(pInfo.policeVisibility);
command.Parameters.Add(new NpgsqlParameter("value3", NpgsqlTypes.NpgsqlDbType.Numeric));
command.Parameters["value3"].Value = pInfo.id;
command.ExecuteNonQuery();
}
catch (Exception ex)
{
HandleException(ex);
}
finally
{
disconnect();
}
}
public IList<PropertyInfo> getPropertyList()
{
List<PropertyInfo> ret = new List<PropertyInfo>();
if (!connect())
return null;
NpgsqlCommand command = new NpgsqlCommand("select ID, NAME, POLICE from PROPERTY order by NAME ASC", connection);
try
{
NpgsqlDataReader rd = command.ExecuteReader();
while (rd.Read())
{
PropertyInfo info = new PropertyInfo();
info.id = Convert.ToUInt64(rd["ID"]);
info.name = Convert.ToString(rd["NAME"]);
info.policeVisibility = dbToBoolean(rd["POLICE"]);
ret.Add(info);
}
}
catch (Exception ex)
{
HandleException(ex);
}
finally
{
disconnect();
}
return ret;
}