Beispiel #1
0
        public async Task <IHttpActionResult> update(Models.CircleModel model)
        {
            if (!ModelState.IsValid)
            {
                return(Json(new { error = true, message = Models.ErrorMessage.getErrorMessage(ModelState) }));
            }
            Boolean result = true;

            try
            {
                System.Web.HttpContext.Current.Application.Lock();
                DAL.Circle nowCircle = _db.Circles.Where(p => p.id == model.id).FirstOrDefault();
                nowCircle.circleName = model.circleName;
                nowCircle.startDate  = model.startDate;
                nowCircle.endDate    = model.endDate;
                nowCircle.status     = model.status;
                _db.SaveChanges();
                System.Web.HttpContext.Current.Application.UnLock();
            }
            catch (Exception e)
            {
                result = false;
            }

            return(Json(new { result = result }));
        }
Beispiel #2
0
        public async Task <IHttpActionResult> create(Models.CircleAddModel model)
        {
            if (!ModelState.IsValid)
            {
                return(Json(new { error = true, message = Models.ErrorMessage.getErrorMessage(ModelState) }));
            }
            Boolean result = true;

            try
            {
                Circle circle = new Circle();

                foreach (var q in model.circles)
                {
                    DAL.Circle c = new DAL.Circle();
                    c.circleName = q.circleName;
                    c.startDate  = q.startDate;
                    c.endDate    = q.endDate;
                    c.semester   = q.semester;
                    c.year       = q.year;
                    c.status     = q.status;

                    _db.Circles.Add(c);
                    _db.SaveChanges();
                }
            }
            catch (Exception e)
            {
                return(Json(e.Message));
            }

            return(Json(new { result = result }));
        }
Beispiel #3
0
        public async Task <IHttpActionResult> search(DAL.Circle model)
        {
            System.Web.HttpContext.Current.Application.Lock();
            var circle = from m in _db.Circles
                         select
                         new
            {
                id         = m.id,
                circleName = m.circleName,
                startDate  = m.startDate,
                endDate    = m.endDate,
                status     = m.status
            };

            if (model.circleName != null)
            {
                circle = from m in circle where m.circleName.Contains(model.circleName) select m;
            }
            if (model.startDate != null)
            {
                circle = from m in circle where m.startDate == model.startDate select m;
            }
            if (model.endDate != null)
            {
                circle = from m in circle where m.endDate == model.endDate select m;
            }
            if (model.status != 0)
            {
                circle = from m in circle where m.status == model.status select m;
            }

            circle = from m in circle orderby m.circleName select m;

            //var circles = from m in circle orderby m.circleName select new
            //{
            //    startDate = m.startDate,
            //    endDate = m.endDate,
            //    startDate = String.Format("{0:dd-MM-yyyy}", m.startDate),
            //    endDate = String.Format("{0:dd-MM-yyyy}", m.endDate )
            //};

            //var circles_new = new {
            //    startDate = circle.,
            //    endDate = circle.endDate,
            //    startDate = String.Format("{0:yyyy-MM-dd}", circle.startDate),
            //    endDate = String.Format("{0:yyyy-MM-dd}", circle.endDate };


            System.Web.HttpContext.Current.Application.UnLock();
            return(Json(circle));
        }
Beispiel #4
0
        public async Task <IHttpActionResult> getCircle(int circleId)
        {
            System.Web.HttpContext.Current.Application.Lock();
            DAL.Circle circle  = _db.Circles.Where(p => p.id == circleId).FirstOrDefault();
            var        circles = new {
                status     = circle.status,
                circleName = circle.circleName,
                //startDate = circle.startDate,
                //endDate = circle.endDate,
                startDate = String.Format("{0:yyyy-MM-dd}", circle.startDate),
                endDate   = String.Format("{0:yyyy-MM-dd}", circle.endDate)
            };

            System.Web.HttpContext.Current.Application.UnLock();
            return(Json(circles));
        }
Beispiel #5
0
        public async Task <IHttpActionResult> delete(int id)
        {
            Boolean result = true;

            try
            {
                System.Web.HttpContext.Current.Application.Lock();
                DAL.Circle circle = _db.Circles.Where(p => p.id == id).FirstOrDefault();
                _db.Circles.Remove(circle);
                _db.SaveChanges();
                System.Web.HttpContext.Current.Application.UnLock();
            }
            catch (Exception e)
            {
                result = false;
            }

            return(Json(new { result = result }));
        }