public int monthlysales(int month, int year) { using (var ctx = new GSQ2_Kiranjeet_DADContext()) { int sales = int.Parse(ctx.MonthlySalesRecord.FromSql("rentSalesForSelectedMonth", month, year).FirstOrDefault().ToString()); return(sales); } }
public int salesBetweenSelectedDates(DateTime startDate, DateTime endDate) { using (var ctx = new GSQ2_Kiranjeet_DADContext()) { int sales = int.Parse(ctx.MonthlySalesRecord.FromSql("rentSalesBetweenGivenDates", startDate, endDate).FirstOrDefault().ToString()); return(sales); } }
public List <TruckData> leastFiveRentedTrucks() { using (var ctx = new GSQ2_Kiranjeet_DADContext()) { List <TruckData> truck = ctx.TruckData.FromSql("leastFiveRentedTrucks").ToList(); return(truck); } }