public bool insertNewProduct(string productName, string image, string typeCode, string supplierCode) { if (!checkExistProduct(productName)) { try { using (var db = new CMART2Entities1()) { ObjectParameter Output = new ObjectParameter("CODE", typeof(String)); db.SP_PRODUCT_ID_AUTO(Output); var id_auto = Output.Value.ToString(); var product = new Product { ProductCode = id_auto, ProductName = productName, Image = image, TypeCode = typeCode, SupplierCode = supplierCode }; db.Products.Add(product); db.SaveChanges(); return(true); } } catch (Exception) { return(false); } } return(false); }