public string GetCatNameById(int id)
        {
            var q = (from r in edm.Categories where r.CategoryID == id select r);
            Category c = new Category();
            c = q.First<Category>();

            string name = c.Category_Name;
            return name;
        }
        public int GetCatIdByName(string name)
        {
            var q = (from r in edm.Categories where r.Category_Name == name select r);
            Category c = new Category();
            c = q.First<Category>();

            int cid = c.CategoryID;
            return cid;
        }
        public int AddNewCategory(string cat_name)
        {
            Category category_info = edm.Categories.FirstOrDefault(m => m.Category_Name == cat_name);
            Category category = new Category();
            //int cat_ID;
            if (category_info != null)
            {
                category.CategoryID = category_info.CategoryID;

            }
            else if (category_info == null)
            {
                //Category category = new Category();
                category.Category_Name = cat_name;
                edm.AddToCategories(category);
                edm.SaveChanges();
                //cat_ID = category.CategoryID;
            }

            //cat_ID = category_info.CategoryID;
            return category.CategoryID;
        }
 /// <summary>
 /// Deprecated Method for adding a new object to the Categories EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToCategories(Category category)
 {
     base.AddObject("Categories", category);
 }
 /// <summary>
 /// Create a new Category object.
 /// </summary>
 /// <param name="categoryID">Initial value of the CategoryID property.</param>
 /// <param name="category_Name">Initial value of the Category_Name property.</param>
 public static Category CreateCategory(global::System.Int32 categoryID, global::System.String category_Name)
 {
     Category category = new Category();
     category.CategoryID = categoryID;
     category.Category_Name = category_Name;
     return category;
 }