protected void btndelete_Click(object sender, EventArgs e)
{
clsbooking objbook = new clsbooking();
objbook.TicketID = DropDownList1.SelectedItem.Value;
objbook.DeleteBooking();
}
protected void Button1_Click(object sender, EventArgs e)
{
clsbooking objbook = new clsbooking();
objbook.TicketID = txttid.Text;
objbook.UserID = txtuid.Text;
objbook.BusNo = txtbno.Text;
objbook.JourneyDate = txtjourneydate.Text;
objbook.No_Of_Passengers = int.Parse(txtnoofpassenger.Text);
objbook.Amount = float.Parse(txtamount.Text);
objbook.BookDate = txtbookdate.Text;
objbook.SeatNo = txtseatno.Text;
try
{
int result = objbook.InsertBooking();
if (result == 1)
{
lblmessage.Text = "Inserted Successfully";
lblmessage.ForeColor = Color.Green;
}
else if (result == 2)
{
lblmessage.Text = "TicketID " + objbook.TicketID + " Already Exits.Try again...";
}
}
catch (Exception err)
{
lblmessage.Text = err.Message.ToString();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int updated;
int rowupdate = e.RowIndex;
clsbooking obj = new clsbooking();
try
{
obj.BookingID = int.Parse((String)GridView1.Rows[rowupdate].Cells[1].Text);
obj.Delete();
obj.CarNo = (String)GridView1.Rows[rowupdate].Cells[5].Text;
String query = "update tblcar set Booked='" + "NO" + "' where CarNo='" + obj.CarNo + "'";
updated = dbobj.InsertUpdateDelete(query);
GridView1.EditIndex = -1;
//refresh the grid view
populateGridview();
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//check the page is posted or not
if (!this.IsPostBack)
{
clsbooking objbook = new clsbooking();
DataSet ds = objbook.getAllTicketID();
DropDownList1.DataSource = ds.Tables[0];
//the table fieldname as hidden
DropDownList1.DataValueField = "TicketID";
DropDownList1.DataBind();
}
}
private void populateGridview()
{
clsbooking objreg = new clsbooking();
try
{
DataSet ds = objreg.GetDetails();
// set the datasourec of the Gridview to
//dataset table
GridView1.DataSource = ds.Tables[0];
//call the databind method
GridView1.DataBind();
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int updated, result;
int rowupdate = e.RowIndex;
clsbooking obj = new clsbooking();
try
{
obj.BookingID = int.Parse((String)GridView1.Rows[rowupdate].Cells[1].Text);
DateTime cdt = DateTime.Now.AddHours(1);
String[] splitdate = GridView1.Rows[rowupdate].Cells[4].Text.Split('-');
String[] splittime = GridView1.Rows[rowupdate].Cells[5].Text.Split(':');
DateTime pdt = new DateTime(int.Parse(splitdate[2]), int.Parse(splitdate[1]), int.Parse(splitdate[0]), int.Parse(splittime[0]), int.Parse(splittime[1]), 00);
result = DateTime.Compare(pdt, cdt);
if (result > 0)
{
obj.Delete();
obj.CarNo = (String)GridView1.Rows[rowupdate].Cells[2].Text;
String query = "update tblcar set Booked='" + "NO" + "' where CarNo='" + obj.CarNo + "'";
updated = dbobj.InsertUpdateDelete(query);
//remove the edit mode
GridView1.EditIndex = -1;
//refresh the grid view
populateGridview();
}
else
{
lblmsg.Text = "Previous Bookings Cannot Be Cancelled";
}
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
