Exemplo n.º 1
0
        public ActionResult Delete(BootcampTestTypeViewModel model)
        {
            ResponseResult result = BootcampTestTypeRepo.Delete(model);

            return(Json(new
            {
                success = result.Success,
                message = result.ErrorMessage,
                entity = result.Entity
            }, JsonRequestBehavior.AllowGet));
        }
Exemplo n.º 2
0
        public static ResponseResult Delete(BootcampTestTypeViewModel entity)
        {
            ResponseResult result = new ResponseResult();

            try
            {
                using (var db = new XBC_Context())
                {
                    t_bootcamp_test_type btt = db.t_bootcamp_test_type.Where(o => o.id == entity.id).FirstOrDefault();
                    if (btt != null)
                    {
                        btt.is_delete  = true;
                        btt.deleted_by = entity.UserId;
                        btt.created_on = DateTime.Now;
                        db.SaveChanges();
                        object data = new
                        {
                            btt.id,
                            btt.name,
                            btt.notes
                        };
                        var json = new JavaScriptSerializer().Serialize(data);

                        t_audit_log log = new t_audit_log();
                        log.type        = "Modified";
                        log.json_insert = json;

                        log.created_by = entity.UserId;
                        log.created_on = DateTime.Now;

                        db.t_audit_log.Add(log);
                        db.SaveChanges();
                    }
                    else
                    {
                        result.Success      = false;
                        result.ErrorMessage = "Bootcamp Test Type Not Found";
                    }
                }
            }
            catch (Exception ex)
            {
                result.Success      = false;
                result.ErrorMessage = ex.Message;
            }
            return(result);
        }
Exemplo n.º 3
0
        public static BootcampTestTypeViewModel ById(long id)
        {
            BootcampTestTypeViewModel result = new BootcampTestTypeViewModel();

            using (var db = new XBC_Context())
            {
                result = (from btt in db.t_bootcamp_test_type
                          where btt.id == id
                          select new BootcampTestTypeViewModel
                {
                    id = btt.id,
                    name = btt.name,
                    notes = btt.notes,
                    isDelete = btt.is_delete
                }).FirstOrDefault();
                if (result == null)
                {
                    result = new BootcampTestTypeViewModel();
                }
            }
            return(result);
        }
Exemplo n.º 4
0
        public static ResponseResult Update(BootcampTestTypeViewModel entity)
        {
            ResponseResult result = new ResponseResult();

            try
            {
                using (var db = new XBC_Context())
                {
                    if (entity.id == 0)
                    {
                        t_bootcamp_test_type btt = new t_bootcamp_test_type();
                        btt.name      = entity.name;
                        btt.notes     = entity.notes;
                        btt.is_delete = false;

                        btt.created_by = entity.UserId;
                        btt.created_on = DateTime.Now;
                        db.t_bootcamp_test_type.Add(btt);
                        db.SaveChanges();
                        //insert AuditLog
                        var         json = new JavaScriptSerializer().Serialize(btt);
                        t_audit_log log  = new t_audit_log();
                        log.type        = "Insert";
                        log.json_insert = json;
                        log.created_by  = entity.UserId;
                        log.created_on  = DateTime.Now;
                        db.t_audit_log.Add(log);
                        db.SaveChanges();

                        entity.id     = btt.id;
                        result.Entity = entity;
                    }
                    else
                    {
                        t_bootcamp_test_type btt = db.t_bootcamp_test_type.Where(o => o.id == entity.id).FirstOrDefault();
                        if (btt != null)
                        {
                            var    Serial     = new JavaScriptSerializer();
                            object dataBefore = new
                            {
                                btt.name,
                                btt.notes,
                                btt.modified_by,
                                btt.modified_on
                            };

                            btt.name      = entity.name;
                            btt.notes     = entity.notes;
                            btt.is_delete = false;

                            btt.modified_by = entity.UserId;
                            btt.modified_on = DateTime.Now;

                            db.SaveChanges();

                            object dataAfter = new
                            {
                                btt.name,
                                btt.notes,
                                btt.modified_by,
                                btt.modified_on
                            };
                            t_audit_log log = new t_audit_log();
                            log.type        = "Modified";
                            log.json_before = Serial.Serialize(dataBefore);
                            log.json_after  = Serial.Serialize(dataAfter);

                            log.created_by = entity.UserId;
                            log.created_on = DateTime.Now;

                            db.t_audit_log.Add(log);
                            db.SaveChanges();
                            result.Entity = entity;
                        }
                        else
                        {
                            result.Success      = false;
                            result.ErrorMessage = "Bootcamp Test Type not Found";
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                result.Success      = false;
                result.ErrorMessage = ex.Message;
            }
            return(result);
        }