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(); }