public ReservationsModel returnReservation(int id) { string query = "SELECT idService, email, name, flName, reservation, process FROM reservations WHERE id = @id"; SqlConnection conn = new SqlConnection(cadena); SqlCommand cmd = new SqlCommand(query, conn); ReservationsModel reservation = new ReservationsModel(); try { conn.Open(); cmd.Parameters.Add("@id", System.Data.SqlDbType.Int).Value = id; SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { reservation.idService = dr.GetInt32(0); reservation.email = dr.GetString(1); reservation.name = dr.GetString(2); reservation.flName = dr.GetString(3); reservation.reservation = dr.GetString(4); reservation.process = dr.GetString(5); } } catch (Exception) { } finally { conn.Close(); } return(reservation); }
public bool updateReservations(ReservationsModel reservation) { string query = "UPDATE reservations SET idService = @idService, email = @email, name = @name, flName = @flName, reservation = @reservation, process = @process WHERE id = @id"; SqlConnection conn = new SqlConnection(cadena); SqlCommand cmd = new SqlCommand(query, conn); try { conn.Open(); cmd.Parameters.Add("@id", System.Data.SqlDbType.Int).Value = reservation.id; cmd.Parameters.Add("@idService", System.Data.SqlDbType.Int).Value = reservation.idService; cmd.Parameters.Add("@email", System.Data.SqlDbType.VarChar).Value = reservation.email; cmd.Parameters.Add("@name", System.Data.SqlDbType.VarChar).Value = reservation.name; cmd.Parameters.Add("@flName", System.Data.SqlDbType.VarChar).Value = reservation.flName; cmd.Parameters.Add("@reservation", System.Data.SqlDbType.VarChar).Value = reservation.reservation; cmd.Parameters.Add("@process", System.Data.SqlDbType.VarChar).Value = reservation.process; int register = cmd.ExecuteNonQuery(); return(register == 1); } catch (Exception) { return(false); } finally { conn.Close(); } }
public bool createReservations(ReservationsModel reservation) { string query = "INSERT INTO reservations VALUES (@idService,@idStore,@email,@name,@flName,GETDATE(),@reservation,DEFAULT)"; SqlConnection conn = new SqlConnection(cadena); SqlCommand cmd = new SqlCommand(query, conn); try { conn.Open(); cmd.Parameters.Add("@idService", System.Data.SqlDbType.Int).Value = reservation.idService; cmd.Parameters.Add("@idStore", System.Data.SqlDbType.Int).Value = reservation.idStore; cmd.Parameters.Add("@email", System.Data.SqlDbType.VarChar).Value = reservation.email; cmd.Parameters.Add("@name", System.Data.SqlDbType.VarChar).Value = reservation.name; cmd.Parameters.Add("@flName", System.Data.SqlDbType.VarChar).Value = reservation.flName; cmd.Parameters.Add("@reservation", System.Data.SqlDbType.VarChar).Value = reservation.reservation; int register = cmd.ExecuteNonQuery(); return(register == 1); } catch (Exception) { return(false); } finally { conn.Close(); } }