public bool InserirBL(Reservas instancia)
{
/*criar as regras de negocio*/
ReservasDA varDA = new ReservasDA();
return varDA.InserirDA(instancia);
}
public bool ExcluirDA(Reservas instancia)
{
SqlParameter[] paramsToSP = new SqlParameter[1];
paramsToSP[0] = new SqlParameter("@id", instancia.Id);
try
{
return (SqlHelper.ExecuteNonQuery(
ConfigurationManager.ConnectionStrings["conexao"].ToString(),
CommandType.StoredProcedure, "stp_delete_Reservas", paramsToSP) > 0);
}
catch (Exception e)
{
return false;
}
}
public bool InserirDA(Reservas instancia)
{
SqlParameter[] paramsToSP = new SqlParameter[4];
paramsToSP[0] = new SqlParameter("@pessoaId", instancia.PessoaId);
paramsToSP[1] = new SqlParameter("@exemplarId", instancia.ExemplarId);
paramsToSP[2] = new SqlParameter("@dataInicio", instancia.DataInicio);
paramsToSP[0] = new SqlParameter("@dataFim", instancia.DataFim);
try
{
return (SqlHelper.ExecuteNonQuery(
ConfigurationManager.ConnectionStrings["conexao"].ToString(),
CommandType.StoredProcedure, "stp_insert_Reservas", paramsToSP) > 0);
}
catch (Exception e)
{
return false;
}
}
private List<Reservas> CarregarObjReservas(SqlDataReader dr)
{
List<Reservas> reservas = new List<Reservas>();
while (dr.Read())
{
Reservas reserva = new Reservas();
reserva.Id = int.Parse(dr["ID"].ToString());
reserva.PessoaId = int.Parse(dr["PESSOAID"].ToString());
reserva.ExemplarId = int.Parse(dr["EXEMPLARID"].ToString());
reserva.DataInicio = Convert.ToDateTime(dr["DATAINICIO"].ToString());
reserva.DataFim = Convert.ToDateTime(dr["DATAFIM"].ToString());
reservas.Add(reserva);
}
return reservas;
}