public void UpdateCategory(workout_category newobj) { using (var ctx = new WorkoutContext()) { workout_category obj = ctx.Workout_category.SingleOrDefault(i => i.category_id == newobj.category_id); obj.category_name = newobj.category_name; ctx.SaveChanges(); } }
public void DeleteCategory(int id) { using (var ctx = new WorkoutContext()) { workout_category obj = ctx.Workout_category.SingleOrDefault(x => x.category_id == id); ctx.Workout_category.Remove(obj); ctx.SaveChanges(); } }
public void AddCategory(workout_category obj) { //workout_category obj = new workout_category() { category_id = 12, category_name = "test" }; using (var ctx = new WorkoutContext()) { ctx.Workout_category.Add(obj); ctx.SaveChanges(); } }
public IHttpActionResult Post(workout_category item) { db.workout_category.Add(item); int NoOfRowsAffected = db.SaveChanges(); if (NoOfRowsAffected > 0) { return(StatusCode(HttpStatusCode.Created)); } { return(BadRequest("Failed To add workout")); } }
public void B_GetCategoryTest() { workout_category wc = null; var catList = workoutCategoryService.GetWorkoutCategories().Where(x => x.category_name.Equals("TestServicecategory", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); if (catList != null) { wc = new workout_category(); wc = workoutCategoryService.GetCategory(catList.category_id); } Assert.AreNotEqual(null, wc); }
public IHttpActionResult Post(workout_category obj) { db.workout_category.Add(obj); var rows = db.SaveChanges(); if (rows > 0) { return(StatusCode(HttpStatusCode.Created)); } else { return(BadRequest()); } }
public IHttpActionResult Put(workout_category obj) { db.workout_category.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; var rows = db.SaveChanges(); if (rows > 0) { return(StatusCode(HttpStatusCode.Accepted)); } else { return(BadRequest()); } }
public IHttpActionResult Put(workout_category obj) { db.workout_category.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; var NoOfRowsAffected = db.SaveChanges(); if (NoOfRowsAffected > 0) { return(StatusCode(HttpStatusCode.Accepted)); } else { return(BadRequest("Failed To Modify supplier")); } }
public void D_GetCategoryTest() { workout_category wc = null; workout_category wcat = new workout_category() { category_id = 0, category_name = "TestRepositorycategory", workout_collection = null }; var catList = workoutCategoryRepository.FindBy(x => x.category_name.Equals(wcat.category_name, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); if (catList != null) { wc = new workout_category(); wc = workoutCategoryRepository.GetCategory(catList.category_id); } Assert.AreNotEqual(null, wc); }
public void A_CreateWorkoutCategoryTest() { workout_category wcat = new workout_category() { category_id = 0, category_name = "TestServicecategory", workout_collection = null }; var catList = workoutCategoryService.GetWorkoutCategories().Where(x => x.category_name.Equals(wcat.category_name, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); if (catList != null) { } else { workoutCategoryService.CreateWorkoutCategory(wcat); } var result = workoutCategoryService.GetWorkoutCategories().Where(x => x.category_name.Equals(wcat.category_name, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); Assert.AreNotEqual(0, result.category_id); }
public void B_CategoryAlreadyExistsTest() { workout_category wcat = new workout_category() { category_id = 0, category_name = "TestRepositorycategory", workout_collection = null }; var catList = workoutCategoryRepository.FindBy(x => x.category_name.Equals(wcat.category_name, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); if (catList != null) { } else { workoutCategoryRepository.AddCategory(wcat); _context.SaveChanges(); } Assert.AreNotEqual(null, catList); Assert.AreEqual(catList.category_name, wcat.category_name); }
public void A_AddCategoryApiTest() { WorkoutCategory result; workout_category wc = new workout_category() { category_id = 0, category_name = "WebApiTestCategory", workout_collection = null }; var input = Helper.CastObject <WorkoutCategory>(wc); var controller = new WorkoutTrackerController(workoutService, categoryService, _logManager); controller.Request = new HttpRequestMessage(); controller.Configuration = new HttpConfiguration(); controller.Request.Headers.Add("Accept", "application/json"); var response = controller.AddCategory(input); result = response.Content.ReadAsAsync <WorkoutCategory>().Result; Assert.AreEqual(HttpStatusCode.OK, response.StatusCode); Assert.AreNotEqual(null, result); response.Dispose(); }
private void MapCategory(workout_category source, ref WorkoutCategory des) { des.category_id = source.category_id; des.category_name = source.category_name; des.workout_collection = Helper.CastObject <IList <WorkoutCollection> >(source.workout_collection); }
public void UpdateCategory(workout_category obj) { dAO.UpdateCategory(obj); }
public void AddCategory(workout_category obj) { dAO.AddCategory(obj); }