/// <summary> /// Get available number of Months the item was in store in all logical stores /// </summary> /// <param name="itemId"></param> /// <param name="dt1"></param> /// <param name="dt2"></param> /// <returns></returns> public static int GetAvailableNoOfMonthsInAllStores(int itemId, DateTime dt1, DateTime dt2) { Balance balance = new Balance(); int count = 1; balance.FlushData(); balance.LoadFromRawSql(HCMIS.Repository.Queries.Balance.SelectGetAvailableNoOfMonthsInAllStores(itemId, dt1, dt2)); DateTime dtLast = (balance.DataTable.Rows.Count > 0) ? balance.GetDateTime("Date") : dt2; TimeSpan tDiff = dt2 - dtLast; count = tDiff.Days / 30; count = (count > 0) ? count : 1; return count; }