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); }