public IActionResult OnGet(int?id) { Console.WriteLine("Delete page : " + id); string DbConnection = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Staffs;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = "SELECT * FROM Staffs WHERE StaffID = @SID"; command.Parameters.AddWithValue("@SID", id); SqlDataReader reader = command.ExecuteReader(); Models.Staff rec = new Models.Staff(); //a local var to hold a record temporarily while (reader.Read()) { rec.Id = reader.GetInt32(0); rec.StaffID = reader.GetString(1); rec.StaffFname = reader.GetString(2); rec.StaffLname = reader.GetString(3); rec.StaffSex = reader.GetString(4); rec.StaffEmail = reader.GetString(5); rec.Stafftype = reader.GetString(6); rec.Staffnationality = reader.GetString(7); rec.Staffpassword = reader.GetString(8); } } conn.Close(); return(Page()); }
public void LoadInformation() { staff = App.StaffDatabase.GetStaffById(Convert.ToInt32(App.SettingsDatabase.GetSetting("AssignedStaffId").Value)); AnnualLeaveBalance.Text = staff.AnnualLeaveBalance.ToString(); AnnualLeaveEntitlement.Text = "Your annual leave entitlement is " + staff.AnnualLeaveAllowance.ToString() + " days, excluding English bank holidays, from Janurary 1st to December 31st."; }
/// <summary> /// 加载父级菜单 /// </summary> public void ParentMenu() { Models.Staff staffinfo = (Models.Staff)Session["loginuser"]; List <Models.v_staffmune> menu = DB.v_staffmune.Where(o => o.staffid.Equals(staffinfo.Id) && o.Type == 0 && o.ParentId == null).ToList(); ViewData.Model = menu; }
public IActionResult OnPost() { if (!ModelState.IsValid) { return(Page()); } else { staff = StudentDatabase.Login(LoginStaff.Username, LoginStaff.Password); if (staff.staffId != 0) { if (staff.Administration == true) // hvis brugeren hentet fra SQL er i administration, så sættes det til True i session. { HttpContext.Session.SetString("Administration", "TRUE"); } if (staff.Teacher == true) // hvis brugeren hentet fra SQL er underviser, så sættes det til True i session. { HttpContext.Session.SetString("Teacher", "TRUE"); } HttpContext.Session.SetString("LoggedIn", "TRUE"); return(RedirectToPage("/Students/StudentList")); // Efter login foretages redirect til studentlist. } else { TempData["LoginMessage"] = "Invalid login"; // Hvis login fejler, sættes en midlertidig besked som vises på login siden bagefter. return(Page()); } } }
public ActionResult Create(FormCollection collection) { if (SUserRole() != "Customer" && SUserRole() != null) { ViewBag.displayMenu = "Yes"; } try { // TODO: Add insert logic here Staff newStaff = new Models.Staff(); newStaff.Address = Request.Form["Address"]; newStaff.AspId = Request.Form["AspId"]; newStaff.Contact = Request.Form["Contact"]; newStaff.Email = Request.Form["Email"]; newStaff.Position = Request.Form["ddlPosition"]; newStaff.StaffName = Request.Form["StaffName"]; newStaff.UserName = Request.Form["UserName"]; db.Staffs.Add(newStaff); db.SaveChanges(); return(RedirectToAction("Index", "Home")); } catch (Exception e) { string error = e.InnerException.Message; string error2 = e.InnerException.InnerException.Message; return(View()); } }
/// <summary> /// 加载子级菜单 /// </summary> /// <param name="parentmeunid">与parentid对应的父子级关系id</param> /// <returns></returns> public ActionResult ChildMenu(string parentmeunid) { Models.Staff staffinfo = (Models.Staff)Session["loginuser"]; List <Models.v_staffmune> menu = DB.v_staffmune.Where(o => o.staffid.Equals(staffinfo.Id) && o.ParentId.ToString().Equals(parentmeunid)).ToList(); return(Json(menu)); }
public ActionResult StaffEditSaveChanges(Models.Staff editedStaffDetails) { // Fetch the old data of staff from database var oldData = _context.Staffs.FirstOrDefault(u => u.Id == editedStaffDetails.Id); // Setting up new data if (oldData != null) { oldData.Address = editedStaffDetails.Address; oldData.Email = editedStaffDetails.Email; oldData.Name = editedStaffDetails.Name; oldData.Phone = editedStaffDetails.Phone; oldData.Surname = editedStaffDetails.Surname; // Commit new changes to database _context.SaveChanges(); // Set the success message TempData["StaffDetailsEditedSuccessfully"] = "Staff details edited successfully"; return(RedirectToAction("Index", "Staff")); } TempData["StaffDetailsEditFailed"] = "Cannot edit staff details."; return(RedirectToAction("Index", "Staff")); }
public ActionResult submitedStaff(Models.Staff formData) { var model = My_Locker_V2.Classes.MyCommonUtilities.GetIgrejas(); if (formData.Email.Contains("@")) { var ID = context.Database.SqlQuery <Staff>("SELECT ID FROM Staff WHERE Email = '" + formData.Email.ToLower() + "'").ToList(); if (ID.Count() == 0) { try { context.Database.ExecuteSqlCommand("INSERT INTO dbo.Staff(Email,_Password,igrejaId) VALUES ('" + formData.Email.ToLower() + "','" + My_Locker_V2.Classes.MyCommonUtilities.Encrypt(formData.C_Password) + "','" + formData.igrejaId + "')"); } catch (Exception er) { } } else { ModelState.AddModelError("Email", "Email Introduzido Já Em Uso"); return(PartialView("_addStaff", model)); } } else { ModelState.AddModelError("Email", "Email Introduzido Incorreto"); return(PartialView("_addStaff", model)); } return(View()); }
public ActionResult Index() { Models.Staff staffinfo = (Models.Staff)Session["loginuser"]; ViewBag.Name = staffinfo.Name; ParentMenu(); return(View()); }
public async Task <Models.Staff> CreateStaffMember(Models.Staff member) { await _unitOfWork.StaffMembers.AddAsync(member); await _unitOfWork.CommitAsync(); return(member); }
/// <summary> /// Default constructor for client, so no null values are returned on initial views. /// </summary> public Client() { raceID = 1; ethnicityID = 1; clientStatusID = 1; primaryLanguageID = 1; schoolInfoID = 1; communicationPreferencesID = 1; sexID = 1; officeID = 1; memberTypeID = 1; altID = ""; accountingSystemID = ""; TKIDcaseNumber = 0; // Referral referralSource = ""; agencyFrom = ""; // Demographics firstName = ""; middleInitial = ""; lastName = ""; fullName = ""; ageInMonths = 0; ssn = 0; // Address clientAddress = new Address(); // Contact phone = new AdditionalContactInfoModel(); clientDiagnosis = new List <Diagnosis>(); clientFamily = new List <Family>(); guardian = new Family(); clientPhysicians = new List <Physician>(); clientStaff = new List <Staff>(); intakeCoordinator = new Models.Staff(); serviceCoordinator = new Staff(); caseManager = new Staff(); clientInsurance = new List <ClientInsurance>(); clientComments = new List <Comments>(); clientReferrals = new List <Referral>(); caseManager = new Staff(); insertClientComplete = false; insertClientDetailsComplete = false; insertFamilyComplete = false; insertReferralComplete = false; }
/// <summary> /// 用来获取用户登录信息 /// </summary> /// <param name="loginOk">是否成功登录</param> /// <param name="message">提示信息</param> /// <param name="staffInfo">用户信息</param> /// <returns></returns> public ActionResult ReturnJosn(bool loginOk, string message, Models.Staff staffInfo) { var result = new { LoginOk = loginOk, Message = message, StaffInfo = staffInfo }; return(Json(result)); }
public ActionResult AddStaffInfo(Models.Staff staffinfo) { staffinfo.Id = Guid.NewGuid(); staffinfo.CreateTime = DateTime.Now; staffinfo.UpdateTime = DateTime.Now; staffinfo.IsHSEGroup = false; staffinfo.Sex = Request.Form[3] == (0).ToString() ? false : true; staffinfo.Password = HelperTools.EncryptHelper.Encode("svse");//默认密码(svse) DB.Staff.Add(staffinfo); return(Content(DB.SaveChanges() > 0 ? "T" : "F")); }
internal static Models.Staff mapStaff(Data.Staff ent, Models.Staff mdl = null) { if (ent == null) return mdl; if (mdl == null) mdl = new Models.Staff(); mdl.ID = new Models.StaffID(ent.StaffID); mdl.FirstName = ent.FirstName; mdl.LastName = ent.LastName; return mdl; }
//------------------------------------------------------TRAINING VIDEO----------------------------------------------------------// public ActionResult TrainingVideoDetail() { Staff s = new Models.Staff(); ViewBag.dts = s.selectall(); VideoCategory vc = new Models.VideoCategory(); ViewBag.dtvc = vc.selectall(); return(View()); }
/// <summary> /// 查看已删除的员工档案 /// </summary> /// <returns>返回列表视图</returns> public ActionResult StaffViewDeleted() { IStaffBLL bLL = new StaffBLL(); IOrgBLL orgBLL = new OrgBLL(); IOccupationBLL occupationBLL = new OccupationBLL(); List <Staff> staffList = bLL.GetAllStaffDeleted(); List <Models.Staff> staffListView = new List <Models.Staff>(); if (staffList != null) { foreach (var staff in staffList) { Models.Staff tempStaff = new Models.Staff { Id = staff.Id, StaffFileNumber = staff.StaffFileNumber, StaffName = staff.StaffName, FileState = staff.FileState, IsDel = staff.IsDel }; ThirdOrg thirdOrg = orgBLL.GetThirdOrgById(staff.ThirdOrgId); SecondOrg secondOrg = orgBLL.GetSecondOrgById(thirdOrg.ParentOrgId); FirstOrg firstOrg = orgBLL.GetFirstOrgById(secondOrg.ParentOrgId); tempStaff.FirstOrg = new Models.FirstOrg { Id = firstOrg.Id, OrgLevel = firstOrg.OrgLevel, OrgName = firstOrg.OrgName }; tempStaff.SecondeOrg = new Models.SecondeOrg { Id = secondOrg.Id, OrgName = secondOrg.OrgName, OrgLevel = secondOrg.OrgLevel, ParentOrg = tempStaff.FirstOrg }; tempStaff.ThirdOrg = new Models.ThirdOrg { Id = thirdOrg.Id, ParentOrg = tempStaff.SecondeOrg, OrgLevel = thirdOrg.OrgLevel, OrgName = thirdOrg.OrgName }; OccupationName occupationName = occupationBLL.GetOccupationNameById(staff.OccId); tempStaff.OccupationName = new Models.OccupationName { Id = occupationName.Id, Name = occupationName.Name }; staffListView.Add(tempStaff); } } ViewData["staffListView"] = staffListView; return(View()); }
public ActionResult Amend(Models.Staff smodel) { if (ModelState.IsValid) { StaffDAL.UpdateEmployeeDetails(smodel); return(Redirect("Home")); } else { return(Redirect("Home")); } }
public ActionResult TeacherAdd(Models.Staff data) { // Add it to context and commit it to DB data.Password = "******"; _context.Staffs.Add(data); _context.SaveChanges(); // Set the success message TempData["StaffAddedMessage"] = "Staff added successfully"; return(RedirectToAction("Index", "Staff")); }
public StaffEdit(DialogMode mode, int?staffID, IDialogService dialogService, IMessageBoxService messageService) : base(mode, dialogService, messageService) { SubTitle = "Сотрудника"; if (staffID.HasValue) { _data = _dc.Staffs.SingleOrDefault(x => x.ID == staffID); } else { _data = new Models.Staff(); _dc.Staffs.Add(_data); }; _staffServices = new List <object>(_data.Services.Cast <object>().ToList()); }
// GET: Users public ActionResult Index() { Staff s = Session["user"] as Staff; var baseCtrler = DependencyResolver.Current.GetService <BaseController>(); Models.Staff user = Session["user"] as Models.Staff; //Session["Job"] = db.Job.Where(r => r.Id == user.JobId); ViewBag.username = user.Name; List <Models.SystemResourceModule> Sredata = baseCtrler.GetSystemResources(user.Id); ViewBag.Parent = Sredata.Where(r => r.ParentId == null); ViewBag.Chiren = Sredata.Where(r => r.ParentId != null); return(View()); }
public ActionResult TrainingVideoEdit(int id) { TrainingVideo c = new TrainingVideo(); c.TrainingVideoID = id; c.SelectByID(); Staff s = new Models.Staff(); ViewBag.dts = s.selectall(); VideoCategory vc = new Models.VideoCategory(); ViewBag.dtvc = vc.selectall(); return(View(c)); }
public ActionResult UpdateStaffInfo(Models.Staff staffinfo) { Models.Staff obj = DB.Staff.FirstOrDefault(o => o.Id.Equals(staffinfo.Id)); obj.No = staffinfo.No; obj.Name = staffinfo.Name; obj.BirthDay = staffinfo.BirthDay; obj.Sex = Request.Form[4] == (0).ToString() ? false : true; obj.NativePlace = staffinfo.NativePlace; obj.Address = staffinfo.Address; obj.Tel = staffinfo.Tel; obj.Email = staffinfo.Email; obj.OrgID = staffinfo.OrgID; obj.JobId = staffinfo.JobId; obj.Status = staffinfo.Status; obj.UpdateTime = DateTime.Now; DB.Staff.Attach(obj); DB.Entry(obj).State = System.Data.Entity.EntityState.Modified; return(Content(DB.SaveChanges() > 0 ? "T" : "F")); }
} // Er nødt til at kolde Models.Staff da jeg har været så klog at kalde mappen i pages staff også. public IActionResult OnGet(int staffId) { if (HttpContext.Session.GetString("Administration") == "TRUE") // Der foretages login tjek { Staff = StudentDatabase.GetStaffById(staffId); // Staff hentes fra databasen if (Staff == null) // Hvis der ikke kunne findes en ansat redirectes man tilbage til stafflist. { return(RedirectToPage("./StaffList")); } else // Hvis der blev fundet en ansat vises detail siden. { return(Page()); } } else { return(RedirectToPage("./StaffLogin")); } }
public ActionResult GetData() { string name = Request["name"].ToString(); string password = Request["pwd"].ToString(); string flag = ""; var list = db.Staff.Where(u => u.Name == name && u.Password == password).ToList(); Models.Staff s = list.FirstOrDefault(); //将泛型集合转成实体对象 if (list.Count > 0) //当集合的成员大于0时候,说明登录成功 { Session["user"] = s; //return RedirectToAction("Index", "Users");//跳转到主页面 return(Json(s.Name, JsonRequestBehavior.AllowGet)); } else { return(Json(flag, JsonRequestBehavior.AllowGet)); } }
public ActionResult Login(string no, string pwd) { //pwd = HelperTools.EncryptHelper.Encode(pwd); Models.Staff staffInfo = DB.Staff.FirstOrDefault(o => o.No.Equals(no) && o.Password.Equals(pwd)); if (string.IsNullOrEmpty(no) || string.IsNullOrEmpty(pwd)) { return(ReturnJosn(false, "账号密码不能为空!", staffInfo)); } else if (staffInfo == null) { return(ReturnJosn(false, "密码错误!", staffInfo)); } else { Session["loginuser"] = staffInfo; return(ReturnJosn(false, "登录成功!", staffInfo)); } }
public ActionResult UpdatePwd(string OldPassword, string NewPassword) { Models.Staff staffinfo = (Models.Staff)Session["loginuser"]; OldPassword = HelperTools.EncryptHelper.Encode(OldPassword); Models.Staff info = DB.Staff.FirstOrDefault(o => o.Password == OldPassword); if (info == null) { var json = new { Error = false, Message = "原密码错误!", }; return(Json(json)); } else { Models.Staff staff = DB.Staff.FirstOrDefault(o => o.No == staffinfo.No); staff.Password = HelperTools.EncryptHelper.Encode(NewPassword); UpdateModel(staff); int rs = DB.SaveChanges(); if (rs > 0) { var json = new { Error = true, Message = "修改成功! 登录信息已经过期!", }; return(Json(json)); } else { var json = new { Error = false, Message = "修改失败!", }; return(Json(json)); } } }
public static OfficeStaff OfficeStaff(Models.Staff entity) { if (entity == null) { return(null); } var s = new OfficeStaff(); s.Active = entity.StaffActive; s.DateCreated = entity.DateCreated; s.DateCreated = entity.DateCreated; s.Email = entity.StaffPrimaryEmail; s.FirstName = entity.StaffFirstName; s.HireDate = entity.StaffHireDate; s.ID = entity.ID; s.LastName = entity.StaffLastName; s.Phone = entity.StaffPrimaryPhone; s.TerminationDate = entity.StaffTerminatedDate; return(s); }
public IActionResult OnGet(int?staffId) { if (HttpContext.Session.GetString("Administration") == "TRUE") // Der foretages login tjek { if (staffId.HasValue) // Hvis der koms staffId med hentes staff fra StudentDB { staff = StudentDatabase.GetStaffById(staffId.Value); } else // Hvis ikke oprettes et nyt staff objekt { staff = new Models.Staff(); } if (staff == null) // Hvis staff er null på dette tidspunkt sendes man til notfound siden. { return(RedirectToPage("/NotFound")); } return(Page()); } else { return(RedirectToPage("./StaffLogin")); } }
public IActionResult OnGet() { string DbConnection = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Staffs;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"SELECT * FROM Staffs ORDER BY StaffFname"; // try order by Name SqlDataReader reader = command.ExecuteReader(); RestaurantProject = new List <Models.Staff>(); // Call Read before accessing data. while (reader.Read()) //keep reading while there is a record { Models.Staff rec = new Models.Staff(); //a local var to hold a record temporarily rec.Id = reader.GetInt32(0); rec.StaffID = reader.GetString(1); //make sure the data type is matched rec.StaffFname = reader.GetString(2); rec.StaffLname = reader.GetString(3); rec.StaffSex = reader.GetString(4); rec.StaffEmail = reader.GetString(5); rec.Stafftype = reader.GetString(6); rec.Staffnationality = reader.GetString(7); RestaurantProject.Add(rec); //the temporary var of rec which consists of a record is added to the the list } // Call Close when done reading. reader.Close(); } return(Page());//return to the page after the result is obtained }
private void btnCreateUser_Click(object sender, EventArgs e) { string names, phone, email, address, natid, np, cp; int level; names = txtNames.Text; phone = txtPhone.Text; email = txtEmail.Text; natid = txtNationalId.Text; np = txtNP.Text; cp = txtCP.Text; level = comboBox1.SelectedIndex + 1; address = txtAddress.Text; string error = ""; if (names.Trim().Equals("")) { error += "\n.Names"; } if (phone.Trim().Equals("")) { error += "\n.Phone"; } if (email.Trim().Equals("")) { error += "\n.Email"; } if (address.Trim().Equals("")) { error += "\n.Address"; } if (natid.Trim().Equals("")) { error += "\n.NationalId"; } else { try { Convert.ToInt32(natid); } catch { error += "\n.Invalid NationalId"; } } if (np.Trim().Equals("")) { error += "\n.New Password"; } if (cp.Trim().Equals("")) { error += "\n.Confirm Password"; } else if (!cp.Equals(np)) { error += "\n.Password Do Not Match"; } if (comboBox1.Text.Trim().Equals("")) { error += "\n.Select A Level"; } if (picUserPhoto.Image == null) { error += "\n.User Photo"; } if (error.Trim().Equals("")) { Models.Staff user = new Models.Staff(); user.Names = names; user.Phone = phone; user.Email = email; user.Address = address; user.NationalId = natid; user.Password = cp; user.UserPhoto = API.ImageToByte(picUserPhoto.Image); try { API.Controllers.Staffs.Create(user); API.Message("User Created Successfully !", MessageBoxIcon.Information); API.ClearFields(this.Controls); } catch (Exception ex) { API.Message(ex.Message, MessageBoxIcon.Error); return; } } else { // API.Message(error, MessageBoxIcon.Warning); } }
private void CreateAccount(object sender, RoutedEventArgs e) { Models.FCS_DBModel db = new Models.FCS_DBModel(); string Role = UserRole.SelectedValue.ToString(); string password = Password.Password.ToString(); string verifiedPW = VerifyPassword.Password.ToString(); string hashedPassword = PasswordHashing.GetHashString(password); int usernameVerify = (from uv in db.Staff where uv.StaffUserName == UserName select uv).Count(); if (Role == "No Access") { if (FirstName == null || FirstName == "" || LastName == null || LastName == "" || StaffTitle == null || StaffTitle == "") { MessageBox.Show("Please check the data entered."); } else { Models.Staff account = new Models.Staff(); account.StaffFirstName = FirstName; account.StaffLastName = LastName; account.StaffTitle = StaffTitle; account.StaffUserName = UserName; account.StaffPassword = hashedPassword; account.StaffDBRole = Role; db.Staff.Add(account); db.SaveChanges(); this.Close(); } } else { if (password.Length < 5) { MessageBox.Show("Please pick a longer password (Minimum length of 5)"); } else if (password != verifiedPW) { MessageBox.Show("Passwords do not match!"); } else if (UserName == null || UserName == "" || FirstName == null || FirstName == "" || LastName == null || LastName == "" || StaffTitle == null || StaffTitle == "") { MessageBox.Show("Please check the data entered. A required field is missing."); } else if (UserName.Contains(" ")) { MessageBox.Show("User name cannot contain spaces"); } else if(usernameVerify != 0) { MessageBox.Show("That username selected is already taken"); } else { Models.Staff account = new Models.Staff(); account.StaffFirstName = FirstName; account.StaffLastName = LastName; account.StaffTitle = StaffTitle; account.StaffUserName = UserName; account.StaffPassword = hashedPassword; account.StaffDBRole = Role; db.Staff.Add(account); db.SaveChanges(); this.Close(); } } }
public void Signin(Models.Staff staff, bool isPersistent) { FormsAuthentication.SetAuthCookie(staff.Id.ToString(), isPersistent); }