public AddAgreementCommandValidator(MembersContext dbContext)
{
RuleFor(x => x.Agreement.MembershipId)
.NotEmpty()
.GreaterThan(0);
RuleFor(x => x.Agreement.MembershipId)
.Must(id => dbContext.Memberships.Any(m => m.MembershipId == id))
.WithMessage(x => $"Membership [MembershipId: {x.Agreement.MembershipId}] not found.");
RuleFor(x => x.Agreement.MemberId)
.NotEmpty()
.GreaterThan(0);
RuleFor(x => x.Agreement.MemberId)
.Must(id => dbContext.Members.Any(m => m.MemberId == id))
.WithMessage(x => $"Member [MemberId: {x.Agreement.MemberId}] not found.");
RuleFor(x => x.Agreement.StartingDate)
.NotEmpty();
RuleFor(x => x.Agreement.StartingDate)
.Must(startingDate => startingDate >= DateTime.Now.Date)
.WithMessage($"Select a date later than {DateTime.Now.Date}");
;
}
public AddMemberCommandValidator(MembersContext dbContext)
{
RuleFor(x => x.Member.Name)
.NotEmpty();
RuleFor(x => x.Member.SurName)
.NotEmpty();
RuleFor(x => x.Member.Email)
.NotEmpty()
.EmailAddress();
RuleFor(x => x.Member.Email)
.Must(email => !dbContext.Members.Any(m => m.Email == email))
.WithMessage(x => $"Email [email: {x.Member.Email}] already in use");
RuleFor(x => x.Member.PhoneNumber)
.Matches(
"^\\d{9}$");
RuleFor(x => x.Member.Pesel)
.NotEmpty()
.Matches("^\\d{11}$");
RuleFor(x => x.Member.Pesel)
.Must(pesel => !dbContext.Members.Any(m => m.Pesel == pesel))
.WithMessage(x => $"Pesel [pesel: {x.Member.Pesel}] already in use");
}
public IActionResult Post(string id, string pin, int?value)
{
if (pin == null || value == null)
{
return(new BadRequestObjectResult(new { Function = "POST", Id = id, Pin = pin, Value = value }));
}
using (MembersContext db = GetContext()) {
Member m = db.Members.Find(id);
if (m == null)
{
return(new NotFoundObjectResult("ID not recognised"));
}
else
{
if (m.PinCode == pin)
{
if (m.Balance + value < 0)
{
return(new StatusCodeResult(412));
}
else
{
m.Balance += (int)value;
db.SaveChanges();
return(Ok(new { balance = m.Balance }));
}
}
else
{
return(new UnauthorizedResult());
}
}
}
}
public IEnumerable <TeamMember> ViewAllMembers()
{
using (var db = new MembersContext())
{
return(db.TeamNames.ToList());
}
}
public IActionResult Put(string id, string name, string email, string mobile, string pin)
{
if (name == null || email == null || mobile == null || pin == null)
{
return(new BadRequestObjectResult(new { Function = "PUT", Id = id, Name = name, Email = email, Mobile = mobile, Pin = pin }));
}
using (MembersContext db = GetContext())
{
Member m = db.Members.Find(id);
if (m == null)
{
db.Members.Add(new Member()
{
Id = id,
Name = name,
EmailAddress = email,
MobilePhoneNumber = mobile,
PinCode = pin,
Balance = 0
});
db.SaveChanges();
return(new StatusCodeResult(201));
}
else
{
return(new StatusCodeResult(409));
}
}
}
public TeamMember[] GetTeamMember(int getMemberId)
{
using (var db = new MembersContext())
{
var teamMember = db.TeamNames
.Where(m => m.Id == getMemberId).ToArray();
return(teamMember);
}
}
public TeamMember[] GetByName(string getMemberName)
{
using (var db = new MembersContext())
{
var teamMembers = db.TeamNames
.Where(m => m.Name.Contains(getMemberName)).ToArray();
return(teamMembers);
}
}
public DeleteMemberCommandValidator(MembersContext dbContext)
{
RuleFor(x => x.MemberId)
.GreaterThan(0);
RuleFor(x => x.MemberId)
.Must(id => dbContext.Members.Any(m => m.MemberId == id))
.WithMessage(x => $"Member [MemberId: {x.MemberId}] not found.");
}
public void DeleteMember(int deleteMemberId)
{
using (var db = new MembersContext())
{
var selectedMember = db.TeamNames
.Where(m => m.Id == deleteMemberId).Single();
db.TeamNames.Remove(selectedMember);
db.SaveChanges();
}
}
public void PartialUpdateMember(int id, JsonPatchDocument <TeamMember> patch)
{
using (var db = new MembersContext())
{
var selectedMember = db.TeamNames
.Where(m => m.Id == id).Single();
patch.ApplyTo(selectedMember);
db.SaveChanges();
}
}
public void DeleteMembersBulk(int [] deleteBulkMemberIds)
{
using (var db = new MembersContext())
{
var selectedBulkMembers = db.TeamNames
.Where(m => deleteBulkMemberIds.Contains(m.Id)).ToList();
db.TeamNames.RemoveRange(selectedBulkMembers);
db.SaveChanges();
}
}
public void AmendMember(int amendMemberID, string nameUpdate)
{
using (var db = new MembersContext())
{
var selectedMember = db.TeamNames
.Where(m => m.Id == amendMemberID).Single();
db.TeamNames.Update(selectedMember);
db.SaveChanges();
}
}
public async Task <TeamMember> CreateMember(TeamMember nameRequest)
{
using (var db = new MembersContext())
{
var newTeamMember = new TeamMember {
Name = nameRequest.Name
};
db.TeamNames.Add(newTeamMember);
await db.SaveChangesAsync();
//correct number returned here for ID
return(newTeamMember);
}
}
private MembersContext GetContext()
{
MembersContext mc = new MembersContext(options);
if (mc.Members.Find("ABC123") == null)
{
mc.Members.Add(new Member()
{
Id = "ABC123",
Name = "John Smith",
EmailAddress = "*****@*****.**",
MobilePhoneNumber = "01234567890",
PinCode = "0000",
Balance = 100
});
mc.SaveChanges();
}
return(mc);
}
public MemberValidator(MembersContext dbContext, Tuple <Member, Member> memberBeforeAndAfterChange)
{
Member memberBeforeChange, memberAfterChange;
(memberBeforeChange, memberAfterChange) = memberBeforeAndAfterChange;
RuleFor(x => x.Name)
.NotEmpty();
RuleFor(x => x.SurName)
.NotEmpty();
RuleFor(x => x.Email)
.EmailAddress();
if (memberBeforeChange.Email != memberAfterChange.Email)
{
RuleFor(x => x.Email)
.Must(email => !dbContext.Members.Any(m => m.Email == email))
.WithMessage(x => $"Email [email: {x.Email}] already in use");
}
RuleFor(x => x.PhoneNumber)
.Matches(
"^\\d{9}$");
RuleFor(x => x.Pesel)
.NotEmpty()
.Matches("^\\d{11}$");
if (memberBeforeChange.Pesel != memberAfterChange.Pesel)
{
RuleFor(x => x.Pesel)
.Must(pesel => !dbContext.Members.Any(m => m.Pesel == pesel))
.WithMessage(x => $"Pesel [pesel: {x.Pesel}] already in use");
}
}
public AddMemberHandler(MembersContext dbContext, IAddMemberSender addMemberSender)
{
_dbContext = dbContext;
_addMemberSender = addMemberSender;
}
public DeleteMemberHandler(MembersContext dbContext, IDeleteMemberSender deleteMemberSender)
{
_dbContext = dbContext;
_deleteMemberSender = deleteMemberSender;
}
public EditMemberHandler(MembersContext dbContext, IEditMemberSender editMemberSender)
{
_dbContext = dbContext;
_editMemberSender = editMemberSender;
}
public ChildrenController(MembersContext context)
{
_context = context;
}
public MembersController(MembersContext context)
{
_context = context;
}
public AddAgreementHandler(MembersContext dbContext, IAddAgreementSender addAgreementSender)
{
_dbContext = dbContext;
_addAgreementSender = addAgreementSender;
}
public GetMemberByIdHandler(MembersContext dbContext)
{
_dbContext = dbContext;
}
public GetAllAgreementsByMemberIdHandler(MembersContext dbContext)
{
_dbContext = dbContext;
}
public ParentChildController(MembersContext context)
{
_context = context;
}
public MembersController(MembersContext membersContext)
{
_membersContext = membersContext;
}
public GetAllMembershipsHandler(MembersContext dbContext)
{
_dbContext = dbContext;
}
