public Destinatarios DestinatariosGrid()
{
Destinatarios userse = new Destinatarios();
string connectionString = UtilSh.strCnn2; //System.Configuration.ConfigurationManager.ConnectionStrings["cnnSql2"].ToString();
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "Exec dbo.DestinatariosGrid";
command.CommandType = CommandType.Text;
connection.Open();
using (SqlDataReader dataReader = command.ExecuteReader())
{
DestinyDTO user;
while (dataReader.Read())
{
user = new DestinyDTO();//Creación de un nuevo objeto del tipo de nuestro DTO en donde cargaremos toda la información proveniente de nuestro comando de DB, discriminando cada elemento con 'request'
user.ID = Convert.ToInt32(dataReader["ID"]);
user.Admin = Convert.ToString(dataReader["Admin"]);
user.Vice = Convert.ToString(dataReader["Vice"]);
userse.Add(user);
}
}
//Convert.ToInt32(paramTotalRecords.Value);
}
}
return userse;
}
public IActionResult Remove(DestinyDTO dto)
{
try
{
_destiny.Remove(dto.IdDestiny);
}
catch (Exception e)
{
Console.WriteLine(e);
//throw;
}
return(RedirectToAction("Info", "Origins", new { id = dto.IdOrigin }));
}
public void Add(DestinyDTO dto)
{
if (_db.Destinies.Any(x => x.Email == dto.Email && x.IdOrigin == dto.IdOrigin))
{
throw new DestinyAlreadyExistException();
}
var destiny = new Destiny
{
IdDestiny = Guid.NewGuid(),
IdOrigin = dto.IdOrigin,
Email = dto.Email
};
_db.Destinies.Add(destiny);
_db.SaveChanges();
}
