コード例 #1
0
        public static ResponseResult Delete(TestTypeViewModel entity)
        {
            ResponseResult result = new ResponseResult();

            using (var db = new XBC_Context())
            {
                t_test_type ttp = db.t_test_type.Where(o => o.id == entity.id).FirstOrDefault();

                if (ttp != null)
                {
                    var         json = new JavaScriptSerializer().Serialize(ttp);
                    t_audit_log log  = new t_audit_log();
                    log.type        = "Modify";
                    log.json_before = json;

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

                    ttp.is_delete  = true;
                    ttp.deleted_by = entity.UserId;
                    ttp.deleted_on = DateTime.Now;
                    var json2 = new JavaScriptSerializer().Serialize(ttp);
                    log.json_after = json2;
                    db.t_audit_log.Add(log);
                    db.SaveChanges();

                    result.Entity = entity;
                }
                else
                {
                    result.Success      = false;
                    result.ErrorMessage = "Test Type not found!";
                }
            }
            return(result);
        }
コード例 #2
0
        public static ResponseResult Update(TestTypeViewModel entity)
        {
            ResponseResult result = new ResponseResult();

            using (var db = new XBC_Context())
            {
                if (entity.id == 0)
                {
                    t_test_type tstp = new t_test_type();
                    tstp.name  = entity.name;
                    tstp.notes = entity.notes;

                    tstp.created_by = entity.UserId;
                    tstp.created_on = DateTime.Now;
                    tstp.is_delete  = false;

                    db.t_test_type.Add(tstp);
                    db.SaveChanges();

                    var         json = new JavaScriptSerializer().Serialize(tstp);
                    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     = tstp.id;
                    result.Entity = entity;
                }
                else //edit
                {
                    t_test_type tstp = db.t_test_type.Where(ttp => ttp.id == entity.id).FirstOrDefault();
                    if (tstp != null)
                    {
                        var         json = new JavaScriptSerializer().Serialize(tstp);
                        t_audit_log log  = new t_audit_log();
                        log.type        = "Modify";
                        log.json_before = json;

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

                        tstp.name  = entity.name;
                        tstp.notes = entity.notes;

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

                        var json2 = new JavaScriptSerializer().Serialize(tstp);
                        log.json_after = json2;
                        db.t_audit_log.Add(log);
                        db.SaveChanges();

                        result.Entity = entity;
                    }
                    else
                    {
                        result.Success      = false;
                        result.ErrorMessage = "Test Type not found";
                    }
                }
            }
            return(result);
        }