Exemple #1
0
        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;
            }
        }
Exemple #2
0
        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;
            }
        }
Exemple #3
0
        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));
        }
Exemple #4
0
        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;
            }
        }