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