public VatCalculatorViewModel() { Diesel = new PurchasesVat(); Super = new PurchasesVat(); Vpower = new PurchasesVat(); Kerosene = new PurchasesVat(); }
public List <PurchasesVat> GetLatestPurchasesVat() { List <PurchasesVat> Entries = new List <PurchasesVat>(); SqlServerConnection conn = new SqlServerConnection(); SqlDataReader dr = conn.SqlServerConnect("DECLARE @date DATE = (SELECT MAX(pv_date) dt FROM PurchaseVATCalc); SELECT pv_idnt, pv_date, pv_product, pv_landing, pv_pipeline, pv_road, pv_pipeloss, pv_depotloss, pv_delivery, (pv_pipeline+ pv_road+pv_pipeloss+pv_depotloss+pv_delivery) B_STORAGE_DIST, pv_margin_import, pv_margin_dealer, (pv_margin_import+pv_margin_dealer) C_MARGINS, pv_excise_duty, pv_merchant_levy, pv_declaration_fee, pv_road_maintainance, pv_devt_petroleum, pv_regu_petroleum, pv_devt_railway, pv_vat, (pv_excise_duty+pv_merchant_levy+pv_declaration_fee+pv_road_maintainance+pv_devt_petroleum+pv_regu_petroleum+pv_devt_railway+pv_vat) D_TAX_LEVIES, pv_landing+(pv_pipeline+ pv_road+pv_pipeloss+pv_depotloss+pv_delivery)+(pv_margin_import+pv_margin_dealer)+(pv_excise_duty+pv_merchant_levy+pv_declaration_fee+pv_road_maintainance+pv_devt_petroleum+pv_regu_petroleum+pv_devt_railway+pv_vat) E_RETAIL, (pv_pipeloss+pv_depotloss+pv_merchant_levy+pv_declaration_fee+pv_road_maintainance+pv_devt_petroleum+pv_regu_petroleum+pv_devt_railway) F_EXEMPT FROM PurchaseVATCalc WHERE pv_date=@date ORDER BY pv_product"); if (dr.HasRows) { while (dr.Read()) { PurchasesVat Entry = new PurchasesVat(); Entry.Id = Convert.ToInt64(dr[0]); Entry.Date = Convert.ToDateTime(dr[1]); Entry.Product.Id = Convert.ToInt64(dr[2]); Entry.LandingCost = Convert.ToDouble(dr[3]); Entry.Pipeline = Convert.ToDouble(dr[4]); Entry.Roads = Convert.ToDouble(dr[5]); Entry.PipesLoss = Convert.ToDouble(dr[6]); Entry.DepotLoss = Convert.ToDouble(dr[7]); Entry.Delivery = Convert.ToDouble(dr[8]); Entry.StorageDist = Convert.ToDouble(dr[9]); Entry.MarginImport = Convert.ToDouble(dr[10]); Entry.MarginDealer = Convert.ToDouble(dr[11]); Entry.MarginSummary = Convert.ToDouble(dr[12]); Entry.ExciseDuty = Convert.ToDouble(dr[13]); Entry.MerchantLevy = Convert.ToDouble(dr[14]); Entry.DeclarationFee = Convert.ToDouble(dr[15]); Entry.RoadsMaintance = Convert.ToDouble(dr[16]); Entry.DevtPetroleum = Convert.ToDouble(dr[17]); Entry.ReguPetroleum = Convert.ToDouble(dr[18]); Entry.DevtRailway = Convert.ToDouble(dr[19]); Entry.ValueAddedTax = Convert.ToDouble(dr[20]); Entry.TaxesAndLevies = Convert.ToDouble(dr[21]); Entry.RetailPrice = Convert.ToDouble(dr[22]); Entry.TaxExempts = Convert.ToDouble(dr[23]); Entry.TaxableAmts = Entry.RetailPrice - Entry.TaxExempts; Entries.Add(Entry); } } return(Entries); }