public WorkPart(string id, string description, decimal price, int quantity, Work work) : base(id, description, price) { Quantity = quantity; parentWork = work; }
public static Invoice Find(Work work) { try { using (SqlConnection conn = Db.Utils.NewConnection()) { using (SqlCommand cmd = new SqlCommand( "select numFact, dataFact, estadoFact, desconto, totalFactura, cliente " + "from Factura where obra = @obra and oficina = @oficina", conn)) { cmd.Parameters.AddWithValue("@obra", work.ID); cmd.Parameters.AddWithValue("@oficina", work.ShopID); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { return new Invoice(dr.GetInt32(0), dr.GetDateTime(1), dr.GetString(2), dr.GetInt32(3), dr.GetDecimal(4), work.ID, work.ShopID, dr.GetInt32(5)); } } } } } catch (SqlException ex) { throw new ModelException("Erro na base de dados.", ex.InnerException); } return null; }