private void button1_Click(object sender, EventArgs e) { System.Windows.Forms.BindingSource membros; Igrejafont10DataSetTableAdapters.Membros1TableAdapter membrosTableAdapter1; membros = new System.Windows.Forms.BindingSource(this.components); ((System.ComponentModel.ISupportInitialize)(membros)).BeginInit(); membros.DataMember = "Membros1"; membros.DataSource = this.igrejafont10DataSet; ((System.ComponentModel.ISupportInitialize)(membros)).EndInit(); membrosTableAdapter1 = new GerenciamentoCelulas.Igrejafont10DataSetTableAdapters.Membros1TableAdapter(); membrosTableAdapter1.ClearBeforeFill = true; membrosTableAdapter1.Fill(igrejafont10DataSet.Membros1); membros.Position = membros.Find("Codigo", dataGridView.CurrentRow.Cells[0].Value.ToString()); DataRowView row = (DataRowView)membros.Current; row["Celula"] = "0"; membros.EndEdit(); membrosTableAdapter1.Update(igrejafont10DataSet.Membros1); membrosTableAdapter.FillBy(igrejafont10DataSet.Membros); FiltraMembros(); }
private void removeMemberButton_Click(object sender, EventArgs e) { if (dataGridView.CurrentRow.Cells[0].Value.ToString().Length > 0) { DialogResult result = MessageBox.Show("Deseja remover o membro: " + dataGridView.CurrentRow.Cells[1].Value.ToString(), "Pergunta", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { System.Windows.Forms.BindingSource escadaSucesso; Igrejafont10DataSetTableAdapters.EscadaSucessoTableAdapter escadaTableAdapter; escadaSucesso = new System.Windows.Forms.BindingSource(this.components); ((System.ComponentModel.ISupportInitialize)(escadaSucesso)).BeginInit(); escadaSucesso.DataMember = "EscadaSucesso"; escadaSucesso.DataSource = this.igrejafont10DataSet; ((System.ComponentModel.ISupportInitialize)(escadaSucesso)).EndInit(); escadaTableAdapter = new GerenciamentoCelulas.Igrejafont10DataSetTableAdapters.EscadaSucessoTableAdapter(); escadaTableAdapter.ClearBeforeFill = true; escadaTableAdapter.Fill(this.igrejafont10DataSet.EscadaSucesso); membrosBindingSource1.RemoveAt(membrosBindingSource1.Find("Codigo", dataGridView.CurrentRow.Cells[0].Value.ToString())); escadaSucesso.RemoveAt(escadaSucesso.Find("Codigo", dataGridView.CurrentRow.Cells[0].Value.ToString())); membrosBindingSource1.EndEdit(); membrosTableAdapter1.Update(igrejafont10DataSet.Membros1); escadaSucesso.EndEdit(); escadaTableAdapter.Update(igrejafont10DataSet.EscadaSucesso); membrosTableAdapter.FillBy(igrejafont10DataSet.Membros); cellMembersLabel.Text = dataGridView.RowCount.ToString(); } catch (Exception ex) { MessageBox.Show("Update failed /n" + ex.ToString()); } } } else { MessageBox.Show("Selecione um membro para ser removido.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void RedeWindowSearchMember_Click(object sender, EventArgs e) { if (celulaComboBox.SelectedValue != null) { GerenciamentoCelulas.Forms.Membros.MembroSearch search = new Membros.MembroSearch(igrejaComboBox.Text); search.ShowDialog(); int newMember = search.MemberCode; if (newMember != 0) { System.Windows.Forms.BindingSource membros; Igrejafont10DataSetTableAdapters.Membros1TableAdapter membrosTableAdapter1; membros = new System.Windows.Forms.BindingSource(this.components); ((System.ComponentModel.ISupportInitialize)(membros)).BeginInit(); membros.DataMember = "Membros1"; membros.DataSource = this.igrejafont10DataSet; ((System.ComponentModel.ISupportInitialize)(membros)).EndInit(); membrosTableAdapter1 = new GerenciamentoCelulas.Igrejafont10DataSetTableAdapters.Membros1TableAdapter(); membrosTableAdapter1.ClearBeforeFill = true; membrosTableAdapter1.Fill(igrejafont10DataSet.Membros1); membros.Position = membros.Find("Codigo", newMember.ToString()); DataRowView row = (DataRowView)membros.Current; row["Celula"] = celulaComboBox.SelectedValue.ToString(); membros.EndEdit(); membrosTableAdapter1.Update(igrejafont10DataSet.Membros1); membrosTableAdapter.FillBy(igrejafont10DataSet.Membros); FiltraMembros(); } } else { MessageBox.Show("Por favor, selecione uma célula!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void Cartao_Click(object sender, EventArgs e) { FormPegarID F = new FormPegarID(ref TravaAPI); F.ShowDialog(this); if (F.fechar && F.encontrou != -1) { return; } if (F.rfiduid == CodigoRFID) { MessageBox.Show("esse já é o cartão desse aluno!", "Cuidado!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (AlunosBindingSource.Find(colunas.CodigoRFID, F.rfiduid) != -1 && AlunosBindingSource.Find(colunas.CodigoRFID, F.rfiduid) != index) { MessageBox.Show("esse cartão já foi cadastrado para outro aluno!", "erro!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Novo cartão lido com sucesso!", "sucesso!", MessageBoxButtons.OK, MessageBoxIcon.Information); CodigoRFID = F.rfiduid; } }
protected override object GetFormattedValue( object value, int rowIndex, ref DataGridViewCellStyle cellStyle, TypeConverter valueTypeConverter, TypeConverter formattedValueTypeConverter, DataGridViewDataErrorContexts context) { if (value == null) return null; int iValue; if (Int32.TryParse(value.ToString(), out iValue)) if (iValue == CashedValue) return CashedFormattedValue; var col = OwningColumn as DataGridViewDictionaryColumn; var CurrBS = col.DataSource as BindingSource; if (CurrBS == null) return null; var bs = new BindingSource() { DataSource = CurrBS.DataSource, DataMember = CurrBS.DataMember, Sort = CurrBS.Sort, Filter = CurrBS.Filter }; var iPos = bs.Find(col.ValueMember, value); if (iPos<0) return null; bs.Position = iPos; var row = (bs.Current as DataRowView).Row; var sValue = String.IsNullOrEmpty(col.DescriptionMember) ? String.Format(col.Format, row[col.DisplayMember]) : String.Format(col.Format, row[col.DisplayMember], row[col.DescriptionMember]); if (Int32.TryParse(value.ToString(), out iValue)) { CashedValue = iValue; CashedFormattedValue = sValue; } return sValue; }
private void EventProcessing(int colIndex, int rowIndex, BindingSource actualEvents, BindingSource actualActions) { try { //запомнить положение скроллбара int saveRow = 0; if (dgv1.Rows.Count > 0) saveRow = dgv1.FirstDisplayedCell.RowIndex; int currEvent = 0; //проверка пересечения мероприятий string cellTag = Convert.ToString(dgv1[colIndex, rowIndex].Tag); if (Int32.TryParse(cellTag, out currEvent)) { if ((dgv1.collapseEvents.Keys.Contains(currEvent)) && (dgv1[colIndex, rowIndex].Style.BackColor == event_error_bg)) { string filter = String.Format("[{0}] IN ({1}, {2})", currEventField, currEvent, dgv1.collapseEvents[currEvent]); CollapseSelect cs = new CollapseSelect(filter, eCategory); if (cs.ShowDialog() == System.Windows.Forms.DialogResult.OK) { currEvent = cs.ReturnEventID(); } else return; } actualEvents.Position = actualEvents.Find(currEventField, currEvent); DataRowView curr = (DataRowView)actualEvents.Current; DateTime ebegin = Convert.ToDateTime(Convert.ToString(curr["BeginTime"])); DateTime eend = Convert.ToDateTime(Convert.ToString(curr["EndTime"])); //if (this.EditCurrentEvent(actualEvents, this.eventlistBindingSource, ebegin, eend)) //выбираем кейсом eCategory и создаем IEditable; IEditable editEventForm = null; IEditable editActionForm = null; switch (eCategory) { case eventCategory.CurrentEvent: { editEventForm = new EditEventItem(actualEvents, this.eventlistBindingSource, ebegin, eend); editActionForm = new EditActionItem(actualActions, actualEvents, facility_tracksBindingSource, groupsBindingSource, group_headersBindingSource); } break; case eventCategory.CalendarEvent: { editEventForm = new EditCalendarEventItem(actualEvents, this.eventlistBindingSource); editActionForm = new EditCalendarActionItem(actualActions, actualEvents, facility_tracksBindingSource, groupsBindingSource, group_headersBindingSource); } break; default: editEventForm = null; editActionForm = null; break; } if (this.GenericEditEvent(editEventForm, actualEvents)) { SaveChanges(); actualActions.MoveFirst(); //если есть записи bool isNew = (actualActions.Current == null) ? true : false; // if (this.EditCurrentAction(this.actionsBindingSource, eventsBindingSource, facility_tracksBindingSource, //groupsBindingSource, group_headersBindingSource, isNew)) if (this.GenericEditAction(editActionForm, this.actionsBindingSource, group_headersBindingSource, isNew)) SaveChanges(); PrepareSelected(); //восстановить положение скроллбара if (saveRow != 0 && saveRow < dgv1.Rows.Count) dgv1.FirstDisplayedScrollingRowIndex = saveRow; } } else if (cellTag.Equals("new")) { DateTime newEventDate = GetCurrentDate(colIndex, dt1.Value); DateTime begin; DateTime end; string btime = String.Format("{0} {1}", currDate.ToShortDateString(), dgv1.Rows[rowIndex].HeaderCell.Value); begin = Convert.ToDateTime(btime); end = begin.AddMinutes(90); Properties.Settings.Default.lastEditEventBeginTime = begin.ToShortTimeString(); Properties.Settings.Default.lastEditEventEndTime = end.ToShortTimeString(); //if (this.EditCurrentEvent(actualEvents, this.eventlistBindingSource, newEventDate, new DateTime(), true, false)) //выбираем кейсом eCategory и создаем IEditable; IEditable editEventForm = null; IEditable editActionForm = null; switch (eCategory) { case eventCategory.CurrentEvent: { editEventForm = new EditEventItem(actualEvents, this.eventlistBindingSource, newEventDate, new DateTime(), false); editActionForm = new EditActionItem(actualActions, actualEvents, facility_tracksBindingSource, groupsBindingSource, group_headersBindingSource); } break; case eventCategory.CalendarEvent: { editEventForm = new EditCalendarEventItem(actualEvents, this.eventlistBindingSource); editActionForm = new EditCalendarActionItem(actualActions, actualEvents, facility_tracksBindingSource, groupsBindingSource, group_headersBindingSource); } break; default: editEventForm = null; editActionForm = null; break; } if (this.GenericEditEvent(editEventForm, actualEvents,true)) { SaveChanges(); actualActions.MoveFirst(); // if (this.EditCurrentAction(this.actionsBindingSource, eventsBindingSource, facility_tracksBindingSource, //groupsBindingSource, group_headersBindingSource, true)) if (this.GenericEditAction(editActionForm, actualActions, group_headersBindingSource, true)) SaveChanges(); PrepareSelected(); if (saveRow != 0 && saveRow < dgv1.Rows.Count) dgv1.FirstDisplayedScrollingRowIndex = saveRow; } } } catch (Exception ex) { ulog.Message(ex.Message, UserLogMessageLevel.Error); } }
private void DeleteEvent(int colIndex, int rowIndex, BindingSource actualEvents) { //запомнить положение скроллбара int saveRow = 0; if (dgv1.Rows.Count > 0) saveRow = dgv1.FirstDisplayedCell.RowIndex; int currEvent = 0; string cellTag = Convert.ToString(dgv1[colIndex, rowIndex].Tag); if (Int32.TryParse(cellTag, out currEvent)) { if ((dgv1.collapseEvents.Keys.Contains(currEvent)) && (dgv1[colIndex, rowIndex].Style.BackColor == event_error_bg)) { string filter = String.Format("[{0}] IN ({1}, {2})", currEventField, currEvent, dgv1.collapseEvents[currEvent]); CollapseSelect cs = new CollapseSelect(filter, eCategory); if (cs.ShowDialog() == System.Windows.Forms.DialogResult.OK) { currEvent = cs.ReturnEventID(); } else return; } } else { ulog.Message("Не удается определить мероприятие.", UserLogMessageLevel.Error); return; } actualEvents.Position = actualEvents.Find(currEventField , currEvent); if (ConfirmDeletion("Мероприятие")) try { actualEvents.RemoveCurrent(); ulog.Message("Запись мероприятия удалена."); SaveChanges(); PrepareSelected(); //восстановить положение скроллбара if (saveRow != 0 && saveRow < dgv1.Rows.Count) dgv1.FirstDisplayedScrollingRowIndex = saveRow; } catch (Exception ex) { MessageBox.Show(ex.Message); } }