public async Task <IActionResult> Update([FromBody] Productentity productentity)
{
try
{
var product = db.Products.Find(productentity.id);
product.ProductName = productentity.name;
product.UnitsInStock = productentity.quantity;
product.UnitPrice = productentity.price;
product.CategoryId = productentity.categoriid;
db.SaveChanges();
return(Ok(product));
}
catch
{
return(BadRequest());
}
}
public async Task <ActionResult> Create([FromBody] Productentity productentity)
{
using (IDbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
var product = new Products()
{
ProductId = productentity.id,
ProductName = productentity.name,
UnitPrice = productentity.price,
CategoryId = productentity.categoriid,
UnitsInStock = productentity.quantity,
};
db.Products.Add(product);
transaction.Commit();
await db.SaveChangesAsync();
var categories = new Categories()
{
CategoryName = productentity.categoriname
};
db.Categories.Add(categories);
await db.SaveChangesAsync();
transaction.Commit();
return(Ok(product));
}
catch
{
transaction.Rollback();
return(BadRequest());
}
}
}
public async Task <IActionResult> CreateMaster([FromBody] Productentity productentity)
{
using (var transaction = db.Database.BeginTransaction())
try
{
var product = new Products()
{
ProductName = productentity.name,
UnitPrice = productentity.price,
UnitsInStock = productentity.quantity,
CategoryId = productentity.categoriid,
};
var categoriy = new Categories()
{
CategoryId = productentity.categoriid,
CategoryName = productentity.CategoryName,
};
db.Products.Add(product);
db.SaveChanges();
transaction.Commit();
return(Ok(product));
}
catch
{
transaction.Rollback();
return(BadRequest());
throw;
}
}
public async Task <IActionResult> Create([FromBody] Productentity productentity)
{
try
{
var product = new Products()
{
ProductName = productentity.name,
UnitPrice = productentity.price,
UnitsInStock = productentity.quantity,
CategoryId = productentity.categoriid
};
db.Products.Add(product);
db.SaveChanges();
return(Ok(product));
}
catch
{
return(BadRequest());
}
}
public List <Productentity> ToProductList(ref int invalidCount)
{
var result = new List <Productentity>();
var range = _worksheet.RangeUsed();
var rowCount = range.RowCount();
Dictionary <int, string> dictColumns = new Dictionary <int, string>();
bool isHeader = true;
for (int i = 1; i <= rowCount; i++)
{
if (isHeader)
{
dictColumns = range.Row(i).RowToDictionary();
isHeader = false;
continue;
}
var entity = new Productentity();
var sb = new StringBuilder("{");
bool isValid = true;
foreach (var column in dictColumns)
{
var value = _worksheet.Cell(i, column.Key).GetString();
if (_dictMapColumns.ContainsKey(column.Value))
{
if (string.IsNullOrWhiteSpace(value))
{
isValid = false;
break;
}
switch (_dictMapColumns[column.Value])
{
case "Maker":
entity.MakerName = value;
break;
case "ProductName":
entity.ProductName = value;
break;
case "JAN":
entity.ProductCode = value;
break;
case "Image":
entity.ImageLink = value;
break;
}
}
if (sb.Length > 1)
{
sb.Append(", ");
}
sb.AppendFormat("'{0}': '{1}'", column.Value, value);
} //End for dictColumns
sb.Append("}");
if (!isValid || string.IsNullOrWhiteSpace(entity.ProductCode))
{
invalidCount++;
continue;
}
// entity.JsonData = sb.ToString();
result.Add(entity);
} //End for each row
return(result);
}
