public DataTable searchCity(addScheduleBE obj)
{
DAL.InsertBus obj1 = new DAL.InsertBus();
DataTable dt = obj1.selectCity(obj);
return(dt);
}
public DataTable findToBus(addScheduleBE obj)
{
DAL.InsertBus obj1 = new DAL.InsertBus();
DataTable dt = obj1.findToBus(obj);
return(dt);
}
public DataTable selectCity(addScheduleBE user)
{
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlCommand cmd = new SqlCommand("usp_SearchCity", con);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@from", user.from);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
try
{
return(dt);
}
catch
{
throw;
}
finally
{
con.Close();
con.Dispose();
}
}
public int newSchedule(addScheduleBE user)
{
string[] str = user.bus_name.Split('-');
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlCommand cmd = new SqlCommand("usp_InsertSchedule", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@schedule_id", user.schedule_id);
cmd.Parameters.AddWithValue("@bus_type", str[1]);
cmd.Parameters.AddWithValue("@name", str[0]);
cmd.Parameters.AddWithValue("@start", user.from);
cmd.Parameters.AddWithValue("@to", user.to);
cmd.Parameters.AddWithValue("@time", user.time);
try
{
cmd.ExecuteNonQuery();
return(1);
}
catch
{
return(-1);
throw;
}
finally
{
con.Close();
con.Dispose();
}
}
public DataTable fillforcity()
{
addScheduleBE obj = new addScheduleBE();
MasterBAL obj1 = new MasterBAL();
DataTable dt = obj1.searchCity(obj);
return(dt);
}
public DataTable fillforbus()
{
addScheduleBE obj1 = new addScheduleBE();
MasterBAL obj = new MasterBAL();
DataTable dt = obj.findbusType();
return(dt);
}
public int BalAddSchedule(addScheduleBE a)
{
DAL.InsertBus obj = new DAL.InsertBus();
//int error=obj.
int error = obj.newSchedule(a);
return(error);
}
public DataTable fillforcitycorre(string city)
{
addScheduleBE obj = new addScheduleBE();
obj.from = city;
MasterBAL obj1 = new MasterBAL();
DataTable dt = obj1.findToBus(obj);
return(dt);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes" && txtScheduleID.Text != "" && txtTime.Text != "")
{
addScheduleBE obj = new addScheduleBE();
obj.schedule_id = txtScheduleID.Text;
obj.bus_name = drpBusName.SelectedItem.Value;
obj.from = drpFrom.SelectedItem.Value;
obj.to = drpTo.SelectedItem.Value;
obj.time = txtTime.Text;
MasterBAL obj1 = new MasterBAL();
int error = obj1.BalAddSchedule(obj);
if (error == 1)
{
string script = "alert('Schedule Added Successfully');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true);
txtScheduleID.Text = "";
txtTime.Text = "";
drpBusName.SelectedIndex = 0;
drpFrom.SelectedIndex = 0;
drpTo.SelectedIndex = 0;
}
else
{
string script = "alert('Schedule Already Exists!!');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true);
txtScheduleID.Text = "";
txtTime.Text = "";
drpBusName.SelectedIndex = 0;
drpFrom.SelectedIndex = 0;
drpTo.SelectedIndex = 0;
}
}
else
{
string script = "alert('Fill All Fields!!!');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true);
txtScheduleID.Text = "";
txtTime.Text = "";
drpBusName.SelectedIndex = 0;
drpFrom.SelectedIndex = 0;
drpTo.SelectedIndex = 0;
}
}
