public static HR_EmployeeOverTimePackage GetHR_OverTimePackageByOverTimePackageID(int OverTimePackageID)
 {
     HR_EmployeeOverTimePackage hR_EmployeeOverTimePackage = new HR_EmployeeOverTimePackage();
     SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
     hR_EmployeeOverTimePackage = sqlHR_EmployeeOverTimePackageProvider.GetHR_EmployeeOverTimePackageByOverTimePackageID(OverTimePackageID);
     return hR_EmployeeOverTimePackage;
 }
 public static DataSet GetDropDownListAllHR_EmployeeOverTimePackage()
 {
     DataSet hR_EmployeeOverTimePackages = new DataSet();
     SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
     hR_EmployeeOverTimePackages = sqlHR_EmployeeOverTimePackageProvider.GetDropDownLisAllHR_EmployeeOverTimePackage();
     return hR_EmployeeOverTimePackages;
 }
 public static DataSet GetAllHR_EmployeeOverTimePackagesWithRelation()
 {
     DataSet hR_EmployeeOverTimePackages = new DataSet();
     SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
     hR_EmployeeOverTimePackages = sqlHR_EmployeeOverTimePackageProvider.GetAllHR_EmployeeOverTimePackages();
     return hR_EmployeeOverTimePackages;
 }
 public static bool IsEmployeeExist(string employeeID)
 {
     SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
     return sqlHR_EmployeeOverTimePackageProvider.IsEmployeeExist(employeeID);
 }
 public static int InsertHR_EmployeeOverTimePackage(HR_EmployeeOverTimePackage hR_EmployeeOverTimePackage)
 {
     SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
     return sqlHR_EmployeeOverTimePackageProvider.InsertHR_EmployeeOverTimePackage(hR_EmployeeOverTimePackage);
 }
 public static bool DeleteHR_EmployeeOverTimePackage(int hR_EmployeeOverTimePackageID)
 {
     SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
     return sqlHR_EmployeeOverTimePackageProvider.DeleteHR_EmployeeOverTimePackage(hR_EmployeeOverTimePackageID);
 }
 public static bool UpdateHR_EmployeeOverTimePackage(HR_EmployeeOverTimePackage hR_EmployeeOverTimePackage)
 {
     SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
     return sqlHR_EmployeeOverTimePackageProvider.UpdateHR_EmployeeOverTimePackage(hR_EmployeeOverTimePackage);
 }
 public static void LoadHR_EmployeeOverTimePackagePage(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);
     SqlHR_EmployeeOverTimePackageProvider sqlHR_EmployeeOverTimePackageProvider = new SqlHR_EmployeeOverTimePackageProvider();
     DataSet ds =  sqlHR_EmployeeOverTimePackageProvider.GetHR_EmployeeOverTimePackagePageWise(pageIndex, PageSize, out recordCount);
     gv.DataSource = ds;
     gv.DataBind();
      hR_EmployeeOverTimePackagesPaggination(rptPager,recordCount, pageIndex, PageSize);
 }