private List <AlertDTO> getAlert(SqlDataReader reader)
{
var alerts = new List <AlertDTO>();
while (reader.Read())
{
var alert = new AlertDTO
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
Notifywhenarriving = reader.GetString(2),
Notifywhenleaving = reader.GetString(3),
Active = reader.GetString(5)
};
//Id = reader[reader.GetOrdinal("a.id")] as int? ?? default(int)
var enterprise = new EnterpriseDTO(
reader.GetInt32(6),
reader[7] as string,
reader[8] as int? ?? default(int),
reader[9] as string,
reader[10] as int? ?? default(int)
);
alert.Enterprise = enterprise;
alerts.Add(alert);
}
return(alerts);
}
public int editAlert(int id, AlertDTO alert)
{
var sql = @$ "UPDATE alert
set name = '{alert.Name}', notifywhenarriving = '{alert.Notifywhenarriving}',
public int addAlert(AlertDTO alert)
{
var sql = $"INSERT INTO alert(id, name, notifywhenarriving, notifywhenleaving, enterpriseid, active) values ({alert.Id}, '{alert.Name}', '{alert.Notifywhenarriving}', '{alert.Notifywhenleaving}', '{alert.Enterprise.Id}', '{alert.Active}')";
return(this.GetNonQuery(sql));
}
