示例#1
0
        public static bool Update(JurusanViewModel model)
        {
            bool result = true;

            try
            {
                using (var db = new DB_UniversityEntities())
                {
                    tbl_m_jurusan attributs = db.tbl_m_jurusan.Where(o => o.id_jurusan_pk == model.id_jurusan_pk).FirstOrDefault();

                    if (attributs != null)
                    {
                        attributs.kode_jurusan = model.kode_jurusan;
                        attributs.nama_jurusan = model.nama_jurusan;
                        attributs.is_active    = model.is_active;
                        attributs.updated_by   = model.updated_by;
                        attributs.updated_date = model.updated_date;
                        attributs.Akreditasi   = model.akreditasi;
                        db.SaveChanges();
                    }
                    else
                    {
                        result  = false;
                        Message = "Categories not found!";
                    }
                }
            }
            catch (Exception hasError)
            {
                Message = hasError.Message;
                result  = false;
            }
            return(result);
        }
        public static bool Delete(AgamaViewModel model)
        {
            bool result = true;

            try
            {
                using (var db = new DB_UniversityEntities())
                {
                    tbl_m_agama attributs = db.tbl_m_agama.Where(o => o.id_agama_pk == model.id_agama_pk).FirstOrDefault();

                    if (attributs != null)
                    {
                        attributs.is_active    = model.is_active;
                        attributs.updated_by   = model.updated_by;
                        attributs.updated_date = model.updated_date;
                        db.SaveChanges();
                    }
                    else
                    {
                        result  = false;
                        Message = "Categories not found!";
                    }
                }
            }
            catch (Exception hasError)
            {
                Message = hasError.Message;
                result  = false;
            }
            return(result);
        }
        public static List <DosenViewModel> GetListAll()
        {
            List <DosenViewModel> result = new List <DosenViewModel>();

            using (var db = new DB_UniversityEntities())
            {
                result = (from attributs in db.tbl_m_dosen
                          join b in db.tbl_m_jurusan on attributs.id_jurusan_fk equals b.id_jurusan_pk
                          join c in db.tbl_m_type_dosen on attributs.id_type_dosen_fk equals c.id_type_dosen_pk
                          select new DosenViewModel
                {
                    id_dosen_pk = attributs.id_dosen_pk,
                    kode_dosen = attributs.kode_dosen,
                    nama_dosen = attributs.nama_dosen,
                    id_jurusan_fk = attributs.id_jurusan_fk,
                    id_type_dosen_fk = attributs.id_type_dosen_fk,
                    is_active = attributs.is_active,
                    created_by = attributs.created_by,
                    created_date = attributs.created_date,
                    updated_by = attributs.updated_by,
                    updated_date = attributs.updated_date,
                    program_studi = b.nama_jurusan,
                    status_karyawan = c.deskripsi
                }
                          ).ToList();
            }
            return(result);
        }
        public static DosenViewModel GetDetailsByid(int id)
        {
            DosenViewModel result = new DosenViewModel();

            using (var db = new DB_UniversityEntities())
            {
                result = (from attributs in db.tbl_m_dosen
                          join b in db.tbl_m_jurusan on attributs.id_jurusan_fk equals b.id_jurusan_pk
                          join c in db.tbl_m_type_dosen on attributs.id_type_dosen_fk equals c.id_type_dosen_pk
                          where attributs.id_dosen_pk == id
                          select new DosenViewModel
                {
                    id_dosen_pk = attributs.id_dosen_pk,
                    kode_dosen = attributs.kode_dosen,
                    nama_dosen = attributs.nama_dosen,
                    id_jurusan_fk = attributs.id_jurusan_fk,
                    id_type_dosen_fk = attributs.id_type_dosen_fk,
                    is_active = attributs.is_active,
                    created_by = attributs.created_by,
                    created_date = attributs.created_date,
                    updated_by = attributs.updated_by,
                    updated_date = attributs.updated_date,
                    program_studi = b.nama_jurusan,
                    status_karyawan = c.deskripsi
                }).FirstOrDefault();
            }
            return(result);
        }
        public static int GetCountData(string paramSearch)
        {
            int countData = 0;

            using (var db = new DB_UniversityEntities())
            {
                countData = (db.tbl_m_dosen.Count(a => a.kode_dosen.ToLower().Trim().Contains(paramSearch) || a.kode_dosen.ToLower().Trim().Contains(paramSearch)));
            }

            return(countData);
        }
        public static AgamaViewModel GetDetailsByid(int id)
        {
            AgamaViewModel result = new AgamaViewModel();

            using (var db = new DB_UniversityEntities())
            {
                result = (from attributs in db.tbl_m_agama
                          where attributs.id_agama_pk == id
                          select new AgamaViewModel
                {
                    id_agama_pk = attributs.id_agama_pk,
                    kode_agama = attributs.kode_agama,
                    deskripsi = attributs.deskripsi,
                    is_active = attributs.is_active,
                    created_by = attributs.created_by,
                    created_date = attributs.created_date,
                    updated_by = attributs.updated_by,
                    updated_date = attributs.updated_date
                }).FirstOrDefault();
            }
            return(result);
        }
        public static List <AgamaViewModel> GetListAll()
        {
            List <AgamaViewModel> result = new List <AgamaViewModel>();

            using (var db = new DB_UniversityEntities())
            {
                result = (from attributs in db.tbl_m_agama
                          select new AgamaViewModel
                {
                    id_agama_pk = attributs.id_agama_pk,
                    kode_agama = attributs.kode_agama,
                    deskripsi = attributs.deskripsi,
                    is_active = attributs.is_active,
                    created_by = attributs.created_by,
                    created_date = attributs.created_date,
                    updated_by = attributs.updated_by,
                    updated_date = attributs.updated_date
                }
                          ).ToList();
            }
            return(result);
        }
        public static bool Insert(DosenViewModel model)
        {
            bool result = true;

            try
            {
                using (var db = new DB_UniversityEntities())
                {
                    tbl_m_dosen attributs = new tbl_m_dosen();
                    attributs.nama_dosen       = model.nama_dosen;
                    attributs.id_jurusan_fk    = model.id_jurusan_fk;
                    attributs.id_type_dosen_fk = model.id_type_dosen_fk;
                    attributs.is_active        = model.is_active;
                    attributs.created_by       = model.created_by;
                    attributs.created_date     = model.created_date;
                    attributs.updated_by       = model.updated_by;
                    attributs.updated_date     = model.updated_date;
                    attributs.kode_dosen       = model.kode_dosen;

                    db.tbl_m_dosen.Add(attributs);
                    db.SaveChanges();
                }
            }
            catch (Exception hasError)
            {
                if (hasError.Message.ToLower().Contains("inner exception"))
                {
                    Message = hasError.InnerException.InnerException.Message;
                }
                else
                {
                    Message = hasError.Message;
                }
                result = false;
            }

            return(result);
        }
示例#9
0
        public static JurusanViewModel GetDetailsByid(int id)
        {
            JurusanViewModel result = new JurusanViewModel();

            using (var db = new DB_UniversityEntities())
            {
                result = (from attributs in db.tbl_m_jurusan
                          where attributs.id_jurusan_pk == id
                          select new JurusanViewModel
                {
                    id_jurusan_pk = attributs.id_jurusan_pk,
                    kode_jurusan = attributs.kode_jurusan,
                    nama_jurusan = attributs.nama_jurusan,
                    is_active = attributs.is_active,
                    created_by = attributs.created_by,
                    created_date = attributs.created_date,
                    updated_by = attributs.updated_by,
                    updated_date = attributs.updated_date,
                    akreditasi = attributs.Akreditasi
                }).FirstOrDefault();
            }
            return(result);
        }
示例#10
0
        public static List <JurusanViewModel> GetListAll()
        {
            List <JurusanViewModel> result = new List <JurusanViewModel>();

            using (var db = new DB_UniversityEntities())
            {
                result = (from attributs in db.tbl_m_jurusan
                          select new JurusanViewModel
                {
                    id_jurusan_pk = attributs.id_jurusan_pk,
                    kode_jurusan = attributs.kode_jurusan,
                    nama_jurusan = attributs.nama_jurusan,
                    is_active = attributs.is_active,
                    created_by = attributs.created_by,
                    created_date = attributs.created_date,
                    updated_by = attributs.updated_by,
                    updated_date = attributs.updated_date,
                    akreditasi = attributs.Akreditasi
                }
                          ).ToList();
            }
            return(result);
        }
        public static bool Insert(AgamaViewModel model)
        {
            bool result = true;

            try
            {
                using (var db = new DB_UniversityEntities())
                {
                    tbl_m_agama attributs = new tbl_m_agama();
                    attributs.deskripsi    = model.deskripsi;
                    attributs.is_active    = model.is_active;
                    attributs.created_by   = model.created_by;
                    attributs.created_date = model.created_date;
                    attributs.updated_by   = model.updated_by;
                    attributs.updated_date = model.updated_date;
                    attributs.kode_agama   = model.kode_agama;

                    db.tbl_m_agama.Add(attributs);
                    db.SaveChanges();
                }
            }
            catch (Exception hasError)
            {
                if (hasError.Message.ToLower().Contains("inner exception"))
                {
                    Message = hasError.InnerException.InnerException.Message;
                }
                else
                {
                    Message = hasError.Message;
                }
                result = false;
            }

            return(result);
        }
        public static List <DosenViewModel> GetListAll(string paramSearch, int paramAsc, int paramDesc, int paramPage, int paramPageSize)
        {
            List <DosenViewModel> result = new List <DosenViewModel>();

            using (var db = new DB_UniversityEntities())
            {
                IQueryable <DosenViewModel> query;

                /* pengurutan / sorting */
                if (paramAsc == 1)
                {
                    query = (from attributs in db.tbl_m_dosen
                             join b in db.tbl_m_jurusan on attributs.id_jurusan_fk equals b.id_jurusan_pk
                             join c in db.tbl_m_type_dosen on attributs.id_type_dosen_fk equals c.id_type_dosen_pk
                             where attributs.kode_dosen.ToLower().Trim().Contains(paramSearch) ||
                             attributs.nama_dosen.ToLower().Trim().Contains(paramSearch)
                             orderby attributs.kode_dosen ascending
                             select new DosenViewModel
                    {
                        id_dosen_pk = attributs.id_dosen_pk,
                        kode_dosen = attributs.kode_dosen,
                        nama_dosen = attributs.nama_dosen,
                        id_jurusan_fk = attributs.id_jurusan_fk,
                        id_type_dosen_fk = attributs.id_type_dosen_fk,
                        is_active = attributs.is_active,
                        created_by = attributs.created_by,
                        created_date = attributs.created_date,
                        updated_by = attributs.updated_by,
                        updated_date = attributs.updated_date,
                        program_studi = b.nama_jurusan,
                        status_karyawan = c.deskripsi
                    }).Skip(paramPage).Take(paramPageSize);
                }
                else
                {
                    query = (from attributs in db.tbl_m_dosen
                             join b in db.tbl_m_jurusan on attributs.id_jurusan_fk equals b.id_jurusan_pk
                             join c in db.tbl_m_type_dosen on attributs.id_type_dosen_fk equals c.id_type_dosen_pk
                             where attributs.kode_dosen.ToLower().Trim().Contains(paramSearch) ||
                             attributs.nama_dosen.ToLower().Trim().Contains(paramSearch)
                             orderby attributs.kode_dosen descending
                             select new DosenViewModel
                    {
                        id_dosen_pk = attributs.id_dosen_pk,
                        kode_dosen = attributs.kode_dosen,
                        nama_dosen = attributs.nama_dosen,
                        id_jurusan_fk = attributs.id_jurusan_fk,
                        id_type_dosen_fk = attributs.id_type_dosen_fk,
                        is_active = attributs.is_active,
                        created_by = attributs.created_by,
                        created_date = attributs.created_date,
                        updated_by = attributs.updated_by,
                        updated_date = attributs.updated_date,
                        program_studi = b.nama_jurusan,
                        status_karyawan = c.deskripsi
                    }).Skip(paramPage).Take(paramPageSize);
                }

                result = query.ToList();
            }
            return(result);
        }