private void AddSessionToList(SessionModel sess) { ListViewItem res = new ListViewItem(listViewAutocollects.Items.Count.ToString()); res.SubItems.Add(sess.Name); res.SubItems.Add(sess.TimeStart.ToShortTimeString()); res.SubItems.Add(sess.Days); listViewAutocollects.Items.Add(res); }
private void buttonAddSesion_Click(object sender, EventArgs e) { if (dateTimeInput.Value == new DateTime()) { ToastNotification.Show(this, @"Ñhoose a time,please"); return; } if (GetDaysStr() == "_______") { ToastNotification.Show(this, @"Ñhoose a day(s),please"); return; } var sess = new SessionModel { Id = -1, Name = textBoxSesionName.Text == "" ? "Untitled session" : textBoxSesionName.Text, IsStartYesterday = true, Days = GetDaysStr(), TimeStart = dateTimeInput.Value, TimeEnd = new DateTime(), }; // ClientDatabaseManager.AddSessionForGroup(_groups.Find(oo => oo.GroupName == group).GroupId, sess); if (listBoxGroupName.SelectedItems.Count != 0) { if (listBoxGroupName.SelectedItems.Count == 1) { AddSessionToList(sess); } for (int index = 0; index < listBoxGroupName.SelectedItems.Count; index++) { var group = listBoxGroupName.SelectedItems[index]; if (index == 0) { ClientDatabaseManager.AddSessionForGroup(_groups.Find(oo => oo.GroupName == group).GroupId, sess); _sessions = ClientDatabaseManager.GetSessions(); continue; } var currSes = _sessions.Find(oo => oo.Name == sess.Name && oo.Days == sess.Days); ClientDatabaseManager.AddSessionForGroup(_groups.Find(oo => oo.GroupName == group).GroupId, currSes.Id); } } else ClientDatabaseManager.AddSessionForGroup(-1, sess); RefreshClik(); textBoxSesionName.Text = ""; dateTimeInput.Value = new DateTime(); comboBoxAutoCollect.Items.Add(sess.Name + "(" + sess.Days + ")"); _sessions = ClientDatabaseManager.GetSessions(); }
void EditListControl_AddSesion(SessionModel sesions) { AddDay(sesions.TimeStart,sesions.Days); }
public static void AddSessionForGroup(int groupId, SessionModel sess) { var sql = "INSERT INTO " + TblSessions + " (Name, StartTime, EndTime, IsStartYesterday, Days) VALUES ("; sql += "'" + sess.Name + "',"; sql += "'" + sess.TimeStart.ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture) + "',"; sql += "'" + sess.TimeEnd.ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture) + "',"; sql += "" + sess.IsStartYesterday + ","; sql += "'" + sess.Days + "');COMMIT;"; DoSql(sql); MySqlCommand cmd = _connectionToDb.CreateCommand(); cmd.CommandText = "SELECT max(ID) FROM " + TblSessions + ";"; var result = cmd.ExecuteScalar().ToString(); var id = result == "" ? 0 : uint.Parse(result); var sql2 = "INSERT INTO " + TblSessionsForGroups + " (GroupId, SessionId) VALUES ("; sql2 += groupId + " , " + id + ");COMMIT;"; DoSql(sql2); }
public static List<SessionModel> GetSessionsInGroup(int groupId) { var symbolsList = new List<SessionModel>(); var sql = DAQueryBuilder.GetSessionsInGroupSql(groupId); var reader = GetReader(sql); if (reader != null) { while (reader.Read()) { var session = new SessionModel { Id = reader.GetInt32("Id"), Name = reader.GetString("Name"), IsStartYesterday = reader.GetBoolean("IsStartYesterday"), TimeStart = reader.GetDateTime("StartTime"), TimeEnd = reader.GetDateTime("EndTime"), Days = reader.GetString("Days") }; symbolsList.Add(session); } reader.Close(); } return symbolsList; }
private void OnAddSesion(SessionModel sesions) { AddSesionHandler handler = AddSesion; if (handler != null) handler(sesions); }
private void buttonX_add_Click_1(object sender, EventArgs e) { var sess = new SessionModel { Id = -1, Name = textBoxX_sessionsName.Text==""?"Untitled session":textBoxX_sessionsName.Text, IsStartYesterday = checkBox_sy.Checked, Days = GetDaysStr(), TimeStart = dateTimeInput1.Value, TimeEnd = dateTimeInput2.Value, }; //OnAddSesion(sess); AddSessionToList(sess); ClientDatabaseManager.AddSessionForGroup(AGroupModel.GroupId, sess); }
private void buttonX1_Click(object sender, EventArgs e) { var ind = comboBoxEx_existigsSessions.SelectedIndex; if (ind == -1) { ToastNotification.Show(panelEx4, "Please, choose any session."); return; } var sess = new SessionModel { Id = -1, Name = addedSessions[ind].Name, IsStartYesterday = addedSessions[ind].IsStartYesterday, Days = addedSessions[ind].Days, TimeStart = addedSessions[ind].TimeStart, TimeEnd = addedSessions[ind].TimeEnd, }; //OnAddSesion(sess); AddSessionToList(sess); ClientDatabaseManager.AddSessionForGroup(AGroupModel.GroupId, sess); }
private void AddSessionToList(SessionModel sess) { var res = listViewEx_times.Items.Add(listViewEx_times.Items.Count.ToString()); res.SubItems.Add(sess.Name); res.SubItems.Add(sess.TimeStart.ToShortTimeString()); res.SubItems.Add(sess.Days); }