public async Task <List <OrderItemDTO> > OrderItemEntry(List <OrderItemDTO> orderItemDTO)
{
var dataObject = orderItemDTO.Cast <Order_Item>().ToList();// orderItemDTO as Order_Item;
await _sqlServerContext.AddRangeAsync(dataObject);
await _sqlServerContext.SaveChangesAsync();
return(orderItemDTO);
}
public async Task <Product> AddProduct(Product product)
{
using (var transaction = _sqlServerContext.Database.BeginTransaction())
{
try
{
var entity = await _sqlServerContext.Products.FirstOrDefaultAsync(item => item.ProductName == product.ProductName);
if (entity == null)
{
await _sqlServerContext.AddRangeAsync(product);
await _sqlServerContext.SaveChangesAsync();
}
else
{
product.ProductId = 0;
product.CategoryId = 0;
product.ProductName = "";
product.ProductCode = "";
product.SerialNo = "";
product.TypeId = 0;
product.UnitId = 0;
product.BrandId = 0;
product.ImageURL = "";
product.Cost = 0;
product.Price = 0;
product.Quantity = 0;
product.IsActive = false;
product.CreatedDate = DateTime.Now;
product.CreatedBy = 0;
product.UpdatedBy = 0;
product.UpdatedDate = DateTime.Now;
}
transaction.Commit();
return(product);
}
catch (Exception exception)
{
transaction.Rollback();
throw exception;
}
}
}
public async Task <Supplier> AddSupplier(Supplier supplier)
{
using (var transaction = _sqlServerContext.Database.BeginTransaction())
{
try
{
var entity = await _sqlServerContext.Suppliers.FirstOrDefaultAsync(item => item.Phone == supplier.Phone);
if (entity == null)
{
await _sqlServerContext.AddRangeAsync(supplier);
await _sqlServerContext.SaveChangesAsync();
}
else
{
supplier.SupplierId = 0;
supplier.SupplierName = "";
supplier.CompanyId = 0;
supplier.CountryId = 0;
supplier.PostalCode = "";
supplier.VatNumber = "";
supplier.Email = "";
supplier.Phone = "";
supplier.Address = "";
supplier.City = "";
supplier.State = "";
supplier.IsActive = false;
supplier.CreatedDate = DateTime.Now;
supplier.CreatedBy = 0;
supplier.UpdatedBy = 0;
supplier.UpdatedDate = DateTime.Now;
}
transaction.Commit();
return(supplier);
}
catch (Exception exception)
{
transaction.Rollback();
throw exception;
}
}
}
