Esempio n. 1
0
 public bool districtInsert(districtBO districtBO)
 {
     try
     {
         if (con.State == ConnectionState.Closed)
         {
             con.Open();
         }
         query = "districtInsert";
         cmd = new SqlCommand(query, con);
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.Parameters.AddWithValue("@stateId", districtBO.stateId);
         cmd.Parameters.AddWithValue("@districtName", districtBO.districtName);
         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();
         }
     }
 }
Esempio n. 2
0
 public void districtUpdate(districtBO districtBO)
 {
     try
     {
         if (con.State == ConnectionState.Closed)
         {
             con.Open();
         }
         query           = "districtUpdate";
         cmd             = new SqlCommand(query, con);
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.Parameters.AddWithValue("@stateId", districtBO.stateId);
         cmd.Parameters.AddWithValue("@districtId", districtBO.districtId);
         cmd.Parameters.AddWithValue("@districtName", districtBO.districtName);
         cmd.ExecuteNonQuery();
     }
     catch
     {
         throw;
     }
     finally
     {
         if (con.State == ConnectionState.Open)
         {
             con.Close();
         }
     }
 }
    public void districtUpdate(districtBO districtBO)
    {
        try
        {
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            query = "districtUpdate";
            cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@stateId", districtBO.stateId);
            cmd.Parameters.AddWithValue("@districtId", districtBO.districtId);
            cmd.Parameters.AddWithValue("@districtName", districtBO.districtName);
            cmd.ExecuteNonQuery();

        }
        catch
        {
            throw;
        }
        finally
        {
            if (con.State == ConnectionState.Open)
            {
                con.Close();
            }
        }
    }
Esempio n. 4
0
 public bool districtInsert(districtBO districtBO)
 {
     try
     {
         if (con.State == ConnectionState.Closed)
         {
             con.Open();
         }
         query           = "districtInsert";
         cmd             = new SqlCommand(query, con);
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.Parameters.AddWithValue("@stateId", districtBO.stateId);
         cmd.Parameters.AddWithValue("@districtName", districtBO.districtName);
         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();
         }
     }
 }
Esempio n. 5
0
 public void districtUpdate(districtBO districtBO)
 {
     try
     {
         districtDAL.districtUpdate(districtBO);
     }
     catch
     {
         throw;
     }
     finally
     {
     }
 }
Esempio n. 6
0
 public bool districtInsert(districtBO districtBO)
 {
     try
     {
         return(districtDAL.districtInsert(districtBO));
     }
     catch
     {
         throw;
     }
     finally
     {
     }
 }
    public void districtUpdate(districtBO districtBO)
    {
        try
        {
            districtDAL.districtUpdate(districtBO);
        }
        catch
        {
            throw;
        }
        finally
        {

        }
    }
    public bool districtInsert(districtBO districtBO)
    {
        try
        {
            return districtDAL.districtInsert(districtBO);
        }
        catch
        {
            throw;
        }
        finally
        {

        }
    }