Bus IService1.GetBus(int id)
{
SqlConnection cnn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Online_Bus_Ticket_System;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "select * from Bus where id=@id";
SqlParameter p = new SqlParameter("@id", id);
cmd.Parameters.Add(p);
cnn.Open();
SqlDataReader reader = cmd.ExecuteReader();
Bus bs = new Bus();
if (reader.Read())
{
bs.ID = reader.GetInt32(0);
bs.Source = reader.GetString(1);
bs.Destination = reader.GetString(2);
bs.Dept_time = reader.GetDateTime(3);
bs.Arrival_time = reader.GetDateTime(4);
bs.Bus_no = reader.GetInt32(5);
bs.Price = reader.GetInt32(6);
}
else
{
NotFoundFolt nf = new NotFoundFolt();
nf.Exception = "No record found with given ID";
throw new FaultException <NotFoundFolt>(nf);
}
reader.Close();
cnn.Close();
return(bs);
}
Bus IService1.UpdateBus(Bus b)
{
SqlConnection cnn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Online_Bus_Ticket_System;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "update Bus set source=@source,destination=@destination,dept_time=@dept_time,arrival_time=@arrival_time,bus_no=@bus_no,price=@price where id=@id";
SqlParameter para6 = new SqlParameter("@id", b.ID);
SqlParameter para = new SqlParameter("@source", b.Source);
SqlParameter para1 = new SqlParameter("@destination", b.Destination);
SqlParameter para2 = new SqlParameter("@dept_time", b.Dept_time);
SqlParameter para3 = new SqlParameter("@arrival_time", b.Arrival_time);
SqlParameter para4 = new SqlParameter("@bus_no", b.Bus_no);
SqlParameter para5 = new SqlParameter("@price", b.Price);
cmd.Parameters.Add(para);
cmd.Parameters.Add(para1);
cmd.Parameters.Add(para2);
cmd.Parameters.Add(para3);
cmd.Parameters.Add(para4);
cmd.Parameters.Add(para5);
cmd.Parameters.Add(para6);
cnn.Open();
int reader = cmd.ExecuteNonQuery();
cnn.Close();
if (reader == 0)
{
NotFoundFolt nf = new NotFoundFolt();
nf.Exception = "Some issue found in updating the product please try after some time!!";
throw new FaultException <NotFoundFolt>(nf);
}
return(b);
}
Ticket IService1.UpdateTicket(Ticket t)
{
SqlConnection cnn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Online_Bus_Ticket_System;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "update Ticket set c_name=@c_name,phone_no=@phone_no,c_to=@c_to,c_from=@c_from,dept_time=@dept_time,arrival_time=@arrival_time,total_seat=@total_seat,seat_num=@seat_num,amount=@amount,status=@status,email=@email where id=@id";
SqlParameter para11 = new SqlParameter("@id", t.ID);
SqlParameter para = new SqlParameter("@c_name", t.C_name);
SqlParameter para1 = new SqlParameter("@phone_no", t.Phone_no);
SqlParameter para2 = new SqlParameter("@c_to", t.C_to);
SqlParameter para3 = new SqlParameter("@c_from", t.C_from);
SqlParameter para4 = new SqlParameter("@dept_time", t.Dept_time);
SqlParameter para5 = new SqlParameter("@arrival_time", t.Arrival_time);
SqlParameter para6 = new SqlParameter("@total_seat", t.Total_seat);
SqlParameter para7 = new SqlParameter("@seat_num", t.Seat_num);
SqlParameter para8 = new SqlParameter("@amount", t.Amount);
SqlParameter para9 = new SqlParameter("@status", t.Status);
SqlParameter para10 = new SqlParameter("@email", t.Email);
cmd.Parameters.Add(para11);
cmd.Parameters.Add(para);
cmd.Parameters.Add(para1);
cmd.Parameters.Add(para2);
cmd.Parameters.Add(para3);
cmd.Parameters.Add(para4);
cmd.Parameters.Add(para5);
cmd.Parameters.Add(para6);
cmd.Parameters.Add(para7);
cmd.Parameters.Add(para8);
cmd.Parameters.Add(para9);
cmd.Parameters.Add(para10);
cnn.Open();
int reader = cmd.ExecuteNonQuery();
cnn.Close();
if (reader == 0)
{
NotFoundFolt nf = new NotFoundFolt();
nf.Exception = "Some issue found in updating the product please try after some time!!";
throw new FaultException <NotFoundFolt>(nf);
}
return(t);
}
bool IService1.DeleteBus(int id)
{
SqlConnection cnn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Online_Bus_Ticket_System;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "delete from Bus where id=@id";
SqlParameter para = new SqlParameter("@id", id);
cmd.Parameters.Add(para);
cnn.Open();
int reader = cmd.ExecuteNonQuery();
cnn.Close();
if (reader == 0)
{
NotFoundFolt nf = new NotFoundFolt();
nf.Exception = "No record found with given ID";
throw new FaultException <NotFoundFolt>(nf);
}
return(true);
}
Ticket IService1.GetTicket(int id)
{
SqlConnection cnn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Online_Bus_Ticket_System;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "select * from Ticket where id=@id";
SqlParameter p = new SqlParameter("@id", id);
cmd.Parameters.Add(p);
cnn.Open();
SqlDataReader reader = cmd.ExecuteReader();
Ticket tc = new Ticket();
if (reader.Read())
{
tc.ID = reader.GetInt32(0);
tc.C_name = reader.GetString(1);
tc.Phone_no = reader.GetString(2);
tc.C_to = reader.GetString(3);
tc.C_from = reader.GetString(4);
tc.Dept_time = reader.GetDateTime(5);
tc.Arrival_time = reader.GetDateTime(6);
tc.Total_seat = reader.GetInt32(7);
tc.Seat_num = reader.GetString(8);
tc.Amount = reader.GetInt32(9);
tc.Status = (bool)reader.GetSqlBoolean(10);
tc.Email = reader.GetString(11);
}
else
{
NotFoundFolt nf = new NotFoundFolt();
nf.Exception = "No record found with given ID";
throw new FaultException <NotFoundFolt>(nf);
}
reader.Close();
cnn.Close();
return(tc);
}