public object AddCourse(courseTab course) { var result = objEntity.courseTabs.Where(x => x.cName == course.cName).FirstOrDefault(); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { if (result == null) { objEntity.courseTabs.Add(course); int x = objEntity.SaveChanges(); return(x); } else { return("Exists"); } } catch (Exception) { throw; } }
public object DeleteCourse(courseTab course) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { courseTab objCourse = objEntity.courseTabs.Find(course.cId); objCourse.cId = course.cId; //if (objCourse != null) //{ // objCourse.isActive = course.isActive; //} //objEntity.Entry(objCourse).Property("isActive").IsModified = true; //int i = objEntity.SaveChanges(); //return i; if (objCourse.isActive == true) { objCourse.isActive = course.isActive; } else { objCourse.isActive = true; } objEntity.Entry(objCourse).Property("isActive").IsModified = true; int i = objEntity.SaveChanges(); return(i); } catch (Exception) { throw; } }
public object GetCourseById(courseTab course) { courseTab objCourse = new courseTab(); int ID = Convert.ToInt32(course.cId); try { objCourse = objEntity.courseTabs.Where(x => x.cId == course.cId).FirstOrDefault(); if (objCourse == null) { return(NotFound()); } } catch (Exception) { throw; } return(Ok(objCourse)); }
public object UpdateCourse(int cId, string cName) { var result = objEntity.courseTabs.Where(x => x.cName == cName).FirstOrDefault(); int i = 0; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { courseTab objCourse = new courseTab(); objCourse = objEntity.courseTabs.Where(x => x.cId == cId).FirstOrDefault(); //objCourse = objEntity.courseTabs.Find(course.cId); if (objCourse != null) { { objCourse.cName = cName; } if (result == null) { objEntity.Entry(objCourse).Property("cName").IsModified = true; i = objEntity.SaveChanges(); } else { return("Exists"); } } return(i); } catch (Exception) { throw; } }