Esempio n. 1
0
        //Delete
        public static ResponseResult Delete(TestViewModel entity)
        {
            ResponseResult result = new ResponseResult();

            try
            {
                using (var db = new XBC_Context())
                {
                    t_test ts = db.t_test.Where(o => o.id == entity.id).FirstOrDefault();

                    if (ts != null)
                    {
                        var    Serial     = new JavaScriptSerializer();
                        object dataBefore = new //Mengambil Data Before for Log
                        {
                            ts.name,
                            ts.is_bootcamp_test,
                            ts.notes,
                            ts.is_delete
                        };

                        ts.deleted_by = entity.UserId;
                        ts.deleted_on = DateTime.Now;
                        ts.is_delete  = true;
                        db.SaveChanges();

                        // Audit Log Modify
                        object dataAfter = new
                        {
                            ts.name,
                            ts.is_bootcamp_test,
                            ts.notes,
                            ts.is_delete
                        };

                        t_audit_log log = new t_audit_log();
                        log.type        = "MODIFY";
                        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 = "Test Not Found";
                    }
                }
            }
            catch (Exception ex)
            {
                result.Success      = false;
                result.ErrorMessage = ex.Message;
            }
            return(result);
        }
Esempio n. 2
0
        public static ResponResultViewModel Deact(TestViewModel model)
        {
            ResponResultViewModel result = new ResponResultViewModel();

            using (var db = new MinProContext())
            {
                t_test test = db.t_test.Where(x => x.id == model.id).FirstOrDefault();
                test.active      = false;
                test.modified_by = 1;
                test.modified_on = DateTime.Now;
                test.name        = model.name;

                try
                {
                    db.SaveChanges();
                    result.Entity = model;
                }
                catch (Exception e)
                {
                    result.Success = false;
                    result.Message = e.Message;
                }
            }
            return(result);
        }
Esempio n. 3
0
        public static ResponResultViewModel Update(TestViewModel entity)
        {
            //untuk create & edit
            ResponResultViewModel result = new ResponResultViewModel();

            try
            {
                using (var db = new MinProContext())
                {
                    if (entity.id == 0)
                    {
                        t_test test = new t_test();
                        test.name       = entity.name;
                        test.notes      = entity.notes;
                        test.active     = entity.active;
                        test.created_by = 1;
                        test.created_on = DateTime.Now;

                        db.t_test.Add(test);
                        db.SaveChanges();

                        result.Entity = test;
                    }
                    else
                    {
                        t_test test = db.t_test.Where(x => x.id == entity.id).FirstOrDefault();
                        if (test != null)
                        {
                            test.name        = entity.name;
                            test.notes       = entity.notes;
                            test.active      = entity.active;
                            test.modified_by = 1;
                            test.modified_on = DateTime.Now;

                            db.SaveChanges();
                            result.Entity = entity;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                result.Success = false;
                result.Message = e.Message;
            }
            return(result);
        }