public ActionResult EditJabatan([Bind(Include = "GE_KOD_JABATAN,GE_KETERANGAN_JABATAN,GE_ALAMAT1,GE_ALAMAT2,GE_ALAMAT3,GE_BANDAR,GE_POSKOD,GE_NEGERI,GE_TELPEJABAT1,GE_TELPEJABAT2,GE_FAKS1,GE_FAKS2,GE_EMAIL,GE_NO_KETUA,GE_SINGKATAN,GE_AKTIF_IND")] GE_JABATAN jabatan) { if (ModelState.IsValid) { db2.Entry(jabatan).State = EntityState.Modified; db2.SaveChanges(); return(RedirectToAction("Index")); } return(View(jabatan)); }
public ActionResult TambahGredJawatan(GredJawatanModels model) { if (ModelState.IsValid) { var checkJawatan = db.HR_JAWATAN.Where(s => s.HR_NAMA_JAWATAN == model.HR_JAWATAN.HR_NAMA_JAWATAN).ToList(); //check samada da ada atau belum //tak boleh guna yg dah ada so panggil HR_NAMA_JAWATAN if (checkJawatan.Count <= 0) { var SelectLastID = db.HR_JAWATAN.OrderByDescending(s => s.HR_KOD_JAWATAN).FirstOrDefault().HR_KOD_JAWATAN; var LastID = new string(SelectLastID.SkipWhile(x => x == 'J' || x == '0').ToArray()); var Increment = Convert.ToSingle(LastID) + 1; var KodJawatan = "J" + Convert.ToString(Increment).PadLeft(4, '0'); model.HR_JAWATAN.HR_KOD_JAWATAN = KodJawatan; db.HR_JAWATAN.Add(model.HR_JAWATAN); } else { db.Entry(model.HR_JAWATAN).State = EntityState.Modified; } var selectGred = db2.GE_PARAMTABLE.Where(s => s.SHORT_DESCRIPTION == model.GE_PARAMTABLE.SHORT_DESCRIPTION && s.STRING_PARAM == model.GE_PARAMTABLE.STRING_PARAM && s.GROUPID == 109).ToList(); if (selectGred.Count() <= 0) { int IncrementGE = db2.GE_PARAMTABLE.Where(s => s.GROUPID == 109).OrderByDescending(s => s.ORDINAL).FirstOrDefault().ORDINAL; model.GE_PARAMTABLE.LONG_DESCRIPTION = model.GE_PARAMTABLE.SHORT_DESCRIPTION; model.GE_PARAMTABLE.AUDIT_WHEN = DateTime.Now; model.GE_PARAMTABLE.GROUPID = 109; model.GE_PARAMTABLE.ORDINAL = IncrementGE + 1; db2.GE_PARAMTABLE.Add(model.GE_PARAMTABLE); } else { db2.Entry(model.GE_PARAMTABLE).State = EntityState.Modified; } model.HR_GELARAN_JAWATAN.HR_KOD_JAWATAN = model.HR_JAWATAN.HR_KOD_JAWATAN; model.HR_GELARAN_JAWATAN.HR_GRED = model.GE_PARAMTABLE.SHORT_DESCRIPTION; var checkGelaran = db.HR_GELARAN_JAWATAN.Where(s => s.HR_PENERANGAN == model.HR_GELARAN_JAWATAN.HR_PENERANGAN).ToList(); //check samada da ada atau belum //tak boleh guna yg dah ada so panggil HR_NAMA_JAWATAN if (checkGelaran.Count <= 0) { var SelectLastID = db.HR_GELARAN_JAWATAN.OrderByDescending(s => s.HR_KOD_GELARAN).FirstOrDefault().HR_KOD_GELARAN; var LastID = new string(SelectLastID.SkipWhile(x => x == 'G' || x == '0').ToArray()); var Increment = Convert.ToSingle(LastID) + 1; var KodGelaran = "G" + Convert.ToString(Increment).PadLeft(4, '0'); model.HR_GELARAN_JAWATAN.HR_KOD_GELARAN = KodGelaran; db.HR_GELARAN_JAWATAN.Add(model.HR_GELARAN_JAWATAN); } else { db.Entry(model.HR_GELARAN_JAWATAN).State = EntityState.Modified; } db.SaveChanges(); return(RedirectToAction("Index")); } return(View(model)); }
public ActionResult EditGred([Bind(Include = "GROUPID,ORDINAL,SHORT_DESCRIPTION,LONG_DESCRIPTION,STRING_PARAM,AUDIT_WHEN")] GE_PARAMTABLE gred) { if (ModelState.IsValid) { List <GE_PARAMTABLE> selectGred = db2.GE_PARAMTABLE.Where(s => s.GROUPID == 109 && s.STRING_PARAM == gred.STRING_PARAM && s.SHORT_DESCRIPTION == gred.SHORT_DESCRIPTION && s.ORDINAL != gred.ORDINAL).ToList(); if (selectGred.Count() <= 0) { gred.LONG_DESCRIPTION = gred.SHORT_DESCRIPTION; db2.Entry(gred).State = EntityState.Modified; db2.SaveChanges(); } return(RedirectToAction("SenaraiGred")); } ViewBag.GE_PARAMTABLE = db2.GE_PARAMTABLE.Where(s => s.GROUPID == 109).ToList(); return(View(gred)); }
public async Task <ActionResult> ChangePassword(ChangePasswordViewModel model, string getuserid) { eSPP.Models.GroupFeature groupFeature = new eSPP.Models.GroupFeature(); List <Guid> userGroupIDList = new List <Guid>(); List <eSPP.Models.GroupFeaturesDisplay> groupFeatureDisplayList = new List <eSPP.Models.GroupFeaturesDisplay>(); if (User.Identity.IsAuthenticated) { UserGroup userGroup = new UserGroup(); userGroupIDList = userGroup.GetGroupByLoginUser(); groupFeatureDisplayList = groupFeature.GetFeatureListByGroup(userGroupIDList); } MajlisContext mc = new MajlisContext(); if (getuserid == null) { getuserid = User.Identity.GetUserId(); } ApplicationDbContext db = new ApplicationDbContext(); if (!ModelState.IsValid) { return(RedirectToAction("ChangePassword", "Manage", new { getuserid = getuserid, Message = ManageMessageId.ErrorPassword })); } var userid = await UserManager.FindByIdAsync(getuserid); var result = await UserManager.ChangePasswordAsync(userid.Id, model.OldPassword, model.NewPassword); if (result.Succeeded) { var user = await UserManager.FindByIdAsync(getuserid); if (user != null) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); } var pokemon = User.Identity.Name; var user1 = db.Users.Where(s => s.UserName == pokemon).SingleOrDefault(); var emel = db.Users.Where(s => s.Email == user1.Email).SingleOrDefault(); var role1 = db.UserRoles.Where(d => d.UserId == user1.Id).SingleOrDefault(); IdentityRole role = new IdentityRole(); if (role != null) { role = db.Roles.Where(e => e.Id == role1.RoleId).SingleOrDefault(); } ApplicationUser ui = db.Users.SingleOrDefault(s => s.Id == getuserid); PRUSER pruser = mc.PRUSER.SingleOrDefault(s => s.USERNAME == ui.UserName); string password = model.NewPassword; string hPassword = ComputeHash(password, new MD5CryptoServiceProvider()); pruser.USERPASSWORD = hPassword; mc.Entry(pruser).State = EntityState.Modified; mc.SaveChanges(); ui.PasswordUpdate = DateTime.Now; db.Entry(ui).State = EntityState.Modified; db.SaveChanges(); new AuditTrailModels().Log(emel.Email, emel.UserName, System.Web.HttpContext.Current.Request.UserHostAddress, role.Name, emel.UserName + " Telah Menukar Katalaluan", System.Net.Dns.GetHostName(), emel.PhoneNumber, Request.RawUrl, "ChangePassword"); var username = User.Identity.Name; HR_MAKLUMAT_PERIBADI name = db.HR_MAKLUMAT_PERIBADI.FirstOrDefault(s => s.HR_NO_KPBARU == username); return(RedirectToAction("Index", "Home", new { id = name.HR_NO_PEKERJA, Message = ManageMessageId.ChangePasswordSuccess })); } AddErrors(result); return(RedirectToAction("ChangePassword", "Manage", new { getuserid = getuserid, Message = ManageMessageId.ErrorPassword })); }