Example #1
0
        public tblProduct UpdateProduct(tblProduct product)
        {
            string sqlQuery = @" UPDATE [dbo].[tblProduct]
                           SET [Item_Number] = '" + product.Item_Number + @"'
                              ,[Item_Group] = '" + product.Item_Group + @"'
                              ,[Description] = '" + product.Description + @"'
                              ,[Customer_Group] = '" + product.Customer_Group + @"'
                              ,[Material_Type] = '" + product.Material_Type + @"'
                              ,[Colors] = '" + product.Colors + @"'
                              ,[Weight] = '" + product.Weight + @"'
                              ,[Dimension] = '" + product.Dimension + @"'
                              ,[Grouping] = '" + product.Grouping +
                              @"' WHERE ProductId ='" + product.ProductId + @"'";
            int noOfRowUpdated = _coreDBEntities.Database.ExecuteSqlCommand(sqlQuery);

            if (noOfRowUpdated > 0)
            {
                return(product);
            }

            return(null);
        }
Example #2
0
 public tblProduct AddProduct(tblProduct product)
 {
     _coreDBEntities.tblProducts.Add(product);
     _coreDBEntities.SaveChanges();
     return(product);
 }