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);
}
