private void cellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString().Equals(_OldValue.ToString()))
{
return;
}
DataSetISpaData datas = new DataSetISpaData();
Console.WriteLine(_CurrentTitle);
String[] arr = new String[dgv.Rows[e.RowIndex].Cells.Count];
for (int i = 0; i < dgv.Rows[e.RowIndex].Cells.Count; i++)
{
arr[i] = dgv.Rows[e.RowIndex].Cells[i].Value.ToString();
}
int posKey;
String primaryKey;
int[] posKeys;
String[] primaryKeys;
switch (_CurrentTitle)
{
case "agenda":
// pos 0 1 et 2 Sont les valeurs de la cle primaire
primaryKeys = new String[3];
primaryKeys[0] = arr[0];
primaryKeys[1] = arr[1];
primaryKeys[2] = arr[2];
for (int i = 0; i < primaryKeys.Length; i++)
{
if (i == _OldValuePos)
{
primaryKeys[i] = _OldValue.ToString();
}
}
DataSetISpaDataTableAdapters.VW_AGENDATableAdapter tableAdapter1 = new DataSetISpaDataTableAdapters.VW_AGENDATableAdapter();
DateTime date = Convert.ToDateTime(arr[0]);
DateTime time = Convert.ToDateTime(arr[1]);
DateTime dateKey = Convert.ToDateTime(primaryKeys[0]);
DateTime timeKey = Convert.ToDateTime(primaryKeys[1]);
tableAdapter1.UpdateQuery(date, time, arr[2].ToString(), arr[3].ToString(), dateKey, timeKey, primaryKeys[2].ToString());
Console.WriteLine("old value " + _OldValue);
Console.WriteLine("new value " + dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value);
break;
case "clients":
// pos 3 est la valeur de la cle primaire
posKey = 3;
primaryKey = arr[posKey];
if (_OldValuePos == posKey)
{
primaryKey = _OldValue.ToString();
}
DataSetISpaDataTableAdapters.VW_CLIENTTableAdapter tableAdapte2 = new DataSetISpaDataTableAdapters.VW_CLIENTTableAdapter();
tableAdapte2.UpdateQuery(arr[0], arr[1], Convert.ToDateTime(arr[2]), arr[3], arr[4], primaryKey.ToString());
Console.WriteLine("old value " + _OldValue);
Console.WriteLine("new value " + dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value);
break;
case "products":
// pos 0 et 2 Sont les valeurs de la cle primaire
primaryKeys = new String[3];
primaryKeys[0] = arr[0];
primaryKeys[2] = arr[2];
for (int i = 0; i < primaryKeys.Length; i++)
{
if (i == _OldValuePos)
{
primaryKeys[i] = _OldValue.ToString();
}
}
DataSetISpaDataTableAdapters.VW_PRODUITTableAdapter tableAdapter3 = new DataSetISpaDataTableAdapters.VW_PRODUITTableAdapter();
tableAdapter3.UpdateQuery(arr[0], arr[1], arr[2], arr[3].ToString().Trim(), primaryKeys[0].ToString(), primaryKeys[2].ToString());
Console.WriteLine("old value " + _OldValue);
Console.WriteLine("new value " + dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value);
break;
case "factures":
// pos 0 1 et 2 Sont les valeurs de la cle primaire
primaryKeys = new String[3];
primaryKeys[0] = arr[0];
primaryKeys[1] = arr[1];
primaryKeys[2] = arr[2];
for (int i = 0; i < primaryKeys.Length; i++)
{
if (i == _OldValuePos)
{
primaryKeys[i] = _OldValue.ToString();
}
}
DateTime date2 = Convert.ToDateTime(arr[0]);
DateTime time2 = Convert.ToDateTime(arr[1]);
DateTime dateKey2 = Convert.ToDateTime(primaryKeys[0]);
DateTime timeKey2 = Convert.ToDateTime(primaryKeys[1]);
DataSetISpaDataTableAdapters.VW_FACTURETableAdapter tableAdapte4 = new DataSetISpaDataTableAdapters.VW_FACTURETableAdapter();
tableAdapte4.UpdateQuery(date2, time2, arr[2].ToString(), arr[3].ToString(), arr[4].ToString(), Convert.ToDecimal(arr[5]), dateKey2, timeKey2, primaryKeys[2].ToString());
Console.WriteLine("old value " + _OldValue);
Console.WriteLine("new value " + dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value);
break;
case "users":
// pos 0 est la valeur de la cle primaire
posKey = 0;
primaryKey = arr[posKey];
if (_OldValuePos == posKey)
{
primaryKey = _OldValue.ToString();
}
DataSetISpaDataTableAdapters.VW_USERTableAdapter tableAdapter5 = new DataSetISpaDataTableAdapters.VW_USERTableAdapter();
tableAdapter5.UpdateQuery(arr[0], arr[1], arr[2], Convert.ToDecimal(arr[3]), primaryKey.ToString());
Console.WriteLine("old value " + _OldValue);
Console.WriteLine("new value " + dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value);
break;
}
}
