private void ExecuteLoad(object obj)
{
try
{
using (SqlConnection conn = new SqlConnection(GlobalClass.TConnectionString))
{
PIN.InDate = InDate;
PIN.InTime = InTime.ToString("hh:mm tt");
PIN.InMiti = nepDate.CBSDate(PIN.InDate);
PIN.VType = VTypeList.First(x => x.VTypeID == PIN.VehicleType);
POUT.Rate_ID = (int)conn.ExecuteScalar("SELECT RATE_ID FROM RATEMASTER WHERE IsDefault = 1");
POUT.OutDate = _CurDate;
POUT.OutTime = _CurTime;
POUT.OutMiti = nepDate.CBSDate(POUT.OutDate);
POUT.Interval = GetInterval(PIN.InDate, POUT.OutDate, PIN.InTime, POUT.OutTime);
POUT.PID = PIN.PID;
CalculateParkingCharge(conn, PIN.InDate.Add(DateTime.Parse(PIN.InTime).TimeOfDay), POUT.OutDate.Add(DateTime.Parse(POUT.OutTime).TimeOfDay), POUT.Rate_ID, PIN.VehicleType);
POUT.CashAmount = POUT.ChargedAmount;
if (POUT.CashAmount > GlobalClass.AbbTaxInvoiceLimit)
{
TaxInvoice = true;
CanChangeInvoiceType = false;
}
else
{
CanChangeInvoiceType = true;
}
FocusedElement = (short)Focusable.CashAmount;
PoleDisplay.WriteToDisplay(POUT.ChargedAmount, PoleDisplayType.AMOUNT);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public ParkingTicket()
{
InTime = DateTime.Now;
OutTime = InTime.Add(new TimeSpan(0, 30, 0));
IsExpired = false;
}
protected override void BuildParameters()
{
base.BuildParameters();
SQLParam sqlparam = new SQLParam();
sqlparam.Name = "@UserID";
sqlparam.Type = System.Data.SqlDbType.Int;
sqlparam.Value = UserId.ToString();
sqlparam.IntValue = UserId;
sqlparam.ColumnName = "UserID";
m_sql.parameters.Add(sqlparam);
sqlparam = new SQLParam();
sqlparam.Name = "@SignInDate";
sqlparam.Type = SqlDbType.Date;
sqlparam.Value = SignInDate.ToString("yyyy-mm-dd");
sqlparam.dtValue = SignInDate;
sqlparam.ColumnName = "SignInDate";
sqlparam.IncludeInModDT = true;
m_sql.parameters.Add(sqlparam);
sqlparam = new SQLParam();
sqlparam.Name = "@SignedIn";
sqlparam.Type = SqlDbType.Bit;
sqlparam.Value = SignedIn.ToString();
if (SignedIn)
{
sqlparam.IntValue = 1;
}
else
{
sqlparam.IntValue = 0;
}
sqlparam.ColumnName = "SignedIn";
sqlparam.IncludeInModDT = false;
m_sql.parameters.Add(sqlparam);
sqlparam = new SQLParam();
sqlparam.Name = "@InTime";
sqlparam.Type = SqlDbType.DateTime;
sqlparam.Value = InTime.ToString();
sqlparam.dtValue = InTime;
sqlparam.ColumnName = "InTime";
sqlparam.IncludeInModDT = false;
m_sql.parameters.Add(sqlparam);
sqlparam = new SQLParam();
sqlparam.Name = "@OutTime";
sqlparam.Type = SqlDbType.DateTime;
sqlparam.Value = OutTime.ToString();
sqlparam.dtValue = OutTime;
sqlparam.ColumnName = "OutTime";
sqlparam.IncludeInModDT = false;
m_sql.parameters.Add(sqlparam);
if (m_IncludeIDInParameters)
{
sqlparam = new SQLParam();
sqlparam.Name = "@ID";
sqlparam.Type = SqlDbType.Int;
sqlparam.Value = Convert.ToString(ID);
sqlparam.IntValue = ID;
sqlparam.ColumnName = m_primarykey;
sqlparam.IsPrimaryKey = true;
sqlparam.IncludeInModDT = true;
m_sql.parameters.Add(sqlparam);
}
}
