public void updateConstituency(constituencyBO constituencyBO)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
query = "constituencyUpdate";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@stateId", constituencyBO.StateId);
cmd.Parameters.AddWithValue("@constituencyId", constituencyBO.constituencyId);
cmd.Parameters.AddWithValue("@constituency", constituencyBO.constituency);
cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
con.Close();
}
}
public bool constituencyInsert(constituencyBO constituencyB0)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
query = "constituencyInsert";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@stateId", constituencyB0.StateId);
cmd.Parameters.AddWithValue("@constituency", constituencyB0.constituency);
SqlParameter message = cmd.Parameters.Add("@res", SqlDbType.Bit);
message.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return(bool.Parse(message.Value.ToString()));
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public bool constituencyInsert(constituencyBO constituencyB0)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
query = "constituencyInsert";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@stateId", constituencyB0.StateId);
cmd.Parameters.AddWithValue("@constituency", constituencyB0.constituency);
SqlParameter message = cmd.Parameters.Add("@res", SqlDbType.Bit);
message.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return (bool.Parse(message.Value.ToString()));
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public DataTable fetchMPBasedOnStateorConstituency(countryBO CountryBO, stateBO StateBO, constituencyBO constituencyBO)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
dap = new SqlDataAdapter("fetchMPBasedOnStateorConstituency", con);
dap.SelectCommand.CommandType = CommandType.StoredProcedure;
dap.SelectCommand.Parameters.AddWithValue("@countryId", CountryBO.countryId);
dap.SelectCommand.Parameters.AddWithValue("@stateId", StateBO.stateId);
dap.SelectCommand.Parameters.AddWithValue("@constituencyId", constituencyBO.constituencyId);
DataSet ds = new DataSet();
dap.Fill(ds, "tblMpDetails");
dap.Dispose();
return ds.Tables["tblMpDetails"];
}
catch
{
throw;
}
finally
{
con.Close();
}
}
public void constituencyIn(constituencyBO ConstituencyBO)
{
try
{
if (care.State == ConnectionState.Closed)
{
care.Open();
}
cmd = new SqlCommand("constituencyIn",care);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@constituency",ConstituencyBO.constituency);
cmd.Parameters.AddWithValue("@stateId", ConstituencyBO.StateId);
cmd.Parameters.AddWithValue("countryId", ConstituencyBO.countryId);
cmd.Parameters.AddWithValue("@partyId", ConstituencyBO.partyId);
cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
care.Close();
}
}
public DataTable fetchMPBasedOnStateorConstituency(countryBO CountryBO, stateBO StateBO, constituencyBO constituencyBO)
{
try
{
return mpDetailsDAL.fetchMPBasedOnStateorConstituency(CountryBO, StateBO, constituencyBO);
}
catch
{
throw;
}
finally
{ }
}
public void updateConstituency(constituencyBO ConstituencyBO)
{
try
{
ob.updateConstituency(ConstituencyBO);
}
catch
{
throw;
}
finally {
}
}
public bool constituencyInsert(constituencyBO constituencyBO)
{
try
{
return(ob.constituencyInsert(constituencyBO));
}
catch
{
throw;
}
finally
{
}
}
public bool constituencyInsert(constituencyBO constituencyBO)
{
try
{
return ob.constituencyInsert(constituencyBO);
}
catch
{
throw;
}
finally
{
}
}
public DataTable fetchMPBasedOnStateorConstituency(countryBO CountryBO, stateBO StateBO, constituencyBO constituencyBO)
{
try
{
return(mpDetailsDAL.fetchMPBasedOnStateorConstituency(CountryBO, StateBO, constituencyBO));
}
catch
{
throw;
}
finally
{ }
}
public void updateConstituency(constituencyBO constituencyBO)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
query = "constituencyUpdate";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@stateId", constituencyBO.StateId);
cmd.Parameters.AddWithValue("@constituencyId", constituencyBO.constituencyId);
cmd.Parameters.AddWithValue("@constituency", constituencyBO.constituency);
cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
con.Close();
}
}
public DataTable fetchMPBasedOnStateorConstituency(countryBO CountryBO, stateBO StateBO, constituencyBO constituencyBO)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
dap = new SqlDataAdapter("fetchMPBasedOnStateorConstituency", con);
dap.SelectCommand.CommandType = CommandType.StoredProcedure;
dap.SelectCommand.Parameters.AddWithValue("@countryId", CountryBO.countryId);
dap.SelectCommand.Parameters.AddWithValue("@stateId", StateBO.stateId);
dap.SelectCommand.Parameters.AddWithValue("@constituencyId", constituencyBO.constituencyId);
DataSet ds = new DataSet();
dap.Fill(ds, "tblMpDetails");
dap.Dispose();
return(ds.Tables["tblMpDetails"]);
}
catch
{
throw;
}
finally
{
con.Close();
}
}
public void constituencyIn(constituencyBO ConstituencyBO)
{
constituencyDAL.constituencyIn(ConstituencyBO);
}
public void updateConstituency(constituencyBO ConstituencyBO)
{
try
{
ob.updateConstituency(ConstituencyBO);
}
catch
{
throw;
}
finally {
}
}
