private void Insert(Part part)
{
_context.Parts.Add(part);
SaveChanges();
}
public void InsertPartToDatabase(string partNoValue, int quantity, long price, string description, double weight)
{
var partNo = GetPartNoByValue(partNoValue);
if (partNo != null)
{
partNo.Quantity = quantity;
partNo.Price = price;
partNo.Description = description;
partNo.Weight = weight;
try
{
SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
}
else
{
var part = new Part()
{
PartNoID = partNoValue,
PartNoValue = partNoValue,
Quantity = quantity,
Price = price,
Description = description,
Weight = weight
};
try
{
Insert(part);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
}
}