public int newBus(addBusBE user) { SqlConnection con = new SqlConnection(conn); con.Open(); SqlCommand cmd = new SqlCommand("usp_InsertBus", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@bus_id", user.bus_no); cmd.Parameters.AddWithValue("@name", user.bus_name); cmd.Parameters.AddWithValue("@bus_type", user.bus_type); try { cmd.ExecuteNonQuery(); return(1); } catch { return(-1); throw; } finally { con.Close(); con.Dispose(); } }
public int BalAddBus(addBusBE a) { DAL.InsertBus obj = new DAL.InsertBus(); int error = obj.newBus(a); return(error); }
protected void btnSubmit_Click(object sender, EventArgs e) { string confirmValue = Request.Form["confirm_value"]; if (confirmValue == "Yes" && txtBusID.Text != "" && txtBusName.Text != "") { addBusBE obj = new addBusBE(); obj.bus_no = txtBusID.Text; obj.bus_name = txtBusName.Text; obj.bus_type = drpBusType.SelectedItem.Value; MasterBAL obj1 = new MasterBAL(); int error = obj1.BalAddBus(obj); if (error == 1) { string script = "alert('Bus Added Successfully');"; Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true); txtBusID.Text = ""; txtBusName.Text = ""; drpBusType.SelectedIndex = 0; } else { string script = "alert('Bus Already Exists!!');"; Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true); txtBusID.Text = ""; txtBusName.Text = ""; drpBusType.SelectedIndex = 0; } } else { string script = "alert('Fill All Fields!!!');"; Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true); txtBusID.Text = ""; txtBusName.Text = ""; drpBusType.SelectedIndex = 0; } }