private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == 4)
{
dataGridView1.Rows.RemoveAt(e.RowIndex);
cr c = new TMS.cr();
c.no = Convert.ToInt32(dataGridView1[0, e.RowIndex].Value);
bool sucess = c.delete();
if (sucess)
{
MessageBox.Show("DELETED SUCESSFULY", "DELETE");
}
else
{
MessageBox.Show("DELETION UNSUCESSFULL", "DELETE");
}
}
}
catch (Exception x)
{
MessageBox.Show("Transaction Does Not Exist", "Error");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
cr c = new TMS.cr();
bool sucess = false;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
c.no = Convert.ToInt32(dataGridView1[0, i].Value);
c.name = dataGridView1[1, i].Value.ToString();
c.descri = dataGridView1[2, i].Value.ToString();
c.date = dateTimePicker1.Text;
c.amt = Convert.ToInt32(dataGridView1[3, i].Value);
sucess = c.insert();
}
int start = Convert.ToInt32(textBox1.Text);
int end = counter - 1 + start;
c.points(start, end);
if (sucess)
{
MessageBox.Show("INSERTION SUCESSFUL", "inerted");
}
clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button3_Click(object sender, EventArgs e)
{
cr c = new TMS.cr();
c.no = Convert.ToInt32(textBox1.Text.ToString());
bool sucess = c.delete();
if (sucess)
{
MessageBox.Show("DELETED SUCESSFULY", "DELETE");
}
else
{
MessageBox.Show("DELETION UNSUCESSFULL", "DELETE");
}
clear();
}
