private void button6_Click(object sender, EventArgs e)
{
try
{
frmContactDetails myForm;
myForm = new frmContactDetails();
//Get contact types
myForm.edtType.Items.Clear();
myForm.dummyTypes.Clear();
tblContactType _tblContactType = new tblContactType();
DataTable dummy = new DataTable();
int retry = 5;
while (dummy.Rows.Count == 0 && retry > 0)
{
dummy = _tblContactType.GetData().Copy();
retry = retry - 1;
}
List <string> tmp = new List <string>();
foreach (DataRow ARec in dummy.Rows)
{
myForm.edtType.Items.Add(ARec["Description"].ToString());
myForm.dummyTypes.Add(ARec["Type"].ToString());
tmp.Add(ARec["IDX"].ToString());
}
myForm.edtType.SelectedIndex = 0;
myForm.ShowDialog();
if (myForm.DialogResult == DialogResult.OK)
{
if (myForm.dummyTypes[myForm.edtType.SelectedIndex] == "Number")
{
IDX = _tblClientContact.AddRec(dataGridView1.CurrentRow.Cells["IDX"].Value.ToString(), tmp[myForm.edtType.SelectedIndex], myForm.edt1.Text);
}
else
{
IDX = _tblClientContact.AddRec(dataGridView1.CurrentRow.Cells["IDX"].Value.ToString(), tmp[myForm.edtType.SelectedIndex], myForm.edt1.Text + "," + myForm.edt2.Text + "," + myForm.edt3.Text + ",");
}
DoRefresh();
foreach (DataGridViewRow ARec in dataGridView2.Rows)
{
if (ARec.Cells[0].Value.ToString() == IDX)
{
dataGridView2.CurrentCell = ARec.Cells[4];
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Select a row first");
}
}
private void DoEdit2()
{
try
{
frmContactDetails myForm;
myForm = new frmContactDetails();
//Get contact types
myForm.edtType.Items.Clear();
myForm.dummyTypes.Clear();
tblContactType _tblContactType = new tblContactType();
DataTable dummy = new DataTable();
int retry = 5;
while (dummy.Rows.Count == 0 && retry > 0)
{
dummy = _tblContactType.GetData().Copy();
retry = retry - 1;
}
List <string> tmp = new List <string>();
foreach (DataRow ARec in dummy.Rows)
{
myForm.edtType.Items.Add(ARec["Description"].ToString());
myForm.dummyTypes.Add(ARec["Type"].ToString());
tmp.Add(ARec["IDX"].ToString());
}
IDX = dataGridView2.CurrentRow.Cells["IDX"].Value.ToString();
int tmpIDX = -1;
for (int i = 0; i < tmp.Count; i++)
{
if (dataGridView2.CurrentRow.Cells["ContactTypeIDX"].Value.ToString() == tmp[i])
{
tmpIDX = i;
break;
}
}
myForm.edtType.SelectedIndex = tmpIDX;
if (myForm.dummyTypes[tmpIDX] == "Number")
{
myForm.edt1.Text = dataGridView2.CurrentRow.Cells["Contact"].Value.ToString();
}
else
{
string theData = dataGridView2.CurrentRow.Cells["Contact"].Value.ToString();
string A1 = theData.Substring(0, theData.IndexOf(","));
theData = theData.Substring(theData.IndexOf(",") + 1);
string A2 = theData.Substring(0, theData.IndexOf(","));
theData = theData.Substring(theData.IndexOf(",") + 1);
string A3 = theData.Substring(0, theData.IndexOf(","));
myForm.edt1.Text = A1;
myForm.edt2.Text = A2;
myForm.edt3.Text = A3;
}
myForm.ShowDialog();
if (myForm.DialogResult == DialogResult.OK)
{
if (myForm.dummyTypes[tmpIDX] == "Number")
{
IDX = _tblClientContact.EditRec(IDX, dataGridView1.CurrentRow.Cells["IDX"].Value.ToString(), tmp[myForm.edtType.SelectedIndex], myForm.edt1.Text);
}
else
{
IDX = _tblClientContact.EditRec(IDX, dataGridView1.CurrentRow.Cells["IDX"].Value.ToString(), tmp[myForm.edtType.SelectedIndex], myForm.edt1.Text + "," + myForm.edt2.Text + "," + myForm.edt3.Text + ",");
}
DoRefresh();
foreach (DataGridViewRow ARec in dataGridView2.Rows)
{
if (ARec.Cells[0].Value.ToString() == IDX)
{
dataGridView2.CurrentCell = ARec.Cells[4];
}
}
}
}
catch
{
MessageBox.Show("Select a row first");
}
}
