public int addTraindetails(TrainBO tbo)
{
int retTrainId = 0;
try
{
con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("sp_insertTrainMaster_MadhusudhanB", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TrainId", tbo.TrainId);
cmd.Parameters.AddWithValue("@TrainName", tbo.TrainName);
cmd.Parameters.AddWithValue("@Source", tbo.Source);
cmd.Parameters.AddWithValue("@Destination", tbo.Destination);
cmd.Parameters.AddWithValue("@TicketFare", tbo.TicketFare);
SqlParameter para = new SqlParameter("@TrainIdout", SqlDbType.Int);
para.Direction = ParameterDirection.Output;
cmd.Parameters.Add(para);
con.Open();
int res = cmd.ExecuteNonQuery();
if (res > 0)
{
retTrainId = Convert.ToInt32(cmd.Parameters["@TrainIdout"].Value);
}
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
return(retTrainId);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandArgument != null)
{
if (e.CommandName.ToLower() == "cmdedit")
{
Response.Redirect("addtraindetails.aspx?id=" + e.CommandArgument);
}
else
{
TrainBO tbo = new TrainBO();
int d = Convert.ToInt32(e.CommandArgument);
TrainBLL tbll = new TrainBLL();
tbll.delete(d);
}
}
}
public DataSet viewbyid(TrainBO tbo)
{
try
{
DataSet ds = new DataSet();
con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("sp_viewTrainMaster_MadhusudhanBbyid", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TrainId", tbo.TrainId);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
return(ds);
}
catch (Exception)
{
throw;
}
}
//BOOKING
public int bookticket(TrainBO tbo)
{
int retbookId = 0;
try
{
con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("sp_insertTrainBooking_MadhusudhanB", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BookingId", tbo.BookId);
cmd.Parameters.AddWithValue("@TrainId", tbo.TrainId);
cmd.Parameters.AddWithValue("@UserName", tbo.UserName);
cmd.Parameters.AddWithValue("@Email", tbo.Email);
cmd.Parameters.AddWithValue("@contactNo", tbo.ContactNo);
cmd.Parameters.AddWithValue("@NoOfTicket", tbo.NoOftickets);
cmd.Parameters.AddWithValue("@TicketAmount", tbo.TicketAmount);
SqlParameter param = new SqlParameter("@BookingIdout", SqlDbType.Int);
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
con.Open();
int res = cmd.ExecuteNonQuery();
if (res > 0)
{
retbookId = Convert.ToInt32(cmd.Parameters["@BookingIdout"].Value);
}
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
return(retbookId);
}
//book
public int bookticket(TrainBO tbo)
{
return(tdal.bookticket(tbo));
}
public DataSet viewbyid(TrainBO tbo)
{
return(tdal.viewbyid(tbo));
}
public int addTraindetails(TrainBO tbo)
{
return(tdal.addTraindetails(tbo));
}
