public bool ValidateAll() { if (EAErr.IsVisible || PErr.IsVisible || MIErr.IsVisible || PPErr.IsVisible) { return(false); } else if (string.IsNullOrEmpty(EmailAddress.Text.ToString().Trim()) || string.IsNullOrEmpty(Password.Password.ToString().Trim()) || string.IsNullOrEmpty(MemberId.Text.ToString().Trim()) || string.IsNullOrEmpty(imgByteArrDB.ToString())) { return(false); } List <MemberDBContext> members = MemberDBContext.GetMembers(); bool isTrue = true; foreach (MemberDBContext member in members) { if (member.Id == int.Parse(MemberId.Text.ToString())) { isTrue = false; } } if (isTrue) { WindowError error = new WindowError(); error.SetContent("Member Id Doesn't Exist"); error.Show(); return(false); } return(true); }
private void UpdateButton_Click(object sender, RoutedEventArgs e) { if ((imageName != "" && ValidateAll()) || (imgByteArrDB != null && ValidateAll())) { foreach (UserDBContext user in users) { if (user.Email.Equals(EmailAddress.Text.ToString())) { MemberDBContext.IntitalizeDB(); List <MemberDBContext> members = MemberDBContext.GetMembers(); var member = members .SingleOrDefault(m => m.Id == int.Parse(MemberId.Text.ToString())); if (member == null) { WindowError error = new WindowError(); error.SetContent("Unknown Member Id"); error.Show(); return; } try { FileStream fs = new FileStream(imageName, FileMode.Open, FileAccess.Read); byte[] imgByteArr = new byte[fs.Length]; fs.Read(imgByteArr, 0, Convert.ToInt32(fs.Length)); fs.Close(); UserDBContext.IntitalizeDB(); UserDBContext.Update(EmailAddress.Text.ToString(), Password.Password.ToString(), UserRole.Text.ToString(), imgByteArr, int.Parse(MemberId.Text.ToString())); InitializeDataGrid(); ClearAll(); WindowSuccess success = new WindowSuccess(); success.SetContent("Account Updated Succefully"); success.Show(); } catch (Exception) { UserDBContext.IntitalizeDB(); UserDBContext.Update(EmailAddress.Text.ToString(), Password.Password.ToString(), UserRole.Text.ToString(), imgByteArrDB, int.Parse(MemberId.Text.ToString())); InitializeDataGrid(); ClearAll(); WindowSuccess success = new WindowSuccess(); success.SetContent("Account Updated Succefully"); success.Show(); } } } } else { WindowError error = new WindowError(); error.SetContent("Empty Filed Or Invalid Input"); error.Show(); } }
private void InitializeFacility() { RequestDBContext.IntitalizeDB(); List <RequestDBContext> requests = RequestDBContext.GetRequests(); foreach (RequestDBContext request in requests) { MemberDBContext.IntitalizeDB(); MemberDBContext member = MemberDBContext.GetMember(request.MemberId); string fullName = string.Format($"{member.FirstName} {member.MiddleName}"); FacilityPannel.Children.Add(new UserControlSingleFacility(fullName, request.PhoneNumber, request.Date, request.Subject, request.Body)); } }
/// <summary> /// 获得个人邮箱 /// </summary> /// <param name="memberPK"></param> /// <returns></returns> public async Task <string> GetPersonEmailAsync(Guid memberPK) { try { using (var memberdbContext = new MemberDBContext(_member_options)) { var dbMember = memberdbContext.Member; var memberEmail = (await dbMember.FirstOrDefaultAsync(x => x.MemberPK == memberPK))?.MemEmail; return(memberEmail); } } catch (Exception ex) { LogHelper.Error(this, ex); throw ex; } }
public IActionResult Index(Member model) { // string message = ""; // message = " surenname " + model.SureName.ToString() + " email " + model.Email.ToString(); // return Content(message); string email = ""; string surename = ""; if(model.Email == null && model.SureName == null) { return RedirectToAction("Index"); } MemberDBContext context = HttpContext.RequestServices.GetService(typeof(mvcMembers.Models.MemberDBContext)) as MemberDBContext; if(model.Email != null) { email = model.Email.ToString(); } if(model.SureName != null) { surename = model.SureName.ToString(); } return View(context.SearchMember(surename, email)); }
public IActionResult Create(Member model) { if (ModelState.IsValid) { if(model.FirstName == null) { SetFlash("Pls complete the inputs (*)"); return RedirectToAction("Create"); } if(model.SureName == null) { SetFlash("Pls complete the inputs (*)"); return RedirectToAction("Create"); } if(model.Email == null) { SetFlash("Pls complete the inputs (*)"); return RedirectToAction("Create"); } // message = "firstname " + model.FirstName.ToString() + " surenname " + model.SureName.ToString() + " email " + model.Email.ToString() + " created successfully"; MemberDBContext context = HttpContext.RequestServices.GetService(typeof(mvcMembers.Models.MemberDBContext)) as MemberDBContext; context.AddMember(model.FirstName.ToString(), model.SureName.ToString(), model.Email.ToString()); } return RedirectToAction("Index"); }
public IActionResult Index() { MemberDBContext context = HttpContext.RequestServices.GetService(typeof(mvcMembers.Models.MemberDBContext)) as MemberDBContext; // string abc = "abc"; return View(context.GetAllMember()); }
public UserController(MemberDBContext memberDBContext) { _memberDBContext = memberDBContext; //自定义的继承自DbContext类的memberDBContext }