public bool updateSaleReservations(SaleServiceReservationModel sale) { string query = "UPDATE saleServicesReservation SET idReservation = @idReservation, idEmploy = @idEmploye, discount = @discount, total = @total 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 = sale.id; cmd.Parameters.Add("@idReservation", System.Data.SqlDbType.Int).Value = sale.idReservation; cmd.Parameters.Add("@idEmploye", System.Data.SqlDbType.Int).Value = sale.idEmploye; cmd.Parameters.Add("@discount", System.Data.SqlDbType.Float).Value = sale.discount; cmd.Parameters.Add("@total", System.Data.SqlDbType.Money).Value = sale.total; int register = cmd.ExecuteNonQuery(); return(register == 1); } catch (Exception) { return(false); } finally { conn.Close(); } }
public SaleServiceReservationModel returnSaleReservation(int id) { string query = "SELECT idReservation, idEmploy, discount, total FROM saleServicesReservation WHERE id = @id"; SqlConnection conn = new SqlConnection(cadena); SqlCommand cmd = new SqlCommand(query, conn); SaleServiceReservationModel sale = new SaleServiceReservationModel(); try { conn.Open(); cmd.Parameters.Add("@id", System.Data.SqlDbType.Int).Value = id; SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { sale.idReservation = dr.GetInt32(0); sale.idEmploye = dr.GetInt32(1); sale.discount = dr.GetDouble(2); sale.total = dr.GetDecimal(3); } } catch (Exception) { } finally { conn.Close(); } return(sale); }
public bool createSaleReservation(SaleServiceReservationModel sale) { string query = "INSERT INTO saleServicesReservation VALUES(@idReservation,@idEmploye,GETDATE(),@discount,@total)"; SqlConnection conn = new SqlConnection(cadena); SqlCommand cmd = new SqlCommand(query, conn); try { conn.Open(); cmd.Parameters.Add("@idReservation", System.Data.SqlDbType.Int).Value = sale.idReservation; cmd.Parameters.Add("@idEmploye", System.Data.SqlDbType.Int).Value = sale.idEmploye; cmd.Parameters.Add("@discount", System.Data.SqlDbType.Float).Value = sale.discount; cmd.Parameters.Add("@total", System.Data.SqlDbType.Money).Value = sale.total; int register = cmd.ExecuteNonQuery(); return(register == 1); } catch (Exception) { return(false); } finally { conn.Close(); } }