public JsonResult <Models.Product> GetProduct(int id)
{
EntityMapper <DataAccessLayer.Product, Models.Product> mapObj = new EntityMapper <DataAccessLayer.Product, Models.Product>();
DataAccessLayer.Product dalProduct = DAL.GetProduct(id);
Models.Product products = new Models.Product();
products = mapObj.Translate(dalProduct);
return(Json <Models.Product>(products));
}
public bool UpdateProduct(Models.Product product)
{
EntityMapper <Models.Product, DataAccessLayer.Product> mapObj = new EntityMapper <Models.Product, DataAccessLayer.Product>();
DataAccessLayer.Product productObj = new DataAccessLayer.Product();
productObj = mapObj.Translate(product);
var status = DAL.UpdateProduct(productObj);
return(status);
}
private void MapProduct(Product productToMap, Product productMapper)
{
productToMap.Name = productMapper.Name;
productToMap.Description = productMapper.Description;
productToMap.CategoryID = productMapper.CategoryID;
productToMap.Price = productMapper.Price;
productToMap.Stock = productMapper.Stock;
productToMap.EntryDate = productMapper.EntryDate;
productToMap.ExpirationDate = productMapper.ExpirationDate;
}
public int Create(Product product)
{
using (_dbContext = new ProductsEntities())
{
_dbContext.Products.Add(product);
var result = _dbContext.SaveChanges();
return (result > 0) ? product.ID : -1;
}
}
public bool UpdateProduct(Models.ProductDetails product)
{
//EntityMapper<Models.ProductDetails, DataAccessLayer.Product> mapObj = new EntityMapper<Models.ProductDetails, DataAccessLayer.Product>();
DataAccessLayer.Product productObj = new DataAccessLayer.Product();
var config = new MapperConfiguration(cfg => cfg.CreateMap <Models.ProductDetails, Product>());
var mapper = new Mapper(config);
productObj = mapper.Map <Product>(product);
var status = DAL.UpdateProduct(productObj);
return(status);
}
public bool InsertProduct(Models.Product product)
{
bool status = false;
if (ModelState.IsValid)
{
EntityMapper <Models.Product, DataAccessLayer.Product> mapObj = new EntityMapper <Models.Product, DataAccessLayer.Product>();
DataAccessLayer.Product productObj = new DataAccessLayer.Product();
productObj = mapObj.Translate(product);
status = DAL.InsertProduct(productObj);
}
return(status);
}
public bool VerifyProductCode(string code)
{
EntityMapper <DataAccessLayer.Product, Models.Product> mapObj = new EntityMapper <DataAccessLayer.Product, Models.Product>();
DataAccessLayer.Product dalProduct = DAL.GetProduct(code);
if (dalProduct != null)
{
return(true);
}
return(false);
}
public bool InsertProduct(Models.ProductDetails product)
{
bool status = false;
if (ModelState.IsValid)
{
//EntityMapper<Models.ProductDetails, DataAccessLayer.Product> mapObj = new EntityMapper<Models.ProductDetails, DataAccessLayer.Product>();
DataAccessLayer.Product productObj = new DataAccessLayer.Product();
var config = new MapperConfiguration(cfg => cfg.CreateMap <Models.ProductDetails, Product>());
var mapper = new Mapper(config);
productObj = mapper.Map <Product>(product);
status = DAL.InsertProduct(productObj);
}
return(status);
}
public DTO.Product Add(DataAccessLayer.Product product)
{
using (var db = new LNBagShopDBEntities())
{
var returnEntity = db.Products.Add(product);
var config = new MapperConfiguration(cfg =>
{
cfg.AddProfile(new MappingProfile());
});
var mapper = config.CreateMapper();
var return1 = mapper.Map <DataAccessLayer.Product, DTO.Product>(returnEntity);
db.SaveChanges();
return(return1);
}
}
public JsonResult <Models.ProductDetails> GetProduct(int id)
{
//EntityMapper<DataAccessLayer.Product, Models.ProductDetails> mapObj = new EntityMapper<DataAccessLayer.Product, Models.ProductDetails>();
DataAccessLayer.Product dalProduct = DAL.GetProduct(id);
if (dalProduct == null)
{
//return Json<Models.ProductDetails>(null);
throw new ArgumentNullException(id.ToString());
}
else
{
Models.ProductDetails products = new Models.ProductDetails();
var config = new MapperConfiguration(cfg => cfg.CreateMap <Product, Models.ProductDetails>());
var mapper = new Mapper(config);
products = mapper.Map <Models.ProductDetails>(dalProduct);
return(Json <Models.ProductDetails>(products));
}
}
public DTO.Product GetProduct(int id)
{
using (var db = new LNBagShopDBEntities())
{
DTO.Product product = null;
DataAccessLayer.Product dbProduct = db.Products.Find(id);
if (dbProduct != null)
{
var config = new MapperConfiguration(cfg =>
{
cfg.AddProfile(new MappingProfile());
});
var mapper = config.CreateMapper();
product = mapper.Map <DataAccessLayer.Product, DTO.Product>(dbProduct);
}
return(product);
}
}
public int Update(Product product)
{
Product dbProduct;
var result = -1;
using (_dbContext = new ProductsEntities())
{
dbProduct = _dbContext.Products.FirstOrDefault(p => p.ID == product.ID);
}
if (dbProduct != null)
{
MapProduct(dbProduct, product);
using (_dbContext = new ProductsEntities())
{
_dbContext.Entry(product).State = System.Data.Entity.EntityState.Modified;
result = _dbContext.SaveChanges();
}
}
return result;
}
public int SaveProduct(TestProduct product)
{
DataAccessLayer.Product newProduct = null;
using (var context = new BhasadEntities())
{
var oldProduct = (from prod in context.Products
where prod.ProductId == product.ProductId
select new TestProduct
{
ProductName = prod.ProductName,
ProductId = prod.ProductId
}).FirstOrDefault();
var ProductBySP = context.GetProductProductTypeData(product.ProductId).FirstOrDefault();
//.Select(m=>new Product
//{
// ProductName=m.ProductName,
// ProductId=m.ProductId,
// ProductTypeId=m.ProductTypeId
//}).FirstOrDefault();
//Group By Example for grouping on one column
//var oldProductQuery = (from prod in context.Products
// where prod.ProductId == product.ProductId
// group prod by prod.ProductName into prodGroup
// select new Product
// {
// ProductName = prodGroup.Key,
// ProductId = prodGroup.Select(m => m.ProductId).FirstOrDefault()
// });
//var query = context.Products.GroupBy(g =>new { g.ProductTypeId, g.ProductName });
//var data = query.ToList();
//var oldProduct = oldProductQuery.FirstOrDefault();
//order by in lambda
// var orderByQuery = context.Products.OrderByDescending(o => o.ProductName).ThenBy(o => o.ProductTypeId).ToList();
//left outer join
//lambda expression
//var joinExample = context.Products.Include("ProductType,ProductVariants,ProductVariants.Items").ToList();
//from query
//var joinFromExample = from prod in context.Products
// join prodType in context.ProductTypes on prod.ProductTypeId equals prodType.ProductTypeId
// into pt from tempProdType in pt.DefaultIfEmpty()
// select new Product
// {
// ProductName=prod.ProductName,
// ProductTypeId=tempProdType.ProductTypeId
// };
//var sqlQuery = context.Products.SqlQuery("select * from product where productTypeId=@producTypeId",
// new SqlParameter("@producTypeId", product.ProductTypeId)).Select(m => new Product
//{
//}).ToList();
//context.Database.SqlQuery<Product>("select * from product where productTypeId=@producTypeId", new SqlParameter("@producTypeId", product.ProductTypeId))
//Group by example for grouping on multiple column
//var oldProduct = (from prod in context.Products
// where prod.ProductId == product.ProductId
// group prod by new { prod.ProductName, prod.ProductTypeId } into prodGroup
// select new Product
// {
// ProductName = prodGroup.Key.ProductName,
// ProductTypeId=prodGroup.Key.ProductTypeId,
// ProductId = prodGroup.Select(m => m.ProductId).FirstOrDefault()
// }).FirstOrDefault();
//var oldProduct = context.Products.Where(m => m.ProductId == product.ProductId).OrderBy(o=>o.ProductName).FirstOrDefault();
if (oldProduct != null)
{
//context.Products.Remove(oldProduct);
oldProduct.ProductName = product.ProductName;
oldProduct.ModifiedBy = 1;
oldProduct.ModifiedDate = DateTime.Now;
context.Entry(oldProduct).State = System.Data.Entity.EntityState.Modified;
}
else
{
newProduct = context.Products.Add(new DataAccessLayer.Product
{
CreatedBy = 1,
CreatedDate = DateTime.Now,
IsActive = true,
ProductName = product.ProductName,
ProductTypeId = product.ProductTypeId
});
var info = context.Entry(newProduct);
context.Entry(newProduct).State = System.Data.Entity.EntityState.Added;
}
int result = context.SaveChanges();
//insert using sp
var insertedOutput = context.sp_InsertProduct(product.ProductTypeId, product.ProductName);
return(result);
}
}
