C# (CSharp) SqlStatesProvider Examples

Example #1

File: StatesManager.cs Project: anam/gp-HO

 public static States GetStatesByStateID(int StateID)
 {
     States states = new States();
     SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();
     states = sqlStatesProvider.GetStatesByStateID(StateID);
     return states;
 }

Example #2

File: StatesManager.cs Project: anam/gp-HO

 public static DataSet GetDropDownListAllStates()
 {
     DataSet statess = new DataSet();
     SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();
     statess = sqlStatesProvider.GetDropDownLisAllStates();
     return statess;
 }

Example #3

File: StatesManager.cs Project: anam/abs

    public static States GetStatesByStateID(int StateID)
    {
        States            states            = new States();
        SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();

        states = sqlStatesProvider.GetStatesByStateID(StateID);
        return(states);
    }

Example #4

File: StatesManager.cs Project: anam/abs

    public static DataSet  GetDropDownListAllStates()
    {
        DataSet           statess           = new DataSet();
        SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();

        statess = sqlStatesProvider.GetDropDownLisAllStates();
        return(statess);
    }

Example #5

File: StatesManager.cs Project: anam/gp-HO

 public static void LoadStatesPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
 {
     int recordCount=0;
     int PageSize =  int.Parse(ddlPageSize.SelectedValue);
     SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();
     DataSet ds =  sqlStatesProvider.GetStatesPageWise(pageIndex, PageSize, out recordCount);
     gv.DataSource = ds;
     gv.DataBind();
      statessPaggination(rptPager,recordCount, pageIndex, PageSize);
 }

Example #6

File: StatesManager.cs Project: anam/abs

    public static void LoadStatesPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
    {
        int recordCount = 0;
        int PageSize    = int.Parse(ddlPageSize.SelectedValue);
        SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();
        DataSet           ds = sqlStatesProvider.GetStatesPageWise(pageIndex, PageSize, out recordCount);

        gv.DataSource = ds;
        gv.DataBind();
        statessPaggination(rptPager, recordCount, pageIndex, PageSize);
    }

Example #7

File: StatesManager.cs Project: anam/abs

    public static bool DeleteStates(int statesID)
    {
        SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();

        return(sqlStatesProvider.DeleteStates(statesID));
    }

Example #8

File: StatesManager.cs Project: anam/abs

    public static bool UpdateStates(States states)
    {
        SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();

        return(sqlStatesProvider.UpdateStates(states));
    }

Example #9

File: StatesManager.cs Project: anam/abs

    public static int InsertStates(States states)
    {
        SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();

        return(sqlStatesProvider.InsertStates(states));
    }

Example #10

File: StatesManager.cs Project: anam/gp-HO

 public static bool UpdateStates(States states)
 {
     SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();
     return sqlStatesProvider.UpdateStates(states);
 }

Example #11

File: StatesManager.cs Project: anam/gp-HO

 public static int InsertStates(States states)
 {
     SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();
     return sqlStatesProvider.InsertStates(states);
 }

Example #12

File: StatesManager.cs Project: anam/gp-HO

 public static bool DeleteStates(int statesID)
 {
     SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();
     return sqlStatesProvider.DeleteStates(statesID);
 }