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
}
