private static bool InsTicketTransactionLocal(long transactionId)
{
bool result = false;
try
{
log.Debug("unitID =" + Parameters.TVMDynamic.GetParameter("unitId") + "InsTicketTransactionLocal 144.");
int unitId = Convert.ToInt32(Parameters.TVMDynamic.GetParameter("unitId").ToString());
int stationId = Convert.ToInt32(Parameters.TVMDynamic.GetParameter("stationId"));
using (var context = new TVM_Entities())
{
var data = context.sp_InsTicketTransaction(0, 0, Ticket.totalPrice, Convert.ToByte(TransactionType.TT_QR),
(byte)PaymentType.cash, Ticket.totalPrice, 0, Ticket.totalPrice,
0,
Constants.Change,
0, unitId, transactionId,
stationId, 0);
result = true;
}
}
catch (Exception ex)
{
log.Error("LogTypes.Error.ToString() " + ex.Message + Environment.NewLine + ex.StackTrace);
result = false;
}
return(result);
}
public static bool FillStationList()
{
bool result = false;
stationList.Clear();
try
{
using (var context = new TVM_Entities())
{
var courses = context.sp_SelStations("en").ToList();
foreach (var item in courses)
{
var listStation = new Station
{
id = Convert.ToInt32(item.recId),
order = Convert.ToInt32(item.recId),
name = item.explanation.ToString(),
description = item.explanation.ToString(),
code = item.stationCode.ToString(),
mapRow = Convert.ToInt32(item.mapRow),
mapColumn = Convert.ToInt32(item.mapColumn),
mapHereRow = Convert.ToInt32(item.mapHereRow),
mapHereColumn = Convert.ToInt32(item.mapHereColumn)
};
AddStation(listStation);
}
}
result = true;
}
catch (Exception ex)
{
}
return(result);
}
private static bool InsQRLocal(long transactionId, DataTable dt)
{
bool result = false;
try
{
log.Debug("unitID =" + Parameters.TVMDynamic.GetParameter("unitId").ToString() + "InsQRLocal 167.");
int unitId = Convert.ToInt32(Parameters.TVMDynamic.GetParameter("unitId").ToString());
int stationId = Convert.ToInt32(Parameters.TVMDynamic.GetParameter("stationId"));
using (var context = new TVM_Entities())
{
for (int i = 0; i < dt.Rows.Count; i++)
{
log.Debug("ticketType =" + dt.Rows[i]["ticketType"]);
var data = context.sp_InsQRCodeTicket(Convert.ToInt16(dt.Rows[i]["ticketType"]), Convert.ToDecimal(dt.Rows[i]["ticketPrice"]), Convert.ToInt16(dt.Rows[i]["fromId"]), Convert.ToInt16(dt.Rows[i]["toId"]), Convert.ToDateTime(dt.Rows[i]["activeFrom"]), Convert.ToDateTime(dt.Rows[i]["activeTo"]),
Convert.ToString(dt.Rows[i]["QRCodeId"]), (short)Ticket.peopleCount, Convert.ToInt16(dt.Rows[i]["alias"]), Convert.ToString(dt.Rows[i]["from"]), Convert.ToString(dt.Rows[i]["to"]), Convert.ToString(dt.Rows[i]["ticketStringValue"]), "0", stationId, unitId, (int)transactionId, 0, Ticket.ticketActivateDts);
}
result = true;
}
result = true;
}
catch (Exception ex)
{
log.Error("LogTypes.Error.ToString() " + ex.Message + Environment.NewLine + ex.StackTrace);
result = false;
}
return(result);
}
public bool Login(string userName, string password, int stationId, ref bool notAuthorized)
{
bool result = false;
string hashedPassword = "";
hashedPassword = USHDLL.Crypto.Ush(password);
try
{
using (var context = new TVM_Entities())
{
var trxDetail = context.sp_TomAppLogon(userName, "TVM", hashedPassword, "127.0.0.1", stationId).FirstOrDefault();
if (trxDetail.alias != null)
{
notAuthorized = true;
result = true;
}
else
{
notAuthorized = false;
}
}
}
catch (Exception ex)
{
}
return(result);
}
public static bool InsRFIDTicket(long transactionId, bool ret, byte[] uid)
{
bool result = false;
var cardId = "";
try
{
cardId = BitConverter.ToString(uid).Replace("-", string.Empty);
using (var context = new TVM_Entities())
{
int courses = context.sp_InsRFIDTicket((int)Ticket.journeyType, Ticket.ticketPrice, Ticket.startStation.id, Ticket.endStation.id, 0, Ticket.ticketActivateDts, Ticket.ticketExpiryDts, cardId, (short)Ticket.peopleCount, "N", Convert.ToInt32(Parameters.TVMDynamic.GetParameter("stationId")), Convert.ToInt32(Parameters.TVMDynamic.GetParameter("unitId")), Convert.ToInt32(transactionId), 0);
if (courses >= 0)
{
result = true;
}
}
}
catch (Exception ex)
{
result = false;
log.Debug("LogTypes.Error.ToString() : " + ex.ToString());
}
return(result);
}
public static bool GiveRPTTicket()
{
bool ret = false, result = false;
try
{
byte[] uid = null;
log.Debug("pass GiveRPTTicket");
if (Init())
{
log.Debug("pass Start");
if (InsTicketTranDet(out long transactionId))
{
log.Debug("pass InsTicketTranDet");
for (int i = 0; i < Ticket.ticketCount; i++)
{
ret = false;
uid = null;
if (Move())
{
log.Debug("pass Move");
if (Personalize(out uid))
{
ret = true;
log.Debug("pass Personalize");
if (Reject())
{
log.Debug("pass Reject");
InsRFIDTicket(transactionId, ret, uid);
result = true;
}
else
{
Trash();
}
}
else
{
Trash();
}
}
}
if (result)
{
using (var context = new TVM_Entities())
{
var courses = context.UpdTransactionStatus(transactionId).ToList();
}
}
}
}
return(result);
}
catch (Exception ex)
{
log.Error("LogTypes.Error GiveRPTTicket() : " + ex.ToString());
return(result);
}
}
public static bool SelStockStatus()
{
bool result = false;
try
{
using (var context = new TVM_Entities())
{
var data = context.sp_SelStockStatus().FirstOrDefault();
rpt = (int)(data.dispenser);
coin1 = (int)(data.hopper1);
coin2 = (int)(data.hopper2);
coin5 = (int)(data.hopper5);
escrow = (int)(data.cassette3);
banknote20 = (int)(data.cassette2);
banknote10 = (int)(data.cassette1);
box = (int)(data.box);
qrSlip = (int)(data.qrSlip);
receiptSlip = (int)(data.receiptSlip);
result = true;
}
}
catch (Exception ex)
{
result = false;
////Logger.Log.log.Write("Error: " + ex.Message);
}
return(result);
}
public static decimal?SelTrxId(long trxTypeId)
{
decimal?trxId = 0;
try
{
using (var context = new TVM_Entities())
{
trxId = context.sp_SelTrxId(trxTypeId).FirstOrDefault();
}
}
catch (Exception ex)
{
}
return(trxId);
}
public static bool InsStock(long trxId, int stockType, int deviceType, int updType, int quantity)
{
bool result = false;
try
{
using (var context = new TVM_Entities())
{
int val = context.sp_InsStock(trxId, stockType, deviceType, updType, quantity);
if (val == 2)
{
result = true;
}
}
}
catch (Exception ex)
{
result = false;
}
return(result);
}
private void btnLogin_Click(object sender, RoutedEventArgs e)
{
TVMUtility.PlayClick();
bool notAuthorized = false;
bool log = Login(txtUserID.Text, pbUserPassword.Password, Stations.currentStation.id, ref notAuthorized);
if (notAuthorized)
{
Parameters.userId = txtUserID.Text;
Parameters.menuItems.Clear();
using (var context = new TVM_Entities())
{
int?userRecId = context.sp_SelUserId(Parameters.userId).FirstOrDefault();
var menu = context.sp_userAuth(userRecId, "TVM").ToList();
foreach (var row2 in menu)
{
Parameters.menuItems.Add(row2.explanation.ToString());
}
}
TVMUtility.RestartExplorer();
NavigationService.Navigate(new Pages.Maintenance.AdminMainPage());
}
else
{
if (notAuthorized)
{
MessageBoxOperations.ShowMessage("Login Failed", "User is not authorized..", MessageBoxButtonSet.OK);
}
else
{
MessageBoxOperations.ShowMessage("Login Failed", "User Id or password is wrong..", MessageBoxButtonSet.OK);
}
}
}
static bool GetAliasLocal(out int alias)
{
bool result = false;
try
{
using (var context = new TVM_Entities())
{
int?data = context.sp_SelAlias().FirstOrDefault();
log.Debug("Debug - GetAliasLocal() : " + data.ToString());
alias = Convert.ToInt16(data);
result = true;
}
}
catch (Exception ex)
{
result = false;
alias = 0;
log.Error("LogTypes.Error.ToString() : " + ex.ToString());
}
return(result);
}
public static bool InsTicketTranDet(out long transactionId)
{
bool result = false;
long tempTransactionId = 0;
try
{
using (var context = new TVM_Entities())
{
Int64 i = 0;
byte j = 0;
decimal k = 0;
var courses = context.sp_InsTicketTransaction(i, j, k, Convert.ToByte(Utils.Enums.TransactionType.TT_RPT), (byte)PaymentType.cash, Ticket.totalPrice, 0, Ticket.totalPrice,
0, Constants.Change,
0, Convert.ToInt32(Parameters.TVMDynamic.GetParameter("unitId")), tempTransactionId,
Convert.ToInt32(Parameters.TVMDynamic.GetParameter("stationId")), 0);
tempTransactionId = Convert.ToInt64(courses);
if (tempTransactionId > 0)
{
result = true;
}
else
{
result = false;
}
}
}
catch (Exception ex)
{
result = false;
log.Error("LogTypes.Error " + ex.ToString());
}
transactionId = tempTransactionId;
return(result);
}
public static bool InsMoney(long trxId, int stockType, int deviceType, int updType, decimal amount)
{
bool result = false;
try
{
using (var context = new TVM_Entities())
{
int data = context.sp_InsMoney(trxId, stockType, deviceType, updType, amount);
if (data == 2)
{
result = true;
}
}
//Logger.Log.log.Write(Logger.LogTypes.Info.ToString() + ": result = " + result);
}
catch (Exception ex)
{
result = false;
//Logger.Log.log.Write(Logger.LogTypes.Error.ToString() + " : Error : " + ex.ToString());
}
return(result);
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
try
{
lblAppVersion.Content = "App Version : " + Parameters.TVMStatic.GetParameter("appVersion");
lblEquipmentID.Content = "Equipment ID : " + Parameters.TVMDynamic.GetParameter("descCode");
btnFinish.Content = "Cancel";
using (var context = new TVM_Entities())
{
DateTime startDate = DateTime.Parse(Parameters.TVMDynamic.GetParameter("sys_WorkHoursStart"));
DateTime endDate = DateTime.Parse(Parameters.TVMDynamic.GetParameter("sys_WorkHoursEnd"));
var trxData = context.sp_SelShiftPaymentReport(Convert.ToInt32(Parameters.TVMDynamic.GetParameter("unitId")), Stations.currentStation.id, 0, 0, startDate, endDate).ToList();
foreach (var data in trxData)
{
if (Convert.ToString(data.Transaction) == "QR SJT-CASH")
{
QRSJTCashCount = Convert.ToInt32(data.Count);
QRSJTCashAmount = Convert.ToInt32(data.Amount);
}
else if (Convert.ToString(data.Transaction) == "QR SJT-NonCASH")
{
QRSJTNonCashCount = Convert.ToInt32(data.Count);
QRSJTNonCashAmount = Convert.ToInt32(data.Amount);
}
if (Convert.ToString(data.Transaction) == "QR RJT-CASH")
{
QRRJTCashCount = Convert.ToInt32(data.Count);
QRRJTCashAmount = Convert.ToInt32(data.Amount);
}
else if (Convert.ToString(data.Transaction) == "QR RJT-NonCASH")
{
QRRJTNonCashCount = Convert.ToInt32(data.Count);
QRRJTNonCashAmount = Convert.ToInt32(data.Amount);
}
else if (Convert.ToString(data.Transaction) == "RPT SJT-CASH")
{
RPTSJTCashCount = Convert.ToInt32(data.Count);
RPTSJTCashAmount = Convert.ToInt32(data.Amount);
}
else if (Convert.ToString(data.Transaction) == "RPT SJT-NonCASH")
{
RPTSJTNonCashCount = Convert.ToInt32(data.Count);
RPTSJTNonCashAmount = Convert.ToInt32(data.Amount);
}
else if (Convert.ToString(data.Transaction) == "RPT RJT-CASH")
{
RPTRJTCashCount = Convert.ToInt32(data.Count);
RPTRJTCashAmount = Convert.ToInt32(data.Amount);
}
else if (Convert.ToString(data.Transaction) == "RPT RJT-NonCASH")
{
RPTRJTNonCashCount = Convert.ToInt32(data.Count);
RPTRJTNonCashAmount = Convert.ToInt32(data.Amount);
}
else if (Convert.ToString(data.Transaction) == "RPT Day Pass-CASH")
{
RPTDayPassCashCount = Convert.ToInt32(data.Count);
RPTDayPassCashAmount = Convert.ToInt32(data.Amount);
}
else if (Convert.ToString(data.Transaction) == "RPT Day Pass-NonCASH")
{
RPTDayPassNonCashCount = Convert.ToInt32(data.Count);
RPTDayPassNonCashAmount = Convert.ToInt32(data.Amount);
}
else if (Convert.ToString(data.Transaction) == "RPT Weekend Pass-CASH")
{
RPTWeekendPassCashCount = Convert.ToInt32(data.Count);
RPTWeekendPassCashAmount = Convert.ToInt32(data.Amount);
}
else if (Convert.ToString(data.Transaction) == "RPT Weekend Pass-NonCASH")
{
RPTWeekendPassNonCashCount = Convert.ToInt32(data.Count);
RPTWeekendPassNonCashAmount = Convert.ToInt32(data.Amount);
}
}
}
}
catch (Exception ex)
{
}
lblQRSJTCashCount.Content = QRSJTCashCount;
lblQRSJTCashAmount.Content = Conversion.MoneyFormat(QRSJTCashAmount);
lblQRSJTNonCashCount.Content = QRSJTNonCashCount;
lblQRSJTNonCashAmount.Content = Conversion.MoneyFormat(QRSJTNonCashAmount);
lblQRRJTCashCount.Content = QRRJTCashCount;
lblQRRJTCashAmount.Content = Conversion.MoneyFormat(QRRJTCashAmount);
lblQRRJTNonCashCount.Content = QRRJTNonCashCount;
lblQRRJTNonCashAmount.Content = Conversion.MoneyFormat(QRRJTNonCashAmount);
lblRPTQRSJTCashCount.Content = RPTSJTCashCount;
lblRPTQRSJTCashAmount.Content = Conversion.MoneyFormat(RPTSJTCashAmount);
lblRPTQRRJTCashCount.Content = RPTRJTCashCount;
lblRPTQRRJTCashAmount.Content = Conversion.MoneyFormat(RPTRJTCashAmount);
lblRPTDayPassCashCount.Content = RPTDayPassCashCount;
lblRPTDayPassCashAmount.Content = Conversion.MoneyFormat(RPTDayPassCashAmount);
lblRPTWeekendCashCount.Content = RPTWeekendPassCashCount;
lblRPTWeekendCashAmount.Content = Conversion.MoneyFormat(RPTWeekendPassCashAmount);
}
