//Insert New member in test
public ActionResult InsertAthlete(MemberTestMapping mb_details)
{
var checkIfAlreadyAddedOrNot = (from mt in DB.MemberTestMapping
where mt.MemberId == mb_details.MemberId &&
mt.TestDetailsId == mb_details.TestDetailsId select mt).ToList();
TestDetails getTestDetails = (from td in DB.TestDetails
where td.TestDetailsId == mb_details.TestDetailsId
select td).SingleOrDefault();
int?noOfCount = getTestDetails.NoOfParticipants;
if (checkIfAlreadyAddedOrNot.Count > 0)
{
return(Json(new { msgdetail = "faill", resultCode = 2 }));
}
DB.MemberTestMapping.Add(mb_details);
int result = DB.SaveChanges();
if (result > 0)
{
noOfCount = noOfCount + 1;
}
getTestDetails.NoOfParticipants = noOfCount;
DB.SaveChanges();
return(Json(new { msgdetail = "success", resultCode = result }));
}
public ActionResult UpdateMember(MemberTestMapping mb_deatils)
{
MemberTestMapping member = (from p in DB.MemberTestMapping
where p.MemberTestId == mb_deatils.MemberTestId
select p).SingleOrDefault();
member.Distance = mb_deatils.Distance;
member.MemberId = mb_deatils.MemberId;
int res = DB.SaveChanges();
return(Json(new { msgdetail = "success", resultCode = res }));
}
//Delete member infrom db
public ActionResult DeleteMemberFromTest(int id)
{
MemberTestMapping result = DB.MemberTestMapping.FirstOrDefault(m => m.MemberTestId == id);
DB.MemberTestMapping.Remove(result);
int res = DB.SaveChanges();
TestDetails getTestDetails = (from td in DB.TestDetails
where td.TestDetailsId == result.TestDetailsId
select td).SingleOrDefault();
int?noOfCount = getTestDetails.NoOfParticipants;
if (res > 0)
{
noOfCount = noOfCount - 1;
}
getTestDetails.NoOfParticipants = noOfCount;
DB.SaveChanges();
return(Json(new { msgdetail = "success", resultCode = res }));
}
