C# (CSharp) SqlTourStatusProvider Examples

Example #1

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

 public static DataSet GetDropDownListAllTourStatus()
 {
     DataSet tourStatuss = new DataSet();
     SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();
     tourStatuss = sqlTourStatusProvider.GetDropDownLisAllTourStatus();
     return tourStatuss;
 }

Example #2

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

 public static TourStatus GetTourStatusByTourStatusID(int TourStatusID)
 {
     TourStatus tourStatus = new TourStatus();
     SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();
     tourStatus = sqlTourStatusProvider.GetTourStatusByTourStatusID(TourStatusID);
     return tourStatus;
 }

Example #3

    public static TourStatus GetTourStatusByTourStatusID(int TourStatusID)
    {
        TourStatus            tourStatus            = new TourStatus();
        SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();

        tourStatus = sqlTourStatusProvider.GetTourStatusByTourStatusID(TourStatusID);
        return(tourStatus);
    }

Example #4

    public static DataSet  GetDropDownListAllTourStatus()
    {
        DataSet tourStatuss = new DataSet();
        SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();

        tourStatuss = sqlTourStatusProvider.GetDropDownLisAllTourStatus();
        return(tourStatuss);
    }

Example #5

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

 public static void LoadTourStatusPage(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);
     SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();
     DataSet ds =  sqlTourStatusProvider.GetTourStatusPageWise(pageIndex, PageSize, out recordCount);
     gv.DataSource = ds;
     gv.DataBind();
      tourStatussPaggination(rptPager,recordCount, pageIndex, PageSize);
 }

Example #6

    public static void LoadTourStatusPage(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);
        SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();
        DataSet ds = sqlTourStatusProvider.GetTourStatusPageWise(pageIndex, PageSize, out recordCount);

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

Example #7

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

 public static bool UpdateTourStatus(TourStatus tourStatus)
 {
     SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();
     return sqlTourStatusProvider.UpdateTourStatus(tourStatus);
 }

Example #8

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

 public static int InsertTourStatus(TourStatus tourStatus)
 {
     SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();
     return sqlTourStatusProvider.InsertTourStatus(tourStatus);
 }

Example #9

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

 public static bool DeleteTourStatus(int tourStatusID)
 {
     SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();
     return sqlTourStatusProvider.DeleteTourStatus(tourStatusID);
 }

Example #10

    public static bool DeleteTourStatus(int tourStatusID)
    {
        SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();

        return(sqlTourStatusProvider.DeleteTourStatus(tourStatusID));
    }

Example #11

    public static bool UpdateTourStatus(TourStatus tourStatus)
    {
        SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();

        return(sqlTourStatusProvider.UpdateTourStatus(tourStatus));
    }

Example #12

    public static int InsertTourStatus(TourStatus tourStatus)
    {
        SqlTourStatusProvider sqlTourStatusProvider = new SqlTourStatusProvider();

        return(sqlTourStatusProvider.InsertTourStatus(tourStatus));
    }