/// <summary>
/// Calculate the image for the Level.
/// </summary>
/// <param name="level">Level for which the image must be returned.</param>
/// <param name="size">Size of the image.</param>
/// <returns>Bitmap with the image corresponding to the training level.</returns>
public static Bitmap GetLevelImage(this TrainingLevel level, ImageSize size)
{
Bitmap result = null;
switch (level)
{
case TrainingLevel.Introductive:
switch (size)
{
case ImageSize.Small:
result = Resources.teacher_small;
break;
case ImageSize.Medium:
result = Resources.teacher;
break;
case ImageSize.Big:
result = Resources.teacher_big;
break;
}
break;
case TrainingLevel.Advanced:
switch (size)
{
case ImageSize.Small:
result = Resources.graduate_small;
break;
case ImageSize.Medium:
result = Resources.graduate;
break;
case ImageSize.Big:
result = Resources.graduate_big;
break;
}
break;
case TrainingLevel.Expert:
switch (size)
{
case ImageSize.Small:
result = Resources.genius_small;
break;
case ImageSize.Medium:
result = Resources.genius;
break;
case ImageSize.Big:
result = Resources.genius_big;
break;
}
break;
}
return(result);
}
public void updateTLTable(TrainingLevel tl, int id)
{
{
SqlConnection con;
SqlCommand cmd;
try
{
con = connect("DBConnectionString"); // create the connection
}
catch (Exception ex)
{
throw (ex);
}
String cStr = BuildInsertCommand1(tl, id);
cmd = CreateCommand(cStr, con);
try
{
int numEffected = cmd.ExecuteNonQuery(); // execute the command
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
}
public List <TrainingLevel> GetTrainingLevel()
{
List <TrainingLevel> TL = new List <TrainingLevel>();
SqlConnection con = null;
try
{
con = connect("DBConnectionString");
String selectSTR = "SELECT * FROM TrainingLevel_2020";
SqlCommand cmd = new SqlCommand(selectSTR, con);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
TrainingLevel trininglevel = new TrainingLevel();
trininglevel.Traininglevel = (string)dr["TrainingLevel"];
trininglevel.Id = Convert.ToInt32(dr["TrainingLevelId"]);
TL.Add(trininglevel);
}
return(TL);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private String BuildInsertCommand(TrainingLevel tl)
{
String command;
String prefix = "INSERT INTO TrainingLevel_2020 (TrainingLevel)";
String str = "Values('" + tl.Traininglevel + "')";
command = prefix + str;
return(command);
}
private String BuildInsertCommand(TrainingLevel tl, int id)
{
String command;
StringBuilder sb = new StringBuilder();
StringBuilder sb1 = new StringBuilder();
string p = id.ToString();
string trl = tl.Id.ToString();
command = "UPDATE Guide_2020 SET TrainingLevelId =" + trl + " WHERE UserId =" + p;
return(command);
}
/// <summary>
/// Get the lessons for a specific level.
/// </summary>
/// <param name="level">Level of the training.</param>
/// <param name="requiredTags">Required tags.</param>
/// <returns>List of Lessons for the given level and with at least one of the searched tags, if specified.</returns>
public IEnumerable <LessonInfo> GetLessons(TrainingLevel level, IEnumerable <string> requiredTags = null)
{
IEnumerable <LessonInfo> result;
if (!_trainings.TryGetValue(level, out var trainings))
{
trainings = null;
}
if ((trainings?.Any() ?? false) && requiredTags != null)
{
result = GetLessons(trainings, requiredTags);
}
else
{
result = trainings;
}
return(result);
}
public static bool IsNull(this TrainingLevel tl)
{
return(tl == null);
}
public void Save(string userName, int age, float height, float weight, float imc, int score, Complexion complexion, TrainingLevel training)
{
/*
* if (isFirstTime)
* isFirstTime = false;
*
* this.userName = userName;
* this.age = age;
* this.height = height;
* this.weight = weight;
* this.imc = imc;
* this.score = score;
*
* this.complexion = complexion;
* this.training = training;
*
* Observer.Singleton.OnSave();
*/
}
public void SaveTraining(TrainingLevel training)
{
this.training = training;
Observer.Singleton.OnSave();
}
// PUT api/<controller>/5
public void Put(int id, [FromBody] TrainingLevel tl)
{
tl.UpdateTL(id);
}
// POST api/<controller>
public void Post([FromBody] TrainingLevel tl)
{
tl.InsertTrainingLevel();
}
// GET api/<controller>
public List <TrainingLevel> Get()
{
TrainingLevel TL = new TrainingLevel();
return(TL.GetTrainingLevel());
}
public static async Task <JSONTraining> ToJSONAsync(this Training training, IUnitOfWork uiOfWork)
{
if (training.TrainingDataId != null)
{
TrainingData data = await uiOfWork.TrainingDatas.GetAsync((int)training.TrainingDataId);
if (data.IsNull())
{
return(null);
}
ProgramType pt = await uiOfWork.ProgramTypes.GetAsync(data.ProgramTypeId);
if (pt.IsNull())
{
return(null);
}
TrainingLevel tl = await uiOfWork.TrainingLevels.GetAsync(data.LevelId);
if (tl.IsNull())
{
return(null);
}
Gym gym = await uiOfWork.Gyms.GetAsync(training.GymId);
if (gym.IsNull())
{
return(null);
}
CoachTraining ct =
await uiOfWork.CoachesTrainings.FindAsync(coachTraining => coachTraining.TrainingId == training.Id);
if (ct.IsNull())
{
return(null);
}
Employee empl = await uiOfWork.Employees.GetAsync(ct.CoachId);
if (empl.IsNull())
{
return(null);
}
JSONTraining tr = new JSONTraining
{
Id = training.Id,
StartTime = training.StartTime,
EndTime = training.EndTime,
IsFinished = training.IsFinished,
GymName = gym.Name,
Description = data.TrainingDescription,
IsMustPay = data.IsMustPay,
TrainingName = data.TrainingName,
IsNewTraining = data.IsNewTraining,
Ispopular = data.Ispopular,
ProgramType = pt.Name,
CoachId = empl.Id,
CoachName = empl.Name,
CoachFamily = empl.Family,
LevelName = tl.Name,
};
//Если это платная тренировка
if (data is PayTraining payTraining)
{
tr.PlacesCount = payTraining.PlacesCount;
tr.BusyPlacesCount = training.BusyPlacesCount;
//tr.FreePlacesCount = payTraining.FreePlacesCount;
}
return(tr);
}
return(null);
}
private String BuildInsertCommand1(TrainingLevel tl, int id)
{
string p = id.ToString();
return("UPDATE TrainingLevel_2020 SET TrainingLevel ='" + tl.Traininglevel + "' WHERE TrainingLevelId =" + p);
}
