private void gridinvoice_CellValueChanged(object sender, DevComponents.DotNetBar.SuperGrid.GridCellValueChangedEventArgs e)
{
if (e.GridCell.ColumnIndex == gridinvoice.PrimaryGrid.Columns["gridcolno"].ColumnIndex)
{
String search = String.Format("{0}-{1}", gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolsdrrno"].ColumnIndex).Value.ToString(), gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinv"].ColumnIndex).Value.ToString());
if (Convert.ToBoolean(e.NewValue))
{
if (!_invoice.ContainsKey(search))
{
List <String> details = new List <string>();
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolsdrrno"].ColumnIndex).Value.ToString());
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinv"].ColumnIndex).Value.ToString());
details.Add("0");
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinvdate"].ColumnIndex).Value.ToString());
details.Add("");
details.Add("");
details.Add("");
details.Add("");
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolzone"].ColumnIndex).Value.ToString());
details.Add("0");
_invoice.Add(search, details);
}
}
else
{
if (_invoice.ContainsKey(search))
{
_invoice.Remove(search);
}
}
}
}
private void gridinvoice_CellValueChanged(object sender, DevComponents.DotNetBar.SuperGrid.GridCellValueChangedEventArgs e)
{
if (e.GridCell.ColumnIndex == gridinvoice.PrimaryGrid.Columns["gridcolno"].ColumnIndex)
{
if (Convert.ToBoolean(e.NewValue))
{
if (!_invoice.ContainsKey(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinvno"].ColumnIndex).Value.ToString()))
{
List <String> details = new List <string>();
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinvno"].ColumnIndex).Value.ToString());
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["invoice_date"].ColumnIndex).Value.ToString());
details.Add("0");
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolcust"].ColumnIndex).Value.ToString());
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolamt"].ColumnIndex).Value.ToString());
details.Add("0");
details.Add("0");
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolamt"].ColumnIndex).Value.ToString());
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolindex"].ColumnIndex).Value.ToString());
details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolzone"].ColumnIndex).Value.ToString());
details.Add("C");
_invoice.Add(details[0], details);
}
}
else
{
if (_invoice.ContainsKey(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinvno"].ColumnIndex).Value.ToString()))
{
_invoice.Remove(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinvno"].ColumnIndex).Value.ToString());
}
}
}
}
/// <summary>
/// Handles invocation of CellValueChanged events
/// </summary>
internal void DoCellValueChangedEvent(
GridCell gridCell, object oldValue, object newValue, DataContext context)
{
if (CellValueChanged != null)
{
GridCellValueChangedEventArgs ev = new
GridCellValueChangedEventArgs(gridCell.GridPanel, gridCell, oldValue, newValue, context);
CellValueChanged(this, ev);
}
}
private void gItems_CellValueChanged(object sender, GridCellValueChangedEventArgs e)
{
}
private void gInspectionFaults_CellValueChanged(object sender, GridCellValueChangedEventArgs e)
{
Program.SQL.AddParameter("id", Convert.ToInt32(grInspectionAnswer.Tag));
Program.SQL.AddParameter("fault", grInspectionAnswer.Cells[1].Value.ToString());
Program.SQL.AddParameter("priority", grInspectionAnswer.Cells[2].Value.ToString());
Program.SQL.AddParameter("resolved", grInspectionAnswer.Cells[3].Value.ToString());
string sResDate = "";
if (grInspectionAnswer.Cells[3].Value.ToString().ToLower() == "y")
{
sResDate = " AND resolveddate=@resolveddate";
Program.SQL.AddParameter("resolveddate", DateTime.Now);
}
Program.SQL.AddParameter("mod", DateTime.Now);
int iRes = Program.SQL.Update("UPDATE inspections_faults SET fault=@fault,priority=@priority,resolved=@resolved" + sResDate + " WHERE id=@id");
if (iRes < 1)
{
MessageBox.Show("The fault update failed. Please try again.", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
private void gInspectionAnswers_CellValueChanged(object sender, GridCellValueChangedEventArgs e)
{
if (!bInspectionScheduleChanged && grInspectionAnswer != null && grInspectionAnswer.Tag.ToString().All(char.IsDigit))
{
Program.SQL.AddParameter("id", Convert.ToInt32(grInspectionAnswer.Tag));
Program.SQL.AddParameter("answer", grInspectionAnswer.Cells[3].Value.ToString());
Program.SQL.AddParameter("mod", DateTime.Now);
int iRes = Program.SQL.Update("UPDATE inspections_answers SET answer=@answer,modified=@mod WHERE id=@id");
if (iRes < 1)
{
MessageBox.Show("The answer update failed. Please try again.", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
