public void insert(Add_stateBLL objectBLL)
{
try
{
int var = 0;
SqlCommand cmd = new SqlCommand("add_state", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@country", objectBLL.Country);
cmd.Parameters.AddWithValue("@state_name", objectBLL.State_name);
con.Open();
var = cmd.ExecuteNonQuery();
if (var > 0)
{
objectBLL.Status = true;
}
}
catch (Exception ex)
{
String msg = ex.Message;
}
finally
{
con.Close();
con.Dispose();
}
}
public void insert(Add_stateBLL objectBLL)
{
objectDLL.insert(objectBLL);
}