public ActionResult Create([Bind(Include = "user_id,user_name,user_password,user_type_id,employee_id,fl_active")] user_accountViewModel user_acc) { if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { ms_employee emp = db.ms_employee.Find(user_acc.employee_id); if (emp == null) { throw new Exception("Employee not found " + user_acc.employee_id.ToString()); } else { user_acc.employee_nik = emp.employee_nik; user_acc.employee_name = emp.employee_name; user_acc.employee_email = emp.employee_email; emp.fl_active = true; emp.updated_by = UserProfile.UserId; emp.updated_date = DateTime.Now; emp.deleted_by = null; emp.deleted_date = null; db.Entry(emp).State = EntityState.Modified; ms_user ms_user = new ms_user() { user_name = user_acc.user_name, user_password = App_Helpers.CryptorHelper.Encrypt(user_acc.user_password, "MD5", true), user_type_id = user_acc.user_type_id, employee_id = emp.employee_id, fl_active = user_acc.fl_active, created_by = UserProfile.UserId, created_date = DateTime.Now, updated_by = UserProfile.UserId, updated_date = DateTime.Now, deleted_by = null, deleted_date = null }; db.ms_user.Add(ms_user); db.SaveChanges(); } transaction.Commit(); ViewBag.ResultMessage = "Record inserted into table successfully."; return(RedirectToAction("Index")); } catch (Exception ex) { transaction.Rollback(); ViewBag.ResultMessage = string.Format("Error occured, records rolledback. {0}", ex.Message); } } } return(View(user_acc)); }
public ActionResult DeleteConfirmed(int id) { ms_employee ms_employee = db.ms_employee.Find(id); db.ms_employee.Remove(ms_employee); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "employee_id,employee_nik,employee_name,employee_email,fl_active,created_date,created_by,updated_date,updated_by,deleted_date,deleted_by,org_id,ip_address")] ms_employee ms_employee) { if (ModelState.IsValid) { db.Entry(ms_employee).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(ms_employee)); }
// GET: employee/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ms_employee ms_employee = db.ms_employee.Find(id); if (ms_employee == null) { return(HttpNotFound()); } return(View(ms_employee)); }
public ActionResult Edit([Bind(Include = "user_id,user_name,user_password,user_type_id,employee_id,fl_active")] user_accountViewModel user_acc) { if (ModelState.IsValid) { ms_user ms_user = db.ms_user.Find(user_acc.user_id); ms_user.user_name = user_acc.user_name; if (!string.IsNullOrWhiteSpace(user_acc.user_password)) { ms_user.user_password = App_Helpers.CryptorHelper.Encrypt(user_acc.user_password, "MD5", true); } ms_user.user_type_id = user_acc.user_type_id; ms_user.fl_active = true; ms_user.updated_by = UserProfile.UserId; ms_user.updated_date = DateTime.Now; ms_user.deleted_by = null; ms_user.deleted_date = null; ms_employee emp = db.ms_employee.Find(user_acc.employee_id); if (emp != null) { ms_user.employee_id = emp.employee_id; emp.fl_active = true; emp.updated_by = UserProfile.UserId; emp.updated_date = DateTime.Now; emp.deleted_by = null; emp.deleted_date = null; db.Entry(emp).State = EntityState.Modified; } db.Entry(ms_user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user_acc)); }
/* * employee setup */ public ActionResult Setup(int?id) { if (id == null) { return(RedirectToAction("Index")); //return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } ms_employee emp_db = db.ms_employee.Single(a => a.employee_id == id); if (emp_db == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } employee_setupViewModel model = new employee_setupViewModel() { employee_id = emp_db.employee_id, ms_employee = emp_db }; List <SelectListItem> first = new List <SelectListItem> { new SelectListItem { Text = "- [Not Set] -", Value = "0", Selected = true } }; model.company_list = (from t in db.ms_asmin_company where (t.fl_active == true && t.deleted_date == null) select t).ToList(); model.sli_register_list = (from t in db.ms_asset_register_location where (t.fl_active == true && t.deleted_date == null) select new SelectListItem { Text = t.asset_reg_location_name, Value = t.asset_reg_location_id.ToString() } ).ToList <SelectListItem>().Union(first); model.sli_location_list = (from t in db.ms_asset_location where (t.fl_active == true && t.deleted_date == null) //&& t.asset_reg_location_id == model.selected_register_id[0] select new SelectListItem { Text = t.location_name, Value = t.location_id.ToString() } ).ToList <SelectListItem>().Union(first); model.sli_department_list = (from t in db.ms_department where (t.fl_active == true && t.deleted_date == null) //from d in db.ms_employee_detail //where (d.employee_id == emp_db.employee_id && t.department_id == d.department_id) select new SelectListItem { Text = t.department_name, Value = t.department_id.ToString() //Selected = (d.employee_id>0) } ).ToList <SelectListItem>().Union(first); model.sli_job_level_list = (from t in db.ms_job_level where (t.fl_active == true && t.deleted_date == null) select new SelectListItem { Text = t.job_level_name, Value = t.job_level_id.ToString() } ).ToList <SelectListItem>().Union(first); model.sli_user_type_list = (from t in db.ms_user_type where (t.fl_active == true && t.deleted_date == null) select new SelectListItem { Text = t.user_type_name, Value = t.user_type_id.ToString() } ).ToList <SelectListItem>().Union(first); model.sli_range_list = (from t in db.ms_approval_range where (t.fl_active == true && t.deleted_date == null) select new SelectListItem { Text = t.range_code, Value = t.range_id.ToString() } ).ToList <SelectListItem>().Union(first); int i_pos = 0; int i_max = model.company_list.Count; foreach (ms_asmin_company company in model.company_list) { employee_detailViewModel _item = new employee_detailViewModel() { employee_id = emp_db.employee_id, ms_asmin_company = company, sli_register_list = model.sli_register_list, sli_location_list = model.sli_location_list, sli_department_list = model.sli_department_list, sli_job_level_list = model.sli_job_level_list, sli_user_type_list = model.sli_user_type_list, sli_range_list = model.sli_range_list }; ms_employee_detail dtl_db = (from d in db.ms_employee_detail where (d.employee_id == emp_db.employee_id && d.company_id == company.company_id) select d).FirstOrDefault <ms_employee_detail>(); if (dtl_db != null) { dtl_db.range_id = 0; //di hide _item.selected_register_id = (dtl_db.asset_reg_location_id.HasValue) ? dtl_db.asset_reg_location_id.Value : 0; _item.selected_location_id = (dtl_db.location_id.HasValue) ? dtl_db.location_id.Value : 0; _item.selected_department_id = (dtl_db.department_id.HasValue) ? dtl_db.department_id.Value : 0; _item.selected_job_level_id = (dtl_db.job_level_id.HasValue) ? dtl_db.job_level_id.Value : 0; //_item.selected_user_type_id = (dtl_db.user_type_id.HasValue) ? dtl_db.user_type_id.Value : 0; _item.selected_fl_approver = (dtl_db.range_id.HasValue) ? ((dtl_db.range_id.Value > 0) ? 1 : 0) : 0; _item.selected_range_id = (dtl_db.range_id.HasValue) ? dtl_db.range_id.Value : 0; model.checkbox_approver.Add(new SelectedApprover_CheckBoxes { Checked = (dtl_db.range_id > 0), Value = "1" }); } else { _item.selected_register_id = 0; _item.selected_location_id = 0; _item.selected_department_id = 0; _item.selected_job_level_id = 0; _item.selected_user_type_id = 0; _item.selected_fl_approver = 0; //di hide _item.selected_range_id = 0; //di hide model.checkbox_approver.Add(new SelectedApprover_CheckBoxes { Checked = false, Value = "1" }); } model.employee_details.Add(_item); i_pos += 1; } return(View(model)); }
public JsonResult CrudEmployee() { if (Request.Form["oper"] == "add") { //prepare for insert data ms_employee ms_emp = new ms_employee(); ms_emp.employee_nik = Request.Form["employee_nik"]; ms_emp.employee_name = Request.Form["employee_name"]; ms_emp.employee_email = Request.Form["employee_email"]; ms_emp.ip_address = Request.Form["ip_address"]; ms_emp.fl_active = Request.Form["rec_isactive"].ToLower().Equals("yes"); ms_emp.created_by = UserProfile.UserId; ms_emp.created_date = DateTime.Now; ms_emp.updated_by = UserProfile.UserId; ms_emp.updated_date = DateTime.Now; ms_emp.org_id = UserProfile.OrgId; ms_emp.deleted_by = null; ms_emp.deleted_date = null; db.ms_employee.Add(ms_emp); db.SaveChanges(); return(Json("Employee successfully saved", JsonRequestBehavior.AllowGet)); } else if (Request.Form["oper"] == "edit") { if (IsNumeric(Request.Form["employee_id"].ToString())) { //prepare for update data int id = Convert.ToInt32(Request.Form["employee_id"]); ms_employee emp = db.ms_employee.Find(id); emp.employee_nik = Request.Form["employee_nik"]; emp.employee_name = Request.Form["employee_name"]; emp.employee_email = Request.Form["employee_email"]; emp.ip_address = Request.Form["ip_address"]; emp.fl_active = Request.Form["rec_isactive"].ToLower().Equals("yes"); emp.updated_by = UserProfile.UserId; emp.updated_date = DateTime.Now; db.SaveChanges(); return(Json("Employee successfully saved", JsonRequestBehavior.AllowGet)); } else { //prepare for insert data //check if nik exists bool is_nik_exist = false; string str_nik = Request.Form["employee_nik"]; ms_employee ms_emp = db.ms_employee.Where(c => c.employee_nik == str_nik).SingleOrDefault <ms_employee>(); is_nik_exist = (ms_emp != null); if (!is_nik_exist) { ms_emp = new ms_employee(); } ms_emp.employee_nik = Request.Form["employee_nik"]; ms_emp.employee_name = Request.Form["employee_name"]; ms_emp.employee_email = Request.Form["employee_email"]; ms_emp.ip_address = Request.Form["ip_address"]; ms_emp.fl_active = Request.Form["rec_isactive"].ToLower().Equals("yes"); if (!is_nik_exist) { ms_emp.created_by = UserProfile.UserId; ms_emp.created_date = DateTime.Now; } ms_emp.updated_by = UserProfile.UserId; ms_emp.updated_date = DateTime.Now; ms_emp.org_id = UserProfile.OrgId; ms_emp.deleted_by = null; ms_emp.deleted_date = null; //db.ms_employee.Add(ms_emp); if (!is_nik_exist) { db.Entry(ms_emp).State = EntityState.Added; } else { db.Entry(ms_emp).State = EntityState.Modified; } db.SaveChanges(); return(Json("Employee successfully saved", JsonRequestBehavior.AllowGet)); } } else { if (Request.Form["oper"] == "del") { //for delete process string ids = Request.Form["id"]; string[] values = ids.Split(','); for (int i = 0; i < values.Length; i++) { values[i] = values[i].Trim(); //prepare for soft delete data int id = Convert.ToInt32(values[i]); ms_employee emp = db.ms_employee.Find(id); emp.fl_active = false; emp.deleted_by = UserProfile.UserId; //userid emp.deleted_date = DateTime.Now; db.SaveChanges(); } } return(Json("Deleted Success!")); } }
public ActionResult Registration(AccountRegistrationViewModel registrationView) { bool statusRegistration = false; string messageRegistration = string.Empty; if (ModelState.IsValid) { // Email Verification string userName = Membership.GetUserNameByEmail(registrationView.employee_email); if (!string.IsNullOrEmpty(userName)) { ModelState.AddModelError("Warning Email", "Sorry: Email already Exists"); return(View(registrationView)); } //Save User Data using (ModelAsmRemote _db = new ModelAsmRemote()) { //var user = new User() //{ // Username = registrationView.Username, // FirstName = registrationView.FirstName, // LastName = registrationView.LastName, // Email = registrationView.Email, // Password = registrationView.Password, // ActivationCode = Guid.NewGuid(), //}; //dbContext.Users.Add(user); var emp = new ms_employee() { employee_email = registrationView.employee_email, employee_nik = registrationView.employee_nik, employee_name = registrationView.employee_name, fl_active = true, created_by = UserProfile.UserId, created_date = DateTime.Now, updated_by = UserProfile.UserId, updated_date = DateTime.Now, deleted_by = null, deleted_date = null, org_id = UserProfile.OrgId }; emp = _db.ms_employee.Add(emp); //int emp_id = emp.employee_id; var user = new ms_user() { user_name = registrationView.user_name, user_password = App_Helpers.CryptorHelper.Encrypt(registrationView.user_password, "MD5", true), employee_id = emp.employee_id, fl_active = true, created_by = UserProfile.UserId, created_date = DateTime.Now, updated_by = UserProfile.UserId, updated_date = DateTime.Now, deleted_by = null, deleted_date = null, org_id = UserProfile.OrgId }; _db.ms_user.Add(user); _db.SaveChanges(); } //Verification Email: //TIDAK usah aktifkan by email -> admin saja yanag mengaktifkan sendiri krna hrus pilih role, job title dan company //VerificationEmail(registrationView.Email, registrationView.ActivationCode.ToString()); messageRegistration = "Your account has been created successfully. ^_^"; statusRegistration = true; } else { messageRegistration = "Something Wrong!"; } ViewBag.Message = messageRegistration; ViewBag.Status = statusRegistration; return(View(registrationView)); }
public ActionResult SaveDataUserAccount([Bind(Include = "user_id,user_name,user_password,user_type_id,employee_id,fl_active")] user_accountViewModel user_acc) { if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { #region INSERT_DATA if (user_acc.FormMode == EnumFormModeKey.Form_New) { ms_employee emp = db.ms_employee.Find(user_acc.employee_id); if (emp == null) { throw new Exception("Employee not found. Please create Employee first " + user_acc.employee_id.ToString()); } else { user_acc.employee_nik = emp.employee_nik; user_acc.employee_name = emp.employee_name; user_acc.employee_email = emp.employee_email; emp.fl_active = true; emp.updated_by = UserProfile.UserId; emp.updated_date = DateTime.Now; emp.deleted_by = null; emp.deleted_date = null; db.Entry(emp).State = EntityState.Modified; ms_user ms_user = db.ms_user.Find(user_acc.user_id); if (ms_user == null) { ms_user = new ms_user() { user_name = user_acc.user_name, user_password = App_Helpers.CryptorHelper.Encrypt(user_acc.user_password, "MD5", true), user_type_id = user_acc.user_type_id, employee_id = emp.employee_id, fl_active = user_acc.fl_active, created_by = UserProfile.UserId, created_date = DateTime.Now, updated_by = UserProfile.UserId, updated_date = DateTime.Now, deleted_by = null, deleted_date = null }; db.ms_user.Add(ms_user); } else { ms_user.user_name = user_acc.user_name; ms_user.user_password = App_Helpers.CryptorHelper.Encrypt(user_acc.user_password, "MD5", true); ms_user.user_type_id = user_acc.user_type_id; ms_user.employee_id = user_acc.employee_id; ms_user.fl_active = user_acc.fl_active; ms_user.created_by = UserProfile.UserId; ms_user.created_date = DateTime.Now; ms_user.updated_by = UserProfile.UserId; ms_user.updated_date = DateTime.Now; ms_user.deleted_by = null; ms_user.deleted_date = null; db.Entry(ms_user).State = EntityState.Modified; } db.SaveChanges(); } ViewBag.ResultMessage = "Record inserted successfully."; } #endregion #region UPDATE_DATA else { ms_user ms_user = db.ms_user.Find(user_acc.user_id); ms_user.user_name = user_acc.user_name; if (!string.IsNullOrWhiteSpace(user_acc.user_password)) { ms_user.user_password = App_Helpers.CryptorHelper.Encrypt(user_acc.user_password, "MD5", true); } ms_user.user_type_id = user_acc.user_type_id; ms_user.fl_active = true; ms_user.updated_by = UserProfile.UserId; ms_user.updated_date = DateTime.Now; ms_user.deleted_by = null; ms_user.deleted_date = null; ms_employee emp = db.ms_employee.Find(user_acc.employee_id); if (emp != null) { ms_user.employee_id = emp.employee_id; emp.fl_active = true; emp.updated_by = UserProfile.UserId; emp.updated_date = DateTime.Now; emp.deleted_by = null; emp.deleted_date = null; db.Entry(emp).State = EntityState.Modified; } db.Entry(ms_user).State = EntityState.Modified; ViewBag.ResultMessage = "Record updated successfully."; } #endregion transaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { transaction.Rollback(); ViewBag.ResultMessage = string.Format("Error occured, records rolledback. {0}", ex.Message); } } } return(View(user_acc)); }