Exemple #1
0
        public ActionResult IndexCutiK()
        {
            if (Session["nik"] == null)
            {
                return(RedirectToAction("Index", "Login"));
            }
            if (Session["jabatan"].ToString() != "k")
            {
                return(RedirectToAction("Admin", "Login"));
            }
            int       id  = Convert.ToInt32(Session["nik"]);
            cuti_user cek = db.cuti_user.Find(id);

            ViewBag.jatah      = cek.jatah_cuti;
            ViewBag.sisa       = cek.sisa_cuti;
            ViewBag.validjatah = cek.valid_jatah;
            ViewBag.validsisa  = cek.valid_sisa;
            return(View());
        }
Exemple #2
0
 public ActionResult NewCuti(cuti cute)
 {
     try
     {
         var cutitit = db.cutis.Where(u => u.nik == cute.nik && ((u.durasi_awal >= cute.durasi_awal && u.durasi_awal <= cute.durasi_akhir) || (u.durasi_akhir <= cute.durasi_akhir && u.durasi_akhir >= cute.durasi_awal))).FirstOrDefault();
         if (cutitit != null)
         {
             return(Json(new { success = false, message = "Cuti sudah ada di hari yang sama!" }, JsonRequestBehavior.AllowGet));
         }
         cute.tanggal = DateTime.Today;
         cute.oleh    = Session["nama"].ToString();
         db.cutis.Add(cute);
         cuti_user cutis     = db.cuti_user.Find(cute.nik);
         int       totalhari = Convert.ToInt32((cute.durasi_akhir - cute.durasi_awal).TotalDays);
         totalhari += 1;
         if (totalhari <= 0)
         {
             return(Json(new { success = false, message = "Periksa kembali tanggal yang diinput!" }, JsonRequestBehavior.AllowGet));
         }
         if (cutis.sisa_cuti >= totalhari)
         {
             cutis.sisa_cuti -= totalhari;
         }
         else
         {
             cutis.jatah_cuti = (cutis.jatah_cuti + cutis.sisa_cuti) - totalhari;
             cutis.sisa_cuti  = 0;
         }
         db.Entry(cutis).State = EntityState.Modified;
         db.SaveChanges();
         return(Json(new { success = true, html = Global.RenderRazorViewToString(this, "RiwayatCuti", GetRiwayatCuti()), message = "Input Cuti Sukses!" }, JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
     }
 }
Exemple #3
0
        public ActionResult Edit(user emp, cuti_user jatahcuti, saldo_medical saldo)
        {
            //try
            //{
            int  id    = Convert.ToInt32(Session["nik"]);
            user users = db.users.Find(id);

            if (users.email != emp.email)
            {
                var cekemail = db.users.Where(u => u.email == emp.email).FirstOrDefault();
                if (cekemail != null)
                {
                    return(Json(new { success = false, message = "E-Mail sudah terdaftar" }, JsonRequestBehavior.AllowGet));
                }
            }
            if (emp.foto != null)
            {
                var fotolama = db.users.Where(u => u.nik == emp.nik).FirstOrDefault();
                var fullpath = Request.MapPath(fotolama.foto_profil);
                if (emp.foto.ContentType.Contains("image"))
                {
                }
                else
                {
                    return(Json(new { success = false, message = "Format foto profil salah" }, JsonRequestBehavior.AllowGet));
                }
                if (fotolama.foto_profil != "~/AppFiles/Images/default.png")
                {
                    if (System.IO.File.Exists(fullpath))
                    {
                        System.IO.File.Delete(fullpath);
                    }
                }
                string fileName  = Path.GetFileNameWithoutExtension(emp.foto.FileName);
                string extension = Path.GetExtension(emp.foto.FileName);
                fileName          = fileName + emp.nama + DateTime.Now.ToString("yymmssffff") + extension;
                users.foto_profil = "~/AppFiles/Images/" + fileName;
                emp.foto.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
            }
            if (emp.filektp != null)
            {
                var filelama = db.users.Where(u => u.nik == emp.nik).FirstOrDefault();
                var fullpath = Request.MapPath(filelama.file_ktp);
                if (System.IO.File.Exists(fullpath))
                {
                    System.IO.File.Delete(fullpath);
                }
                string fileName  = Path.GetFileNameWithoutExtension(emp.filektp.FileName);
                string extension = Path.GetExtension(emp.filektp.FileName);
                fileName       = fileName + emp.nama + DateTime.Now.ToString("yymmssffff") + extension;
                users.file_ktp = "~/AppFiles/FileUser/" + fileName;
                emp.filektp.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/FileUser/"), fileName));
            }
            if (emp.filenpwp != null)
            {
                var filelama = db.users.Where(u => u.nik == emp.nik).FirstOrDefault();
                var fullpath = Request.MapPath(filelama.file_npwp);
                if (System.IO.File.Exists(fullpath))
                {
                    System.IO.File.Delete(fullpath);
                }
                string fileName  = Path.GetFileNameWithoutExtension(emp.filenpwp.FileName);
                string extension = Path.GetExtension(emp.filenpwp.FileName);
                fileName        = fileName + emp.nama + DateTime.Now.ToString("yymmssffff") + extension;
                users.file_npwp = "~/AppFiles/FileUser/" + fileName;
                emp.filenpwp.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/FileUser/"), fileName));
            }
            if (emp.filerekening != null)
            {
                var filelama = db.users.Where(u => u.nik == emp.nik).FirstOrDefault();
                var fullpath = Request.MapPath(filelama.file_rekening);
                if (System.IO.File.Exists(fullpath))
                {
                    System.IO.File.Delete(fullpath);
                }
                string fileName  = Path.GetFileNameWithoutExtension(emp.filerekening.FileName);
                string extension = Path.GetExtension(emp.filerekening.FileName);
                fileName            = fileName + emp.nama + DateTime.Now.ToString("yymmssffff") + extension;
                users.file_rekening = "~/AppFiles/FileUser/" + fileName;
                emp.filerekening.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/FileUser/"), fileName));
            }
            if (emp.fileijasah != null)
            {
                var filelama = db.users.Where(u => u.nik == emp.nik).FirstOrDefault();
                var fullpath = Request.MapPath(filelama.file_ijasah);
                if (System.IO.File.Exists(fullpath))
                {
                    System.IO.File.Delete(fullpath);
                }
                string fileName  = Path.GetFileNameWithoutExtension(emp.fileijasah.FileName);
                string extension = Path.GetExtension(emp.fileijasah.FileName);
                fileName          = fileName + emp.nama + DateTime.Now.ToString("yymmssffff") + extension;
                users.file_ijasah = "~/AppFiles/FileUser/" + fileName;
                emp.fileijasah.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/FileUser/"), fileName));
            }
            users.nama  = emp.nama;
            users.email = emp.email;

            users.no_hp        = emp.no_hp;
            users.tempat_lahir = emp.tempat_lahir;
            if (emp.tanggal_lahir != null)
            {
                users.tanggal_lahir = emp.tanggal_lahir;
            }
            if (emp.nip != null)
            {
                users.nip = emp.nip;
            }
            users.oleh             = Session["nama"].ToString();
            users.jenis_kelamin    = emp.jenis_kelamin;
            users.alamat_domisili  = emp.alamat_domisili;
            users.pendidikan_akhir = emp.pendidikan_akhir;
            users.no_ktp           = emp.no_ktp;
            users.alamat_ktp       = emp.alamat_ktp;
            users.jurusan          = emp.jurusan;
            users.agama            = emp.agama;
            users.npwp             = emp.npwp;
            users.bpjs             = emp.bpjs;
            users.status_pajak     = emp.status_pajak;
            users.status_kerja     = emp.status_kerja;
            users.no_rekening      = emp.no_rekening;
            users.jabatan          = emp.jabatan;
            users.penempatan       = emp.penempatan;
            db.Entry(users).State  = EntityState.Modified;
            db.SaveChanges();
            return(Json(new { success = true, html = Global.RenderRazorViewToString(this, "Details", GetDetail()), message = "Edit Data Sukses" }, JsonRequestBehavior.AllowGet));
            // }
            //catch (Exception ex)
            //{

            //    return Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet);
            //}
        }
Exemple #4
0
 public ActionResult Validate(user user, string returnUrl)
 {
     using (dbOpsModel db = new dbOpsModel())
     {
         string email = Convert.ToString(user.email).ToUpper().Trim();
         string pass  = md5.encryption(user.password);
         //string pass = user.password;
         var userDetails = db.users.Where(x => x.email.ToUpper() == email && x.password == pass).FirstOrDefault();
         if (userDetails == null)
         {
             ViewBag.msg = "<script>Swal.fire({ type: 'error', title: 'Login Gagal!', text: 'E-Mail atau Password salah'});</script>";
             return(View("Index"));
         }
         else if (userDetails.status_kerja == "Tidak Aktif")
         {
             ViewBag.msg = "<script>Swal.fire({ type: 'error', title: 'Login Gagal!', text: 'Akun anda sudah dinon-aktifkan!'});</script>";
             return(View("Index"));
         }
         else
         {
             FormsAuthentication.SetAuthCookie(user.email, false);
             Session["nik"]     = userDetails.nik;
             Session["nama"]    = userDetails.nama;
             Session["jabatan"] = userDetails.jabatan;
             if (userDetails.jabatan == "a" || userDetails.jabatan == "s")
             {
                 return(RedirectToAction("Admin", "Login"));
             }
             else if (userDetails.jabatan == "k")
             {
                 //renewal cuti
                 cuti_user cek = db.cuti_user.Find(userDetails.nik);
                 if (cek.valid_jatah <= DateTime.Today)
                 {
                     while (cek.valid_jatah <= DateTime.Today)
                     {
                         DateTime validdate2 = cek.valid_jatah;
                         cek.valid_jatah = validdate2.AddYears(1);
                     }
                     DateTime validdate = cek.valid_jatah;
                     if (cek.jatah_cuti > 0)
                     {
                         cek.sisa_cuti   = cek.jatah_cuti;
                         cek.jatah_cuti += 12;
                         cek.jatah_cuti -= cek.sisa_cuti;
                         cek.valid_sisa  = validdate.AddMonths(6);
                     }
                     else
                     {
                         cek.jatah_cuti += 12;
                         cek.valid_sisa  = validdate.AddMonths(6);
                     }
                 }
                 if (cek.valid_sisa <= DateTime.Today)
                 {
                     cek.sisa_cuti = 0;
                 }
                 db.Entry(cek).State = EntityState.Modified;
                 db.SaveChanges();
                 //akhir renewal cuti
                 //renewal saldo medical
                 saldo_medical valid     = db.saldo_medical.Find(userDetails.nik);
                 saldo_awal    saldoawal = db.saldo_awal.Find(1);
                 if (valid.valid_rawat <= DateTime.Today)
                 {
                     valid.saldo_rawatinap  = saldoawal.default_inap;
                     valid.saldo_rawatjalan = saldoawal.default_jalan;
                     if (valid.valid_rawat == userDetails.join_date.AddMonths(3))
                     {
                         DateTime validdate = userDetails.join_date;
                         valid.valid_rawat = validdate.AddYears(1);
                         while (valid.valid_rawat <= DateTime.Today)
                         {
                             DateTime validdate2 = valid.valid_rawat;
                             valid.valid_rawat = validdate2.AddYears(1);
                         }
                     }
                     else
                     {
                         DateTime validdate = valid.valid_rawat;
                         valid.valid_rawat = validdate.AddYears(1);
                     }
                 }
                 if (valid.valid_kacamata <= DateTime.Today)
                 {
                     valid.saldo_kacamata = saldoawal.default_kacamata;
                     if (valid.valid_kacamata == userDetails.join_date.AddMonths(3))
                     {
                         DateTime validkacamata = userDetails.join_date;
                         valid.valid_kacamata = validkacamata.AddYears(2);
                         while (valid.valid_kacamata <= DateTime.Today)
                         {
                             DateTime validdate2 = valid.valid_kacamata;
                             valid.valid_kacamata = validdate2.AddYears(2);
                         }
                         int tai = Convert.ToInt32(userDetails.join_date.Year);
                         if (tai % 2 == 0)
                         {
                             DateTime validdate2 = valid.valid_kacamata;
                             valid.valid_kacamata = validdate2.AddYears(1);
                         }
                     }
                     else
                     {
                         DateTime validkacamata = valid.valid_kacamata;
                         valid.valid_kacamata = validkacamata.AddYears(2);
                     }
                 }
                 db.Entry(valid).State = EntityState.Modified;
                 //end renewalmedical
                 db.SaveChanges();
                 return(RedirectToAction("Karyawan", "Login"));
             }
             else
             {
                 return(View("../Home/Index"));
             }
         }
     }
 }
Exemple #5
0
 public ActionResult AddorEdit(user emp, cuti_user cuti, saldo_medical saldo)
 {
     try
     {
         user users = db.users.Find(emp.nik);
         if (emp.nik == 0)
         {
             var cekemail = db.users.Where(u => u.email == emp.email).FirstOrDefault();
             if (cekemail != null)
             {
                 return(Json(new { success = false, message = "E-Mail sudah terdaftar" }, JsonRequestBehavior.AllowGet));
             }
             var ceknip = db.users.Where(u => u.nip == emp.nip).FirstOrDefault();
             if (ceknip != null)
             {
                 return(Json(new { success = false, message = "NIP sudah terdaftar" }, JsonRequestBehavior.AllowGet));
             }
         }
         else
         {
             if (users.email != emp.email)
             {
                 var cekemail = db.users.Where(u => u.email == emp.email).FirstOrDefault();
                 if (cekemail != null)
                 {
                     return(Json(new { success = false, message = "E-Mail sudah terdaftar" }, JsonRequestBehavior.AllowGet));
                 }
             }
             if (users.nip != emp.nip)
             {
                 var ceknip = db.users.Where(u => u.nip == emp.nip).FirstOrDefault();
                 if (ceknip != null)
                 {
                     return(Json(new { success = false, message = "NIP sudah terdaftar" }, JsonRequestBehavior.AllowGet));
                 }
             }
         }
         if (emp.foto != null)
         {
             string fileName  = Path.GetFileNameWithoutExtension(emp.foto.FileName);
             string extension = Path.GetExtension(emp.foto.FileName);
             fileName = fileName + emp.nama + DateTime.Now.ToString("yymmssffff") + extension;
             if (emp.nik == 0)
             {
                 emp.foto_profil = "~/AppFiles/Images/" + fileName;
             }
             else
             {
                 var fotolama = db.users.Where(u => u.nik == emp.nik).FirstOrDefault();
                 var fullpath = Request.MapPath(fotolama.foto_profil);
                 if (emp.foto.ContentType.Contains("image"))
                 {
                 }
                 else
                 {
                     return(Json(new { success = false, message = "Format foto profil salah" }, JsonRequestBehavior.AllowGet));
                 }
                 if (fotolama.foto_profil != "~/AppFiles/Images/default.png")
                 {
                     if (System.IO.File.Exists(fullpath))
                     {
                         System.IO.File.Delete(fullpath);
                     }
                 }
                 users.foto_profil = "~/AppFiles/Images/" + fileName;
             }
             emp.foto.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
         }
         if (emp.filektp != null)
         {
             string fileName  = Path.GetFileNameWithoutExtension(emp.filektp.FileName);
             string extension = Path.GetExtension(emp.filektp.FileName);
             fileName = fileName + emp.nama + DateTime.Now.ToString("yymmssffff") + extension;
             if (emp.nik == 0)
             {
                 emp.file_ktp = "~/AppFiles/FileUser/" + fileName;
             }
             else
             {
                 var filelama = db.users.Where(u => u.nik == emp.nik).FirstOrDefault();
                 var fullpath = Request.MapPath(filelama.file_ktp);
                 if (System.IO.File.Exists(fullpath))
                 {
                     System.IO.File.Delete(fullpath);
                 }
                 users.file_ktp = "~/AppFiles/FileUser/" + fileName;
             }
             emp.filektp.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/FileUser/"), fileName));
         }
         if (emp.filenpwp != null)
         {
             string fileName  = Path.GetFileNameWithoutExtension(emp.filenpwp.FileName);
             string extension = Path.GetExtension(emp.filenpwp.FileName);
             fileName = fileName + emp.nama + DateTime.Now.ToString("yymmssffff") + extension;
             if (emp.nik == 0)
             {
                 emp.file_npwp = "~/AppFiles/FileUser/" + fileName;
             }
             else
             {
                 var filelama = db.users.Where(u => u.nik == emp.nik).FirstOrDefault();
                 var fullpath = Request.MapPath(filelama.file_npwp);
                 if (System.IO.File.Exists(fullpath))
                 {
                     System.IO.File.Delete(fullpath);
                 }
                 users.file_npwp = "~/AppFiles/FileUser/" + fileName;
             }
             emp.filenpwp.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/FileUser/"), fileName));
         }
         if (emp.filerekening != null)
         {
             string fileName  = Path.GetFileNameWithoutExtension(emp.filerekening.FileName);
             string extension = Path.GetExtension(emp.filerekening.FileName);
             fileName = fileName + emp.nama + DateTime.Now.ToString("yymmssffff") + extension;
             if (emp.nik == 0)
             {
                 emp.file_rekening = "~/AppFiles/FileUser/" + fileName;
             }
             else
             {
                 var filelama = db.users.Where(u => u.nik == emp.nik).FirstOrDefault();
                 var fullpath = Request.MapPath(filelama.file_npwp);
                 if (System.IO.File.Exists(fullpath))
                 {
                     System.IO.File.Delete(fullpath);
                 }
                 users.file_rekening = "~/AppFiles/FileUser/" + fileName;
             }
             emp.filerekening.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/FileUser/"), fileName));
         }
         if (emp.fileijasah != null)
         {
             string fileName  = Path.GetFileNameWithoutExtension(emp.fileijasah.FileName);
             string extension = Path.GetExtension(emp.fileijasah.FileName);
             fileName = fileName + emp.nama + DateTime.Now.ToString("yymmssffff") + extension;
             if (emp.nik == 0)
             {
                 emp.file_ijasah = "~/AppFiles/FileUser/" + fileName;
             }
             else
             {
                 var filelama = db.users.Where(u => u.nik == emp.nik).FirstOrDefault();
                 var fullpath = Request.MapPath(filelama.file_ijasah);
                 if (System.IO.File.Exists(fullpath))
                 {
                     System.IO.File.Delete(fullpath);
                 }
                 users.file_ijasah = "~/AppFiles/FileUser/" + fileName;
             }
             emp.fileijasah.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/FileUser/"), fileName));
         }
         if (emp.nik == 0)
         {
             //input data jatah cuti,dll saat nik di buat
             emp.password    = md5.encryption(emp.password);
             cuti.nik        = emp.nik;
             cuti.jatah_cuti = 0;
             cuti.sisa_cuti  = 0;
             DateTime joindate = emp.join_date;
             cuti.valid_jatah       = joindate.AddYears(1);
             cuti.valid_sisa        = joindate.AddMonths(18);
             saldo.nik              = emp.nik;
             saldo.saldo_kacamata   = 0;
             saldo.saldo_rawatinap  = 0;
             saldo.saldo_rawatjalan = 0;
             saldo.valid_rawat      = joindate.AddMonths(3);
             saldo.valid_kacamata   = joindate.AddMonths(3);
             db.cuti_user.Add(cuti);
             db.saldo_medical.Add(saldo);
             db.users.Add(emp);
             db.SaveChanges();
         }
         else
         {
             users.nip   = emp.nip;
             users.nama  = emp.nama;
             users.email = emp.email;
             users.no_hp = emp.no_hp;
             if (emp.tanggal_lahir != null)
             {
                 users.tanggal_lahir = emp.tanggal_lahir;
             }
             users.tempat_lahir     = emp.tempat_lahir;
             users.jenis_kelamin    = emp.jenis_kelamin;
             users.alamat_domisili  = emp.alamat_domisili;
             users.pendidikan_akhir = emp.pendidikan_akhir;
             users.no_ktp           = emp.no_ktp;
             users.alamat_ktp       = emp.alamat_ktp;
             users.jurusan          = emp.jurusan;
             users.agama            = emp.agama;
             users.npwp             = emp.npwp;
             users.status_pajak     = emp.status_pajak;
             users.status_kerja     = emp.status_kerja;
             users.no_rekening      = emp.no_rekening;
             users.jabatan          = emp.jabatan;
             users.penempatan       = emp.penempatan;
             users.posisi           = emp.posisi;
             users.bpjs             = emp.bpjs;
             db.Entry(users).State  = EntityState.Modified;
             db.SaveChanges();
             return(Json(new { success = true, html = Global.RenderRazorViewToString(this, "ViewAll", GetAllUser()), message = "Edit data sukses" }, JsonRequestBehavior.AllowGet));
         }
         return(Json(new { success = true, html = Global.RenderRazorViewToString(this, "ViewAll", GetAllUser()), message = "Input Sukses" }, JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
     }
 }