protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Bus_Management_Client.ServiceReference1.Service1Client pr = new Bus_Management_Client.ServiceReference1.Service1Client("BasicHttpBinding_IService1");
int ID = (int)e.Keys["Id"];
Ticket t = new Ticket();
string c_name = (string)e.NewValues["c_name"];
string phone_no = (string)e.NewValues["phone_no"];
string c_to = (string)e.NewValues["c_to"];
string c_from = (string)e.NewValues["c_from"];
DateTime dept_time = DateTime.Parse((string)e.NewValues["dept_time"]);
DateTime arrival_time = DateTime.Parse((string)e.NewValues["arrival_time"]);
int total_seat = int.Parse((string)e.NewValues["total_seat"]);
string seat_num = (string)e.NewValues["source"];
int amount = int.Parse((string)e.NewValues["amount"]);
Boolean status = bool.Parse((string)e.NewValues["status"]);
string email = (string)e.NewValues["email"];
t.ID = ID;
t.C_name = c_name;
t.Phone_no = phone_no;
t.C_to = c_to;
t.C_from = c_from;
t.Dept_time = dept_time;
t.Arrival_time = arrival_time;
t.Total_seat = total_seat;
t.Seat_num = seat_num;
t.Amount = amount;
t.Status = status;
t.Email = email;
pr.UpdateTicket(t);
GridView1.EditIndex = -1;
BindData();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Bus_Management_Client.ServiceReference1.Service1Client pr = new Bus_Management_Client.ServiceReference1.Service1Client("BasicHttpBinding_IService1");
int ID = (int)e.Keys["Id"];
Bus b = new Bus();
string source = (string)e.NewValues["source"];
string destination = (string)e.NewValues["destination"];
DateTime dept_time = DateTime.Parse((string)e.NewValues["dept_time"]);
DateTime arrival_time = DateTime.Parse((string)e.NewValues["arrival_time"]);
int bus_no = int.Parse((string)e.NewValues["bus_no"]);
int price = int.Parse((string)e.NewValues["price"]);
Label1.Text = "Hello";
b.ID = ID;
b.Source = source;
b.Destination = destination;
b.Dept_time = dept_time;
b.Arrival_time = arrival_time;
b.Bus_no = bus_no;
b.Price = price;
pr.UpdateBus(b);
GridView1.EditIndex = -1;
BindData();
}
private void BindData()
{
Bus_Management_Client.ServiceReference1.Service1Client bs = new Bus_Management_Client.ServiceReference1.Service1Client("BasicHttpBinding_IService1");
DataSet ds = bs.GetAllBus();
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Bus_Management_Client.ServiceReference1.Service1Client pr = new Bus_Management_Client.ServiceReference1.Service1Client("BasicHttpBinding_IService1");
int ID = (int)e.Keys["Id"];
pr.DeleteTicket(ID);
// Delete here the database record for the selected patientID
BindData();
}
protected void Button1_Click(object sender, EventArgs e)
{
Bus_Management_Client.ServiceReference1.Service1Client bm = new Bus_Management_Client.ServiceReference1.Service1Client("BasicHttpBinding_IService1");
Bus b = new ServiceReference1.Bus();
b.Source = TextBox1.Text;
b.Destination = TextBox2.Text;
b.Dept_time = DateTime.Parse(TextBox3.Text);
b.Arrival_time = DateTime.Parse(TextBox4.Text);
b.Bus_no = int.Parse(TextBox5.Text);
b.Price = int.Parse(TextBox6.Text);
bm.AddBus(b);
Response.Redirect("Update_delete_bus.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
Bus_Management_Client.ServiceReference1.Service1Client bm = new Bus_Management_Client.ServiceReference1.Service1Client("BasicHttpBinding_IService1");
Ticket t = new ServiceReference1.Ticket();
t.C_name = TextBox1.Text;
t.Phone_no = TextBox2.Text;
t.C_to = TextBox3.Text;
t.C_from = TextBox4.Text;
t.Dept_time = DateTime.Parse(TextBox5.Text);
t.Arrival_time = DateTime.Parse(TextBox6.Text);
t.Total_seat = int.Parse(TextBox7.Text);
t.Seat_num = TextBox8.Text;
t.Email = TextBox9.Text;
t.Status = true;
t.Amount = int.Parse(TextBox10.Text);
bm.AddTicket(t);
Response.Redirect("Payment.aspx");
}
private void BindData()
{
Bus_Management_Client.ServiceReference1.Service1Client bs = new Bus_Management_Client.ServiceReference1.Service1Client("BasicHttpBinding_IService1");
string email = TextBox1.Text;
Console.WriteLine(email);
if (email == "" || email == null)
{
Console.WriteLine("Email is null");
}
else
{
Console.WriteLine("Email is non null");
DataSet ds = bs.GetCustTicket(email);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
}
