private void searchDash_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 8)
{
//MessageBox.Show("Seat " + dataTable.Rows[e.RowIndex][4]+"\nAvailable seat "+ dataTable.Rows[e.RowIndex][6]);
if (Convert.ToInt32(dataTable.Rows[e.RowIndex][4].ToString()) == Convert.ToInt32(dataTable.Rows[e.RowIndex][6].ToString()))
{
AdminSearchDashRepo adminSearchDashRepo = new AdminSearchDashRepo();
adminSearchDashRepo.deleteSchedule(Convert.ToInt32(dataTable.Rows[e.RowIndex][0].ToString()));
MessageBox.Show(" Train Schedule has been deleted !");
this.getDashBoardData();
}
else
{
MessageBox.Show("\tMetro Rail Ticket manageent System\n\n Schedule can't be deleted ! \n Minimum 1 ticket has been sold ! ");
}
}
}
public void getDashBoardData()
{
AdminSearchDashRepo adminSearchDashRepo = new AdminSearchDashRepo();
SqlDataAdapter sqlDataAdapter = adminSearchDashRepo.getSearchDash(searchTrainName, searchDate, searchTime);
sqlDataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
searchDash.AutoGenerateColumns = false;
searchDash.DataSource = dataTable;
searchDash.Refresh();
}
else
{
searchDash.Visible = false;
notfoundLabel.Visible = true;
}
/*searchDash.AutoGenerateColumns = false;
* searchDash.DataSource = ds;
* searchDash.Refresh();*/
}
