public IEnumerable <InventoryReportItem> GetNewVehicles() { List <InventoryReportItem> cars = new List <InventoryReportItem>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("CarSelectNewInventory", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReportItem row = new InventoryReportItem(); row.CarMakeName = dr["CarMakeName"].ToString(); row.CarModelName = dr["CarModelName"].ToString(); row.CarYear = (int)dr["CarYear"]; row.Count = (int)dr["Count"]; row.StockValue = (decimal)dr["Stock Value"]; cars.Add(row); } } } return(cars); }
public IEnumerable <InventoryReportItem> GetUsedInventory() { List <InventoryReportItem> usedList = new List <InventoryReportItem>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("UsedInventory", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReportItem currentRow = new InventoryReportItem(); currentRow.MakeID = (int)dr["MakeID"]; currentRow.ModelID = (int)dr["ModelID"]; currentRow.MakeName = dr["MakeName"].ToString(); currentRow.ModelName = dr["ModelName"].ToString(); currentRow.Year = (int)dr["Year"]; currentRow.Count = (int)dr["Count"]; currentRow.StockValue = (int)dr["StockValue"]; usedList.Add(currentRow); } } } return(usedList); }
public List <InventoryReportItem> GetInventoryReport(string vehicleType) { List <InventoryReportItem> vehicles = new List <InventoryReportItem>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("InventoryReport", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@vehicleType", vehicleType); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReportItem currentRow = new InventoryReportItem(); currentRow.VehicleYear = (int)dr["VehicleYear"]; currentRow.MakeName = dr["MakeName"].ToString(); currentRow.ModelName = dr["ModelName"].ToString(); currentRow.Count = (int)dr["Count"]; currentRow.StockValue = (decimal)dr["StockValue"]; vehicles.Add(currentRow); } } } return(vehicles); }
private InventoryReportItem GetReportsInventoryModel(InventoryReportItem model) { var repo = InventoryRepositoryFactory.GetRepository(); model.inventoryNew = repo.GetNewVehicles(); model.inventoryUsed = repo.GetUsedVehicles(); return(model); }
public ActionResult Inventory() { InventoryReportItem model = new InventoryReportItem(); var repo = InventoryRepositoryFactory.GetRepository(); model = GetReportsInventoryModel(model); return(View(model)); }
public static List <InventoryReportItem> GetSelectedInventoryReportItemList(string search) { List <InventoryReportItem> reportItemList = new List <InventoryReportItem>(); List <Item> iList = EFBroker_Item.SearchItemsByItemCodeOrDesc(search); foreach (Item i in iList) { InventoryReportItem rItem = new InventoryReportItem(i); reportItemList.Add(rItem); } return(reportItemList); }
public static List <InventoryReportItem> GetInventoryReportItemList() { List <InventoryReportItem> reportItemList = new List <InventoryReportItem>(); List <Item> iList = EFBroker_Item.GetActiveItemList(); foreach (Item i in iList) { InventoryReportItem rItem = new InventoryReportItem(i); reportItemList.Add(rItem); } return(reportItemList); }
public List <InventoryReportItem> GetInventoryReport() { List <InventoryReportItem> reports = new List <InventoryReportItem>(); using (SqlConnection cn = new SqlConnection(DataSettings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetInventoryReport", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReportItem current = new InventoryReportItem(); current.ModelName = dr["ModelName"].ToString(); current.MakeName = dr["MakeName"].ToString(); current.ModelYear = (int)dr["ModelYear"]; current.InStock = (int)dr["InStock"]; reports.Add(current); } } } return(reports); }