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()); }