Esempio n. 1
0
        public static ResponResultViewModel Update2(BiodataViewModel entity)
        {
            ResponResultViewModel result = new ResponResultViewModel();

            try
            {
                using (var db = new MinProContext())
                {
                    t_biodata bio = db.t_biodata.Where(o => o.id == entity.id).FirstOrDefault();
                    if (bio != null)
                    {
                        bio.active = false;
                        db.SaveChanges();
                        result.Entity = entity;
                    }
                }
            }
            catch (Exception ex)
            {
                result.Success = false;
                result.Message = ex.Message;
            }
            return(result);
        }
Esempio n. 2
0
        public static ResponResultViewModel Update(BiodataViewModel entity)
        {
            //Untuk create dan edit
            ResponResultViewModel result = new ResponResultViewModel();

            try
            {
                using (var db = new MinProContext())
                {
                    //Create
                    if (entity.id == 0)
                    {
                        t_biodata bi = new t_biodata();
                        bi.name              = entity.name;
                        bi.last_education    = entity.last_education;
                        bi.educational_level = entity.educational_level;
                        bi.graduation_year   = entity.graduation_year;
                        bi.majors            = entity.majors;
                        bi.gpa    = entity.gpa;
                        bi.active = entity.active;

                        bi.created_by = 1;
                        bi.created_on = DateTime.Now;
                        db.t_biodata.Add(bi);
                        db.SaveChanges();

                        result.Entity = bi;
                    }
                    //Edit
                    else
                    {
                        t_biodata bi = db.t_biodata.Where(o => o.id == entity.id).FirstOrDefault();
                        if (bi != null)
                        {
                            bi.name              = entity.name;
                            bi.last_education    = entity.last_education;
                            bi.educational_level = entity.educational_level;
                            bi.graduation_year   = entity.graduation_year;
                            bi.majors            = entity.majors;
                            bi.gpa    = entity.gpa;
                            bi.active = entity.active;

                            bi.modified_by = 2;
                            bi.modified_on = DateTime.Now;

                            db.SaveChanges();

                            result.Entity = entity;
                        }
                        else
                        {
                            result.Success = false;
                            result.Message = "Biodata not Found!";
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                result.Success = false;
                result.Message = ex.Message;
            }
            return(result);
        }
Esempio n. 3
0
        public static ResponseResult Update(BiodataViewModel entity)
        {
            ResponseResult result = new ResponseResult();

            try
            {
                using (var db = new XBC_Context())
                {
                    //CREATE
                    if (entity.id == 0)
                    {
                        t_biodata bio = new t_biodata();
                        bio.name              = entity.name; //sesuai yg kita input di web
                        bio.last_education    = entity.last_education;
                        bio.educational_level = entity.educational_level;
                        bio.graduation_year   = entity.graduation_year;
                        bio.majors            = entity.majors;
                        bio.gpa        = entity.gpa;
                        bio.is_deleted = entity.is_deleted;

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

                        db.t_biodata.Add(bio);
                        db.SaveChanges();

                        object data = new
                        {
                            bio.id,
                            bio.name,
                            bio.gender,
                            bio.last_education,
                            bio.graduation_year,
                            bio.educational_level,
                            bio.majors,
                            bio.gpa,
                            bio.bootcamp_test_type,
                            bio.iq,
                            bio.du,
                            bio.arithmetic,
                            bio.nested_logic,
                            bio.join_table,
                            bio.tro,
                            bio.notes,
                            bio.interviewer
                        };

                        var json = new JavaScriptSerializer().Serialize(data);

                        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     = bio.id;
                        result.Entity = entity;
                    }
                    else //EDIT
                    {
                        t_biodata bio = db.t_biodata
                                        .Where(o => o.id == entity.id && o.is_deleted == false)
                                        .FirstOrDefault();

                        if (bio != null)
                        {
                            object data = new
                            {
                                bio.id,
                                bio.name,
                                bio.gender,
                                bio.last_education,
                                bio.graduation_year,
                                bio.educational_level,
                                bio.majors,
                                bio.gpa,
                                bio.bootcamp_test_type,
                                bio.iq,
                                bio.du,
                                bio.arithmetic,
                                bio.nested_logic,
                                bio.join_table,
                                bio.tro,
                                bio.notes,
                                bio.interviewer
                            };

                            var         json = new JavaScriptSerializer().Serialize(data);
                            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;

                            bio.name              = entity.name;
                            bio.gender            = entity.gender;
                            bio.last_education    = entity.last_education;
                            bio.graduation_year   = entity.graduation_year;
                            bio.educational_level = entity.educational_level;
                            bio.majors            = entity.majors;
                            bio.gpa = entity.gpa;
                            bio.bootcamp_test_type = entity.bootcamp_test_type;
                            bio.iq           = entity.iq;
                            bio.du           = entity.du;
                            bio.arithmetic   = entity.arithmetic;
                            bio.nested_logic = entity.nested_logic;
                            bio.join_table   = entity.join_table;
                            bio.tro          = entity.tro;
                            bio.notes        = entity.notes;
                            bio.interviewer  = entity.interviewer;

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

                            object data2 = new
                            {
                                bio.id,
                                bio.name,
                                bio.gender,
                                bio.last_education,
                                bio.graduation_year,
                                bio.educational_level,
                                bio.majors,
                                bio.gpa,
                                bio.bootcamp_test_type,
                                bio.iq,
                                bio.du,
                                bio.arithmetic,
                                bio.nested_logic,
                                bio.join_table,
                                bio.tro,
                                bio.notes,
                                bio.interviewer
                            };

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

                            db.SaveChanges();

                            result.Entity = entity;
                        }
                        else
                        {
                            result.Success      = false;
                            result.ErrorMessage = "Biodata not found!";
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                result.Success      = false;
                result.ErrorMessage = ex.Message;
            }
            return(result);
        }
Esempio n. 4
0
        //DELETE
        public static ResponseResult Delete(BiodataViewModel entity)
        {
            ResponseResult result = new ResponseResult();

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

                    if (bio != null)
                    {
                        object data = new
                        {
                            bio.id,
                            bio.name,
                            bio.gender,
                            bio.last_education,
                            bio.graduation_year,
                            bio.educational_level,
                            bio.majors,
                            bio.gpa,
                            bio.bootcamp_test_type,
                            bio.iq,
                            bio.du,
                            bio.arithmetic,
                            bio.nested_logic,
                            bio.join_table,
                            bio.tro,
                            bio.notes,
                            bio.interviewer,
                            bio.is_deleted
                        };

                        var         json = new JavaScriptSerializer().Serialize(data);
                        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;

                        bio.is_deleted = true;
                        bio.deleted_by = entity.UserId;
                        bio.deleted_on = DateTime.Now;

                        object data2 = new
                        {
                            bio.id,
                            bio.name,
                            bio.gender,
                            bio.last_education,
                            bio.graduation_year,
                            bio.educational_level,
                            bio.majors,
                            bio.gpa,
                            bio.bootcamp_test_type,
                            bio.iq,
                            bio.du,
                            bio.arithmetic,
                            bio.nested_logic,
                            bio.join_table,
                            bio.tro,
                            bio.notes,
                            bio.interviewer,
                            bio.is_deleted
                        };

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

                        db.SaveChanges();

                        result.Entity = entity;
                    }
                    else
                    {
                        result.Success      = false;
                        result.ErrorMessage = "Biodata not found!";
                    }
                }
            }
            catch (Exception ex)
            {
                result.Success      = false;
                result.ErrorMessage = ex.Message;
            }
            return(result);
        }