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; } }