public void RequestFocus()
{
Dispatcher.Invoke(() =>
{
CollectionListView.FocusSelectedItem();
}, DispatcherPriority.Background);
}
private void AddFileToDatabase(DatabaseReference database)
{
var dialog = new OpenFileDialog
{
Filter = "All files|*.*",
Multiselect = false
};
if (dialog.ShowDialog() != true)
{
return;
}
try
{
if (InputBoxWindow.ShowDialog("New file id:", "Enter new file id", Path.GetFileName(dialog.FileName), out string id) == true)
{
var file = database.AddFile(id, dialog.FileName);
Store.Current.SelectCollection(database.Collections.First(a => a.Name == "_files"));
Store.Current.SelectDocument(file);
CollectionListView.ScrollIntoSelectedItem();
}
}
catch (Exception exc)
{
MessageBox.Show(
"Failed to upload file:" + Environment.NewLine + exc.Message,
"Database error",
MessageBoxButton.OK,
MessageBoxImage.Error
);
}
}
public void SelectItem(object item)
{
Dispatcher.Invoke(() =>
{
CollectionListView.ScrollIntoItem(item);
CollectionListView.ListCollectionData.SelectedItem = item;
}, DispatcherPriority.Normal);
}
private void Application_Startup(object sender, StartupEventArgs e)
{
log4net.Config.XmlConfigurator.Configure();
log.Debug(string.Format("{0}: Application starting", MethodBase.GetCurrentMethod().Name));
CollectionListView w = new CollectionListView();
w.Show();
}
private void AddFileToDatabase(DatabaseReference database)
{
var result = _databaseInteractions.AddFileToDatabase(database);
if (result.IsSuccess)
{
CollectionListView.ScrollIntoSelectedItem();
}
}
private void AddFileToDatabase(DatabaseReference database)
{
var result = _databaseInteractions.AddFileToDatabase(database);
if (result.IsSuccess)
{
Store.Current.SelectCollection(database.Collections.First(a => a.Name == "_files"));
Store.Current.SelectDocument(result.Value.DocumentReference);
CollectionListView.ScrollIntoSelectedItem();
}
}
private void AddFileToDatabase(DatabaseReference database)
{
var result = _databaseInteractions.AddFileToDatabase(database);
if (result.IsSuccess)
{
var documentsCreated = result.Value;
Store.Current.SelectCollection(documentsCreated.CollectionReference);
Store.Current.SelectDocument(documentsCreated.Items?.FirstOrDefault());
CollectionListView.ScrollIntoSelectedItem();
}
}
private void Settings_PropertyChanged(object sender, PropertyChangedEventArgs e)
{
switch (e.PropertyName)
{
case nameof(Settings.ColorTheme):
SetColorTheme();
break;
case nameof(Settings.FieldSortOrder):
CollectionListView.UpdateGridColumns(Store.Current.SelectedCollection);
break;
}
}
private void AddCommand_Executed(object sender, ExecutedRoutedEventArgs e)
{
var result = _databaseInteractions.CreateItem(Store.Current.SelectedCollection);
if (result.IsSuccess)
{
var reference = result.Value;
Store.Current.SelectCollection(reference.CollectionReference);
Store.Current.SelectDocument(reference.Items?.FirstOrDefault());
if (!reference.CollectionReference.IsFilesOrChunks)
{
UpdateGridColumns(Store.Current.SelectedDocument.LiteDocument);
}
CollectionListView.ScrollIntoSelectedItem();
UpdateDocumentPreview();
}
}
private void AddCommand_Executed(object sender, ExecutedRoutedEventArgs e)
{
if (Store.Current.SelectedCollection is FileCollectionReference)
{
AddFileToDatabase(Store.Current.SelectedCollection.Database);
}
else
{
var newDoc = new BsonDocument
{
["_id"] = ObjectId.NewObjectId()
};
var documentReference = Store.Current.SelectedCollection.AddItem(newDoc);
Store.Current.SelectDocument(documentReference);
CollectionListView.ScrollIntoSelectedItem();
UpdateGridColumns(newDoc);
}
UpdateDocumentPreview();
}
void CollectionLoad()
{
DateTime?startDate = null;
if (!string.IsNullOrEmpty(dpDueDate.Value))
{
startDate = DateTime.Parse(dpDueDate.Value);
}
SqlConnection sqlConnection1 = new SqlConnection(CollectionDataSource.ConnectionString);
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
try
{
cmd.CommandText = "[collection].[sp_get_collections_by_duedate]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection1;
cmd.Parameters.Add("@PaymentDueDate", SqlDbType.DateTime).Value = startDate;
da.SelectCommand = cmd;
da.Fill(dt);
CollectionListView.DataSourceID = string.Empty;
CollectionListView.DataSource = dt;
CollectionListView.DataBind();
}
catch (Exception exp)
{
ErrorLabel.Text = "Error a ejecutar busqueda.. : " + exp.Message;
ErrorLabel.Visible = true;
}
}
private void AddCommand_Executed(object sender, ExecutedRoutedEventArgs e)
{
var result = _databaseInteractions.CreateItem(Store.Current.SelectedCollection);
if (result.IsSuccess)
{
var reference = result.Value;
if (reference.Type == DocumentType.File)
{
Store.Current.SelectCollection(Store.Current.SelectedCollection.Database.Collections.First(a => a.Name == "_files"));
Store.Current.SelectDocument(reference.DocumentReference);
}
else
{
Store.Current.SelectDocument(reference.DocumentReference);
UpdateGridColumns(reference.DocumentReference.LiteDocument);
}
CollectionListView.ScrollIntoSelectedItem();
UpdateDocumentPreview();
}
}
//
public List <CollectionListView> GetCollectionDetailsforListView(CollectionView _collectionRecords)
{
var collectionDetails = new List <CollectionListView>();
var collGrossView = new CollectionListView();
var collNetView = new CollectionListView();
var colShortpayview = new CollectionListView();
decimal treasurySum = Convert.ToDecimal(_collectionRecords.DecHandpay);
decimal shortPayTreasurySum = Convert.ToDecimal(_collectionRecords.Shortpay);
decimal OfflineshortPayTreasurySum = Convert.ToDecimal(_collectionRecords.OffLineShortpay);
decimal voidTreasurySum = Convert.ToDecimal(_collectionRecords.Void);
decimal CoinsOut = Convert.ToDecimal(_collectionRecords.RDC_Total_Coinage_Out);
decimal totalCollection = Convert.ToDecimal(_collectionRecords.CashIn);
int POP = Convert.ToInt32(_collectionRecords.Installation_Price_of_Play);
collGrossView.Name = "Gross";
collNetView.Name = "Net";
collNetView.Total = collGrossView.Total = Convert.ToDecimal(_collectionRecords.CashCollected) + (_isAFTIncludedInCalculation ? (Convert.ToDecimal(_collectionRecords.EftIn) / 100) : 0);
collNetView.V1000 = collGrossView.V1000 = Convert.ToDecimal(_collectionRecords.Cash_Collected_100000p);
collNetView.V500 = collGrossView.V500 = Convert.ToDecimal(_collectionRecords.Cash_Collected_50000p);
collNetView.V200 = collGrossView.V200 = Convert.ToDecimal(_collectionRecords.Cash_Collected_20000p);
collNetView.V100 = collGrossView.V100 = Convert.ToDecimal(_collectionRecords.Cash_Collected_10000p);
collNetView.V50 = collGrossView.V50 = Convert.ToDecimal(_collectionRecords.Cash_Collected_5000p);
collNetView.V20 = collGrossView.V20 = Convert.ToDecimal(_collectionRecords.Cash_Collected_2000p);
collNetView.V10 = collGrossView.V10 = Convert.ToDecimal(_collectionRecords.Cash_Collected_1000p);
collNetView.V5 = collGrossView.V5 = Convert.ToDecimal(_collectionRecords.Cash_Collected_500p);
collNetView.V2 = collGrossView.V2 = Convert.ToDecimal(_collectionRecords.Cash_Collected_200p);
collNetView.V1 = collGrossView.V1 = Convert.ToDecimal(_collectionRecords.Cash_Collected_100p);
collNetView.V50p = collGrossView.V50p = Convert.ToDecimal(_collectionRecords.Cash_Collected_50p);
collNetView.V20p = collGrossView.V20p = Convert.ToDecimal(_collectionRecords.Cash_Collected_20p);
collNetView.V10P = collGrossView.V10P = Convert.ToDecimal(_collectionRecords.Cash_Collected_10p);
decimal grossTotalCoins = Convert.ToDecimal(_collectionRecords.Declared_Total_TrueCoin_In);
collNetView.TotalCoins = collGrossView.TotalCoins = Convert.ToDecimal(grossTotalCoins) - CoinsOut;
collNetView.CoinsIn = collGrossView.CoinsIn = Convert.ToDecimal(grossTotalCoins);
collNetView.CoinsOut = collGrossView.CoinsOut = CoinsOut;
collNetView.TicketsIn = collGrossView.TicketsIn = Convert.ToDecimal(_collectionRecords.DeclaredTicketValue); // Non cashable has been removed as it is added in the declared value (Convert.ToDecimal(_collectionRecords.RDC_TICKETS_INSERTED_NONCASHABLE_VALUE)/100);
if (Settings.Client == "SGVI" && Settings.TicketDeclaration.ToUpper() == "AUTO")
{
collNetView.TicketsOut = collGrossView.TicketsOut = Convert.ToDecimal(_collectionRecords.DeclaredTicketPrintedValue);
}
else
{
if (Settings.AddShortpayInVoucherOut)
{
collNetView.TicketsOut = collGrossView.TicketsOut = Convert.ToDecimal(_collectionRecords.DeclaredTicketPrintedValue) +
(Convert.ToDecimal(shortPayTreasurySum) + Convert.ToDecimal(OfflineshortPayTreasurySum))
- Convert.ToDecimal(voidTreasurySum);
}
else
{
collNetView.TicketsOut = collGrossView.TicketsOut = Convert.ToDecimal(_collectionRecords.DeclaredTicketPrintedValue) +
+Convert.ToDecimal(OfflineshortPayTreasurySum)
- Convert.ToDecimal(voidTreasurySum);
}
}
collNetView.PromoCashableValue = collGrossView.PromoCashableValue = Convert.ToDecimal(_collectionRecords.PromoCashableValue);
collNetView.PromoNonCashableValue = collGrossView.PromoNonCashableValue = Convert.ToDecimal(_collectionRecords.PromoNonCashableValue);
// Non cashable voucher out is removed as it is added in the declared ticket printed value(Convert.ToDecimal(_collectionRecords.RDC_TICKETS_PRINTED_NONCASHABLE_VALUE)/100);
collNetView.EFTIn = collGrossView.EFTIn = (Convert.ToDecimal(_collectionRecords.EftIn) / 100); // (((Convert.ToDecimal(_collectionRecords.Promo_Cashable_EFT_IN) + Convert.ToDecimal(_collectionRecords.NonCashable_EFT_IN) + Convert.ToDecimal(_collectionRecords.Cashable_EFT_IN))) / 100);
collNetView.EFTOut = collGrossView.EFTOut = (Convert.ToDecimal(_collectionRecords.EftOut) / 100);
collNetView.EFT = collGrossView.EFT = (Convert.ToDecimal(_collectionRecords.EftIn) / 100) - (Convert.ToDecimal(_collectionRecords.EftOut) / 100);
collNetView.Tickets = collGrossView.Tickets = Convert.ToDecimal(collGrossView.TicketsIn) - Convert.ToDecimal(collGrossView.TicketsOut);
collNetView.Handpay = collGrossView.Handpay = Convert.ToDecimal(_collectionRecords.DecHandpay.Value.ToString("r"));// Value Calculated in View/Function
collNetView.Progressive = collGrossView.Progressive = Convert.ToDecimal(_collectionRecords.Progressive_Value_Declared);
collNetView.IsMatch = collGrossView.IsMatch = totalCollection == Convert.ToDecimal(_collectionRecords.CashCollected) ? true : false;
collectionDetails.Add(collGrossView);
//ShortPay
colShortpayview.Name = "Shortpay";
colShortpayview.TicketsOut = Convert.ToDecimal(_collectionRecords.Shortpay);
colShortpayview.Tickets = ((_collectionRecords.Shortpay > 0) ? Convert.ToDecimal((_collectionRecords.Shortpay * -1)) : Convert.ToDecimal(_collectionRecords.Shortpay));
collectionDetails.Add(colShortpayview);
//copy the gross object to net
collectionDetails.Add(collNetView);
CollectionListView collMeterView = new CollectionListView();
collMeterView.Name = "Meters";
var collVarView = new CollectionListView {
Name = "Variance"
};
decimal totaCashDiff = CalculateCashDiff(_collectionRecords);
decimal totalCoins;
collVarView.Total = (Convert.ToDecimal(_collectionRecords.CashCollected) + (_isAFTIncludedInCalculation ? (Convert.ToDecimal(_collectionRecords.EftIn) / 100) : 0))
- (CalculateCashDiff(_collectionRecords) + Convert.ToDecimal(_collectionRecords.RDC_Total_Coinage_In));
if (_collectionRecords.Collection_EDC_Status == 0)
{
collMeterView.Total = CalculateCashDiff(_collectionRecords) + Convert.ToDecimal(_collectionRecords.RDC_Total_Coinage_In);
collMeterView.V1000 = (Convert.ToDecimal(_collectionRecords.CASH_IN_100000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_100000P)) * 1000;
collMeterView.V500 = (Convert.ToDecimal(_collectionRecords.CASH_IN_50000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_50000P)) * 500;
collMeterView.V200 = (Convert.ToDecimal(_collectionRecords.CASH_IN_20000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_20000P)) * 200;
collMeterView.V100 = (Convert.ToDecimal(_collectionRecords.CASH_IN_10000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_10000P)) * 100;
collMeterView.V50 = (Convert.ToDecimal(_collectionRecords.CASH_IN_5000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_5000P)) * 50;
collMeterView.V20 = (Convert.ToDecimal(_collectionRecords.CASH_IN_2000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_2000P)) * 20;
collMeterView.V10 = (Convert.ToDecimal(_collectionRecords.CASH_IN_1000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_1000P)) * 10;
collMeterView.V5 = (Convert.ToDecimal(_collectionRecords.CASH_IN_500P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_500P)) * 5;
collMeterView.V2 = (Convert.ToDecimal(_collectionRecords.CASH_IN_200P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_200P)) * 2;
collMeterView.V1 = Convert.ToDecimal(_collectionRecords.CASH_IN_100P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_100P);
collMeterView.V50p = (Convert.ToDecimal(_collectionRecords.CASH_IN_50P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_50P)) / 2;
collMeterView.V20p = (Convert.ToDecimal(_collectionRecords.CASH_IN_20P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_20P)) / 5;
collMeterView.V10P = (Convert.ToDecimal(_collectionRecords.CASH_IN_10P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_10P)) / 10;
totalCoins = (Convert.ToDecimal(_collectionRecords.RDC_Total_Coinage_In) - Convert.ToDecimal(_collectionRecords.RDC_Total_Coinage_Out));
collMeterView.TotalCoins = Convert.ToDecimal(totalCoins);
collMeterView.CoinsIn = Convert.ToDecimal(totalCoins) + CoinsOut;
collMeterView.CoinsOut = CoinsOut;
collMeterView.TotalCoins = Convert.ToDecimal(totalCoins);
collMeterView.TicketsIn = (Convert.ToDecimal(_collectionRecords.COLLECTION_RDC_TICKETS_INSERTED_VALUE) / 100) + (Convert.ToDecimal(_collectionRecords.RDC_TICKETS_INSERTED_NONCASHABLE_VALUE));
collMeterView.TicketsOut = (Convert.ToDecimal(_collectionRecords.COLLECTION_RDC_TICKETS_PRINTED_VALUE) / 100) + (Convert.ToDecimal(_collectionRecords.RDC_TICKETS_PRINTED_NONCASHABLE_VALUE));
collMeterView.Tickets = collMeterView.TicketsIn - collMeterView.TicketsOut;
collMeterView.EFTIn = (Convert.ToDecimal(_collectionRecords.Promo_Cashable_EFT_IN) + Convert.ToDecimal(_collectionRecords.NonCashable_EFT_IN) + Convert.ToDecimal(_collectionRecords.Cashable_EFT_IN));
collMeterView.EFTOut = (Convert.ToDecimal(_collectionRecords.Promo_Cashable_EFT_OUT) + Convert.ToDecimal(_collectionRecords.NonCashable_EFT_OUT) + Convert.ToDecimal(_collectionRecords.Cashable_EFT_OUT));
collMeterView.EFT = collMeterView.EFTIn - collMeterView.EFTOut;
collMeterView.Handpay = ((Convert.ToDecimal(_collectionRecords.COLLECTION_RDC_HANDPAY) * POP) / 100) + (Convert.ToDecimal(_collectionRecords.COLLECTION_RDC_JACKPOT));
collMeterView.Progressive = ((Convert.ToDecimal(_collectionRecords.progressive_win_Handpay_value)) * POP / 100);
collectionDetails.Add(collMeterView);
//Difference between net and meter
collVarView.V1000 = collNetView.V1000 - collMeterView.V1000;
collVarView.V500 = collNetView.V500 - collMeterView.V500;
collVarView.V200 = collNetView.V200 - collMeterView.V200;
collVarView.V100 = collNetView.V100 - collMeterView.V100;
collVarView.V50 = collNetView.V50 - collMeterView.V50;
collVarView.V20 = collNetView.V20 - collMeterView.V20;
collVarView.V10 = collNetView.V10 - collMeterView.V10;
collVarView.V5 = collNetView.V5 - collMeterView.V5;
collVarView.V2 = collNetView.V2 - collMeterView.V2;
collVarView.V1 = collNetView.V1 - collMeterView.V1;
collVarView.V50p = collNetView.V50p - collMeterView.V50p;
collVarView.V20p = collNetView.V20p - collMeterView.V20p;
collVarView.V10P = collNetView.V10P - collMeterView.V10P;
collVarView.TotalCoins = collNetView.TotalCoins - collMeterView.TotalCoins;
collVarView.CoinsIn = collNetView.CoinsIn - collMeterView.CoinsIn;
collVarView.CoinsOut = 0;
collVarView.TicketsIn = collNetView.TicketsIn - collMeterView.TicketsIn;
collVarView.TicketsOut = collNetView.TicketsOut - collMeterView.TicketsOut;
collVarView.Tickets = collVarView.TicketsIn - collVarView.TicketsOut;
collVarView.EFTIn = collNetView.EFTIn - collMeterView.EFTIn;
collVarView.EFTOut = collNetView.EFTOut - collMeterView.EFTOut;
collVarView.EFT = collVarView.EFTIn - collVarView.EFTOut;
collVarView.Handpay = collNetView.Handpay - collMeterView.Handpay;
collVarView.Progressive = collNetView.Progressive - collMeterView.Progressive;
collVarView.PromoCashableValue = collNetView.PromoCashableValue - collMeterView.PromoCashableValue;
collVarView.PromoNonCashableValue = collNetView.PromoNonCashableValue - collMeterView.PromoNonCashableValue;
collectionDetails.Add(collVarView);
}
else
{
collMeterView.Total = 0;
collMeterView.V1000 = 0;
collMeterView.V500 = 0;
collMeterView.V200 = 0;
collMeterView.V100 = 0;
collMeterView.V50 = 0;
collMeterView.V20 = 0;
collMeterView.V10 = 0;
collMeterView.V5 = 0;
collMeterView.V2 = 0;
collMeterView.V1 = 0;
collMeterView.V50p = 0;
collMeterView.V20p = 0;
collMeterView.V10P = 0;
collMeterView.TotalCoins = 0;
collMeterView.CoinsIn = 0;
collMeterView.CoinsOut = 0;
collMeterView.TicketsIn = 0;
collMeterView.TicketsOut = 0;
collMeterView.EFTIn = 0;
collMeterView.EFTOut = 0;
collMeterView.EFT = 0;
collMeterView.Tickets = 0;
collMeterView.Handpay = 0;
collMeterView.Progressive = 0;
collectionDetails.Add(collMeterView);
//Reusing Gross View as Variance since Meters values are zero
collGrossView.Name = "Variance";
collectionDetails.Add(collGrossView);
}
return(collectionDetails);
}
public void FindPrevious(string text, bool matchCase)
{
CollectionListView.FindPrevious(text, matchCase);
}
/// <summary>
/// 点击刷新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void RefreshButton_Click(object sender, RoutedEventArgs e)
{
_list_collections.DoRefresh();
await CollectionListView.LoadMoreItemsAsync();
}
private void UpdateGridColumns(BsonDocument dbItem)
{
CollectionListView.UpdateGridColumns(dbItem);
}
public void UpdateView(CollectionReference collectionReference)
{
CollectionListView.UpdateGridColumns(collectionReference);
}
public void ScrollIntoItem(object item)
{
CollectionListView.ScrollIntoItem(item);
}
public void ScrollIntoSelectedItem()
{
CollectionListView.ScrollIntoSelectedItem();
}
private void SelectDocumentInView(DocumentReference document)
{
Store.Current.SelectDocument(document);
CollectionListView.ScrollIntoSelectedItem();
}
public void UpdateView(DocumentReference documentReference)
{
CollectionListView.UpdateGridColumns(documentReference.LiteDocument);
}
public void FindClear()
{
CollectionListView.FindClear();
}
