public static Dictionary <Decimal, int> GetNotesValuesAndCount(long startId, long endId = long.MaxValue)
{
var cashinNotes = new Dictionary <decimal, int>();
try
{
var lParams = new List <IDbDataParameter> {
SqlObjectFactory.CreateParameter("lastCashoutStartId", startId, string.Empty), SqlObjectFactory.CreateParameter("lastCashoutEndId", endId, string.Empty)
};
List <StationCashSr> lStationCash = StationCashSr.GetStationCashListByQuery("SELECT * FROM StationCash where stationcashid >= @lastCashoutStartId and stationcashid <= @lastCashoutEndId order by stationcashid desc", lParams);
foreach (StationCashSr stationCashBo in lStationCash)
{
if (stationCashBo.MoneyIn)
{
if (cashinNotes.ContainsKey(stationCashBo.Cash))
{
cashinNotes[stationCashBo.Cash]++;
}
else
{
cashinNotes.Add(stationCashBo.Cash, 1);
}
}
}
}
catch (Exception ex)
{
}
return(cashinNotes);
}
private ObservableCollection <CashOperation> GetCashOperations(long startId, long endId = long.MaxValue)
{
var cashOperations = new ObservableCollection <CashOperation>();
decimal cashinValue = 0;
decimal cashoutValue = 0;
string additionalCommand = "";
if (startId == 0 && endId == 0)
{
CashInOperationsNum = cashinValue;
CashOutOperationsNum = cashoutValue;
OnPropertyChanged("CashInOperationsNum");
OnPropertyChanged("CashOutOperationsNum");
return(cashOperations);
}
try
{
if (PayIn && !PayOut)
{
additionalCommand = "and MoneyIn=1";
}
else if (!PayIn && PayOut)
{
additionalCommand = "and MoneyIn=0";
}
List <IDbDataParameter> lParams = new List <IDbDataParameter>()
{
SqlObjectFactory.CreateParameter("lastCashoutStartId", startId, string.Empty),
SqlObjectFactory.CreateParameter("lastCashoutEndId", endId, string.Empty)
};
//List<StationCashSr> lStationCash = StationCashSr.GetStationCashListByQuery("SELECT * FROM StationCash where stationcashid >= @lastCashoutStartId and stationcashid <= @lastCashoutEndId " + additionalCommand + " order by DateModified desc", lParams);
CashOperationtData[] lStationCash = WsdlRepository.GetStationCashHistory(StationRepository.StationNumber, StartDate, EndDate); //WsdlRepository.GetStationCashHistory(StationRepository.StationNumber, StartDate, EndDate);
foreach (CashOperationtData stationCashBo in lStationCash)
{
decimal multiplier;
string type = stationCashBo.operation_type;
string translation;
if (type == "CASH_IN")
{
multiplier = 1;
cashinValue += stationCashBo.amount;
translation = TranslationProvider.Translate(MultistringTags.STATION_CASH_IN).ToString();
}
else if (type == "EMPTY_BOX")
{
multiplier = -1;
cashoutValue += stationCashBo.amount;
translation = TranslationProvider.Translate(MultistringTags.STATION_CASH_OUT).ToString();
}
else
{
translation = "";
multiplier = 1;
}
//if (type == "CASH_IN")
//{
// cashinValue += stationCashBo.amount;
//}
//else if (type == "EMPTY_BOX")
//{
// cashoutValue += stationCashBo.amount;
//}
cashOperations.Add(new CashOperation(0, stationCashBo.amount * multiplier, stationCashBo.created_at, translation,
String.IsNullOrEmpty(stationCashBo.operator_name) ? StationRepository.StationTyp : stationCashBo.operator_name));
}
}
catch (Exception)
{
}
CashInOperationsNum = cashinValue;
CashOutOperationsNum = cashoutValue;
OnPropertyChanged("CashInOperationsNum");
OnPropertyChanged("CashOutOperationsNum");
return(cashOperations);
}
