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 bool updateMeetingStatus(MeetModel meeting)
{
bool result = true;
try
{
using (OracleConnection connection = new OracleConnection(OracleSQLConnector.GetConnectionString()))
{
try
{
connection.Open();
OracleCommand cmd;
string sql = String.Format("update meet_table set accepted = {1}, isnew = {2} where id = {0}", meeting.ID, meeting.Accepted, meeting.New);
cmd = new OracleCommand(sql, connection);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch
{
result = false;
}
}
}catch
{
result = false;
}
return(result);
}
/// <summary>
/// Filling textBoxes
/// </summary>
/// <param name="meeting"></param>
private void setTextBoxesWithData(MeetModel meeting)
{
OracleSQLConnector oracleSQLConnector = new OracleSQLConnector();
int globalUserID = GlobalClass.getUserID();
GlobalClass.setUserID(meeting.IDUser);
UserModel user = oracleSQLConnector.loadUserFromDataBase();
GlobalClass.setUserID(globalUserID);
PlaceModel place = oracleSQLConnector.loadPlaceFromDataBase(meeting.IDPlace);
userTextBox.Text = user.getFullName();
userPhoneNumberTextBox.Text = user.getPhoneNumberStr();
placeTextBox.Text = place.getFullDetails();
dateAndHourTextBox.Text = meeting.getDateAndHourStr();
}
public static List <ScheduleEntry> ToScheduledOrder([NotNull] this MeetModel meetModel)
{
var ids = meetModel.Events
.Select(tp => tp.Id)
.ToList();
var scheduledIds = meetModel.TimePoints
.OrderBy(tp => tp.Time)
.SelectMany(tp => tp.EventIds)
.ToList();
var unscheduledIds = ids
.Except(scheduledIds)
.ToList();
var unscheduledEventsEntry = new ScheduleEntry
{
Time = meetModel.DateOfEvent.TimeOfDay,
Behavior = SchedulingBehavior.Unspecified,
Events = meetModel.Events
.Where(e => unscheduledIds.Contains(e.Id))
.Select(e => e.Name)
.ToList()
};
var schedule = new List <ScheduleEntry> {
unscheduledEventsEntry
};
var scheduledEvents = meetModel.TimePoints
.OrderBy(tp => tp.Time)
.Select(tp => new ScheduleEntry
{
Time = tp.Time,
Behavior = tp.Behavior,
Events = tp.EventIds
.Select(id => meetModel[id].Name)
.ToList()
})
.ToList();
schedule.AddRange(scheduledEvents);
return(schedule);
}
// GET: /Liveboard/
public ActionResult Index()
{
MeetModel model = new MeetModel()
{
MeetList = new List <OneMeet>()
};
using (MARS_Meet_dbEntities meetDb = new MARS_Meet_dbEntities())
{
DateTime d = new DateTime(2014, 01, 01);
foreach (var meet in from mars_Meet in meetDb.mars_MMeet where mars_Meet.StartDate >= d orderby mars_Meet.StartDate descending select mars_Meet)
{
model.MeetList.Add(createMeet(meet, Selection.Events));
}
}
return(View(model));
}
private void toDeclinedListButton_Click(object sender, RoutedEventArgs e)
{
if (pendingMeetingsListBox.SelectedIndex >= 0)
{
MeetModel meetingToMove = pendingMeetingsList.ElementAt(pendingMeetingsListBox.SelectedIndex);
meetingToMove.Accepted = 0;
meetingToMove.New = 0;
OracleSQLConnectorTrainerWindow oraclesql = new OracleSQLConnectorTrainerWindow();
if (oraclesql.updateMeetingStatus(meetingToMove))
{
pendingMeetingsList.Remove(meetingToMove);
declinedMeetingsList.Add(meetingToMove);
pendingMeetingsListBox.Items.Refresh();
declinedMeetingsListBox.Items.Refresh();
}
else
{
meetingToMove.Accepted = 0;
meetingToMove.New = 1;
}
}
}
private void addMeetingButton_Click(object sender, RoutedEventArgs e)
{
if (isDataValidForInsert())
{
DateTime dateTime = new DateTime();
String dateStr = datePicker.SelectedDate.ToString();
dateStr = dateStr.Substring(0, 11);
String timeStr = hourPicker.Text + ":" + minutePicker.Text + ":00";
String dateAndTimeStr = dateStr + " " + timeStr;
dateTime = Convert.ToDateTime(dateAndTimeStr);
durationComboBox.SelectedValue.ToString().Trim();
MeetModel meet = new MeetModel(GlobalClass.getUserID(), GlobalClass.getTrainerID(), GlobalClass.getPlaceID(), dateTime, Int32.Parse(durationComboBox.SelectedValue.ToString().Trim()));
OracleSQLConnectorUserWindow oraclesql = new OracleSQLConnectorUserWindow();
if (oraclesql.insertMeetingToDBReturnItsID(meet))
{
addLabelFailed.Visibility = Visibility.Hidden;
addLabelSuccess.Visibility = Visibility.Visible;
}
else
{
addLabelFailed.Visibility = Visibility.Visible;
addLabelSuccess.Visibility = Visibility.Hidden;
}
// date + timepicker = DateTime
// to model
//send
}
else
{
addLabelSuccess.Visibility = Visibility.Hidden;
addLabelFailed.Visibility = Visibility.Visible;
//Data invalid error
}
//check for empty
//insert
}
public IModel Create(IDataProvider provider, IModelFactoryContainer modelFactoryContainer)
{
var model = new MeetModel(provider, modelFactoryContainer);
return(model);
}
public MeetModelIterator([NotNull] MeetModel rootModel)
{
this.rootModel = rootModel;
}
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());
}
