/// <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;
}
