/// <summary> /// Updates the year end value. /// </summary> /// <param name="yearEndQuantity2">The year end quantity2.</param> /// <param name="itemID">The item ID.</param> /// <param name="unitID">The unit ID.</param> /// <param name="year">The year.</param> public static void UpdateYearEndValue(long yearEndQuantity2, int itemID, int unitID, int year) { string query = HCMIS.Repository.Queries.YearEnd.UpdateUpdateYearEndValue(yearEndQuantity2, itemID, unitID, year); BLL.YearEnd ye = new YearEnd(); ye.LoadFromRawSql(query); }
/// <summary> /// Determines whether [is performed for year] [the specified year]. /// </summary> /// <param name="year">The year.</param> /// <returns> /// <c>true</c> if [is performed for year] [the specified year]; otherwise, <c>false</c>. /// </returns> public static bool IsPerformedForYear(int year) { string query = HCMIS.Repository.Queries.YearEnd.SelectIsPerformedForYear(year); YearEnd yearend = new YearEnd(); yearend.LoadFromRawSql(query); return (yearend.RowCount > 0); }
/// <summary> /// Determines whether [is performed for year] [the specified year]. /// </summary> /// <param name="year">The year.</param> /// <returns> /// <c>true</c> if [is performed for year] [the specified year]; otherwise, <c>false</c>. /// </returns> public static bool IsPerformedForYear(int year) { string query = HCMIS.Repository.Queries.YearEnd.SelectIsPerformedForYear(year); YearEnd yearend = new YearEnd(); yearend.LoadFromRawSql(query); return(yearend.RowCount > 0); }
/// <summary> /// Updates the year end value. /// </summary> /// <param name="yearEndQuantity2">The year end quantity2.</param> /// <param name="itemID">The item ID.</param> /// <param name="unitID">The unit ID.</param> /// <param name="year">The year.</param> public static void UpdateYearEndValue(long yearEndQuantity2, int itemID, int unitID,int year) { string query = HCMIS.Repository.Queries.YearEnd.UpdateUpdateYearEndValue(yearEndQuantity2, itemID, unitID, year); BLL.YearEnd ye = new YearEnd(); ye.LoadFromRawSql(query); }