public List <ProductionVModel> GetProduction()
{
List <Production> prodList = new List <Production>();
using (MySqlConnection con = new MySqlConnection(connString))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "GetWeeklyProduction";
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Production product = new Production();
product.Date = (DateTime)reader["Date"];
product.ProductName = reader["ProductName"].ToString();
product.Quantity = (int)reader["Quantity"];
product.ProductionId = (int)reader["ProductionId"];
prodList.Add(product);
}
reader.NextResult();
}
}
}
}
List <ProductionVModel> viewList = new List <ProductionVModel>();
if (prodList.Count > 0)
{
List <Product> list = new ProductDAL().GetProductList();
foreach (var product in list)
{
if (product.Show == "True")
{
ProductionVModel model = new ProductionVModel();
model.ProductName = product.ProductName;
model.Quantity = 0;
foreach (var production in prodList)
{
if (model.ProductName == production.ProductName)
{
model.Quantity = model.Quantity + production.Quantity;
}
}
viewList.Add(model);
}
}
}
else
{
return(viewList);
}
return(viewList);
}
public List <ProductionVModel> GetWeeklyProduction()
{
List <Production> prodList = new List <Production>();
using (MySqlConnection con = new MySqlConnection(connString))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "GetWeeklyProduction";
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Production product = new Production();
product.Date = (DateTime)reader["Date"];
product.ProductName = reader["ProductName"].ToString();
product.Quantity = (int)reader["Quantity"];
product.ProductionId = (int)reader["ProductionId"];
prodList.Add(product);
}
reader.NextResult();
}
}
}
}
List <ProductionVModel> viewList = new List <ProductionVModel>();
if (prodList.Count > 0)
{
List <Product> list = new ProductDAL().GetProductList();
foreach (var production in prodList)
{
Product product = list.Where(p => p.ProductName == production.ProductName).FirstOrDefault();
ProductionVModel model = new ProductionVModel();
model.ProductName = product.ProductName;
model.Quantity = production.Quantity;
model.Date = production.Date;
model.ImagePath = product.ImagePath;
model.ProductId = product.ProductID;
model.Category = product.Category;
model.Id = production.ProductionId;
if (model.Quantity > 0)
{
viewList.Add(model);
}
}
}
else
{
return(viewList);
}
return(viewList);
}