public int AddAthlete(int athleteTestId, int athleteId, decimal distance, int editMode, int mapId)
{
int result = 0;
int count = 0;
try
{
AthleteTestMapping athleteTest = new AthleteTestMapping();
User user = new User();
count = (editMode == 0)
? _dbContext.AthleteTestMapping.Where(a => a.AthleteId == athleteId && a.AthleteTestId == athleteTestId && a.IsDeleted == false).Count()
: _dbContext.AthleteTestMapping.Where(a => a.AthleteId == athleteId && a.AthleteTestId == athleteTestId && a.MapId != mapId.ToSafeInt() && a.IsDeleted == false).Count();
if (count == 0)
{
if (editMode == 0)
{
user = _dbContext.User.Where(u => u.UserId == athleteId).FirstOrDefault();
athleteTest.AthleteTestId = athleteTestId.ToSafeInt();
athleteTest.AthleteId = athleteId.ToSafeInt();
athleteTest.AthleteName = user.UserName.ToSafeString();
athleteTest.Distance = distance;
athleteTest.IsDeleted = false;
_dbContext.Add(athleteTest);
Test test = _dbContext.Test.Where(c => c.TestId == athleteTest.AthleteTestId).FirstOrDefault();
test.TotalParticipats = test.TotalParticipats.ToSafeInt() + 1;
_dbContext.Test.Update(test);
result = 1;
}
else
{
athleteTest = _dbContext.AthleteTestMapping.Find(mapId);
user = _dbContext.User.Where(u => u.UserId == athleteId).FirstOrDefault();
athleteTest.AthleteTestId = athleteTestId.ToSafeInt();
athleteTest.AthleteId = athleteId.ToSafeInt();
athleteTest.AthleteName = user.UserName.ToSafeString();
athleteTest.Distance = distance;
athleteTest.IsDeleted = false;
_dbContext.Update(athleteTest);
result = 2;
}
_dbContext.SaveChanges();
}
else
{
result = -1;
}
}
catch (Exception ex)
{
_logger.LogError(ex.Message.ToSafeString());
}
return(result);
}
public static int AddAthlete(AthleteTestMapping athleteTestMapping, string domainName, int editMode, int mapId)
{
int result = 0;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(domainName);
HttpResponseMessage response = client.PostAsync(client.BaseAddress + "/User/AddAthlete?athleteTestId=" + athleteTestMapping.AthleteTestId.ToSafeInt() + "&athleteId=" + athleteTestMapping.AthleteId.ToSafeInt() + "&distance=" + athleteTestMapping.Distance + "&editMode=" + editMode + "&MapId=" + mapId, null).Result;
result = response.Content.ReadAsStringAsync().Result.ToSafeInt();
}
return(result);
}
public AthleteTestMapping GetAthlete(int athleteId)
{
AthleteTestMapping record = null;
try
{
record = _dbContext.AthleteTestMapping.Where(x => x.AthleteId == athleteId && x.IsDeleted == false).FirstOrDefault();
}
catch (Exception ex)
{
_logger.LogError(ex.Message.ToSafeString());
}
return(record);
}
public static AthleteTestMapping GetAthlete(int athleteId, string domainName)
{
AthleteTestMapping record = null;
string strJson = string.Empty;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(domainName);
HttpResponseMessage response = client.GetAsync(client.BaseAddress + "/User/GetAthlete?athleteId=" + athleteId).Result;
strJson = response.Content.ReadAsStringAsync().Result.ToSafeString();
record = JsonConvert.DeserializeObject <AthleteTestMapping>(strJson);
}
return(record);
}
public IActionResult CreateNewAthlete(AthleteModel model)
{
int result = 0;
string domainName = _configuration["DomainName"].ToSafeString();
if (!string.IsNullOrEmpty(domainName))
{
AthleteTestMapping athleteTest = new AthleteTestMapping();
athleteTest.AthleteTestId = model.TestId.ToSafeInt();
athleteTest.AthleteId = model.AthleteId.ToSafeInt();
athleteTest.Distance = model.Distance;
if (model.IsEditMode)
{
result = BALUser.AddAthlete(athleteTest, domainName, 1, model.MapId.ToSafeInt());
}
else
{
result = BALUser.AddAthlete(athleteTest, domainName, 0, model.MapId.ToSafeInt());
}
switch (result)
{
case -1:
TempData["message"] = "Athlete already exists in this test.";
TempData["IsSuccess"] = 0;
break;
case 0:
TempData["message"] = "Something went wrong.";
TempData["IsSuccess"] = 0;
break;
case 1:
TempData["message"] = "Record successfully inserted.";
TempData["IsSuccess"] = 1;
break;
case 2:
TempData["message"] = "Record successfully updated.";
TempData["IsSuccess"] = 1;
break;
}
}
return(RedirectToAction("AthleteList", new { id = model.TestId }));
}
public IActionResult CreateAthlete(int?testId, int?athleteId)
{
AthleteModel model = new AthleteModel();
Test test = new Test();
AthleteTestMapping athleteTestMapping = new AthleteTestMapping();
string domainName = _configuration["DomainName"].ToSafeString();
if (!string.IsNullOrEmpty(domainName))
{
if (testId.HasValue && athleteId.ToSafeInt() == 0)
{
model.TestId = testId.ToSafeInt();
model.userList = BALUser.GetUserListByRoleId((int)Enums.UserRole.Athlete, domainName);
test = BALUser.GetTestTypeByTestId(testId.ToSafeInt(), domainName);
model.TestName = test.TestName.ToSafeString() + " " + test.TestDate.ToString("yyyy/MM/dd");
model.IsEditMode = false;
}
else
{
model.TestId = testId.ToSafeInt();
model.userList = BALUser.GetUserListByRoleId((int)Enums.UserRole.Athlete, domainName);
test = BALUser.GetTestTypeByTestId(testId.ToSafeInt(), domainName);
model.TestName = test.TestName.ToSafeString() + " " + test.TestDate.ToString("yyyy/MM/dd");
athleteTestMapping = BALUser.GetAthlete(athleteId.ToSafeInt(), domainName);
if (athleteTestMapping != null)
{
model.AthleteId = athleteTestMapping.AthleteId.ToSafeInt();
model.Distance = athleteTestMapping.Distance;
model.IsEditMode = true;
model.MapId = athleteTestMapping.MapId.ToSafeInt();
}
}
}
return(PartialView("~/Views/Home/AddAthlete.cshtml", model));
}
public int DeleteAthlete(int mapId)
{
int record = 0;
AthleteTestMapping athleteTest = new AthleteTestMapping();
try
{
athleteTest = _dbContext.AthleteTestMapping.Find(mapId);
athleteTest.IsDeleted = true;
_dbContext.Update(athleteTest);
Test test = _dbContext.Test.Where(c => c.TestId == athleteTest.AthleteTestId).FirstOrDefault();
test.TotalParticipats = test.TotalParticipats.ToSafeInt() - 1;
_dbContext.Test.Update(test);
_dbContext.SaveChanges();
record = 1;
}
catch (Exception ex)
{
_logger.LogError(ex.Message.ToSafeString());
}
return(record);
}
