public async Task Insert()
{
var products = new List <Domain.Aggregate.Products>();
string con =
@"Provider=Microsoft.ACE.OLEDB.12.0;;Data Source=.\Data\stock-2020.xlsx;" +
@"Extended Properties='Excel 12.0;HDR=Yes;'";
using (OleDbConnection connection = new OleDbConnection(con))
{
connection.Open();
DataSet ds = new DataSet();
OleDbDataAdapter d = new OleDbDataAdapter("SELECT * from [Sheet1$]", con);
d.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
if (!string.IsNullOrEmpty(row["rasma"].ToString()))
{
if (GetColumValue(row["M"]) != 0)
{
var product = new Products(row["Name"] + " " +
row["rasma"].ToString(), 160, (short)GetColumValue(row["M"]), 0, 1, "M");
product.GetNewProductNumber();
products.Add(product);
}
if (GetColumValue(row["L"]) != 0)
{
var product = new Products(row["Name"] + " " +
row["rasma"].ToString(), 160, (short)GetColumValue(row["L"]), 0, 1, "L");
product.GetNewProductNumber();
products.Add(product);
}
if (GetColumValue(row["XL"]) != 0)
{
var product = new Products(row["Name"] + " " +
row["rasma"].ToString(), 160, (short)GetColumValue(row["XL"]), 0, 1, "XL");
product.GetNewProductNumber();
products.Add(product);
}
if (GetColumValue(row["2XL"]) != 0)
{
var product = new Products(row["Name"] + " " +
row["rasma"].ToString(), 160, (short)GetColumValue(row["2XL"]), 0, 1, "2XL");
product.GetNewProductNumber();
products.Add(product);
}
if (GetColumValue(row["3XL"]) != 0)
{
var product = new Products(row["Name"] + " " +
row["rasma"].ToString(), 160, (short)GetColumValue(row["3XL"]), 0, 1, "3XL");
product.GetNewProductNumber();
products.Add(product);
}
}
}
}
_repostiory.CreateRange(products, "");
await _repostiory.SaveAsync();
}
