Пример #1
0
        private void StoreDataToDatabase(DataDeduct dataDeduct, ParkingOut parkingOut)
        {
            try
            {
                // store deduct result card to server
                string result       = dataDeduct.DeductResult;
                int    amount       = dataDeduct.Amount;
                string created      = dataDeduct.CreatedDatetime;
                string bank         = dataDeduct.Bank;
                string ipv4         = dataDeduct.IpAddress;
                string operatorName = dataDeduct.OperatorName;
                string idReader     = dataDeduct.IdReader;
                int    parkingOutId = parkingOut.ParkingOutId;

                string query = "INSERT INTO deduct_card_results (parking_out_id, result, amount, transaction_dt, bank, ipv4, operator, ID_reader, created) VALUES('" + parkingOutId + "', '" +
                               result + "', '" + amount + "', '" + created + "', '" + bank + "', '" + ipv4 + "', '" + operatorName + "', '" + idReader + "', '" + created + "')";

                database.Insert(query);
            }
            catch (Exception ex)
            {
                notifyIcon.ShowBalloonTip(Constant.NOTIFICATION_TRAY_TIMEOUT, "Error", ex.Message, ToolTipIcon.Error);
                return;
            }
        }
Пример #2
0
 public CreditNoteViewModel()
 {
     try
     {
         MessageBoxCaption = "Credit Note";
         TaxInvoice        = false;
         nepDate           = new DateConverter(GlobalClass.TConnectionString);
         PIN            = new ParkingIn();
         POUT           = new ParkingOut();
         CurDate        = DateTime.Today;
         CurTime        = DateTime.Now.ToString("hh:mm tt");
         timer          = new DispatcherTimer();
         timer.Interval = new TimeSpan(0, 0, 1);
         timer.Tick    += timer_Tick;
         timer.Start();
         NewCommand   = new RelayCommand(ExeucteNew);
         LoadData     = new RelayCommand(ExecuteLoad);
         SaveCommand  = new RelayCommand(ExecuteSave, CanExecuteSave);
         UndoCommand  = new RelayCommand(ExecuteUndo);
         PrintCommand = new RelayCommand(ExecutePrint, CanExecutePrint);
         SetAction(ButtonAction.Init);
         this.PropertyChanged += CreditNoteViewModel_PropertyChanged;
     }
     catch (Exception ex)
     {
         MessageBox.Show(GlobalClass.GetRootException(ex).Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
     }
 }
Пример #3
0
        public POutWithoutSlipVM()
        {
            try
            {
                MessageBoxCaption    = "Exit Without Slip";
                TaxInvoice           = false;
                CanChangeInvoiceType = true;
                nepDate = new DateConverter(GlobalClass.TConnectionString);
                PIN     = new ParkingIn();
                InDate  = DateTime.Today.Date;
                InTime  = DateTime.Now;
                POUT    = new ParkingOut();

                CurDate        = DateTime.Today;
                CurTime        = DateTime.Now.ToString("hh:mm tt");
                timer          = new DispatcherTimer();
                timer.Interval = new TimeSpan(0, 0, 1);
                timer.Tick    += timer_Tick;
                timer.Start();
                LoadData     = new RelayCommand(ExecuteLoad);
                NewCommand   = new RelayCommand(ExecuteNew);
                SaveCommand  = new RelayCommand(ExecuteSave, CanExecuteSave);
                UndoCommand  = new RelayCommand(ExecuteUndo);
                PrintCommand = new RelayCommand(ExecutePrint, CanExecutePrint);
                SetAction(ButtonAction.Init);
                using (SqlConnection conn = new SqlConnection(GlobalClass.TConnectionString))
                {
                    VTypeList = new ObservableCollection <VehicleType>(conn.Query <VehicleType>("SELECT VTypeID, Description FROM VehicleType"));
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(GlobalClass.GetRootException(ex).Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }
        public FunctionResponse ValidateStaffOrStamp(BarCodeTransfer barCodeTransfer)
        {
            ParkingOut POUT = barCodeTransfer.POUT;
            ParkingIn  PIN  = barCodeTransfer.PIN;

            try
            {
                using (SqlConnection conn = new SqlConnection(GlobalClass.DataConnectionString))
                {
                    if (POUT.STAFF_BARCODE != "STAMP")
                    {
                        POUT.STAFF_BARCODE = conn.ExecuteScalar <string>("SELECT BARCODE FROM tblStaff WHERE STATUS = 0 AND BCODE = '" + POUT.STAFF_BARCODE + "'");
                        if (string.IsNullOrEmpty(POUT.STAFF_BARCODE))
                        {
                            return(new FunctionResponse()
                            {
                                status = "error", Message = "Invalid Barcode. Please Try Again."
                            });
                        }
                        if (GlobalClass.AllowMultiVehicleForStaff == 0)
                        {
                            if (conn.ExecuteScalar <int>
                                (
                                    string.Format
                                    (
                                        @"SELECT COUNT(*) FROM
                            (
                                SELECT  INDATE + CAST(INTIME AS TIME) INTIME, OUTDATE + CAST(OUTTIME AS TIME) OUTTIME FROM ParkingInDetails PID 
                                JOIN ParkingOutDetails POD ON PID.PID =POD.PID AND PID.FYID = POD.FYID WHERE POD.STAFF_BARCODE = '{0}'
                            ) A WHERE (INTIME < '{1}' AND OUTTIME > '{1}') OR (INTIME > '{1}' AND OUTTIME > '{1}')", POUT.STAFF_BARCODE, PIN.InDate.Add(DateTime.Parse(PIN.InTime).TimeOfDay)
                                    )
                                ) > 0)
                            {
                                return(new FunctionResponse()
                                {
                                    status = "error", Message = "Staff already parked one vehicle during current vehile's parked period. Staff are not allowed to park multiple vehicle at a time"
                                });
                            }
                        }
                    }
                }
                POUT.CashAmount = 0;
                return(ExecuteSave(barCodeTransfer));

                //if (StaffBarcode != null)
                //    StaffBarcode.Close();
            }
            catch (Exception ex)
            {
                POUT.STAFF_BARCODE = null;
                return(new FunctionResponse()
                {
                    status = "error", Message = ex.Message
                });
            }
        }
Пример #5
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            string feedback = this.ValidateFields();

            if (feedback == Constant.MESSAGE_OK)
            {
                // check the payment method whether it's cash or non-cash
                int    totalFare     = TKHelper.IDRToNominal(txtGrandTotal.Text.ToString());
                string paymentMethod = nonCash.Checked ? "NCSH" : "CASH";

                if (paymentMethod == "NCSH")
                {
                    string bankCode      = "BNI";
                    string ipv4          = TKHelper.GetLocalIPAddress();
                    string TIDSettlement = Properties.Settings.Default.TID;
                    string operator_name = Properties.Settings.Default.Username;

                    // need to disconnect SCard from WinsCard.dll beforehand in order to execute further actions to avoid 'Outstanding Connection' Exception.
                    mifareCard.disconnect();

                    DataDeduct responseDeduct = bni.DeductBalance(bankCode, ipv4, TIDSettlement, operator_name);
                    if (!responseDeduct.IsError)
                    {
                        string base64WebcamImage        = CameraHelper.CaptureWebcamImage(camera, webcamImage);
                        string base64LiveCameraSnapshot = CameraHelper.SnapshotLiveCamera();
                        if (!string.IsNullOrEmpty(base64LiveCameraSnapshot))
                        {
                            ParkingOut parkingOut = SendDataToServer(totalFare, base64WebcamImage, base64LiveCameraSnapshot, paymentMethod);
                            StoreDataToDatabase(responseDeduct, parkingOut);
                            notifyIcon.ShowBalloonTip(Constant.NOTIFICATION_TRAY_TIMEOUT, "Success", Constant.TRANSACTION_SUCCESS, ToolTipIcon.Info);
                            Clear(true);
                        }
                    }
                    else
                    {
                        notifyIcon.ShowBalloonTip(Constant.NOTIFICATION_TRAY_TIMEOUT, "Error", responseDeduct.Message, ToolTipIcon.Error);
                    }
                }
                else
                {
                    string base64WebcamImage       = CameraHelper.CaptureWebcamImage(camera, webcamImage);
                    string base4LiveCameraSnapshot = CameraHelper.SnapshotLiveCamera();
                    if (!string.IsNullOrEmpty(base4LiveCameraSnapshot))
                    {
                        ParkingOut parkingOut = SendDataToServer(totalFare, base64WebcamImage, base4LiveCameraSnapshot, paymentMethod);
                        notifyIcon.ShowBalloonTip(Constant.NOTIFICATION_TRAY_TIMEOUT, "Success", Constant.TRANSACTION_SUCCESS, ToolTipIcon.Info);
                        Clear(true);
                    }
                }
            }
            else
            {
                notifyIcon.ShowBalloonTip(Constant.NOTIFICATION_TRAY_TIMEOUT, "Warning", feedback, ToolTipIcon.Warning);
            }
        }
Пример #6
0
 void CreditNoteViewModel_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e)
 {
     if (_action == ButtonAction.New)
     {
         if (e.PropertyName == "RefBillNo" || e.PropertyName == "TaxInvoice")
         {
             PIN  = new ParkingIn();
             POUT = new ParkingOut();
         }
     }
 }
Пример #7
0
 private void ExecuteUndo(object obj)
 {
     InvoiceNo  = string.Empty;
     RefBillNo  = string.Empty;
     Remarks    = string.Empty;
     TaxInvoice = false;
     PIN        = new ParkingIn();
     POUT       = new ParkingOut();
     SetAction(ButtonAction.Init);
     OnPropertyChanged("IsEntryMode");
 }
Пример #8
0
        public async void ExecuteFinishCommand()
        {
            try
            {
                if (PIN == null || POUT == null)
                {
                    DependencyService.Get <IMessage>().ShortAlert("No Vehicle to exit");
                    return;
                }
                if (POUT.PID == 0 || PIN.PID == 0)
                {
                    DependencyService.Get <IMessage>().ShortAlert("No vehicle entered to exit.");
                    return;
                }
                var ans = await App.Current.MainPage.DisplayAlert("Confirm", "Are you sure to Exit Vehicle?", "Yes", "No");

                if (!ans)
                {
                    return;
                }

                IsLoading = true;
                var transferData = new BarCodeTransfer()
                {
                    barcode = Barcode, Vouchers = Vouchers, mDiscount = mDiscount, PIN = PIN, POUT = POUT, Session = GlobalClass.User.Session
                };
                var res = await ParkingDetailsConnection.SavePOUT(transferData);

                if (res.status == "ok")
                {
                    DependencyService.Get <IMessage>().ShortAlert("Vehicle exited Successfully");
                    POUT      = new ParkingOut();
                    PIN       = new ParkingIn();
                    Vouchers  = new List <Voucher>();
                    mDiscount = new MemberDiscount();
                }
                else if (res.status == "error")
                {
                    DependencyService.Get <IMessage>().ShortAlert(res.Message);
                }
                else
                {
                    DependencyService.Get <IMessage>().ShortAlert("Error: Server Connection Problem");
                }
                IsLoading = false;
            }
            catch (Exception ex)
            {
                IsLoading = false;
                DependencyService.Get <IMessage>().ShortAlert(ex.Message);
            }
        }
Пример #9
0
 private void ExecuteUndo(object obj)
 {
     FocusedElement       = (short)Focusable.Barcode;
     TaxInvoice           = false;
     InvoiceNo            = string.Empty;
     CanChangeInvoiceType = true;
     PIN    = new ParkingIn();
     InDate = DateTime.Today.Date;
     InTime = DateTime.Now;
     POUT   = new ParkingOut();
     SetAction(ButtonAction.Init);
     OnPropertyChanged("IsEntryMode");
     PoleDisplay.WriteToDisplay(POUT.ChargedAmount, PoleDisplayType.AMOUNT);
 }
Пример #10
0
 private void btnSave_Click(object sender, EventArgs e)
 {
     if (ValidateFields())
     {
         string base64WebcamImage             = CameraHelper.CaptureWebcamImage(camera, webcamImage);
         string base64LiveCameraSnapshotImage = CameraHelper.SnapshotLiveCamera();
         if (!string.IsNullOrEmpty(base64LiveCameraSnapshotImage))
         {
             ParkingOut parkingOut = SendDataToServer(base64WebcamImage, base64LiveCameraSnapshotImage);
             notifyIcon.ShowBalloonTip(Constant.NOTIFICATION_TRAY_TIMEOUT, "Success", Constant.TRANSACTION_SUCCESS, ToolTipIcon.Info);
             Clear(true);
         }
     }
 }
Пример #11
0
 private void ExecuteSave(object obj)
 {
     try
     {
         if (!ParkingList.Any(x => x.Close))
         {
             MessageBox.Show("No entrance is checked for closing.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Exclamation);
             return;
         }
         if (ParkingList.Any(x => x.Close && string.IsNullOrEmpty(x.Remarks)))
         {
             MessageBox.Show("Remarks must be given for closing the entrance", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Exclamation);
             return;
         }
         using (SqlConnection conn = new SqlConnection(GlobalClass.TConnectionString))
         {
             conn.Open();
             using (SqlTransaction tran = conn.BeginTransaction())
             {
                 foreach (var p in ParkingList.Where(x => x.Close))
                 {
                     ParkingOut pout = new ParkingOut()
                     {
                         PID        = p.PID,
                         FYID       = p.FYID,
                         OutDate    = p.InDate,
                         OutMiti    = p.InMiti,
                         OutTime    = p.InTime,
                         SESSION_ID = GlobalClass.Session,
                         UID        = GlobalClass.User.UID,
                         Remarks    = p.Remarks,
                         Interval   = string.Empty,
                         Rate_ID    = 1
                     };
                     pout.Save(tran);
                 }
                 tran.Commit();
                 MessageBox.Show("Success", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Exclamation);
                 ParkingList.Clear();
             }
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.GetBaseException().Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
     }
 }
Пример #12
0
 public HomePageVM()
 {
     Test             = "Test";
     IsLoading        = false;
     LoadingMessage   = "Loading!! Please wait.....";
     Barcode          = "";
     LoadCommand      = new Command(ExecuteLoad);
     FinishCommand    = new Command(ExecuteFinishCommand);
     StampCommand     = new Command(ExecuteStampCommand);
     StaffCommand     = new Command(ExecuteStaffCommand);
     BackCommand      = new Command(ExecuteBackCommand);
     ViewStaffBarcode = new Command(ExecuteViewStaffBarcode);
     PIN            = new ParkingIn();
     POUT           = new ParkingOut();
     ParkingDetails = new BarCodeTransfer();
     Vouchers       = new List <Voucher>();
     mDiscount      = new MemberDiscount();
     StaffBarcode   = "";
 }
Пример #13
0
        private void SaveDataLostTicket()
        {
            int    totalFare     = TKHelper.IDRToNominal(txtGrandTotal.Text.ToString());
            string paymentMethod = cash.Checked ? "CASH" : "NCSH";

            if (paymentMethod == "NCSH")
            {
                string bankCode      = "BNI";
                string ipv4          = TKHelper.GetLocalIPAddress();
                string TIDSettlement = Properties.Settings.Default.TID;
                string operator_name = Properties.Settings.Default.Username;

                DataDeduct responseDeduct = bni.DeductBalance(bankCode, ipv4, TIDSettlement, operator_name);
                if (!responseDeduct.IsError)
                {
                    string base64WebcamImage             = CameraHelper.CaptureWebcamImage(camera, webcamImage);
                    string base64LiveCameraSnapshotImage = CameraHelper.SnapshotLiveCamera();
                    if (!string.IsNullOrEmpty(base64LiveCameraSnapshotImage))
                    {
                        ParkingOut parkingOut = SendDataToServer(base64WebcamImage, base64LiveCameraSnapshotImage, paymentMethod, totalFare);
                        StoreDataToDatabase(responseDeduct, parkingOut);
                        notifyIcon.ShowBalloonTip(Constant.NOTIFICATION_TRAY_TIMEOUT, "Success", Constant.TRANSACTION_SUCCESS, ToolTipIcon.Info);
                        Clear();
                    }
                }
                else
                {
                    notifyIcon.ShowBalloonTip(Constant.NOTIFICATION_TRAY_TIMEOUT, "Error", responseDeduct.Message, ToolTipIcon.Error);
                }
            }
            else
            {
                string base64WebcamImage             = CameraHelper.CaptureWebcamImage(camera, webcamImage);
                string base64LiveCameraSnapshotImage = CameraHelper.SnapshotLiveCamera();
                if (!string.IsNullOrEmpty(base64LiveCameraSnapshotImage))
                {
                    SendDataToServer(base64WebcamImage, base64LiveCameraSnapshotImage, paymentMethod, totalFare);
                    notifyIcon.ShowBalloonTip(Constant.NOTIFICATION_TRAY_TIMEOUT, "Success", Constant.TRANSACTION_SUCCESS, ToolTipIcon.Info);
                    Clear();
                }
            }
        }
Пример #14
0
        public async void ExecuteStaffCommand()
        {
            try
            {
                //IsStaffBarcode = false;
                if (string.IsNullOrEmpty(StaffBarcode))
                {
                    DependencyService.Get <IMessage>().ShortAlert("Invalid Barcode. Please Try Again");
                    return;
                }

                POUT.SESSION_ID    = GlobalClass.User.Session;
                POUT.STAFF_BARCODE = StaffBarcode;
                var transferData = new BarCodeTransfer()
                {
                    barcode = Barcode, Vouchers = Vouchers, mDiscount = mDiscount, PIN = PIN, POUT = POUT, Session = GlobalClass.User.Session
                };
                var res = await ParkingDetailsConnection.SaveStaffOrStampPOUT(transferData);

                if (res.status == "ok")
                {
                    IsStaffBarcode = false;
                    DependencyService.Get <IMessage>().ShortAlert("Vehicle exited Successfully");
                    POUT      = new ParkingOut();
                    PIN       = new ParkingIn();
                    Vouchers  = new List <Voucher>();
                    mDiscount = new MemberDiscount();
                }
                else if (res.status == "error")
                {
                    DependencyService.Get <IMessage>().ShortAlert(res.Message);
                }
            }
            catch (Exception ex)
            {
                DependencyService.Get <IMessage>().ShortAlert(ex.Message);
            }
        }
Пример #15
0
        public FunctionResponse CheckParkingSlip(BarCodeTransfer transferData)
        {
            try
            {
                string     barcode = transferData.barcode;
                ParkingOut POUT    = new ParkingOut();


                decimal ChargedHours  = 0;
                decimal ChargedAmount = 0;
                using (SqlConnection conn = new SqlConnection(ConnectionDbInfo.ConnectionString))
                {
                    try
                    {
                        if (transferData.POUT != null && (transferData.POUT.PID) != 0)
                        {
                            transferData.POUT.SaveLog(conn);
                        }
                    }
                    catch { }


                    var PINS = conn.Query <ParkingIn>(@"SELECT PID, VehicleType, InDate, InMiti, InTime, PlateNo, Barcode, UID FROM ParkingInDetails 
WHERE((BARCODE <> '' AND  BARCODE = @barcode) OR(ISNULL(PLATENO, '') <> '' AND ISNULL(PlateNo, '') = @barcode))
AND FYID = @fyid", new { barcode, fyid = GlobalClass.FYID });
                    if (PINS.Count() <= 0)
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "Invalid barcode readings."
                        });
                    }
                    ParkingIn PIN = PINS.First();
                    PIN.VType = conn.Query <VehicleType>(string.Format("SELECT VTypeId, Description FROM VehicleType WHERE VTypeId = {0}", PIN.VehicleType)).First();
                    var POUTS = conn.Query <ParkingOut>(string.Format("SELECT * FROM ParkingOutDetails WHERE PID = {0} AND FYID = {1}", PIN.PID, GlobalClass.FYID));
                    if (POUTS.Count() > 0)
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "Entity already exited"
                        });
                    }
                    POUT.Rate_ID = (int)conn.ExecuteScalar("SELECT RATE_ID FROM RATEMASTER WHERE IsDefault = 1");

                    DateTime ServerTime = conn.ExecuteScalar <DateTime>("SELECT GETDATE()");
                    POUT.OutDate  = ServerTime.Date;
                    POUT.OutTime  = ServerTime.ToString("hh:mm:ss tt");
                    POUT.OutMiti  = conn.ExecuteScalar <String>("SELECT MITI FROM DATEMITI WHERE AD = @AD", new { AD = ServerTime.Date });
                    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, ref ChargedAmount, ref ChargedHours);
                    POUT.ChargedHours  = ChargedHours;
                    POUT.ChargedAmount = ChargedAmount;
                    POUT.CashAmount    = POUT.ChargedAmount;
                    PIN.Barcode        = string.Empty;
                    bool IsHoliday = conn.ExecuteScalar <int>("SELECT COUNT(*) FROM Holiday WHERE HolidayDate = @HolidayDate", new { HolidayDate = POUT.OutDate }) > 0;
                    return(new FunctionResponse()
                    {
                        status = "ok", result = new BarCodeTransfer()
                        {
                            barcode = barcode, Vouchers = new List <Voucher>(), mDiscount = new MemberDiscount(), POUT = POUT, PIN = PIN, IsHoliday = IsHoliday
                        }
                    });
                }
            }
            catch (Exception ex)
            {
                return(new FunctionResponse()
                {
                    status = "error", Message = ex.Message
                });
            }
        }
Пример #16
0
        public FunctionResponse ValidateMember(BarCodeTransfer obj)
        {
            try
            {
                string         barcode   = obj.barcode;
                List <Voucher> Vouchers  = obj.Vouchers;
                MemberDiscount mDiscount = obj.mDiscount;
                ParkingIn      PIN       = obj.PIN;
                ParkingOut     POUT      = obj.POUT;

                if (mDiscount != null && !string.IsNullOrEmpty(mDiscount.MemberId))
                {
                    return new FunctionResponse()
                           {
                               status = "error", Message = "Member already accepted."
                           }
                }
                ;
                TimeSpan InTime         = DateTime.Parse(PIN.InTime).TimeOfDay;
                TimeSpan OutTime        = DateTime.Parse(POUT.OutTime).TimeOfDay;
                decimal  DiscountAmount = 0;
                decimal  DiscountHour   = 0;
                int      Interval;

                using (SqlConnection conn = new SqlConnection(GlobalClass.DataConnectionString))
                {
                    Member m = conn.Query <Member>("SELECT MemberId, MemberName, SchemeId, ExpiryDate, ActivationDate, Barcode, Address FROM Members WHERE Barcode = @MemberId ", new { MemberId = barcode.ToString() }).FirstOrDefault();

                    if (m == null)
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "The member does not exists."
                        });
                    }
                    else if (m.ActivationDate > POUT.OutDate || m.ExpiryDate < POUT.OutDate)
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "The membership is expired or not yet activated."
                        });
                    }
                    MembershipScheme scheme = conn.Query <MembershipScheme>("SELECT * FROM MembershipScheme WHERE SchemeId = @SchemeId", m).FirstOrDefault();
                    if (scheme == null)
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "Membership scheme does not exists."
                        });
                    }
                    else if (!scheme.ValidOnWeekends && POUT.OutDate.DayOfWeek == DayOfWeek.Saturday)
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "The Membership is not valid on Weekends"
                        });
                    }
                    else if (!scheme.ValidOnHolidays && conn.ExecuteScalar <int>("SELECT COUNT(*) FROM Holiday WHERE HolidayDate = @HolidayDate", new { HolidayDate = POUT.OutDate }) > 0)
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "The Membership is not valid on Public Holidays"
                        });
                    }
                    List <dynamic> TimeSpentInEachSession = GetTimeSpentInEachSession(InTime, OutTime, scheme, PIN);

                    Interval = conn.ExecuteScalar <int>("SELECT ISNULL(SUM(MDD.Interval - MDD.SkipInterval),0) Interval FROM MemberDiscountDetail MDD JOIN ParkingOutDetails POD ON MDD.PID = POD.PID WHERE MemberId = @MemberId AND POD.OutDate = @OutDate", new { MemberId = m.MemberId, OutDate = POUT.OutDate });
                    if (Interval >= scheme.Limit && !TimeSpentInEachSession.Any(x => x.SkipValidityPeriod && x.TimeSpent > 0))
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "Free Entrance for the Member has exceeded for day."
                        });
                    }

                    mDiscount = new MemberDiscount
                    {
                        MemberId = m.MemberId,
                        SchemeId = m.SchemeId,
                        FYID     = POUT.FYID,
                        PID      = PIN.PID,
                    };
                    POUT.BILLTO    = m.MemberName;
                    POUT.BILLTOADD = m.Address;

                    if (TimeSpentInEachSession.Any(x => x.SkipValidityPeriod))
                    {
                        mDiscount.SkipInterval = TimeSpentInEachSession.Where(x => x.SkipValidityPeriod).Sum(x => x.TimeSpent);
                    }

                    int DiscountInterval = scheme.Limit - Interval + mDiscount.SkipInterval;
                    foreach (dynamic session in TimeSpentInEachSession.Where(x => x.TimeSpent > 0))
                    {
                        if (session.IgnoreLimit)
                        {
                            CalculateParkingCharge(conn, session.Start, session.End, POUT.Rate_ID, PIN.VehicleType, ref DiscountAmount, ref DiscountHour);
                            DiscountInterval -= session.TimeSpent;
                        }
                        else
                        {
                            CalculateParkingCharge(conn, session.Start, (DiscountInterval < session.TimeSpent) ? session.Start.AddMinutes(DiscountInterval) : session.End, POUT.Rate_ID, PIN.VehicleType, ref DiscountAmount, ref DiscountHour);
                            DiscountInterval -= (DiscountInterval < session.TimeSpent) ? DiscountInterval : session.TimeSpent;
                        }
                        mDiscount.Interval       += DiscountHour * 60;
                        mDiscount.DiscountAmount += DiscountAmount * scheme.Discount / 100;
                        DiscountHour              = 0;
                        DiscountAmount            = 0;
                    }
                    POUT.CashAmount = POUT.ChargedAmount = POUT.ChargedAmount - mDiscount.DiscountAmount;
                    obj.mDiscount   = mDiscount;

                    return(new FunctionResponse()
                    {
                        status = "ok", result = obj
                    });
                }

                //if (POUT.CashAmount == 0)
                //    ExecuteSave(null);
                //PoleDisplay.WriteToDisplay(POUT.CashAmount, PoleDisplayType.AMOUNT);
            }catch (Exception ex)
            {
                return(new FunctionResponse()
                {
                    status = "error", Message = ex.Message
                });
            }
        }
Пример #17
0
        public FunctionResponse ValidateVoucher(BarCodeTransfer obj)
        {
            try
            {
                string         barcode   = obj.barcode;
                List <Voucher> Vouchers  = obj.Vouchers;
                MemberDiscount mDiscount = obj.mDiscount;
                ParkingIn      PIN       = obj.PIN;
                ParkingOut     POUT      = obj.POUT;

                if (Vouchers.Any(x => x.Barcode.ToUpper() == barcode.ToUpper().ToString()))
                {
                    return new FunctionResponse()
                           {
                               status = "error", Message = "Voucher already accepted."
                           }
                }
                ;

                using (SqlConnection conn = new SqlConnection(GlobalClass.DataConnectionString))
                {
                    Voucher v = conn.Query <Voucher>("SELECT VoucherNo, Barcode, VoucherId, Value, ExpDate, ValidStart, ValidEnd, ScannedTime FROM ParkingVouchers WHERE Barcode = @Barcode", new { Barcode = barcode.ToString() }).FirstOrDefault();

                    if (v == null)
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "InValid Voucher"
                        });
                    }
                    else if (v.ScannedTime == null)
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "Voucher already redeemed."
                        });
                    }
                    else if (!VoucherTypes.Any(x => x.VoucherId == v.VoucherId && x.VehicleType == PIN.VehicleType))
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "The Voucher is not valid for current Entrance Type."
                        });
                    }
                    else if (v.ExpDate < CurDate)
                    {
                        return(new FunctionResponse()
                        {
                            status = "error", Message = "Voucher has expired."
                        });
                    }
                    else
                    {
                        TimeSpan outTime = Convert.ToDateTime(POUT.OutTime).TimeOfDay;
                        if (v.ValidStart < v.ValidEnd)
                        {
                            if (outTime < v.ValidStart || outTime > v.ValidEnd)
                            {
                                return(new FunctionResponse()
                                {
                                    status = "error", Message = "Voucher is not valid for current Shift."
                                });
                            }
                        }
                        else
                        {
                            if (outTime < v.ValidStart && outTime > v.ValidEnd)
                            {
                                return(new FunctionResponse()
                                {
                                    status = "error", Message = "Voucher is not valid for current Shift."
                                });
                            }
                        }
                        v.Value         = (POUT.ChargedAmount > v.Value) ? v.Value : POUT.ChargedAmount;
                        POUT.CashAmount = POUT.CashAmount - v.Value;
                        //PIN.Barcode = string.Empty;
                        Vouchers.Add(v);

                        return(new FunctionResponse()
                        {
                            status = "ok", result = obj
                        });

                        //if (POUT.CashAmount == 0)
                        //    ExecuteSave(null);
                        //PoleDisplay.WriteToDisplay(POUT.CashAmount, PoleDisplayType.AMOUNT);
                    }
                }
            }catch (Exception ex)
            {
                return(new FunctionResponse()
                {
                    status = "error", Message = ex.Message
                });
            }
        }
Пример #18
0
        public FunctionResponse ExecuteSave(BarCodeTransfer obj)
        {
            int            Session   = obj.Session;
            List <Voucher> Vouchers  = obj.Vouchers;
            string         barcode   = obj.barcode;
            MemberDiscount mDiscount = obj.mDiscount;
            ParkingOut     POUT      = obj.POUT;

            GlobalClass.GetUser(POUT.UID);

            string  strSQL;
            decimal Taxable, VAT, Amount, Discount = 0, NonTaxable, Rate, Quantity;
            string  BillNo = string.Empty;

            try
            {
                using (SqlConnection conn = new SqlConnection(ConnectionDbInfo.ConnectionString))
                {
                    conn.Open();
                    using (SqlTransaction tran = conn.BeginTransaction())
                    {
                        POUT.SESSION_ID = Session;
                        POUT.FYID       = GlobalClass.FYID;
                        POUT.Save(tran);
                        if (POUT.CashAmount > 0)
                        {
                            BillNo   = InvoicePrefix + GlobalClass.GetInvoiceNo(InvoicePrefix, tran);
                            Quantity = POUT.ChargedHours;
                            if (Vouchers.Count > 0)
                            {
                                Discount = Vouchers.Sum(x => x.Value);
                            }
                            else if (mDiscount != null && !string.IsNullOrEmpty(mDiscount.MemberId))
                            {
                                Discount = mDiscount.DiscountAmount;
                            }
                            else if (POUT.CashAmount < POUT.ChargedAmount)
                            {
                                Discount = POUT.ChargedAmount - POUT.CashAmount;
                            }
                            Amount     = POUT.ChargedAmount / (1 + (GlobalClass.VAT / 100));
                            Discount   = Discount / (1 + (GlobalClass.VAT / 100));
                            Rate       = Amount / Quantity;
                            NonTaxable = 0;
                            Taxable    = Amount - (NonTaxable + Discount);
                            VAT        = Taxable * GlobalClass.VAT / 100;

                            TParkingSales PSales = new TParkingSales
                            {
                                BillNo      = BillNo,
                                TDate       = POUT.OutDate,
                                TMiti       = POUT.OutMiti,
                                TTime       = POUT.OutTime,
                                BillTo      = POUT.BILLTO,
                                BILLTOADD   = POUT.BILLTOADD,
                                BILLTOPAN   = POUT.BILLTOPAN,
                                Amount      = Amount,
                                Discount    = Discount,
                                NonTaxable  = NonTaxable,
                                Taxable     = Taxable,
                                VAT         = VAT,
                                GrossAmount = POUT.CashAmount,
                                PID         = POUT.PID,
                                UID         = POUT.UID,
                                SESSION_ID  = POUT.SESSION_ID,
                                FYID        = GlobalClass.FYID,
                                TaxInvoice  = TaxInvoice
                            };
                            PSales.Save(tran);
                            TParkingSalesDetails PSalesDetails = new TParkingSalesDetails
                            {
                                BillNo      = BillNo,
                                PType       = 'P',
                                Description = "Parking Charge",
                                FYID        = GlobalClass.FYID,
                                Quantity    = Quantity,
                                Rate        = Rate,
                                Amount      = Amount,
                                Discount    = Discount,
                                NonTaxable  = NonTaxable,
                                Taxable     = Taxable,
                                VAT         = VAT,
                                NetAmount   = POUT.CashAmount,
                            };
                            PSalesDetails.Save(tran);

                            conn.Execute("UPDATE tblSequence SET CurNo = CurNo + 1 WHERE VNAME = @VNAME AND FYID = @FYID", new { VNAME = InvoicePrefix, FYID = GlobalClass.FYID }, transaction: tran);


                            GlobalClass.SetUserActivityLog(tran, "Exit", "New", VCRHNO: BillNo, WorkDetail: "Bill No : " + BillNo);
                            //SyncFunctions.LogSyncStatus(tran, BillNo, GlobalClass.FYNAME);
                        }
                        if (Vouchers.Count > 0)
                        {
                            strSQL = "INSERT INTO VoucherDiscountDetail (BillNo, FYID, VoucherNo, DiscountAmount, UID) VALUES (@BillNo, @FYID, @VoucherNo, @DiscountAmount, @UID)";
                            foreach (Voucher v in Vouchers)
                            {
                                conn.Execute(strSQL, new
                                {
                                    BillNo         = string.IsNullOrEmpty(BillNo) ? "CS1" : BillNo,
                                    FYID           = GlobalClass.FYID,
                                    VoucherNo      = v.VoucherNo,
                                    DiscountAmount = v.Value,
                                    UID            = POUT.UID
                                }, transaction: tran);
                                conn.Execute("UPDATE ParkingVouchers SET ScannedTime = GETDATE() WHERE VoucherNo = @VoucherNo", v, tran);
                            }
                        }
                        else if (mDiscount != null && !string.IsNullOrEmpty(mDiscount.MemberId))
                        {
                            mDiscount.BillNo = string.IsNullOrEmpty(BillNo) ? "MS1" : BillNo;
                            mDiscount.Save(tran);
                        }
                        tran.Commit();
                        //if (!string.IsNullOrEmpty(SyncFunctions.username) && POUT.CashAmount > 0)
                        //{
                        //    SyncFunctions.SyncSalesData(SyncFunctions.getBillObject(BillNo), 1);
                        //}
                    }
                    //if (!string.IsNullOrEmpty(BillNo))
                    //{
                    //    RawPrinterHelper.SendStringToPrinter(GlobalClass.PrinterName, ((char)27).ToString() + ((char)112).ToString() + ((char)0).ToString() + ((char)64).ToString() + ((char)240).ToString(), "Receipt");   //Open Cash Drawer
                    //    PrintBill(BillNo.ToString(), conn, (TaxInvoice) ? "TAX INVOICE" : "ABBREVIATED TAX INVOCE");
                    //    if (TaxInvoice)
                    //    {
                    //        PrintBill(BillNo.ToString(), conn, "INVOICE");
                    //    }
                    //}

                    return(new FunctionResponse()
                    {
                        status = "ok", Message = "Saved Successfully"
                    });
                }
            }
            catch (Exception ex)
            {
                return(new FunctionResponse()
                {
                    status = "error", Message = ex.Message
                });
            }
        }
Пример #19
0
        public async void ExecuteLoad()
        {
            try
            {
                if (string.IsNullOrEmpty(Barcode))
                {
                    DependencyService.Get <IMessage>().ShortAlert("Enter Correct barcode ");
                    return;
                }
                IsLoading = true;
                var res = new FunctionResponse();
                if (Barcode.ToString().StartsWith("#"))
                {
                    if (POUT.PID == 0)
                    {
                        DependencyService.Get <IMessage>().ShortAlert("Voucher cannot be accepted. No Vehicle barcode scanned.");
                        IsLoading = false;
                        return;
                    }
                    if (Vouchers.Any(x => x.Barcode.ToUpper() == Barcode.ToUpper().ToString()))
                    {
                        DependencyService.Get <IMessage>().ShortAlert("Voucher already Accepted.");
                        IsLoading = false;
                        return;
                    }
                    var transferData = new BarCodeTransfer()
                    {
                        barcode = Barcode.ToUpper(), Vouchers = Vouchers, mDiscount = mDiscount, PIN = PIN, POUT = POUT
                    };
                    res = await ParkingDetailsConnection.UploadVoucherCode(transferData);

                    if (res.status == "ok")
                    {
                        DependencyService.Get <IMessage>().ShortAlert("Voucher Discount applied Successfully");
                    }
                }
                else if (Barcode.ToUpper().ToString().StartsWith(GlobalClass.MemberBarcodePrefix))
                {
                    if (POUT.PID == 0)
                    {
                        DependencyService.Get <IMessage>().LongAlert("MemberCard cannot be accepted. No Vehicle barcode scanned.");
                        IsLoading = false;
                        return;
                    }
                    if (mDiscount != null && !string.IsNullOrEmpty(mDiscount.MemberId))
                    {
                        DependencyService.Get <IMessage>().ShortAlert("Member already Accepted.");
                        IsLoading = false;
                        return;
                    }
                    var transferData = new BarCodeTransfer()
                    {
                        barcode = Barcode.ToUpper(), Vouchers = Vouchers, mDiscount = mDiscount, PIN = PIN, POUT = POUT
                    };
                    res = await ParkingDetailsConnection.UploadMemberCode(transferData);

                    if (res.status == "ok")
                    {
                        DependencyService.Get <IMessage>().ShortAlert("Member Discount applied successfully");
                    }
                }
                else
                {
                    var transferData = new BarCodeTransfer()
                    {
                        barcode = Barcode.ToUpper(), PIN = PIN, POUT = POUT
                    };

                    res = await ParkingDetailsConnection.LoadParkingOutAsync(transferData);

                    if (res.status == "error")
                    {
                        PIN       = new ParkingIn();
                        POUT      = new ParkingOut();
                        Vouchers  = new List <Voucher>();
                        mDiscount = new MemberDiscount();
                    }
                    if (res.status == "ok")
                    {
                        DependencyService.Get <IMessage>().ShortAlert("Details Loaded Successfully");
                    }
                }
                if (res.status == "ok")
                {
                    ParkingDetails = JsonConvert.DeserializeObject <BarCodeTransfer>(res.result.ToString());
                    if (ParkingDetails != null)
                    {
                        PIN             = ParkingDetails.PIN;
                        POUT            = ParkingDetails.POUT;
                        POUT.UID        = GlobalClass.User.UID;
                        POUT.SESSION_ID = GlobalClass.User.Session;
                        Vouchers        = ParkingDetails.Vouchers;
                        mDiscount       = ParkingDetails.mDiscount;
                        Barcode         = "";
                    }
                }
                else
                {
                    DependencyService.Get <IMessage>().ShortAlert(res.Message);
                }
                IsLoading = false;
            }catch (Exception ex)
            {
                IsLoading = false;
                DependencyService.Get <IMessage>().ShortAlert(ex.Message);
            }
        }