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());
}
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());
}
}
}
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);
}
//Post
public static bool Register(Meets1 m)
{
//אותו דבר כמו הפונקציות האחרות של אד
Meets meet = Meets1.Todal(m);
return(Dal.MeetsDal.Register(meet));
}
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 bool ShouldSerializeMeets()
{
return(Meets?.Any() ?? false);
}
public void All_returns_an_instance_of_AllConstraint(IConstraint[] constraints)
{
var result = Meets.All(constraints);
Assert.That(result, Is.InstanceOf <AllConstraint>());
}
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());
}
public async Task <IEnumerable <JoinToTheEvent> > GetUserMeetUp(Guid userId) => await Meets.AsQueryable().SelectMany(x => x.MeetMember).Where(k => k.UserId == userId).ToListAsync();
public async Task <Meet> GetMeetById(Guid meetupId)
=> await Meets.AsQueryable().FirstOrDefaultAsync(x => x.Id == meetupId);
public async Task UpdateAsync(Meet meetup)
{
await Meets.ReplaceOneAsync(x => x.Id == meetup.Id, meetup);
}
public async Task DeleteAsync(Guid Id)
{
await Meets.DeleteOneAsync(x => x.Id == Id);
}
public async Task <IEnumerable <Meet> > BrowseAsync() => await Meets.AsQueryable().ToListAsync();
public async Task AddAsync(Meet meetUp)
{
await Meets.InsertOneAsync(meetUp);
}
