public void Update() { MeetDisplayModel exists = Meets.Where(x => x.Id == SelectedMeet.Id).FirstOrDefault(); if (exists != null) { if (SelectedMeet != null && Meets.Count > 0) { isUpdating = true; MeetModel e = new MeetModel { Id = SelectedMeet.Id, MeetName = _meetName, StartDate = _startDate, EndDate = _endDate, Location = _location }; SqlDataAccess sql = new SqlDataAccess(); sql.UpdateData <MeetModel>("dbo.spMeet_Update", e, "ADBData"); msg = $"Meet ({SelectedMeet.MeetName}) was successfully updated."; MessageBox.Show(msg, "Meet Updated"); Meets = new BindingList <MeetDisplayModel>(GetAllMeets()); Clear(); isUpdating = false; _events.PublishOnUIThread(new MeetChangedEvent()); } } }
public void Add() { isAdding = true; MeetDisplayModel e = Meets.Where(x => x.MeetName == MeetName).FirstOrDefault(); if (e == null) { SqlDataAccess sql = new SqlDataAccess(); sql.SaveData <dynamic>("dbo.spMeet_Insert", new { MeetName = _meetName, StartDate = _startDate, EndDate = _endDate, Location = _location }, "ADBData"); Meets = new BindingList <MeetDisplayModel>(GetAllMeets()); NotifyOfPropertyChange(() => Meets); Clear(); } else { msg = $"Error: An Meet named ({SelectedMeet.MeetName}) already exist!!!"; MessageBox.Show(msg, "Error"); } isAdding = false; _events.PublishOnUIThread(new MeetChangedEvent()); }
private int GetMeetId(string meetName) { int id = 0; id = Meets.Where(x => x.MeetName == meetName).Any() ? Meets.Where(x => x.MeetName == meetName).FirstOrDefault().Id : 0; return(id); }
public void Delete() { MeetDisplayModel e = Meets.Where(x => x.Id == SelectedMeet.Id).FirstOrDefault(); if (e != null) { SqlDataAccess sql = new SqlDataAccess(); sql.DeleteData <dynamic>("dbo.spMeet_Delete", new { Id = SelectedMeet.Id }, "ADBData"); Meets = new BindingList <MeetDisplayModel>(GetAllMeets()); SelectedMeet = null; Clear(); _events.PublishOnUIThread(new MeetChangedEvent()); } }
public void UpdateFields() { if (SelectedResult != null) { //SelectedMeet.Id = SelectedResult.MeetId; //SelectedAthlete.Id = SelectedResult.AthleteId; //SelectedEvent.Id = SelectedResult.EventId; //Mark = SelectedResult.Mark.ToString(); //PerfDate = SelectedResult.PerfDate; SelectedMeet = Meets.Where(x => x.Id == SelectedResult.MeetId).FirstOrDefault(); SelectedAthlete = Athletes.Where(x => x.Id == SelectedResult.AthleteId).FirstOrDefault(); SelectedEvent = EventList.Where(x => x.Id == SelectedResult.EventId).FirstOrDefault(); Mark = SelectedResult.Mark.ToString(); Wind = SelectedResult.Wind; PerfDate = SelectedResult.PerfDate; } }
public void Import() { resultsToSave = new List <ResultModel>(); id = 0; athleteId = 0; eventId = 0; meetId = 0; meetDay = 0; importedResults = new List <ResultImportModel>(); mark = 0.00f; perfDate = DateTime.Now; startDate = DateTime.Now; endDate = DateTime.Now; eventCode = ""; meetName = ""; firstName = ""; lastName = ""; wind = ""; result = new ResultImportModel(); resultToSave = new ResultModel(); string filePath = @"C:\Exported_MM_Results_CSV"; OpenFileDialog openFD = new OpenFileDialog(); openFD.InitialDirectory = filePath; if (openFD.ShowDialog() == true) { string file = openFD.FileName; List <string> lines = File.ReadAllLines(file).ToList(); foreach (var line in lines) { string[] rec = line.Split(';'); if (rec[0] == "H") { meetName = rec[1]; startDate = DateTime.Parse(rec[2]); endDate = DateTime.Parse(rec[3]); var meet = Meets.Where(x => x.MeetName == meetName).FirstOrDefault(); if (meet == null) { MeetModel m = new MeetModel() { MeetName = meetName, StartDate = startDate, EndDate = endDate, Location = "" }; SqlDataAccess sql = new SqlDataAccess(); sql.SaveData <dynamic>("dbo.spMeet_Insert", new { MeetName = m.MeetName, StartDate = m.StartDate, EndDate = m.EndDate, Location = "" }, "ADBData"); } Meets = new BindingList <MeetDisplayModel>(GetAllMeets()); } else if (rec[0] == "E" && rec[1] == "T") { if (rec[10] == "DNS" || rec[10] == "DQ" || rec[10] == "FS" || rec[10] == "NT" || rec[10] == "SCR" || rec[10] == "DNF") { } else { if (rec[4] == "100" || rec[4] == "200" || rec[4] == "100H" || rec[4] == "110H") { string mk = rec[10]; string[] ts = mk.Split(':'); if (ts.GetLength(0) == 1) { mark = float.Parse(rec[10]); } else { var secs = float.Parse(ts[0]) * 60; secs += float.Parse(ts[1]); } } else if (rec[4] == "400" || rec[4] == "400H") { string temp = rec[10]; string[] ts = temp.Split(':'); if (ts.GetLength(0) > 1) { var secs = float.Parse(ts[0]) * 60; secs += float.Parse(ts[1]); mark = secs; } else { mark = float.Parse(rec[10]); } } else if (rec[4] == "800" || rec[4] == "1500") { string temp = rec[10]; string[] ts = temp.Split(':'); var secs = float.Parse(ts[0]) * 60; secs += float.Parse(ts[1]); mark = secs; } firstName = rec[23]; lastName = rec[22]; eventCode = rec[4] + "M"; //mark = float.Parse(rec[10]); wind = rec[12]; meetDay = 1; perfDate = startDate; result = new ResultImportModel() { FirstName = firstName, LastName = lastName, EventCode = eventCode, MeetName = meetName, Mark = mark, Wind = wind, MeetDay = 1, PerfDate = startDate, StartDate = startDate, EndDate = endDate }; importedResults.Add(result); } } else if (rec[0] == "R") { } } } foreach (var athlete in Athletes) { var aId = athlete.Id; firstName = athlete.FirstName; lastName = athlete.LastName; meetId = Meets.Where(x => x.MeetName == meetName).FirstOrDefault().Id; var aResults = importedResults.Where(x => x.FirstName == firstName && x.LastName == lastName).ToList(); if (aResults.Count > 0) { foreach (var rs in aResults) { eventId = GetEventId(rs.EventCode); meetId = GetMeetId(rs.MeetName); athleteId = GetAthleteId(rs.FirstName, rs.LastName); mark = rs.Mark; wind = rs.Wind; meetDay = rs.MeetDay; perfDate = startDate; ResultModel rts = new ResultModel() { AthleteId = athleteId, EventId = eventId, MeetId = meetId, Mark = mark, Wind = wind, PerfDate = perfDate }; SqlDataAccess sql = new SqlDataAccess(); sql.SaveData <dynamic>("dbo.spResult_Insert", new { rts.AthleteId, rts.EventId, rts.MeetId, rts.Mark, rts.Wind, rts.PerfDate }, "ADBData"); } } } Meets = new BindingList <MeetDisplayModel>(GetAllMeets()); Results = new BindingList <ResultDisplayModel>(GetAllResults()); }