public ActionResult Create(TrainingViewModel model)
{
if (model != null)
{
var fileName = Path.GetFileNameWithoutExtension(model.ImageFile.FileName);
var extension = Path.GetExtension(model.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
model.ProjectPhoto = "~/Areas/production/images/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Areas/production/images/"), fileName);
model.ImageFile.SaveAs(fileName);
TrainingDTO training = new TrainingDTO
{
Resource = model.Resource,
Course = model.Course,
Duration = model.Duration,
FinalEvaluation = model.FinalEvaluation,
ProjectPhoto = model.ProjectPhoto,
CityId = model.CityId,
KnowledgeId = model.KnowledgeId,
UserId = model.UserId
};
trainingService.Create(training);
ModelState.Clear();
return(RedirectToAction("Index"));
}
return(View(model));
}
public List <TD> getWeekday(int id, int[] days)
{
List <TD> tds = new List <TD>();
for (int i = 0; i < days.Length; i++)
{
TD td = new TD();
TrainingProgramTrainingDTO[] trainingDay = GetTrainingDay(id, days[i]);
List <Training> ts = new List <Training>();
for (int j = 0; j < trainingDay.Length; j++)
{
TrainingDTO training = GetTraining(trainingDay[j].training_TID);
Training t = new Training();
//td.time = trainingDay[j].timeOfDay.ToString();
t.durationMin = training.durationMin.ToString();
t.reps = training.numberOfReps.ToString();
t.sets = training.numberOfReps.ToString();
t.restBetween = training.restBetweenMin.ToString();
t.exercise = GetExercise(training.exercise_EID);
ts.Add(t);
}
td.training = ts;
tds.Add(td);
}
return(tds);
}
/// <summary>
/// Méthode permettant d'obtenir la formation
/// </summary>
/// <param name="idtraining"></param>
/// <returns></returns>
public Training GetTraining(int idtraining)
{
DALWSR_Result r3 = dal.GetTrainingByIdAsync(idtraining, CancellationToken.None);
TrainingDTO trainingDto = (TrainingDTO)r3.Data;
return(new Training(trainingDto));
}
public ActionResult Edit(TrainingViewModel model)
{
var fileName = Path.GetFileNameWithoutExtension(model.ImageFile.FileName);
var extension = Path.GetExtension(model.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
model.ProjectPhoto = "~/Areas/production/images/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Areas/production/images/"), fileName);
model.ImageFile.SaveAs(fileName);
TrainingDTO trainingDTO = new TrainingDTO
{
Id = model.Id,
Resource = model.Resource.Trim(),
Course = model.Course.Trim(),
Duration = model.Duration.Trim(),
FinalEvaluation = model.FinalEvaluation,
ProjectPhoto = model.ProjectPhoto.Trim(),
CityId = model.CityId,
KnowledgeId = model.KnowledgeId,
UserId = model.UserId
};
trainingService.Update(trainingDTO);
return(RedirectToAction("Index"));
}
public void SaveTraining(ref TrainingDTO training)
{
SqlCommand command = new SqlCommand();
SqlParameter paramNewTrainingId = new SqlParameter();
bool isNewRecord = false;
if (training.IdTraining.Equals(Common.DTOBase.Int_NullValue))
{
command = GetDbSprocCommand("INSERTTRAINING");
paramNewTrainingId = CreateOutputParameter("@NEWTRAININGID", SqlDbType.Int);
command.Parameters.Add(paramNewTrainingId);
isNewRecord = true;
}
else
{
command = GetDbSprocCommand("UPDATETRAINING");
command.Parameters.Add(CreateParameter("@ID", training.IdTraining));
}
command.Parameters.Add(CreateParameter("@NAME", training.NameTraining, 30));
// Exécute la commande.
command.Connection.Open();
int nb = command.ExecuteNonQuery();
command.Connection.Close();
if (nb == 1)
{
if (isNewRecord && nb == 1)
{
training.IdTraining = (int)paramNewTrainingId.Value;
}
}
}
public TrainingDTO GetById(int id)
{
TrainingDTO training;
string queryString =
"SELECT * from training" +
" WHERE @training_id = training.id";
using (SqlConnection connection = EstablishingConnection.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand(queryString, connection))
{
command.Parameters.AddWithValue("@training_id", id);
SqlDataReader reader = command.ExecuteReader();
training = new TrainingDTO();
while (reader.Read())
{
TrainingDTO trainingNew = new TrainingDTO
{
Id = (int)reader["id"],
ProgramId = (int)reader["program_id"],
TrainingTypeId = (int)reader["training_type_id"],
StartTime = Convert.ToDateTime(reader["start_time"]),
EndTime = Convert.ToDateTime(reader["end_time"]),
Description = (string)reader["description"],
};
training = trainingNew;
}
connection.Close();
}
return(training);
}
}
public TrainingDTO getById(int Id)
{
TrainingDTO training;
string query =
"SELECT * FROM training WHERE id=@id ";
using (SqlConnection connection = EstablishingConnection.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@id", Id);
SqlDataReader reader = command.ExecuteReader();
training = new TrainingDTO();
while (reader.Read())
{
TrainingDTO newTraining = new TrainingDTO()
{
Id = (int)reader["id"],
Description = (string)reader["description"],
StartTime = Convert.ToDateTime(reader["start_time"]),
EndTime = Convert.ToDateTime(reader["end_time"]),
ProgramId = (int)reader["program_id"],
TrainingTypeId = (int)reader["training_type_id"]
};
training = newTraining;
}
}
connection.Close();
}
return(training);
}
public List <TrainingDTO> GetUserTrainings(string userID)
{
List <TrainingDTO> trainings = new List <TrainingDTO>();
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("SELECT * FROM Trainings WHERE UserID = @UserID ORDER BY Date DESC", connection);
cmd.Parameters.AddWithValue("@UserID", userID);
connection.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Guid trainingID = Guid.Parse(reader["ID"].ToString());
DateTime date = (DateTime)reader["Date"];
TrainingTypeDTO trainingType = (TrainingTypeDTO)Enum.Parse(typeof(TrainingTypeDTO), reader["TrainingType"].ToString());
TrainingDTO training = new TrainingDTO(trainingID, Guid.Parse(userID), date, trainingType);
trainings.Add(training);
}
}
}
return(trainings);
}
public async Task <List <BillDTO> > GetUserBills(Guid UserId)
{
var bills = await ServiceRepository.GetUserBills(UserId);
var billDtos = new List <BillDTO>();
foreach (var bill in bills)
{
var trainingsInBills = await ServiceUnitOfWork.TrainingInBillRepository.GetTrainingsInBill(bill.Id);
var trainings = new List <TrainingDTO>();
foreach (var trainingInBill in trainingsInBills)
{
var training = await ServiceUnitOfWork.TrainingRepository.FirstOrDefaultAsync(trainingInBill.TrainingId);
var trainingDTO = new TrainingDTO()
{
TrainingDate = training.Start,
Description = training.Description
};
trainings.Add(trainingDTO);
}
var billDto = new BillDTO()
{
Total = bill.Total,
Deadline = bill.Deadline,
Trainings = trainings
};
billDtos.Add(billDto);
}
return(billDtos);
}
/// <summary>
/// Constructeur complet
/// </summary>
/// <param name="idtraining"></param>
/// <param name="nametraining"></param>
public Training(int idtraining, string nametraining)
{
IdTraining = idtraining;
NameTraining = nametraining;
DTO = new TrainingDTO();
DTO.IdTraining = idtraining;
DTO.NameTraining = nametraining;
}
public void UpdateTraining(TrainingDTO training)
{
Training updatedTraining = new Training {
Id = Convert.ToInt32(training.Id), SwimmerId = Convert.ToInt32(training.SwimmerId), SwimStyleId = Convert.ToInt32(training.SwimStyleId),
Distance = Convert.ToInt32(training.Distance), TrainingDate = Convert.ToDateTime(training.TrainingDate)
};
_trainingManager.Update(Convert.ToInt32(training.Id), updatedTraining);
}
private async Task ValidateAccessToTraining(int trainingId)
{
TrainingDTO training = await trainingService.GetTrainingAsync(trainingId);
if (training == null)
{
throw new BadRequestException("Invalid training id!");
}
await ValidateAccessToTeamAsync(training.TeamId);
}
public IActionResult Edit(TrainingDTO training)
{
try
{
service.UpdateTraining(training);
}
catch
{
return(Content("\tERROR!\n\n\n Entered data is invalid!"));
}
return(RedirectToAction("Index", "Training"));
}
public void AddTraining(TrainingDTO training)
{
Training newTraining = new Training
{
SwimmerId = Convert.ToInt32(training.SwimmerId),
SwimStyleId = Convert.ToInt32(training.SwimStyleId),
TrainingDate = Convert.ToDateTime(training.TrainingDate),
Distance = Convert.ToInt32(training.Distance)
};
_trainingManager.Add(newTraining);
}
public async Task <IActionResult> GetLastTrainingForTeamAsync(int id)
{
await ValidateAccessToTeamAsync(id);
TrainingDTO training = await trainingService.GetCurrentTrainingForTeamAsync(id);
return(new JsonResult(new
{
training.Id,
training.TeamId,
training.BeginTime,
}));
}
public async Task <IActionResult> GetTrainingInfoAsync(int id)
{
TrainingDTO training = await trainingService.GetTrainingAsync(id);
await ValidateAccessToTeamAsync(training.TeamId);
return(Ok(new
{
training.Id,
training.TeamId,
training.BeginTime
}));
}
