public Consignment GetConsignment(string consignmentID) { SqlConnection connection; SqlCommand command; SqlDataReader reader; string query; Consignment newConsignment = new Consignment(); connection = new SqlConnection(ConfigurationManager.ConnectionStrings["PeninsulaRV"].ConnectionString); query = "SELECT * FROM ConsignmentView WHERE ConsignmentID = @ConsignmentID"; connection.Open(); command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@ConsignmentID", consignmentID); reader = command.ExecuteReader(); while (reader.Read()) { newConsignment.ConsignmentID = reader["ConsignmentID"].ToString(); newConsignment.VehicleRef = reader["VehicleRef"].ToString(); newConsignment.CustomerRef = reader["CustomerRef"].ToString(); newConsignment.DealType = reader["DealType"].ToString(); newConsignment.LienHolder = reader["LienHolder"].ToString(); newConsignment.Status = reader["Status"].ToString(); newConsignment.Term = Convert.ToInt16(reader["Term"]); newConsignment.AskingPrice = Convert.ToDecimal(reader["AskingPrice"]); newConsignment.MinimumPrice = Convert.ToDecimal(reader["MinimumPrice"]); newConsignment.DealCalc = Convert.ToDecimal(reader["DealCalc"]); newConsignment.BalanceOwed = Convert.ToDecimal(reader["BalanceOwed"]); newConsignment.ConsignDate = Convert.ToDateTime(reader["ConsignDate"]); newConsignment.ExpireDate = Convert.ToDateTime(reader["ExpireDate"]); newConsignment.OwnerType = reader["OwnerType"].ToString(); } Customer newCustomer = new Customer(); newCustomer = newCustomer.GetCustomer(newConsignment.CustomerRef); newConsignment.Seller = newCustomer; Vehicle newVehicle = new Vehicle(); newVehicle = newVehicle.GetVehicle(newConsignment.VehicleRef); newConsignment.SaleVehicle = newVehicle; return(newConsignment); }
public Offer GetOffer(string offerID) { SqlConnection connection; SqlCommand command; SqlDataReader reader; string query; Offer newOffer = new Offer(); connection = new SqlConnection(ConfigurationManager.ConnectionStrings["PeninsulaRV"].ConnectionString); query = "SELECT * FROM OfferView WHERE OfferID = @OfferID"; connection.Open(); command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@OfferID", offerID); reader = command.ExecuteReader(); while (reader.Read()) { newOffer.OfferID = reader["OfferID"].ToString(); this.OfferID = reader["OfferID"].ToString(); newOffer.SaleDate = Convert.ToDateTime(reader["SaleDate"]); newOffer.ConsignmentRef = reader["ConsignmentRef"].ToString(); newOffer.BuyerRef = reader["BuyerRef"].ToString(); newOffer.TradeInfo = reader["TradeInfo"].ToString(); newOffer.ExemptReason = reader["ExemptReason"].ToString(); newOffer.NewLienHolder = reader["NewLienHolder"].ToString(); newOffer.Status = reader["OfferStatus"].ToString(); newOffer.SalePrice = Convert.ToDecimal(reader["SalePrice"]); newOffer.OptionTotal = Convert.ToDecimal(reader["OptionsPrice"]); newOffer.DocumentFee = Convert.ToDecimal(reader["DocumentFee"]); newOffer.LicenseFee = Convert.ToDecimal(reader["LicenseFee"]); newOffer.SalesTax = Convert.ToDecimal(reader["SalesTax"]); newOffer.SubTotal = Convert.ToDecimal(reader["SubTotal"]); newOffer.GrandTotal = Convert.ToDecimal(reader["GrandTotal"]); newOffer.BalanceDue = Convert.ToDecimal(reader["BalanceDue"]); newOffer.TradeCredit = Convert.ToDecimal(reader["TradeCredit"]); newOffer.TradeTaxCredit = Convert.ToDecimal(reader["TradeTaxCredit"]); newOffer.CashWithOrder = Convert.ToDecimal(reader["CashWithOrder"]); newOffer.Deposit = Convert.ToDecimal(reader["Deposit"]); newOffer.SellerPaidFee = Convert.ToDecimal(reader["SellerPaidFee"]); newOffer.DealerCost = Convert.ToDecimal(reader["DealerCost"]); newOffer.GrossProfit = Convert.ToDecimal(reader["Commission"]); newOffer.SellerDue = Convert.ToDecimal(reader["SellerDue"]); } Customer newCustomer = new Customer(); newCustomer = newCustomer.GetCustomer(newOffer.BuyerRef); newOffer.Buyer = newCustomer; Consignment newConsignment = new Consignment(); newConsignment = newConsignment.GetConsignment(newOffer.ConsignmentRef); newOffer.Salesmen = GetSalesmen(); newOffer.Options = GetOptions(); newOffer.SaleConsignment = newConsignment; return(newOffer); }