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