void RemoveElementHandler()
{
if (SelectedItem2 != null && Trainings.Any(t => t.Id == SelectedItem2.Id))
{
Trainings.Remove(SelectedItem2);
}
}
public void Navigate()
{
Navigate("https://www.softuni.bg");
Trainings.Click();
QAModule.Click();
QAAutomationCourse.Click();
}
void AddElementHandler()
{
if (SelectedItem != null && !Trainings.Any(t => t.Id == SelectedItem.Training.Id))
{
Trainings.Add(SelectedItem.Training);
}
}
private void insert_btn_Click(object sender, EventArgs e)
{
Finalize_btn.Enabled = true;
int num;
if ((exercises_cb.Text == "") || (muscles_cb.Text == ""))
{
MessageBox.Show("Muscle and Exercise fields cannot be empty!");
}
else
{
if ((int.TryParse(Sets_tb.Text, out num) != true) || (Int32.Parse(Sets_tb.Text) < 1))
{
MessageBox.Show("Invalid format for the field: Number of sets!");
}
else
{
var db = new Model1();
var obj = new add_into_database();
Exercises_trainings inserted_extrain = new Exercises_trainings();
if (training_started == false)
{
training_started = true;
inserted_training = obj.add_training(usern, date_dtp.Value);
}
inserted_extrain = obj.add_exercise_training(exercises_cb.Text, inserted_training.id);
obj.add_sets(inserted_extrain, Int32.Parse(Sets_tb.Text));
Sets_tb.Text = "";
}
}
}
public void Update(Trainings training)
{
training.Certification = _context.Certifications.FirstOrDefault(c => c.Id.Equals(training.CertificationId));
training.ModificatedAt = DateTimeOffset.Now;
_context.Trainings.Update(training);
_context.SaveChanges();
}
public Trainings GetMobileConfigurationTrainings(int id)
{
Trainings trainings = new Trainings();
try
{
string query = $"select * from dsto_Training where configuration_id = '{id}' and Deleted=0";
var table = DbInfo.ExecuteSelectQuery(query);
if (table.Rows.Count > 0)
{
System.Data.DataRow row = table.Rows[0];
DCAnalytics.Training training = trainings.Add();
InitTraining(training, row);
training.Trainers = new TrainerProvider(DbInfo).GetTrainers(training.Key);
training.Trainees = new TraineeProvider(DbInfo).GetTrainees(training.Key);
training.Topics = new TopicProvider(DbInfo).GetTopics(training.Key);
}
}
catch (Exception ex)
{
throw ex;
}
return(trainings);
}
async Task ExecuteLoadItemsCommand()
{
if (IsBusy)
{
return;
}
IsBusy = true;
try
{
Trainings.Clear();
var trainings = await App.Database.GetTrainingsAsync();
foreach (var t in trainings)
{
Trainings.Add(t);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
finally
{
IsBusy = false;
}
}
public ActionResult DeleteConfirmed(int id)
{
Trainings trainings = db.Trainings.Find(id);
db.Trainings.Remove(trainings);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task LoadTrainings()
{
await SetBusyAsync(async() =>
{
var result = await this.trainingService.GetTrainingsAsync(this.CurrentUserInformation.DefaultSeason.Id, this.CurrentUserInformation.DefaultTeam.Id);
Trainings.ReplaceRange(result.OrderByDescending(t => t.Date));
});
}
public void TeamMemberGetDepartureTest()
{
String name = "Test";
Trainings trainLevel = Trainings.firstAid;
DateTime departure = DateTime.Now;
TeamMember a = new TeamMember(name, trainLevel, departure);
Assert.AreEqual(a.getDeparture(), departure);
}
void AddIfNotExist(List <ResultVM> elements, ObservableCollection <TrainingVM> data)
{
foreach (ResultVM item in elements)
{
if (!data.Any(d => d.Id == item.Training.Id))
{
Trainings.Add(item.Training);
}
}
}
public IEnumerable <Trainings> Post([FromBody] Trainings training)
{
var trainings = GetTrainingsFromDB();
var id = (int)trainings.Max(x => x.Id);
training.Id = id + 1;
trainings.Add(training);
return(trainings);
}
public void TeamMemberSetNameGridTest_Null()
{
String name = "Test";
Trainings trainLevel = Trainings.firstAid;
DateTime departure = DateTime.Now;
TeamMember a = new TeamMember(name, trainLevel, departure);
Grid nameGrid = new Grid();
Assert.AreEqual(a.getNameGrid(), null);
}
public void TeamMemberCreation()
{
String name = "Test";
Trainings trainLevel = Trainings.firstAid;
DateTime departure = new DateTime(2014, 11, 20);
TeamMember a = new TeamMember(name, trainLevel, departure);
Assert.AreEqual(a.getName(), "Test");
Assert.AreEqual(a.getTrainingLevel(), Trainings.firstAid);
}
public ActionResult Edit([Bind(Include = "TrainingID,Date,Duration,TrainInfo,Address")] Trainings trainings)
{
if (ModelState.IsValid)
{
db.Entry(trainings).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(trainings));
}
//public static Exercises_trainings rename_exercise_for_training(int exercise_id, int training_id)
public static Trainings rename_training(int training_id, DateTime newdate)
{
var db = new Model1();
var training = new Trainings();
training = (from x in db.Trainings where x.id == training_id select x).First();
training.training_date = newdate;
db.SaveChanges();
return(training);
}
public async Task <IActionResult> Create(Trainings training)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
await _genericRepository.CreateAsync(training);
return(Ok(_genericRepository.SaveAsync().Result));
}
public Trainings add_training(string username, DateTime training_date)
{
var db = new Model1();
var training = new Trainings();
training.id_users = (from x in db.Users where x.username == username select x).First().id;
training.training_date = training_date;
db.Trainings.Add(training);
db.SaveChanges();
return(training);
}
public ActionResult Create([Bind(Include = "TrainingID,Date,Duration,TrainInfo,Address")] Trainings trainings)
{
if (ModelState.IsValid)
{
db.Trainings.Add(trainings);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(trainings));
}
public List <int> AddTrainings(List <Training> trainings)
{
Trainings.AddRange(trainings);
int count = Trainings.Count;
//Faking database logic
foreach (var training in trainings)
{
training.Id = ++count;
}
return(trainings.Select(x => x.Id).ToList());
}
public Trainings Add(int personId, Trainings training)
{
var person = _context.Persons.Include(p => p.Trainings).FirstOrDefault(p => p.Id.Equals(personId));
training.Certification = _context.Certifications.FirstOrDefault(c => c.Id.Equals(training.CertificationId));
training.CreatedAt = DateTimeOffset.Now;
person.Trainings.Add(training);
_context.Persons.Update(person);
_context.SaveChanges();
return(training);
}
public List <Training> GetTrainings(TrainingFilter filter)
{
if (filter == null)
{
return(Trainings);
}
//Not Good Code. Just for Demo. You will need to handle all cases here.
return(Trainings.Where(x => String.Equals(x.City, filter.City, StringComparison.CurrentCultureIgnoreCase) ||
(x.Country != null && (String.Equals(x.Country, filter.Country, StringComparison.CurrentCultureIgnoreCase))) ||
(x.Country != null && (String.Equals(x.Country, filter.Country, StringComparison.CurrentCultureIgnoreCase))) ||
(x.Zip != null && (String.Equals(x.Zip, filter.Zip, StringComparison.CurrentCultureIgnoreCase)))).ToList());
}
public IActionResult Post([FromBody] Trainings trainings)
{
if (ModelState.IsValid)
{
bool result = mentorrepository.AddTraining(trainings);
if (result)
{
return(Created("Add Training", trainings.Id));
}
return(StatusCode(StatusCodes.Status500InternalServerError));
}
return(BadRequest(ModelState));
}
public void Reset()
{
SelectedEmployee = null;
FirstName = null;
LastName = null;
Status = false;
HireDate = null;
ReviewDate = null;
Positions.Clear();
Trainings.Clear();
NotifyOfPropertyChange(() => CanSave);
NotifyOfPropertyChange(() => CanReset);
}
// GET: Trainings/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Trainings trainings = db.Trainings.Find(id);
if (trainings == null)
{
return(HttpNotFound());
}
return(View(trainings));
}
//Adds a maximum of 3 new member to the team
public bool AddMember(TeamMember member)
{
if (memberList.Count <= 2)
{
memberList.Add(member);
StaticDBConnection.NonQueryDatabase("INSERT INTO [Team_Members] (Team_ID, Volunteer_ID, Departure, Joined) VALUES (" + teamID + ", " + member.getID() + ", '" + StaticDBConnection.DateTimeSQLite(member.getDeparture()) + "', '" + StaticDBConnection.DateTimeSQLite(DateTime.Now) + "');");
if ((int)highestLevelOfTraining < (int)member.getTrainingLevel())
{
highestLevelOfTraining = member.getTrainingLevel();
}
InstanceModifiedNotification();
return(true);
}
return(false);
}
public async Task <IActionResult> Update([Required] int id, Trainings trainings)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != trainings.Id)
{
return(NotFound());
}
_genericRepository.Update(trainings);
return(Ok(await _genericRepository.SaveAsync()));
}
private void Delete1_btn_Click(object sender, EventArgs e)
{
if (trainings_out.SelectedRows.Count == 0)
{
MessageBox.Show("No training was selected for delete!");
}
else
{
var db = new Model1();
var training = new Trainings();
training.id = Convert.ToInt32(trainings_out.SelectedRows[0].Cells[0].Value);
foreach (var ex_train in db.Exercises_trainings.Where(m => m.id_training == training.id))
{
foreach (var set in db.Series.Where(x => x.id_exercise_training == ex_train.id))
{
db.Series.Attach(set);
db.Series.Remove(set);
}
db.Exercises_trainings.Attach(ex_train);
db.Exercises_trainings.Remove(ex_train);
}
db.Trainings.Attach(training);
db.Trainings.Remove(training);
db.SaveChanges();
MessageBox.Show("The item was deleted!");
if (isadmin)
{
trainings_out.Columns.Remove("username");
trainings_out.DataSource = db.Trainings.ToList();
trainings_out.Refresh();
trainings_out.Columns.Add("username", "username");
foreach (DataGridViewRow item in trainings_out.Rows)
{
var user_id = Convert.ToInt32(trainings_out.Rows[item.Index].Cells[2].Value);
trainings_out.Rows[item.Index].Cells[5].Value = db.Users.Where(m => m.id == user_id).First().username;
}
}
else
{
trainings_out.DataSource = db.Trainings.Where(m => m.Users.username == usern).ToList();
trainings_out.Refresh();
}
}
}
/// <summary>
/// Добавить тренировку.
/// </summary>
/// <param name="training">Тренировка.</param>
public void Add(Training training)
{
var Train = Trainings.SingleOrDefault(t => t.Name == training.Name);
if (Train == null)
{
Trainings.Add(training);
TodaysTraining.Add(training);
Save();
}
else
{
TodaysTraining.Add(Train);
Save();
}
}
/// <summary>
/// Save a training added or modified
/// </summary>
/// <param name="training"></param>
public static void SaveTraining(Training training)
{
List <Training> trainings = new List <Training>(Trainings);
if (Trainings.Contains(training))
{
trainings.Remove(training);
trainings.Add(training);
}
else
{
trainings.Add(training);
}
Trainings = trainings;
DalManager.Save(Trainings);
}
