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 DataTable ScheduleFinal()
{
viewSchedule obj1 = new viewSchedule();
MasterBAL obj = new MasterBAL();
DataTable dt = obj.finalScheduleDetail();
return(dt);
}
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;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes" && txtCost.Text != "" && txtRouteId.Text != "")
{
addRouteBE obj = new addRouteBE();
obj.route_id = txtRouteId.Text;
obj.from = drpFrom.SelectedItem.Value;
obj.to = drpTo.SelectedItem.Value;
obj.cost = Convert.ToInt32(txtCost.Text);
MasterBAL obj1 = new MasterBAL();
int error = obj1.BalAddRoute(obj);
if (error == 1)
{
string script = "alert('Route Added Successfully');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true);
txtRouteId.Text = "";
txtCost.Text = "";
drpFrom.SelectedIndex = 0;
drpTo.SelectedIndex = 0;
}
else
{
string script = "alert('Route Already Exists!!!');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true);
txtRouteId.Text = "";
txtCost.Text = "";
drpFrom.SelectedIndex = 0;
drpTo.SelectedIndex = 0;
}
}
else
{
string script = "alert('Fill All Fields!!!');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true);
txtRouteId.Text = "";
txtCost.Text = "";
drpFrom.SelectedIndex = 0;
drpTo.SelectedIndex = 0;
}
}
private void BindSymptom()
{
DataTable dtSymptoms = new MasterBAL().GetSymptom();
rlbSymptomList.DataSource = dtSymptoms;
rlbSymptomList.DataTextField = "Symptom";
rlbSymptomList.DataValueField = "SymptomId";
rlbSymptomList.DataBind();
rcbSymptomList.DataSource = dtSymptoms;
rcbSymptomList.DataTextField = "Symptom";
rcbSymptomList.DataValueField = "SymptomId";
rcbSymptomList.DataBind();
rcbSymptomList.Items.Insert(0, new RadComboBoxItem("Select Symptom", "0"));
rcbSymptomList.SelectedIndex = 0;
SortSymptom();
}
private void BindDiagnosis()
{
DataTable dtDiagnosis = new MasterBAL().GetDiagnosis();
rlbDiagnosisList.DataSource = dtDiagnosis;
rlbDiagnosisList.DataTextField = "Diagnosis";
rlbDiagnosisList.DataValueField = "DiagnosisId";
rlbDiagnosisList.DataBind();
rcbDiagnosisList.DataSource = dtDiagnosis;
rcbDiagnosisList.DataTextField = "Diagnosis";
rcbDiagnosisList.DataValueField = "DiagnosisId";
rcbDiagnosisList.DataBind();
rcbDiagnosisList.Items.Insert(0, new RadComboBoxItem("Select Diagnosis", "0"));
rcbDiagnosisList.SelectedIndex = 0;
SortDiagnosis();
}
