//consultar reserva public DataTable ConsultaReserva(DReserva Reserva) { DataTable dtResultado = new DataTable("tbReservas"); SqlConnection sqlCon = new SqlConnection(); try { sqlCon.ConnectionString = Conexao.Cn; SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandText = "consultarReserva"; sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter parReserva = new SqlParameter(); parReserva.ParameterName = "@idReserva"; parReserva.SqlDbType = SqlDbType.Int; parReserva.Value = Reserva.IdReserva; sqlCmd.Parameters.Add(parReserva); SqlDataAdapter sqlDat = new SqlDataAdapter(sqlCmd); sqlDat.Fill(dtResultado); } catch (Exception) { dtResultado = null; } return(dtResultado); }
// exclui reserva public static string ExcluirReserva(int idReserva) { DReserva Obj = new CamadaDados.DReserva(); Obj.IdReserva = idReserva; return(Obj.ExcluirReserva(Obj)); }
//inclui reserva public static string InserirReserva(string area, DateTime data, int idMorador) { DReserva Obj = new CamadaDados.DReserva(); Obj.Area = area; Obj.Data = data; Obj.IdMorador = idMorador; return(Obj.IncluirReserva(Obj)); }
//excluir reserva public string ExcluirReserva(DReserva Reserva) { string resp = ""; SqlConnection sqlCon = new SqlConnection(); try { //codigo sqlCon.ConnectionString = Conexao.Cn; sqlCon.Open(); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandText = "excluirReserva"; sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter parIdMorador = new SqlParameter(); parIdMorador.ParameterName = "@idreserva"; parIdMorador.SqlDbType = SqlDbType.Int; parIdMorador.Value = Reserva.IdReserva; sqlCmd.Parameters.Add(parIdMorador); //executar comando resp = sqlCmd.ExecuteNonQuery() == 1 ? "Reserva excluido" : "Reserva não excluido"; } catch (Exception ex) { resp = ex.Message; } finally { if (sqlCon.State == ConnectionState.Open) { sqlCon.Close(); } } return(resp); }
// incluir reserva public string IncluirReserva(DReserva Reserva) { string resp = ""; SqlConnection sqlCon = new SqlConnection(); try { //codigo sqlCon.ConnectionString = Conexao.Cn; sqlCon.Open(); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandText = "inserirReserva"; sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter parIdReserva = new SqlParameter(); parIdReserva.ParameterName = "@idReserva"; parIdReserva.SqlDbType = SqlDbType.Int; parIdReserva.Direction = ParameterDirection.Output; sqlCmd.Parameters.Add(parIdReserva); SqlParameter parIdMorador = new SqlParameter(); parIdMorador.ParameterName = "@idMorador"; parIdMorador.SqlDbType = SqlDbType.Int; parIdMorador.Direction = ParameterDirection.Input; parIdMorador.Value = Reserva.IdMorador; sqlCmd.Parameters.Add(parIdMorador); SqlParameter parArea = new SqlParameter(); parArea.ParameterName = "@area"; parArea.SqlDbType = SqlDbType.VarChar; parArea.Size = 25; parArea.Value = Reserva.Area; sqlCmd.Parameters.Add(parArea); SqlParameter parData = new SqlParameter(); parData.ParameterName = "@data"; parData.SqlDbType = SqlDbType.DateTime; parData.Value = Reserva.Data; sqlCmd.Parameters.Add(parData); //executar comando resp = sqlCmd.ExecuteNonQuery() == 1 ? "Reserva Inserido" : "Reserva não inserido"; } catch (Exception ex) { resp = ex.Message; } finally { if (sqlCon.State == ConnectionState.Open) { sqlCon.Close(); } } return(resp); }