public IHttpActionResult PutMember(int id, Member member)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != member.Id)
{
return(BadRequest());
}
db.Entry(member).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!MemberExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,Age,Status,Email,PhoneNumber,DOB,Address,Image")] Member member)
{
if (ModelState.IsValid)
{
db.Members.Add(member);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(member));
}
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 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 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 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 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 DeleteMember(int deleteMemberId)
{
using (var db = new MembersContext())
{
var selectedMember = db.TeamNames
.Where(m => m.Id == deleteMemberId).Single();
db.TeamNames.Remove(selectedMember);
db.SaveChanges();
}
}
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 IActionResult Post(Member data)
{
_context.Members.Add(data);
_context.SaveChanges();
return(Ok());
}
