public DataSet BAL_SYS_State_Select(SYS_State SYS_State, string mode)
    {
        DAL_SYS_State = new DataAccess();
        arrParameter  = new ArrayList();

        arrParameter.Add(new parameter("mode", mode));
        arrParameter.Add(new parameter("StateID", SYS_State.stateid));
        arrParameter.Add(new parameter("StateIDStr", SYS_State.stateidStr));
        arrParameter.Add(new parameter("CountryID", SYS_State.countryid));
        return(DAL_SYS_State.DAL_Select("SELECT_DELETE_SYS_State", arrParameter));
    }
    public int BAL_SYS_State_Delete(SYS_State SYS_State, string mode)
    {
        DAL_SYS_State = new DataAccess();
        arrParameter  = new ArrayList();

        arrParameter.Add(new parameter("mode", mode));
        arrParameter.Add(new parameter("StateID", SYS_State.stateid));
        arrParameter.Add(new parameter("StateIDStr", SYS_State.stateidStr));
        arrParameter.Add(new parameter("CountryID", SYS_State.countryid));
        arrParameter.Add(new parameter("IsActive", SYS_State.isactive));
        return(DAL_SYS_State.DAL_Delete_Return("SELECT_DELETE_SYS_State", arrParameter));
    }
    public int BAL_SYS_State_Update(SYS_State SYS_State, string mode)
    {
        DAL_SYS_State = new DataAccess();
        arrParameter  = new ArrayList();

        arrParameter.Add(new parameter("mode", mode));
        arrParameter.Add(new parameter("StateID", SYS_State.stateid));
        arrParameter.Add(new parameter("CountryID", SYS_State.countryid));
        arrParameter.Add(new parameter("State", SYS_State.state));
        arrParameter.Add(new parameter("CreatedBy", SYS_State.createdby));
        return(DAL_SYS_State.DAL_InsertUpdate_Return("Proc_SYS_StateInsertUpdate", arrParameter));
    }