public bool Subscribe(int user_id, int cat_id) { List <Subscribtion_table> myRecord = context.Subscribtion_table.Where(s => s.User_Id == user_id && s.Cat_Id == cat_id).Select(s => s).ToList(); if (myRecord.Count() == 0) { Subscribtion_table model = new Subscribtion_table() { User_Id = user_id, Cat_Id = cat_id }; context.Subscribtion_table.Add(model); context.SaveChanges(); } return(true); }
//Insert SubscribedCategories in Subscribtion table public void putSubscribeCategories(int[] Categories, int id) { Subscribtion_table subscribe = new Subscribtion_table(); subscribe.User_Id = id; // Enter Session subscribe.User_Id =; for (int i = 0; i < Categories.Length; i++) { subscribe.Cat_Id = Categories[i]; context.Subscribtion_table.Add(subscribe); context.SaveChanges(); } }