private void UpdateDriverCommission(decimal rentLimit)
        {
            try
            {
                long?updateCommissionId = null;
                using (TaxiDataContext db = new TaxiDataContext())
                {
                    updateCommissionId = db.Fleet_DriverCommision_Charges.OrderByDescending(c => c.Id).FirstOrDefault().DefaultIfEmpty().TransId;


                    if (updateCommissionId.ToLong() > 0)
                    {
                        Fleet_DriverCommision objCommission = db.Fleet_DriverCommisions.FirstOrDefault(c => c.Id == updateCommissionId);


                        if (objCommission != null && objCommission.CommissionTotal > rentLimit)
                        {
                            decimal Credit         = 0.00m;
                            decimal Debit          = 0.00m;
                            decimal totalCredit    = 0.00m;
                            decimal totalDebit     = 0.00m;
                            decimal owedBalance    = 0.00m;
                            decimal Currentbalance = 0.00m;


                            decimal pdaRent = objCommission.PDARent.ToDecimal();
                            decimal collectionAndDelivery = objCommission.CollectionDeliveryCharges.ToDecimal();


                            decimal accountJobsTotal = objCommission.Fleet_DriverCommision_Charges.Where(c => c.Booking.PaymentTypeId != Enums.PAYMENT_TYPES.CASH).Sum(c => (c.Booking.FareRate + c.Booking.MeetAndGreetCharges)).ToDecimal();
                            decimal jobsFareTotal    = objCommission.Fleet_DriverCommision_Charges.Sum(c => (c.Booking.FareRate + c.Booking.MeetAndGreetCharges)).ToDecimal();

                            decimal agentTotal = objCommission.Fleet_DriverCommision_Charges.Where(c => c.Booking.PaymentTypeId == Enums.PAYMENT_TYPES.CASH).Sum(c => c.Booking.AgentCommission).ToDecimal();

                            //  decimal commissionTotal = objCommission.Fleet_DriverCommision_Charges.Sum(c => ((c.Booking.FareRate + c.Booking.MeetAndGreetCharges) * objCommission.DriverCommision) / 100).ToDecimal();
                            decimal commissionTotal = rentLimit;

                            decimal owed = Math.Round((pdaRent + agentTotal + commissionTotal) - accountJobsTotal, 2);

                            if (objCommission.Fleet_DriverCommissionExpenses.Count > 0)
                            {
                                Debit  = objCommission.Fleet_DriverCommissionExpenses.Sum(c => c.Debit).ToDecimal();
                                Credit = objCommission.Fleet_DriverCommissionExpenses.Sum(c => c.Credit).ToDecimal();
                            }


                            totalCredit = (commissionTotal + Credit);
                            totalDebit  = (accountJobsTotal + Debit);

                            owedBalance    = (totalCredit - totalDebit);
                            Currentbalance = owedBalance;

                            objCommission.CommissionTotal = commissionTotal;
                            objCommission.AccJobsTotal    = accountJobsTotal;
                            objCommission.Balance         = Currentbalance;
                            objCommission.AgentFeesTotal  = agentTotal;

                            objCommission.JobsTotal  = jobsFareTotal;
                            objCommission.DriverOwed = owed;

                            db.SubmitChanges();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
示例#2
0
 public DriversController(TaxiDataContext dbContext)
 {
     DbContext = dbContext;
 }
示例#3
0
        private void Display()
        {
            try
            {
                int Id = ddlCompany.SelectedValue.ToInt();
                grdPayment.RowCount = 0;
                using (TaxiDataContext db = new TaxiDataContext())
                {
                    var item = (from a in db.Invoices.Where(c => (c.CompanyId == Id) && (InvoiceId == 0 || c.Id == InvoiceId))
                                orderby a.Id descending
                                select new
                    {
                        Id = a.Id,
                        a.InvoiceTotal,
                        a.TotalInvoiceAmount,
                        a.InvoiceNo,
                        a.Gen_Company.HasVat,
                        a.CurrentBalance,
                        a.Gen_Company.AdminFees,
                        a.Gen_Company.DiscountPercentage
                    }).FirstOrDefault();

                    var objCreditNote = db.InvoiceCreditNotes.Where(c => c.InvoiceId == InvoiceId).Select(c => new { c.Id, c.CreditNoteTotal }).FirstOrDefault();


                    if (item == null)
                    {
                        lblMessage.Visible = true;
                        grdPayment.Rows.Clear();
                        txtInvoiceno.Text    = "";
                        txtBalance.Value     = 0;
                        txtInvoiceTotal.Text = "0.00";
                        return;
                    }


                    lblMessage.Visible = false;
                    InvoiceId          = item.Id.ToInt();;
                    txtInvoiceno.Text  = item.InvoiceNo;

                    decimal creditNoteTotal = 0.00m;

                    decimal Total          = item.InvoiceTotal.ToDecimal();
                    decimal adminFees      = item.AdminFees.ToInt();
                    decimal discountAmount = 0.00m;

                    if (objCreditNote != null)
                    {
                        creditNoteTotal = objCreditNote.CreditNoteTotal.ToDecimal();
                    }

                    if (item.DiscountPercentage.ToDecimal() > 0)
                    {
                        lblDiscount.Text = "Discount " + string.Format("{0:##0.##}", item.DiscountPercentage.ToDecimal()) + "%";
                        discountAmount   = ((Total * item.DiscountPercentage) / 100).ToDecimal();

                        Total = Total - discountAmount;



                        if (creditNoteTotal > 0)
                        {
                            discountAmount  = ((creditNoteTotal * item.DiscountPercentage) / 100).ToDecimal();
                            creditNoteTotal = creditNoteTotal - discountAmount;
                        }
                    }

                    if (item.HasVat.ToBool())
                    {
                        Total = (Total + ((Total * 20) / 100));

                        if (creditNoteTotal > 0)
                        {
                            creditNoteTotal = (creditNoteTotal + ((creditNoteTotal * 20) / 100));
                        }
                    }
                    else
                    {
                        Total = (Total + ((Total * adminFees) / 100));


                        if (creditNoteTotal > 0)
                        {
                            creditNoteTotal = (creditNoteTotal + ((creditNoteTotal * adminFees) / 100));
                        }
                    }



                    txtInvoiceTotal.Text = Total.ToStr();

                    if (objCreditNote != null)
                    {
                        lblCreditNote.Visible = true;
                        txtCreditNote.Visible = true;
                        txtCreditNote.Text    = creditNoteTotal.ToStr();
                    }
                    else
                    {
                        txtCreditNote.Text = creditNoteTotal.ToStr();
                    }

                    var data1 = db.invoice_Payments.Where(c => c.invoiceId == item.Id).OrderBy(c => c.id);



                    var query = (from a in data1
                                 select new
                    {
                        Id = a.id,
                        invoiceID = a.invoiceId,
                        Payment = a.InvoicePayment,
                        Balance = a.Balance,
                        Date = a.PaymentDate,
                        a.AddBy,
                        a.AddOn
                    }).AsQueryable();


                    if (query.Count() > 0)
                    {
                        DataTable dt = query.ToDataTable();
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            GridViewRowInfo row = null;

                            if (grdPayment.CurrentRow != null)
                            {
                                row = grdPayment.CurrentRow;
                            }

                            else
                            {
                                row = grdPayment.Rows.AddNew();
                            }
                            row.Cells[COL_PAYMENT.PAYMENT].Value  = dt.Rows[i]["Payment"].ToDecimal();
                            row.Cells[COL_PAYMENT.BALANCE].Value  = dt.Rows[i]["Balance"].ToDecimal();
                            row.Cells[COL_PAYMENT.DATE].Value     = dt.Rows[i]["Date"].ToDateTime();
                            row.Cells[COL_PAYMENT.AddOn].Value    = dt.Rows[i]["AddOn"].ToDateTime();
                            row.Cells[COL_PAYMENT.AddBy].Value    = dt.Rows[i]["AddBy"];
                            row.Cells[COL_PAYMENT.ID].Value       = dt.Rows[i]["Id"].ToInt();
                            row.Cells[COL_PAYMENT.MASTERID].Value = InvoiceId;
                            grdPayment.CurrentRow = null;
                        }
                    }



                    if (Total > 0 && grdPayment.Rows.Count == 0)
                    {
                        txtBalance.Value = Total - creditNoteTotal;
                    }
                    else
                    {
                        txtBalance.Value = item.CurrentBalance.ToDecimal();
                    }
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
示例#4
0
        public static async Task <(Taxi Taxi, Driver Driver, int ID)> AddDummyRideAsync(this TaxiDataContext DbContext)
        {
            var newTaxi = await DbContext.AddDummyTaxiAsync();

            var newDriver = await DbContext.AddDummyDriverAsync();

            var newRideID = await DbContext.StartRideAsync(newTaxi.Taxi, newDriver.Driver);

            return(newTaxi.Taxi, newDriver.Driver, newRideID);
        }
示例#5
0
        public void GenerateReport()
        {
            try
            {
                if (ddlCompany.SelectedValue == null)
                {
                    pnlCriteria.Visible = false;
                }

                reportViewer1.LocalReport.EnableExternalImages = true;


                if (ObjSubCompany == null)
                {
                    ObjSubCompany = AppVars.objSubCompany;
                }



                Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[28];

                string address = ObjSubCompany.Address;
                string telNo   = string.Empty;



                string sortCode     = ObjSubCompany.SortCode.ToStr();
                string accountNo    = ObjSubCompany.AccountNo.ToStr();
                string accountTitle = ObjSubCompany.AccountTitle.ToStr();
                string bank         = ObjSubCompany.BankName.ToStr();

                string hasBankDetails = "1";
                if (string.IsNullOrEmpty(sortCode) && string.IsNullOrEmpty(accountNo) && string.IsNullOrEmpty(accountTitle) &&
                    string.IsNullOrEmpty(bank))
                {
                    hasBankDetails = "0";
                }

                if (!string.IsNullOrEmpty(sortCode))
                {
                    sortCode = "Sort Code : " + sortCode;
                }



                if (!string.IsNullOrEmpty(accountTitle))
                {
                    accountTitle = "Account Title : " + accountTitle;
                }



                string website = ObjSubCompany.WebsiteUrl.ToStr();
                if (!string.IsNullOrEmpty(website))
                {
                    website += " , ";
                }

                website += "Email:" + ObjSubCompany.EmailAddress.ToStr();


                string companyNumber = ObjSubCompany.CompanyNumber.ToStr();
                if (!string.IsNullOrEmpty(companyNumber))
                {
                    companyNumber = "Company Number: " + companyNumber;
                }

                string vatNumber = ObjSubCompany.CompanyVatNumber.ToStr();


                //if (AppVars.objPolicyConfiguration.DefaultClientId.ToStr().Trim() == "yeAr$ettle_ltd_t/A_c!ty_cAr$")
                //{
                //    vatNumber = "Acc No          :     11616162" + Environment.NewLine +
                //                "Sort Code     :     83-07-06" + Environment.NewLine +
                //                "Ref No          :     Call Sign" + Environment.NewLine +
                //                "Bank             :     Royal Bank of Scotland";


                //}

                param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address);

                param[18] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Footer", ObjSubCompany.WebsiteUrl.ToStr());

                param[14] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_MobileNo", "Mobile: " + ObjSubCompany.EmergencyNo.ToStr());
                param[15] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Website", website);
                param[16] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Email", "Email: " + ObjSubCompany.EmailAddress.ToStr());

                param[20] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CompanyNumber", companyNumber);
                param[21] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_VATNumber", vatNumber);


                param[7]  = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_SortCode", sortCode);
                param[9]  = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_AccountTitle", accountTitle);
                param[10] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Bank", bank);


                List <ClsLogo> objLogo = new List <ClsLogo>();
                objLogo.Add(new ClsLogo {
                    ImageInBytes = ObjSubCompany.CompanyLogo != null ? ObjSubCompany.CompanyLogo.ToArray() : null
                });
                ReportDataSource imageDataSource = new ReportDataSource("Taxi_AppMain_Classes_ClsLogo", objLogo);
                this.reportViewer1.LocalReport.DataSources.Add(imageDataSource);

                string path = @"File:";
                param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Path", path);
                param[6] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CompanyHeader", ObjSubCompany.CompanyName.ToStr());

                param[22] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CompanyHeading", ObjSubCompany.CompanyName.ToStr());

                int?driverId = this.DataSource.FirstOrDefault().DefaultIfEmpty().DriverId;

                var data = this.DataSource.FirstOrDefault().DefaultIfEmpty();

                telNo = "Tel No. " + ObjSubCompany.TelephoneNo;

                if (!string.IsNullOrEmpty(accountNo))
                {
                    accountNo = "Account No : " + accountNo;
                }


                param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo);
                param[8] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_AccountNo", accountNo);



                string  vat            = "0";
                decimal discountAmount = 0.00m;
                decimal valueAddedTax  = VAT;


                string discount = string.Format("{0:c}", discountAmount);
                discount = discount.Substring(1);

                string grandTotal = "";

                param[17] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Discount", discount);

                param[3]  = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_InvoiceTotal", grandTotal);
                param[4]  = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_HasVat", vat);
                param[5]  = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_VAT", valueAddedTax.ToStr());
                param[11] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_HasDepartment", "0");

                param[12] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Net", "0");



                param[19] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_HasBankDetails", hasBankDetails);

                int cnt = this.DataSource.Count;

                string BalanceType = string.Empty;
                int    DriverId    = 0;

                string oldBalanceDate = string.Empty;
                if (this.DataSource.Count > 0)
                {
                    DriverId = this.DataSource.FirstOrDefault().DriverId.ToInt();
                    int Id = this.DataSource.FirstOrDefault().Id.ToInt();

                    string StatementDate = string.Empty;
                    using (TaxiDataContext db = new TaxiDataContext())
                    {
                        var query = db.DriverRents.Where(c => c.DriverId == driverId && c.Id < Id).OrderByDescending(c => c.Id).FirstOrDefault();


                        if (query == null)
                        {
                            BalanceType   = "Initial Balance";
                            StatementDate = string.Format("{0:dd/MM}", this.DataSource.FirstOrDefault().TransDate);
                        }
                        else
                        {
                            BalanceType   = "Balance from statement " + query.TransNo.ToStr();
                            StatementDate = string.Format("{0:dd/MM}", this.DataSource.FirstOrDefault().TransDate);

                            try
                            {
                                oldBalanceDate = string.Format("{0:dd/MM}", query.TransDate.ToDate());
                            }
                            catch
                            {
                                oldBalanceDate = StatementDate;
                            }
                        }
                    }
                    param[23] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_jobCount", cnt.ToStr());
                    param[24] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_BalanceType", BalanceType);
                    param[25] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_StatementDate", StatementDate);

                    param[13] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_HasCostCenter", oldBalanceDate);


                    string balance = string.Empty;

                    decimal bal = this.DataSource.FirstOrDefault().DefaultIfEmpty().Balance.ToDecimal();


                    //if(bal>=0)
                    //{

                    balance = "Balance Due £" + string.Format("{0:f2}", bal);
                    //}
                    //else
                    //{
                    //    balance = "You are due to receive £" + string.Format("{0:f2}", bal);

                    //    balance = balance.Replace("-", "").Trim();

                    //}


                    param[26] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Balance", balance);

                    param[27] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_DisplayType", this.DisplayCriteriaType);
                }
                else
                {
                    param[23] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_jobCount", cnt.ToStr());
                    param[24] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_BalanceType", BalanceType);
                    // param[28] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_AccountExpenses", AccountExpenses.ToStr());
                    param[25] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_StatementDate", "");
                    param[26] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Balance", "");
                    param[27] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_DisplayType", this.DisplayCriteriaType);
                }



                if (templateName.ToStr().Length == 0)
                {
                    using (TaxiDataContext db = new TaxiDataContext())
                    {
                        templateName = db.UM_Form_Templates.Where(c => c.UM_Form.FormName == "frmDriverRentDebitCredit3" && c.IsDefault == true).Select(c => c.TemplateName).FirstOrDefault();


                        if (templateName.ToStr().Trim().Length > 0)
                        {
                            templateName = templateName + "_";
                        }
                    }
                }

                if (templateName.ToStr().Trim().Length == 0)
                {
                    templateName = " ";
                }

                this.reportViewer1.LocalReport.ReportEmbeddedResource = "Taxi_AppMain.ReportDesigns." + templateName.ToStr().Trim() + "rptDriverRentExpenses3.rdlc";


                reportViewer1.LocalReport.SetParameters(param);

                this.vu_DriverRentExpenseBindingSource.DataSource      = this.DataSource;
                this.vu_FleetDriverRentExpenseBindingSource.DataSource = this.DataSource2;
                this.reportViewer1.ZoomPercent = 100;
                this.reportViewer1.ZoomMode    = Microsoft.Reporting.WinForms.ZoomMode.Percent;
                this.reportViewer1.RefreshReport();
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
        private void SaveBooking()
        {
            string reason = txtCancelReason.Text.Trim();

            if (string.IsNullOrEmpty(reason))
            {
                reason = "XXX";
                //ENUtils.ShowMessage("Please enter Cancel Reason...");
                //return;
            }



            if (objMaster == null || objMaster.Current == null)
            {
                objMaster.GetByPrimaryKey(BookingId);
            }



            if (objMaster.Current == null)
            {
                Close();
                return;
            }

            bool cancelReturnJob = false;
            long?returnBookingId = null;

            if (objMaster.Current.JourneyTypeId.ToInt() == Enums.JOURNEY_TYPES.RETURN)
            {
                DialogResult dialog = MessageBox.Show("Do you want to cancel Return Booking as well ?", "", MessageBoxButtons.YesNoCancel);
                if (dialog == System.Windows.Forms.DialogResult.Yes)
                {
                    cancelReturnJob = true;
                }
                else if (dialog == System.Windows.Forms.DialogResult.Cancel)
                {
                    return;
                }
            }


            this._onlineBookingId = objMaster.Current.OnlineBookingId.ToLong();


            using (TaxiDataContext db = new TaxiDataContext())
            {
                //db.stp_CancelBooking(BookingId, reason,AppVars.LoginObj.UserName.ToStr());
                db.stp_CancelBookingWithUserLog(BookingId, reason, AppVars.LoginObj.UserName.ToStr(), AppVars.LoginObj.LuserId.ToInt());

                jobIds = objMaster.Current.Id.ToStr();
                if (cancelReturnJob && objMaster.Current.BookingReturns.Count > 0)
                {
                    returnBookingId = objMaster.Current.BookingReturns[0].Id;
                    db.stp_CancelBookingWithUserLog(returnBookingId, reason, AppVars.LoginObj.UserName.ToStr(), AppVars.LoginObj.LuserId.ToInt());
                    jobIds += "," + returnBookingId.ToStr();
                }



                //db.stp_AddUserLogs(AppVars.LoginObj.LuserId.ToInt(),"JOB CANCELLED",3);
                // db.stp_BookingLog(BookingId, AppVars.LoginObj.UserName.ToStr(), "Job is Cancelled ! Reason : " + reason);
            }

            IsSaved = true;



            try
            {
                int driverId = objMaster.Current.DriverId.ToInt();



                if (objMaster.Current.BookingStatusId.ToInt() != Enums.BOOKINGSTATUS.WAITING && driverId > 0)
                {
                    if (objMaster.Current.JobCode.ToStr().Length > 0 && AppVars.objPolicyConfiguration.EnableGhostJob.ToBool())
                    {
                        //  new BroadcasterData().BroadCastToAll(RefreshTypes.REFRESH_ACTIVE_DASHBOARD);
                        General.SendMessageToPDA("request broadcast=" + RefreshTypes.REFRESH_ACTIVE_DASHBOARD);
                    }
                    else
                    {
                        if (General.GetQueryable <Fleet_DriverQueueList>(c => c.DriverId == driverId && c.CurrentJobId == BookingId).Count() > 0)
                        {
                            new Thread(delegate()
                            {
                                CancelCurrentBookingFromPDA(BookingId, driverId);
                            }).Start();

                            //   RefreshBookingListOnActive();

                            //  new BroadcasterData().BroadCastToAll(RefreshTypes.REFRESH_ACTIVE_DASHBOARD);
                            General.SendMessageToPDA("request broadcast=" + RefreshTypes.REFRESH_ACTIVE_DASHBOARD);
                        }
                        else
                        {
                            if (objMaster.Current.BookingStatusId.ToInt() == Enums.BOOKINGSTATUS.PENDING_START)
                            {
                                new Thread(delegate()
                                {
                                    General.ReCallPreBooking(BookingId, driverId);
                                }).Start();
                            }
                            else
                            {
                                new Thread(delegate()
                                {
                                    ReCallFOJBookingFromPDA(BookingId, driverId);
                                }).Start();
                            }



                            //  new BroadcasterData().BroadCastToAll(RefreshTypes.REFRESH_ACTIVE_DASHBOARD);
                            General.SendMessageToPDA("request broadcast=" + RefreshTypes.REFRESH_ACTIVE_DASHBOARD);
                            //   RefreshActiveData();
                        }
                    }

                    this.IsRefresh = true;

                    Thread.Sleep(500);
                }


                if (objMaster.Current.BookingTypeId.ToInt() == Enums.BOOKING_TYPES.THIRDPARTY)
                {
                    General.UpdateThirdPartyJobStatus(objMaster.Current, objMaster.Current.Id, "declined");
                }



                if (chkCancellationSMS.Checked && objMaster.Current != null && objMaster.Current.CustomerMobileNo.ToStr().Length >= 9 && AppVars.objPolicyConfiguration.SMSCancelJob.ToStr().Trim().Length > 0)
                {
                    string  rtnMsg = string.Empty;
                    EuroSMS sms    = new EuroSMS();
                    sms.Message  = GetMessage(AppVars.objPolicyConfiguration.SMSCancelJob.ToStr(), objMaster.Current, objMaster.Current.Id);
                    sms.ToNumber = objMaster.Current.CustomerMobileNo.ToStr().Trim();
                    sms.Send(ref rtnMsg);
                }
            }
            catch
            {
            }

            SendCancelEmail();


            this.Close();
        }
        private void Save()
        {
            decimal Fare     = txtFare.Value;
            decimal custFare = txtCustFare.Value;
            decimal compFare = txtCompFare.Value;

            decimal oldFares = 0.00m;

            decimal oldTotalCharges = 0.00m;
            decimal TotalCharges    = 0.00m;


            if (ObjMaster.Current != null)
            {
                bool allowUpdateTransaction = false;

                try
                {
                    long id = ObjMaster.Current.Id;

                    if (AppVars.listUserRights.Count(c => c.formName == "frmBooking" && (c.functionId == "LOCK BOOKING AFTER TRANSACTION")) > 0)
                    {
                        int    reasonCnt = 0;
                        string error     = string.Empty;
                        using (TaxiDataContext db = new TaxiDataContext())
                        {
                            if (db.Invoice_Charges.Count(c => c.BookingId == id) > 0)
                            {
                                reasonCnt++;
                                error = reasonCnt + ". Account Invoice Exist" + Environment.NewLine;
                            }

                            if (db.DriverRent_Charges.Count(c => c.BookingId == id) > 0)
                            {
                                reasonCnt++;
                                error += reasonCnt + ". Driver Rent Statement Exist" + Environment.NewLine;
                            }

                            if (db.Fleet_DriverCommision_Charges.Count(c => c.BookingId == id) > 0)
                            {
                                reasonCnt++;
                                error += reasonCnt + ". Driver Commission Statement Exist" + Environment.NewLine;
                            }
                        }

                        if (error.Length > 0)
                        {
                            ENUtils.ShowMessage("You cannot edit this booking" + Environment.NewLine + Environment.NewLine + "Reasons:-" + Environment.NewLine + error);
                            return;
                        }
                    }
                    else
                    {
                        allowUpdateTransaction = true;
                    }
                }
                catch
                {
                }



                string pdafares = AppVars.objPolicyConfiguration.PDAFaresPropertyName.ToStr().ToLower().Trim();



                ObjMaster.CheckDataValidation    = false;
                ObjMaster.AllowUpdateTransaction = allowUpdateTransaction;
                ObjMaster.Edit();

                oldFares        = ObjMaster.Current.FareRate.ToDecimal();
                oldTotalCharges = ObjMaster.Current.TotalCharges.ToDecimal();


                ObjMaster.Current.FareRate      = Fare;
                ObjMaster.Current.CustomerPrice = custFare;
                ObjMaster.Current.CompanyPrice  = compFare;

                ObjMaster.DisableUpdateReturnJob  = true;
                ObjMaster.CheckCustomerValidation = false;

                farerate = Fare;


                if (oldFares != Fare)
                {
                    ObjMaster.Current.Booking_Logs.Add(new Booking_Log {
                        BookingId = ObjMaster.Current.Id, User = AppVars.LoginObj.LoginName, BeforeUpdate = "Fares : " + oldFares, AfterUpdate = "Update from (Edit Fare) ,Fares : " + Fare, UpdateDate = DateTime.Now
                    });



                    General.UpdateOnlineBookingFares(ObjMaster.Current.OnlineBookingId.ToLong(), Fare, ObjMaster.Current.BookingTypeId.ToInt());
                }


                if (ObjMaster.Current.CompanyId == null)
                {
                    ObjMaster.Current.TotalCharges = ObjMaster.Current.FareRate.ToDecimal()
                                                     + ObjMaster.Current.ExtraDropCharges.ToDecimal() + ObjMaster.Current.MeetAndGreetCharges.ToDecimal() + ObjMaster.Current.CongtionCharges.ToDecimal();
                }
                else
                {
                    ObjMaster.Current.TotalCharges = ObjMaster.Current.CompanyPrice.ToDecimal() + ObjMaster.Current.ParkingCharges.ToDecimal() + ObjMaster.Current.WaitingCharges.ToDecimal() + ObjMaster.Current.ExtraDropCharges.ToDecimal();
                }


                TotalCharges = ObjMaster.Current.TotalCharges.ToDecimal();

                ObjMaster.Save();
                this.Close();



                //if (openForm == 1)
                //{
                //   // AppVars.frmMDI.RefreshDashBoardBookings();

                //   // General.RefreshListWithoutSelected<frmBookingDashBoard>("frmBookingDashBoard1");
                //}
                if (openForm == 2)
                {
                    (Application.OpenForms.OfType <Form>().FirstOrDefault(c => c.Name == "frmBookingDashBoard") as frmBookingDashBoard).RefreshBookingList();
                    // AppVars.frmMDI.RefreshDashBoardBookings();
                }
                else if (openForm == 0)
                {
                    General.RefreshListWithoutSelected <frmBookingsList>("frmBookingsList1");
                }



                // For TCP Connection
                if (ObjMaster.Current.DriverId != null && ObjMaster.Current.Gen_PaymentType.ShowFaresOnPDA.ToStr() == "1" &&
                    (ObjMaster.Current.BookingStatusId == Enums.BOOKINGSTATUS.ONROUTE || ObjMaster.Current.BookingStatusId == Enums.BOOKINGSTATUS.ARRIVED ||
                     ObjMaster.Current.BookingStatusId == Enums.BOOKINGSTATUS.POB || ObjMaster.Current.BookingStatusId == Enums.BOOKINGSTATUS.STC) &&
                    AppVars.objPolicyConfiguration.IsListenAll.ToBool() && !string.IsNullOrEmpty(AppVars.objPolicyConfiguration.ListenerIP.ToStr().Trim()))
                {
                    if (pdafares == "totalcharges")
                    {
                        oldFares = oldTotalCharges;
                        Fare     = TotalCharges;
                    }


                    if (oldFares != Fare)
                    {
                        string A_Phone = ObjMaster.Current.CustomerPhoneNo.ToStr();
                        string Phone   = ObjMaster.Current.CustomerPhoneNo.ToStr();
                        string mobNo   = ObjMaster.Current.CustomerMobileNo;
                        if (string.IsNullOrEmpty(mobNo))
                        {
                            mobNo = " ";
                        }


                        else if (!string.IsNullOrEmpty(A_Phone))
                        {
                            mobNo = Phone + "/" + A_Phone;
                        }



                        string A_Account = ObjMaster.Current.Gen_Company.DefaultIfEmpty().CompanyName.ToStr();

                        if (string.IsNullOrEmpty(A_Account))
                        {
                            A_Account = " ";
                        }



                        string babySeats = ObjMaster.Current.BabySeats.ToStr().Trim();

                        if (string.IsNullOrEmpty(babySeats))
                        {
                            babySeats = " ";
                        }


                        string A_journeyType = "O/W";

                        if (ObjMaster.Current.JourneyTypeId.ToInt() == Enums.JOURNEY_TYPES.WAITANDRETURN)
                        {
                            A_journeyType = "W/R";
                        }


                        string A_Via = " ";

                        if (ObjMaster.Current.ViaString.ToStr().Trim().Length > 0)
                        {
                            int i = 1;
                            A_Via = string.Join(" * ", ObjMaster.Current.Booking_ViaLocations.Select(c => "(" + i++.ToStr() + ")" + c.ViaLocValue.ToStr()).ToArray <string>());
                        }



                        string msg = (!string.IsNullOrEmpty(ObjMaster.Current.FromDoorNo) ? ObjMaster.Current.FromDoorNo + "-" + ObjMaster.Current.FromAddress + ObjMaster.Current.Gen_Zone1.DefaultIfEmpty().ZoneName.ToStr() : ObjMaster.Current.FromAddress + ObjMaster.Current.Gen_Zone1.DefaultIfEmpty().ZoneName.ToStr()) +
                                     ">>" +
                                     (!string.IsNullOrEmpty(ObjMaster.Current.ToDoorNo) ? ObjMaster.Current.ToDoorNo + "-" + ObjMaster.Current.ToAddress + ObjMaster.Current.Gen_Zone.DefaultIfEmpty().ZoneName.ToStr() : ObjMaster.Current.ToAddress + ObjMaster.Current.Gen_Zone.DefaultIfEmpty().ZoneName.ToStr()) +
                                     ">>" +
                                     string.Format("{0:dd/MM/yyyy   HH:mm}", ObjMaster.Current.PickupDateTime) +
                                     ">>" +
                                     ObjMaster.Current.CustomerName +
                                     ">>" +
                                     mobNo +
                                     ">>" + ObjMaster.Current.SpecialRequirements.ToStr() + " "
                                     + ">>" + Fare +
                                     ">>" + ObjMaster.Current.Fleet_VehicleType.DefaultIfEmpty().VehicleType.ToStr()
                                     + ">>" + A_Account

                                     + ">>" + A_journeyType
                                     + ">>" + ObjMaster.Current.Gen_PaymentType.PaymentType.ToStr()
                                     + ">>" + A_Via
                                     + ">>" + ObjMaster.Current.NoofPassengers.ToInt()
                                     + ">>" + ObjMaster.Current.NoofLuggages.ToInt()
                                     + ">>" + babySeats;

                        new Thread(delegate()
                        {
                            General.SendMessageToPDA("request pda=" + ObjMaster.Current.DriverId + "=" + ObjMaster.Current.Id + "=" + "Update Job>>" + ObjMaster.Current.DriverId + ">>" + ObjMaster.Current.Id + ">>" + msg + "=8");
                        }).Start();
                    }
                }
            }
        }
示例#8
0
        private void NoShow()
        {
            try
            {
                if (ddl_Driver.SelectedValue == null)
                {
                    ENUtils.ShowMessage("Select any Driver");

                    return;
                }
                else
                {
                    int driverId = ddl_Driver.SelectedValue.ToInt();
                    var list     = from a in General.GetQueryable <Fleet_DriverQueueList>(c => c.Id > 0)
                                   where a.DriverId == driverId && a.Status == true && a.CurrentJobId != null
                                   select new
                    {
                        Id = a.Id,
                    };

                    string val = list.ToStr();

                    if (list.Count() != 0)
                    {
                        long jobId = 0;

                        using (TaxiDataContext db = new TaxiDataContext())
                        {
                            jobId = db.Fleet_DriverQueueLists.FirstOrDefault(c => c.Id == list.FirstOrDefault().Id).DefaultIfEmpty().CurrentJobId.ToLong();
                        }



                        if (jobId != 0)
                        {
                            string[] driverNo = (ddl_Driver.SelectedItem.Text).Split('-');

                            new Thread(delegate()
                            {
                                int loopCnt = 1;
                                while (loopCnt < 3)
                                {
                                    bool success = General.ReCallBookingWithStatus(jobId.ToLong(), driverId.ToInt(), Enums.BOOKINGSTATUS.NOPICKUP, Enums.Driver_WORKINGSTATUS.AVAILABLE);

                                    if (success)
                                    {
                                        break;
                                    }
                                    else
                                    {
                                        loopCnt++;
                                    }
                                }
                            }).Start();

                            Thread.Sleep(500);


                            new BroadcasterData().BroadCastToAll(RefreshTypes.REFRESH_DASHBOARD);
                            // (Application.OpenForms.OfType<Form>().FirstOrDefault(c => c.Name == "frmBookingDashBoard") as frmBookingDashBoard).RefreshData();


                            using (TaxiDataContext db = new TaxiDataContext())
                            {
                                db.stp_BookingLog(jobId, AppVars.LoginObj.UserName.ToStr(), "Controller Pressed NO Pickup from Driver (" + driverNo[0] + ")");
                            }
                        }
                        else
                        {
                            MessageBox.Show("No Current Job Found");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }
        }
示例#9
0
        private void ReCallJob()
        {
            if (ddl_Driver.SelectedValue == null)
            {
                return;
            }
            try
            {
                int driverId = ddl_Driver.SelectedValue.ToInt();

                int    statusId = 0;
                long   jobId    = 0;
                string driverNO = string.Empty;
                using (TaxiDataContext db = new TaxiDataContext())
                {
                    Fleet_DriverQueueList objLogin = db.Fleet_DriverQueueLists.FirstOrDefault(c => c.Status == true && c.DriverId == driverId);

                    if (objLogin != null)
                    {
                        statusId = objLogin.DriverWorkStatusId.ToInt();
                        jobId    = objLogin.CurrentJobId.ToLong();
                        driverNO = objLogin.Fleet_Driver.DriverNo.ToStr();
                    }
                }


                if (jobId == 0)
                {
                    MessageBox.Show("No Current Job Found");
                    return;
                }
                else
                {
                    if (statusId == Enums.Driver_WORKINGSTATUS.NOTAVAILABLE || statusId == Enums.Driver_WORKINGSTATUS.SOONTOCLEAR)
                    {
                        MessageBox.Show("Job cannot be Re-Call as driver is on " + "POB or STC Status.");
                        return;
                    }
                }


                if (DialogResult.Yes == RadMessageBox.Show("Are you sure you want to Re-Call a Booking ? ", "", MessageBoxButtons.YesNo, RadMessageIcon.Question))
                {
                    new Thread(delegate()
                    {
                        int loopCnt  = 1;
                        bool success = false;
                        while (loopCnt < 3)
                        {
                            success = General.ReCallBooking(jobId, driverId);

                            if (success)
                            {
                                break;
                            }
                            else
                            {
                                loopCnt++;
                            }
                        }
                    }).Start();


                    using (TaxiDataContext dbX = new TaxiDataContext())
                    {
                        dbX.stp_BookingLog(jobId, AppVars.LoginObj.UserName.ToStr(), "Recall Job from Driver (" + driverNO + ")");
                    }

                    // new BroadcasterData().BroadCastToAll(RefreshTypes.REFRESH_DASHBOARD);
                }
            }
            catch
            {
            }
        }
        public override void Save()
        {
            try
            {
                if (grdPostCodes.RowCount == 0)
                {
                    ENUtils.ShowMessage("Required : Post Code");
                    return;
                }

                StringBuilder sb  = new StringBuilder();
                StringBuilder sb2 = new StringBuilder();
                //sb.Append("delete from StreetsData.dbo.Localization;");
                //sb.Append("delete from StreetsData.dbo.LocalizationDetails;");
                List <string> objList     = new List <string>();
                string        PostCode    = string.Join(",", grdPostCodes.Rows.Select(c => c.Cells[COLS.PostCode].Value.ToStr()).ToArray <string>());
                string        NewPostCode = string.Empty;

                foreach (var item in PostCode.Split(','))
                {
                    string Word = string.Empty;

                    for (int i = 0; i < item.Length; i++)
                    {
                        if (item[i].ToStr().IsNumeric() == true)
                        {
                            objList.Add(Word);
                            break;
                        }
                        else
                        {
                            Word += item[i].ToStr();
                        }
                    }
                }

                //var list = objList.Distinct().ToList();
                //foreach (var item in list)
                //{
                //    sb.Append("insert into PAFDb.dbo.Localization (PostCode) values ('" + item.ToStr() + "%" + "');");
                //}


                var list2 = grdPostCodes.Rows.Select(c => c.Cells[COLS.PostCode].Value).ToList();

                foreach (var item in list2)
                {
                    sb2.Append("insert into PAFDb.dbo.LocalizationDetail (PostCode) values ('" + item.ToStr() + "');");
                }

                using (TaxiDataContext db = new TaxiDataContext())
                {
                    db.stp_SaveLocalaization(sb.ToStr(), sb2.ToStr());
                }


                General.LoadZoneList();

                this.Close();
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
示例#11
0
        private void TrackDriver()
        {
            if (ddl_Driver.SelectedValue == null)
            {
                ENUtils.ShowMessage("Select any Driver");
            }

            try
            {
                int driverId = ddl_Driver.SelectedValue.ToInt();

                using (TaxiDataContext db = new TaxiDataContext())
                {
                    var objLogin = db.Fleet_DriverQueueLists.FirstOrDefault(c => c.Status == true && c.DriverId == driverId);

                    if (objLogin == null)
                    {
                        ENUtils.ShowMessage("Driver is not Login");
                    }
                    else
                    {
                        long jobId = objLogin.CurrentJobId.ToLong();

                        if (File.Exists(Application.StartupPath + "\\Booking\\TreasureBooking.exe"))
                        {
                            ClsDataTransfer polObj = new ClsDataTransfer();

                            foreach (System.Reflection.PropertyInfo item in AppVars.objPolicyConfiguration.GetType().GetProperties())
                            {
                                try
                                {
                                    if (polObj.GetType().GetProperty(item.Name) != null)
                                    {
                                        polObj.GetType().GetProperty(item.Name).SetValue(polObj, item.GetValue(AppVars.objPolicyConfiguration, null), null);
                                    }
                                }
                                catch
                                {
                                }
                            }


                            polObj.DataString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToStr().Replace(" ", "**");
                            string  pol = Newtonsoft.Json.JsonConvert.SerializeObject(polObj, Newtonsoft.Json.Formatting.Indented).Replace(" ", "~").Replace(Environment.NewLine, "").Replace("\"", "*");
                            string  s   = "XXX";
                            Process pp  = new Process();
                            pp.StartInfo.FileName   = Application.StartupPath + "\\Booking\\TreasureBooking.exe";
                            pp.StartInfo.Arguments  = s + " " + pol + " " + Newtonsoft.Json.JsonConvert.SerializeObject(AppVars.LoginObj, Newtonsoft.Json.Formatting.Indented).Replace(" ", "").Replace(Environment.NewLine, "").Replace("\"", "*") + " " + Newtonsoft.Json.JsonConvert.SerializeObject(AppVars.keyLocations, Newtonsoft.Json.Formatting.Indented).Replace(" ", "").Replace(Environment.NewLine, "").Replace("\"", "*") + " " + Newtonsoft.Json.JsonConvert.SerializeObject(AppVars.zonesList, Newtonsoft.Json.Formatting.Indented).Replace(" ", "").Replace(Environment.NewLine, "").Replace("\"", "*");
                            pp.StartInfo.Arguments += " " + "rptJobRouthPathGoogle" + " " + jobId + " " + "true" + " " + driverId;
                            pp.Start();
                            Thread.Sleep(500);
                            //   pp.WaitForExit();
                        }
                        else
                        {
                            rptJobRouthPathGoogle rpt = new rptJobRouthPathGoogle(jobId > 0 ? db.Bookings.FirstOrDefault(c => c.Id == jobId) : null, true, driverId);
                            rpt.ShowDialog();
                            rpt.Dispose();

                            GC.Collect();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
        void grdPaymentHistory_CommandCellClick(object sender, EventArgs e)
        {
            try
            {
                //if (grdPaymentHistory.CurrentRow != null && grdPaymentHistory.CurrentRow is GridViewDataRowInfo)
                //{
                //    long paymentId = grdPaymentHistory.CurrentRow.Cells["Id"].Value.ToLong();
                //    if (grdPaymentHistory.Rows.Count > 1 && paymentId < grdPaymentHistory.Rows.Where(c => c.Index != grdPaymentHistory.CurrentRow.Index)
                //                                              .OrderByDescending((c => c.Cells["Id"].Value.ToLong())).FirstOrDefault().Cells["Id"].Value.ToLong())
                //    {
                //        ENUtils.ShowMessage("Payment History will be Delete in Reverse Order");
                //        return;
                //    }
                //    else
                //    {
                //        decimal commissionPay=grdPaymentHistory.CurrentRow.Cells["CommissionPay"].Value.ToDecimal();
                //        using (TaxiDataContext db = new TaxiDataContext())
                //        {
                //            db.stp_UpdateDriverCommissionPayment(CommissionId, paymentId, commissionPay);
                //        }
                //        grdPaymentHistory.CurrentRow.Delete();
                //        DisplayRecord();
                //    }
                //}
                GridCommandCellElement gridCell = (GridCommandCellElement)sender;
                if (gridCell.ColumnInfo.Name.ToLower() == "btndelete")
                {
                    if (DialogResult.Yes == RadMessageBox.Show("Are you sure you want to delete a Record ? ", "", MessageBoxButtons.YesNo, RadMessageIcon.Question))
                    {
                        long Id = grdPaymentHistory.CurrentRow.Cells["Id"].Value.ToLong();
                        if (grdPaymentHistory.CurrentRow != null && grdPaymentHistory.CurrentRow is GridViewDataRowInfo)
                        {
                            if (grdPaymentHistory.Rows.Count > 1 && Id < grdPaymentHistory.Rows.Where(c => c.Index != grdPaymentHistory.CurrentRow.Index)
                                .OrderByDescending((c => c.Cells["Id"].Value.ToLong())).FirstOrDefault().Cells["Id"].Value.ToLong())
                            {
                                ENUtils.ShowMessage("Expenses History will be Delete in Reverse Order");
                                return;
                            }
                        }

                        string  Type           = grdPaymentHistory.CurrentRow.Cells[COLS.Type].Value.ToStr().ToLower();
                        decimal Amount         = grdPaymentHistory.CurrentRow.Cells[COLS.Amount].Value.ToDecimal();
                        decimal CurrentBalance = numCurrBalance.Value.ToDecimal();
                        grdPaymentHistory.CurrentRow.Delete();
                        if (Type == "credit")
                        {
                            //if (CurrentBalance > 0)
                            //{
                            numCurrBalance.Value = (CurrentBalance - Amount);
                        }
                        else
                        {
                            //if (CurrentBalance > 0)
                            //{
                            numCurrBalance.Value = (CurrentBalance + Amount);
                        }
                        objDriverCommision.GetByPrimaryKey(CommissionId);
                        objDriverCommision.Edit();
                        objDriverCommision.Current.Balance = numCurrBalance.Value.ToDecimal();

                        objDriverCommision.Save();
                        using (TaxiDataContext db = new TaxiDataContext())
                        {
                            var query = db.Fleet_DriverCommissionExpenses.Single(c => c.Id == Id);
                            db.Fleet_DriverCommissionExpenses.DeleteOnSubmit(query);
                            db.SubmitChanges();
                        }
                        DisplayRecord();
                    }
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
        private void UpdatePaymentCollection()
        {
            try
            {
                string Error = string.Empty;
                if (grdLister.Rows.Count() > 0 && grdLister.Rows.Count(c => c.Cells["IsPaid"].Value.ToBool() == true) == 0)
                {
                    Error = "Please select record to update";
                }

                if (!string.IsNullOrEmpty(Error))
                {
                    ENUtils.ShowMessage(Error);
                    return;
                }
                if (grdLister.Rows.Count(c => c.Cells["IsPaid"].Value.ToBool() == true) > 0)
                {
                    foreach (var item in grdLister.Rows.Where(c => c.Cells["IsPaid"].Value.ToBool() == true))
                    {
                        long TranId = item.Cells["TransId"].Value.ToLong();


                        if (TranId > 0)
                        {
                            try
                            {
                                int IsPaid = item.Cells["IsPaid"].Value.ToBool() == true ? 1 : 0;
                                // decimal adjustments = row.Cells[COLS.Adjustment].Value.ToDecimal();

                                string query = "update fleet_drivercommision set IsWeeklyPaid=" + IsPaid + " where Id=" + TranId;

                                using (TaxiDataContext db = new TaxiDataContext())
                                {
                                    db.stp_RunProcedure(query);
                                }


                                UpdateDriverCommission(item.Cells["TotalRentCommission"].Value.ToDecimal());

                                //PopulateData();
                                DateTime?dtFrom = item.Cells["FromDate"].Value.ToDateorNull();
                                DateTime?dtTill = item.Cells["ToDate"].Value.ToDateorNull();

                                string DateRange = string.Format("{0:dd/MMMM/yyyy}", dtFrom) + " to " + string.Format("{0:dd/MMMM/yyyy}", dtTill);
                                int    DriverId  = item.Cells["Id"].Value.ToInt();
                                int    Id        = 0;

                                objDriverWeeklyRentHistory = new DriverWeeklyRentHistoryBO();

                                var MasterQuery = General.GetObject <Fleet_DriverWeeklyRentHistory>(c => (c.FromDate == dtFrom && c.TillDate == dtTill));
                                if (MasterQuery != null)
                                {
                                    Id = MasterQuery.Id;
                                    objDriverWeeklyRentHistory.GetByPrimaryKey(Id);
                                    objDriverWeeklyRentHistory.Edit();
                                    objDriverWeeklyRentHistory.Current.EditBy  = AppVars.LoginObj.LuserId.ToInt();
                                    objDriverWeeklyRentHistory.Current.EditLog = AppVars.LoginObj.UserName;
                                    objDriverWeeklyRentHistory.Current.EditOn  = DateTime.Now;
                                }
                                else
                                {
                                    objDriverWeeklyRentHistory.New();
                                    objDriverWeeklyRentHistory.Current.AddBy  = AppVars.LoginObj.LuserId.ToInt();
                                    objDriverWeeklyRentHistory.Current.AddLog = AppVars.LoginObj.UserName;
                                    objDriverWeeklyRentHistory.Current.AddOn  = DateTime.Now;
                                }
                                objDriverWeeklyRentHistory.Current.DateRange = DateRange;
                                objDriverWeeklyRentHistory.Current.FromDate  = dtFrom;
                                objDriverWeeklyRentHistory.Current.TillDate  = dtTill;
                                objDriverWeeklyRentHistory.Current.CreatedOn = DateTime.Now;

                                if (objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.Count(c => c.DriverId == DriverId) == 0)
                                {
                                    objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.Add(new Fleet_DriverWeeklyRentHistory_Detail
                                    {
                                        TransId         = objDriverWeeklyRentHistory.PrimaryKeyValue.ToInt(),
                                        AccountBookings = item.Cells["AccountBookings"].Value.ToDecimal(),
                                        Active          = item.Cells["Active"].Value.ToStr(),
                                        DriverNo        = item.Cells["DriverNo"].Value.ToStr(),
                                        DriverId        = DriverId,
                                        RentComm        = item.Cells["TotalRentCommission"].Value.ToDecimal(),
                                        IsPaid          = item.Cells["IsPaid"].Value.ToBool(),
                                        OfficeToPay     = item.Cells["OfficeToPay"].Value.ToDecimal(),
                                        PreviousBalance = item.Cells["PreviousBalance"].Value.ToDecimal(),
                                        DriverToPay     = item.Cells["DriverToPay"].Value.ToDecimal()
                                    });
                                }
                                else
                                {
                                    Fleet_DriverWeeklyRentHistory_Detail objDriverWeeklyRentDetail = objDriverWeeklyRentDetail = objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.FirstOrDefault(c => c.DriverId == DriverId);
                                    objDriverWeeklyRentDetail.TransId         = objDriverWeeklyRentHistory.PrimaryKeyValue.ToInt();
                                    objDriverWeeklyRentDetail.IsPaid          = item.Cells["IsPaid"].Value.ToBool();;
                                    objDriverWeeklyRentDetail.AccountBookings = item.Cells["AccountBookings"].Value.ToDecimal();
                                    objDriverWeeklyRentDetail.Active          = item.Cells["Active"].Value.ToStr();
                                    objDriverWeeklyRentDetail.DriverNo        = item.Cells["DriverNo"].Value.ToStr();
                                    objDriverWeeklyRentDetail.DriverId        = DriverId;
                                    objDriverWeeklyRentDetail.RentComm        = item.Cells["TotalRentCommission"].Value.ToDecimal();
                                    objDriverWeeklyRentDetail.OfficeToPay     = item.Cells["OfficeToPay"].Value.ToDecimal();
                                    objDriverWeeklyRentDetail.PreviousBalance = item.Cells["PreviousBalance"].Value.ToDecimal();
                                    objDriverWeeklyRentDetail.DriverToPay     = item.Cells["DriverToPay"].Value.ToDecimal();
                                }
                                objDriverWeeklyRentHistory.Save();
                                objDriverWeeklyRentHistory.Clear();
                            }
                            catch (Exception ex)
                            {
                                ENUtils.ShowMessage(ex.Message);
                            }
                        }
                    }
                }
                PopulateData();
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
        void grdLister_CommandCellClick(object sender, EventArgs e)
        {
            GridCommandCellElement gridCell = (GridCommandCellElement)sender;

            if (gridCell.ColumnInfo.Name == "btnUpdate")
            {
                GridViewRowInfo row = gridCell.RowInfo;

                if (row is GridViewDataRowInfo)
                {
                    long TranId = row.Cells["TransId"].Value.ToLong();


                    if (TranId > 0)
                    {
                        try
                        {
                            int IsPaid = row.Cells["IsPaid"].Value.ToBool() == true ? 1 : 0;
                            // decimal adjustments = row.Cells[COLS.Adjustment].Value.ToDecimal();

                            string query = "update fleet_drivercommision set IsWeeklyPaid=" + IsPaid + " where Id=" + TranId;

                            using (TaxiDataContext db = new TaxiDataContext())
                            {
                                db.stp_RunProcedure(query);
                            }


                            UpdateDriverCommission(grdLister.CurrentRow.Cells["TotalRentCommission"].Value.ToDecimal());


                            PopulateData();
                            DateTime?dtFrom = grdLister.CurrentRow.Cells["FromDate"].Value.ToDateorNull();
                            DateTime?dtTill = grdLister.CurrentRow.Cells["ToDate"].Value.ToDateorNull();

                            string DateRange = string.Format("{0:dd/MMMM/yyyy}", dtFrom) + " to " + string.Format("{0:dd/MMMM/yyyy}", dtTill);
                            int    DriverId  = grdLister.CurrentRow.Cells["Id"].Value.ToInt();
                            int    Id        = 0;

                            objDriverWeeklyRentHistory = new DriverWeeklyRentHistoryBO();

                            var MasterQuery = General.GetObject <Fleet_DriverWeeklyRentHistory>(c => (c.FromDate == dtFrom && c.TillDate == dtTill));
                            if (MasterQuery != null)
                            {
                                Id = MasterQuery.Id;
                                objDriverWeeklyRentHistory.GetByPrimaryKey(Id);
                                objDriverWeeklyRentHistory.Edit();
                                objDriverWeeklyRentHistory.Current.EditBy  = AppVars.LoginObj.LuserId.ToInt();
                                objDriverWeeklyRentHistory.Current.EditLog = AppVars.LoginObj.UserName;
                                objDriverWeeklyRentHistory.Current.EditOn  = DateTime.Now;
                            }
                            else
                            {
                                objDriverWeeklyRentHistory.New();
                                objDriverWeeklyRentHistory.Current.AddBy  = AppVars.LoginObj.LuserId.ToInt();
                                objDriverWeeklyRentHistory.Current.AddLog = AppVars.LoginObj.UserName;
                                objDriverWeeklyRentHistory.Current.AddOn  = DateTime.Now;
                            }
                            objDriverWeeklyRentHistory.Current.DateRange = DateRange;
                            objDriverWeeklyRentHistory.Current.FromDate  = dtFrom;
                            objDriverWeeklyRentHistory.Current.TillDate  = dtTill;
                            objDriverWeeklyRentHistory.Current.CreatedOn = DateTime.Now;



                            if (objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.Count(c => c.DriverId == DriverId) == 0)
                            {
                                objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.Add(new Fleet_DriverWeeklyRentHistory_Detail
                                {
                                    TransId         = objDriverWeeklyRentHistory.PrimaryKeyValue.ToInt(),
                                    AccountBookings = grdLister.CurrentRow.Cells["AccountBookings"].Value.ToDecimal(),
                                    Active          = grdLister.CurrentRow.Cells["Active"].Value.ToStr(),
                                    DriverNo        = grdLister.CurrentRow.Cells["DriverNo"].Value.ToStr(),
                                    DriverId        = DriverId,
                                    RentComm        = grdLister.CurrentRow.Cells["TotalRentCommission"].Value.ToDecimal(),
                                    IsPaid          = grdLister.CurrentRow.Cells["IsPaid"].Value.ToBool(),
                                    OfficeToPay     = grdLister.CurrentRow.Cells["OfficeToPay"].Value.ToDecimal(),
                                    PreviousBalance = grdLister.CurrentRow.Cells["PreviousBalance"].Value.ToDecimal(),
                                    DriverToPay     = grdLister.CurrentRow.Cells["DriverToPay"].Value.ToDecimal()
                                });
                            }
                            else
                            {
                                Fleet_DriverWeeklyRentHistory_Detail objDriverWeeklyRentDetail = objDriverWeeklyRentDetail = objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.FirstOrDefault(c => c.DriverId == DriverId);



                                //var query2 = General.GetObject<Fleet_DriverWeeklyRentHistory_Detail>(c => (c.TransId == objDriverWeeklyRentHistory.PrimaryKeyValue.ToInt() && c.DriverId == DriverId));
                                //if (query2 != null)
                                //{
                                //    int HistoryId = query2.Id;
                                //    using (TaxiDataContext db = new TaxiDataContext())
                                //    {
                                //   Fleet_DriverWeeklyRentHistory_Detail objDriverWeeklyRentDetail = db.Fleet_DriverWeeklyRentHistory_Details.FirstOrDefault(c => c.Id == HistoryId);
                                objDriverWeeklyRentDetail.TransId         = objDriverWeeklyRentHistory.PrimaryKeyValue.ToInt();
                                objDriverWeeklyRentDetail.IsPaid          = grdLister.CurrentRow.Cells["IsPaid"].Value.ToBool();;
                                objDriverWeeklyRentDetail.AccountBookings = grdLister.CurrentRow.Cells["AccountBookings"].Value.ToDecimal();
                                objDriverWeeklyRentDetail.Active          = grdLister.CurrentRow.Cells["Active"].Value.ToStr();
                                objDriverWeeklyRentDetail.DriverNo        = grdLister.CurrentRow.Cells["DriverNo"].Value.ToStr();
                                objDriverWeeklyRentDetail.DriverId        = DriverId;
                                objDriverWeeklyRentDetail.RentComm        = grdLister.CurrentRow.Cells["TotalRentCommission"].Value.ToDecimal();
                                objDriverWeeklyRentDetail.OfficeToPay     = grdLister.CurrentRow.Cells["OfficeToPay"].Value.ToDecimal();
                                objDriverWeeklyRentDetail.PreviousBalance = grdLister.CurrentRow.Cells["PreviousBalance"].Value.ToDecimal();
                                objDriverWeeklyRentDetail.DriverToPay     = grdLister.CurrentRow.Cells["DriverToPay"].Value.ToDecimal();
                                //     db.SubmitChanges();
                                //        }
                                //     }
                            }
                            objDriverWeeklyRentHistory.Save();
                            objDriverWeeklyRentHistory.Clear();
                        }
                        catch (Exception ex)
                        {
                            ENUtils.ShowMessage(ex.Message);
                        }
                    }
                }
            }
        }
        private void LoadCommisionList()
        {
            try
            {
                string searchTxt = txtSearch.Text.ToStr().ToLower().Trim();
                string col       = ddlColumns.Text.ToStr().Trim().ToLower();

                if (searchTxt.Length < 3)
                {
                    searchTxt = string.Empty;
                }


                bool col_No         = false;
                bool col_DriverName = false;
                if (col == "driver no")
                {
                    col_No = true;
                }
                if (col == "driver name")
                {
                    col_DriverName = true;
                }

                //var query = from a in General.GetQueryable<Fleet_Driver>(c => c.IsActive == true && c.DriverTypeId == 2).AsEnumerable()

                //            where

                //       (col_No && (a.DriverNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty))
                //       || (col_DriverName && (a.DriverName.ToLower().Contains(searchTxt) || searchTxt == string.Empty))
                //            select new
                //            {
                //                Id = a.Id,
                //                No = a.DriverNo,
                //                Name = a.DriverName,
                //                MobileNo = a.MobileNo,
                //                LastDate = a.Fleet_DriverCommisions.Count > 0 ? a.Fleet_DriverCommisions[a.Fleet_DriverCommisions.Count - 1].TransDate : null
                //            };

                using (TaxiDataContext db = new TaxiDataContext())
                {
                    var query = from a in db.GetTable <Fleet_Driver>().Where(c => c.DriverTypeId == 2 && c.IsActive == true)
                                join b in db.GetTable <Fleet_DriverCommision>() on a.Id equals b.DriverId into table2

                                from b in table2.DefaultIfEmpty().OrderByDescending(c => c.TransDate).Take(1)

                                where
                                (
                        (col_No && (a.DriverNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) ||
                        (col_DriverName && (a.DriverName.ToLower().Contains(searchTxt) || searchTxt == string.Empty))
                                )
                                select new
                    {
                        Id       = a.Id,
                        No       = a.DriverNo,
                        Name     = a.DriverName,
                        MobileNo = a.MobileNo,
                        LastDate = b != null ? b.TransDate : null
                    };


                    grdLister.DataSource = query.AsEnumerable().OrderBy(item => item.No, new NaturalSortComparer <string>()).ToList();
                }

                //   db.Dispose();
            }
            catch (Exception ex)
            {
                ENUtils.ShowErrorMessage(ex.Message);
            }
        }
示例#16
0
        private void BreakDriver()
        {
            if (ddl_Driver.SelectedValue == null)
            {
                return;
            }
            try
            {
                if (General.GetQueryable <Fleet_DriverQueueList>(null).Count(c => c.Status == true && c.DriverId == ddl_Driver.SelectedValue.ToInt()) == 0)
                {
                    return;
                }


                //   ddl_Driver.DropDownListElement.AutoCompleteSuggest.SU.AutoCompleteSuggest.SuggestMode

                int statusId = Enums.Driver_WORKINGSTATUS.ONBREAK;

                using (TaxiDataContext db = new TaxiDataContext())
                {
                    var obj = db.Fleet_DriverQueueLists.FirstOrDefault(c => c.Status == true && c.DriverId == ddl_Driver.SelectedValue.ToInt());


                    if (obj != null && (obj.DriverWorkStatusId == Enums.Driver_WORKINGSTATUS.AVAILABLE || obj.DriverWorkStatusId == Enums.Driver_WORKINGSTATUS.ONBREAK))
                    {
                        if (obj.DriverWorkStatusId == Enums.Driver_WORKINGSTATUS.ONBREAK)
                        {
                            statusId = Enums.Driver_WORKINGSTATUS.AVAILABLE;
                        }

                        db.stp_ChangeDriverStatus(ddl_Driver.SelectedValue.ToInt(), statusId);

                        new BroadcasterData().BroadCastToAll(RefreshTypes.REFRESH_DASHBOARD_DRIVER);

                        try
                        {
                            int loopCnt = 1;


                            while (loopCnt < 3)
                            {
                                bool success = General.SendMessageToPDA("request pda=" + ddl_Driver.SelectedValue.ToInt() + "=" + 0 + "="
                                                                        + "Message>>" + "onbreak--x" + ">>" + String.Format("{0:dd/MM/yyyy HH:mm:ss}", DateTime.Now) + "=4").Result.ToBool();

                                if (success)
                                {
                                    break;
                                }
                                else
                                {
                                    loopCnt++;
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                        }
                    }
                }
            }
            catch
            {
            }
        }
示例#17
0
        private void PopulateGraph()
        {
            try
            {
                string   DateStatus       = "";
                DateTime FromDate         = DateTime.Now.ToDate();
                DateTime TillDate         = DateTime.Now.ToDate();
                DateTime Last_WK_FromDate = DateTime.Now.ToDate();
                DateTime Last_WK_TillDate = DateTime.Now.ToDate();

                using (Taxi_Model.TaxiDataContext db = new TaxiDataContext())
                {
                    if (DateType == "CURRENT_WEEK")
                    {
                        FromDate         = DateTime.Now.GetStartOfCurrentWeek().ToDate();
                        TillDate         = DateTime.Now.GetEndOfCurrentWeek().ToDate();
                        Last_WK_FromDate = DateTime.Now.GetStartOfCurrentWeek().ToDate().AddDays(-7);
                        Last_WK_TillDate = DateTime.Now.GetStartOfCurrentWeek().ToDate().AddDays(-1);

                        DateStatus = " For " + string.Format("{0:dd/MM/yyyy}", FromDate.ToDate()) + " to " + string.Format("{0:dd/MM/yyyy}", TillDate.ToDate());
                    }
                    //else if (DateType == "LAST_WEEK")
                    //{

                    //}
                    else if (DateType == "MONTHLY")
                    {
                        FromDate = new DateTime(Year, Month, 1);

                        TillDate = new DateTime(Year, Month, DateTime.DaysInMonth(Year, Month));


                        //Last_WK_FromDate = new DateTime(Year, Month - 1, 1);

                        //Last_WK_TillDate = new DateTime(Year, Month - 1, DateTime.DaysInMonth(Year, Month - 1));

                        DateStatus = " For " + string.Format("{0:dd/MM/yyyy}", FromDate.ToDate()) + " to " + string.Format("{0:dd/MM/yyyy}", TillDate.ToDate());
                    }

                    else if (DateType == "Datewise")
                    {
                        FromDate = from;

                        TillDate = till;


                        //Last_WK_FromDate = new DateTime(Year, Month - 1, 1);

                        //Last_WK_TillDate = new DateTime(Year, Month - 1, DateTime.DaysInMonth(Year, Month - 1));

                        DateStatus = " For " + string.Format("{0:dd/MM/yyyy}", FromDate.ToDate()) + " to " + string.Format("{0:dd/MM/yyyy}", TillDate.ToDate());
                    }

                    else if (DateType == "DAILY")
                    {
                        FromDate = DateTime.Today.ToDateTime();
                        TillDate = DateTime.Now.ToDateTime();

                        DateStatus = "For " + string.Format("{0:dd/MM/yyyy}", FromDate.ToDate()) + " to " + string.Format("{0:dd/MM/yyyy}", TillDate.ToDate());
                    }

                    FromDate = FromDate.ToDate();
                    TillDate = TillDate.ToDate() + TimeSpan.Parse("23:59:59");
                    var Value = db.stp_GraphData(User_Id, DayName, ReportType, FromDate, TillDate, Last_WK_FromDate, Last_WK_TillDate).ToList();

                    if (Value.Count > 0)
                    {
                        if (ReportType == "ACCOUNT_CASH")
                        {
                            //int CashBooking = Value[0].CashBookings.ToInt();
                            //int AccountBooking = Value[0].AccountBookings.ToInt();

                            //int[] yValues = { CashBooking, AccountBooking };
                            //string[] xNames = { "Cash: " + CashBooking, "Account: " + AccountBooking };
                            //MainChart.Series[0].Points.DataBindXY(xNames, yValues);
                            //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie;
                            //MainChart.Series[1].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie;
                            //lblTop.Text = "Account VS Cash";

                            //MainChart.Titles[0].Text = "Account VS Cash " + DateStatus;
                        }
                        else if (ReportType == "WEEKLY_JOBS")
                        {
                            //int?[] Totalbookings = Value.Where(c => c.Status == "CurrentWeek").Select(c => c.Total_Booking).ToArray();
                            //string[] DaysName = Value.Where(c => c.Status == "CurrentWeek").Select(c => c.Days).ToArray();
                            //MainChart.Series[0].Name = "Job Cureent Week";

                            //MainChart.Series[0].Points.DataBindXY(DaysName, Totalbookings);
                            //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;

                            //int?[] LastTotalbookings = Value.Where(c => c.Status == "lastWeek").Select(c => c.Total_Booking).ToArray();
                            //string[] LastDaysName = Value.Where(c => c.Status == "lastWeek").Select(c => c.Days).ToArray();
                            //MainChart.Series[1].Name = "History Average";
                            //MainChart.Series[1].Points.DataBindXY(LastDaysName, LastTotalbookings);
                            //lblTop.Text = "Job History";


                            //for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                            //{
                            //    MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();

                            //}

                            //for (int i = 0; i < MainChart.Series[1].Points.Count; i++)
                            //{
                            //    MainChart.Series[1].Points[i].Label = MainChart.Series[1].Points[i].YValues[0].ToStr();

                            //}


                            //MainChart.Titles[0].Text = "Jobs History " + DateStatus;
                        }



                        else if (ReportType == "DAILY_TOTAL_JOBS")
                        {
                            //int?[] Totalbookings = Value.Where(c => c.Status == "CurrentDay").Select(c => c.Total_Booking).ToArray();
                            //string[] DaysName = Value.Where(c => c.Status == "CurrentDay").Select(c => c.Days).ToArray();
                            //MainChart.Series[0].Name = "Job Cureent Day";

                            //MainChart.Series[0].Points.DataBindXY(DaysName, Totalbookings);
                            //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;

                            //int?[] LastTotalbookings = Value.Where(c => c.Status == "lastDay").Select(c => c.Total_Booking).ToArray();
                            //string[] LastDaysName = Value.Where(c => c.Status == "lastDay").Select(c => c.Days).ToArray();
                            //MainChart.Series[1].Name = "History Average";
                            //MainChart.Series[1].Points.DataBindXY(LastDaysName, LastTotalbookings);
                            //lblTop.Text = "Job History";


                            //for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                            //{
                            //    MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                            //    MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                            //}

                            //for (int i = 0; i < MainChart.Series[1].Points.Count; i++)
                            //{
                            //    MainChart.Series[1].Points[i].Label = MainChart.Series[1].Points[i].YValues[0].ToStr();

                            //}


                            //MainChart.Titles[0].Text = "Jobs History " + DateStatus;
                        }


                        else if (ReportType == "HOUR_JOBS")
                        {
                            //int?[] Totalbookings = Value.Where(c => c.HourStatus == "Today_Hour").Select(c => c.TotalHourBookings).ToArray();

                            //string[] hour = Value.Where(c => c.HourStatus == "Today_Hour").Select(c => c.OnHour.ToStr()).ToArray();
                            //MainChart.Series[0].Name = "Today";
                            //MainChart.Series[0].Points.DataBindXY(hour, Totalbookings);
                            //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;



                            //int?[] AvgTotalbooking = Value.Where(c => c.HourStatus == "Avg_Hour").Select(c => c.TotalHourBookings).ToArray();
                            //string[] Avghour = Value.Where(c => c.HourStatus == "Avg_Hour").Select(c => c.OnHour.ToStr()).ToArray();
                            //MainChart.Series[1].Name = "Average";
                            //MainChart.Series[1].Points.DataBindXY(Avghour, AvgTotalbooking);
                            //lblTop.Text = "jobs Per Hour";

                            //for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                            //{
                            //    MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();

                            //}

                            //for (int i = 0; i < MainChart.Series[1].Points.Count; i++)
                            //{
                            //    MainChart.Series[1].Points[i].Label = MainChart.Series[1].Points[i].YValues[0].ToStr();

                            //}
                            //MainChart.Titles[0].Text = "jobs Per Hour" + DateStatus;
                        }
                        else if (ReportType == "TOP_BOTTOM_DRIVERS")
                        {
                            //FromDate = FromDate.ToDate();
                            //TillDate = TillDate.ToDate() + TimeSpan.Parse("23:59:59");
                            //var DriverList = db.stp_GraphData(User_Id, DayName, ReportType, FromDate, TillDate, Last_WK_FromDate, Last_WK_TillDate).OrderByDescending(c => c.DriverStatus).ToList();

                            //int?[] Totalbookings = DriverList.Select(c => c.TotalDriverJobs).ToArray();

                            //string[] Driver = DriverList.Select(c => c.DriverNo).ToArray();
                            //MainChart.Series[0].Name = "Top Driver";
                            //MainChart.Series[0].Points.DataBindXY(Driver, Totalbookings);
                            //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;


                            //for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                            //{
                            //    MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();

                            //}

                            //for (int i = 0; i < MainChart.Series[1].Points.Count; i++)
                            //{
                            //    MainChart.Series[1].Points[i].Label = MainChart.Series[1].Points[i].YValues[0].ToStr();

                            //}

                            //MainChart.Titles[0].Text = "Top=Bottom Drivers " + DateStatus;


                            //MainChart.Series[0].Points[3].Color = Color.Orange;
                            //MainChart.Series[0].Points[4].Color = Color.Orange;
                            //MainChart.Series[0].Points[5].Color = Color.Orange;
                            //MainChart.Series[1].Name = "Bottom Driver";
                            //MainChart.Series[1].Color = Color.Orange;

                            //lblTop.Text = "Top=Bottom Drivers";
                        }
                        else if (ReportType == "YEARLY_BOOKINGS")
                        {
                            //foreach (var obj in Value.Where(c => c.YearlyStatus == "Cureent_Year"))
                            //{
                            //    DataPoint point = new DataPoint();
                            //    point.Label = obj.TotalMonthlyBooking.ToStr();
                            //    point.AxisLabel = obj.month.ToStr();
                            //    point.LabelForeColor = Color.Navy;
                            //    point.YValues[0] = (double)obj.TotalMonthlyBooking;
                            //    point.XValue = Convert.ToDouble(obj.month_No);
                            //    MainChart.Series[0].Points.Add(point);
                            //}
                            //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;

                            //foreach (var obj in Value.Where(c => c.YearlyStatus == "Last_Year"))
                            //{
                            //    DataPoint point = new DataPoint();
                            //    point.Label = obj.TotalMonthlyBooking.ToStr();
                            //    point.AxisLabel = obj.month.ToStr();
                            //    point.LabelForeColor = Color.Navy;
                            //    point.YValues[0] = (double)obj.TotalMonthlyBooking;
                            //    point.XValue = Convert.ToDouble(obj.month_No);
                            //    MainChart.Series[1].Points.Add(point);
                            //}
                            //MainChart.Series[1].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
                            //MainChart.Series[0].Name = "Job This Year";
                            //MainChart.Series[1].Name = "History Average";
                            //MainChart.Series[0].BorderWidth = 5;
                            //MainChart.Series[1].BorderWidth = 5;
                            //lblTop.Text = "Job This Year/historical";


                            //MainChart.Titles["Title1"].Text = "Job This Year/historical";
                        }
                        else if (ReportType == "TOTAL_DESPATCH")
                        {
                            //int?[] TotalDespatch = Value.Select(c => c.TotalDespatch).ToArray();

                            //string[] Controller = Value.Select(c => c.Despatchby).ToArray();
                            //MainChart.Series[0].Name = "Top 3 operater(jobs Dispatch)";
                            //MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch);
                            //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;


                            //for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                            //{
                            //    MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();

                            //}

                            //MainChart.Series[1].Enabled = false;
                            //lblTop.Text = "Jobs Dispatch";

                            //MainChart.Titles[0].Text = "Jobs Dispatch" + DateStatus;
                        }

                        //    else if (ReportType == "TOTAL_TAKEN_All_OPERATOR")
                        //    {
                        //        int?[] TotalDespatch = Value.Select(c => c.TotalDespatch).ToArray();

                        //        string[] Controller = Value.Select(c => c.ControllerName).ToArray();
                        //        MainChart.Series[0].Name = "All operater(jobs Taken)";
                        //        MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;

                        //        var colors = new List<Color>
                        //        {

                        //            Color.Blue,
                        //            Color.Red,
                        //            Color.Yellow,
                        //            Color.Green,
                        //            Color.Pink,
                        //            Color.AliceBlue,
                        //             Color.Aqua,
                        //              Color.Aquamarine,
                        //               Color.Azure,
                        //                Color.Beige,
                        //                 Color.Bisque,
                        //                  Color.BlueViolet,
                        //                   Color.Chartreuse,
                        //                    Color.Coral,
                        //                     Color.Cornsilk,
                        //                      Color.DarkOrange,
                        //                       Color.DarkSalmon,
                        //                        Color.Fuchsia,

                        //            Color.Maroon
                        //        };

                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Color = colors[i];
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Jobs Taken";
                        //        MainChart.Titles[1].Text = "Operators";
                        //        MainChart.Titles[2].Text = "No of Bookings";
                        //        MainChart.Titles[0].Text = "Jobs Taken" + DateStatus;
                        //    }

                        //    else if (ReportType == "WEEKLY_JOBS_TAKEN")
                        //    {
                        //        int?[] TotalDespatch = Value.Select(c => c.TotalHourBookings).ToArray();
                        //        string User = Value.Select(c => c.ControllerName).FirstOrDefault().ToStrIfEmpty();
                        //        string[] Controller = Value.Select(c => c.OnHour.ToStr()).ToArray();
                        //        MainChart.Series[0].Name = "Weekly Jobs By " + User + "";
                        //        MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;



                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Weekly Jobs";

                        //        MainChart.Titles[0].Text = "Weekly Jobs" + DateStatus;
                        //        MainChart.Titles[1].Text = "Week No";
                        //        MainChart.Titles[2].Text = "No of Bookings";

                        //    }

                        //    else if (ReportType == "DAILY_JOBS")
                        //    {
                        //        int?[] TotalDespatch = Value.Select(c => c.TotalHourBookings).ToArray();
                        //        string User = Value.Select(c => c.ControllerName).FirstOrDefault().ToStrIfEmpty();
                        //        int?[] Controller = Value.Select(c => c.OnHour).ToArray();
                        //        MainChart.Series[0].Name = "Daily Jobs By " + User + "";
                        //        MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;



                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //           // MainChart.ChartAreas.["ChartArea1"].AxisX.LabelStyle.Font = new System.Drawing.Font("Trebuchet MS", 2.25F, System.Drawing.FontStyle.Bold);
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        //MainChart.Series[1].Font = Font.Bold;
                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Daily Jobs";

                        //        MainChart.Titles[0].Text = "Daily Jobs" + DateStatus;
                        //        MainChart.Titles[1].Text = "Hours";
                        //        MainChart.Titles[2].Text = "No of Bookings";
                        //    }


                        //    else if (ReportType == "MONTHLY_JOBS_TAKEN")
                        //    {
                        //        int?[] TotalDespatch = Value.Select(c => c.Total_Booking).ToArray();
                        //        string User = Value.Select(c => c.ControllerName).FirstOrDefault().ToStrIfEmpty();
                        //        string[] Controller = Value.Select(c => c.Bookingmonth).ToArray();
                        //        MainChart.Series[0].Name = "Monthly Jobs By " + User +"";
                        //        MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;


                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Monthly Jobs";
                        //        MainChart.Titles[2].Text = "No of Bookings";
                        //        MainChart.Titles[1].Text = "Month";
                        //        MainChart.Titles[0].Text = "Monthly Jobs" + DateStatus;
                        //    }

                        //    else if (ReportType == "VEHICLE_EARNING")
                        //    {
                        //        decimal?[] TotalEarning = Value.Select(c => c.DriverTotalEarning).ToArray();

                        //        string[] Controller = Value.Select(c => c.ControllerName).ToArray();
                        //        MainChart.Series[0].Name = "All Vehicle(Vehicle Earning)";
                        //        MainChart.Series[0].Points.DataBindXY(Controller, TotalEarning);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;



                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Vehicle Earning";

                        //      //  MainChart.Titles[0].Text = "Jobs Taken" + DateStatus;
                        //        MainChart.Titles[1].Text = "Vehicle";
                        //        MainChart.Titles[2].Text = "Bookings";
                        //    }

                        //    else if (ReportType == "COMPANY_VEHICLE_EARNING")
                        //    {
                        //        decimal?[] TotalEarning = Value.Select(c => c.DriverTotalEarning).ToArray();

                        //        string[] Controller = Value.Select(c => c.ControllerName).ToArray();
                        //        MainChart.Series[0].Name = "All Company Vehicle(Company Vehicle Earning)";
                        //        MainChart.Series[0].Points.DataBindXY(Controller, TotalEarning);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;



                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Company Vehicle Earning";

                        //       // MainChart.Titles[0].Text = "Jobs Taken" + DateStatus;
                        //        MainChart.Titles[1].Text = "Company Vehicle";
                        //        MainChart.Titles[2].Text = "Bookings";
                        //    }

                        //   else if (ReportType == "TOTAL_DESPATCH_All_OPERATOR")
                        //    {
                        //        int?[] TotalDespatch = Value.Select(c => c.TotalDespatch).ToArray();

                        //        string[] Controller = Value.Select(c => c.Despatchby).ToArray();
                        //        MainChart.Series[0].Name = "All operater(jobs Dispatch)";
                        //        MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;

                        //        var colors = new List<Color>
                        //        {

                        //            Color.Blue,
                        //            Color.Red,
                        //            Color.Yellow,
                        //            Color.Green,
                        //            Color.Pink,
                        //            Color.AliceBlue,
                        //             Color.Aqua,
                        //              Color.Aquamarine,
                        //               Color.Azure,
                        //                Color.Beige,
                        //                 Color.Bisque,
                        //                  Color.BlueViolet,
                        //                   Color.Chartreuse,
                        //                    Color.Coral,
                        //                     Color.Cornsilk,
                        //                      Color.DarkOrange,
                        //                       Color.DarkSalmon,
                        //                        Color.Fuchsia,

                        //            Color.Maroon
                        //        };

                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Color = colors[i];
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Jobs Dispatch";
                        //        MainChart.Titles[1].Text = "Operators";
                        //        MainChart.Titles[2].Text = "No of Bookings";
                        //        MainChart.Titles[0].Text = "Jobs Dispatch" + DateStatus;
                        //    }

                        //    else if (ReportType == "DRIVER_RECOVERED_BOOKING")
                        //    {
                        //        int?[] TotalRejectedJobs = Value.Select(c => c.rejectedjobs).ToArray();

                        //        string[] DriverName = Value.Select(c => c.DriverName).ToArray();
                        //        MainChart.Series[0].Name = "Drivers(Recovered Jobs)";
                        //        MainChart.Series[0].Points.DataBindXY(DriverName, TotalRejectedJobs);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;


                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Drivers Recovered Jobs";
                        //        MainChart.Titles[1].Text = "Drivers";
                        //        MainChart.Titles[2].Text = "No of Booking";
                        //        MainChart.Titles[0].Text = "Drivers Recovered Jobs" + DateStatus;
                        //    }

                        //    else if (ReportType == "TOTAL_CALLRECIVE")
                        //    {
                        //        int?[] TotalCall = Value.Select(c => c.TotalCallRecive).ToArray();

                        //        string[] Controller = Value.Select(c => c.ControllerName).ToArray();
                        //        MainChart.Series[0].Name = "Top 3 operater(Call Received)";
                        //        MainChart.Series[0].Points.DataBindXY(Controller, TotalCall);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;


                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Jobs Taken";

                        //        MainChart.Titles[0].Text = "Jobs Taken" + DateStatus;
                        //    }
                        //    else if (ReportType == "DRIVER_REJECT_BOOKING")
                        //    {
                        //        int?[] TotalRejectedJobs = Value.Select(c => c.rejectedjobs).ToArray();

                        //        string[] DriverName = Value.Select(c => c.DriverName).ToArray();
                        //        MainChart.Series[0].Name = "Top 3 Drivers(Rejected Jobs)";
                        //        MainChart.Series[0].Points.DataBindXY(DriverName, TotalRejectedJobs);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;


                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Drivers Rejected Jobs";
                        //        MainChart.Titles[1].Text = "Drivers";
                        //        MainChart.Titles[2].Text = "No of Booking";
                        //        MainChart.Titles[0].Text = "Drivers Rejected Jobs" + DateStatus;
                        //    }
                        //    else if (ReportType == "LATE_BOOKING_DISPATCH")
                        //    {
                        //        int?[] TotallateJobs = Value.Select(c => c.TotalLateBooking).ToArray();

                        //        string[] jobLateBy = Value.Select(c => c.BookingLateBy).ToArray();
                        //        MainChart.Series[0].Name = "Top 3 operator(Late Jobs)";
                        //        MainChart.Series[0].Points.DataBindXY(jobLateBy, TotallateJobs);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;


                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Operator Late Jobs";

                        //        MainChart.Titles[0].Text = "Operator Late Jobs" + DateStatus;
                        //    }
                        //    else if (ReportType == "COMPLAINT_DRIVERS")
                        //    {
                        //        int?[] TotalComplaints = Value.Select(c => c.TotalCompaintsForDriver).ToArray();

                        //        string[] DriverNameComplaint = Value.Select(c => c.CompalintForDriver).ToArray();
                        //        MainChart.Series[0].Name = "Complaints For Drivers";
                        //        MainChart.Series[0].Points.DataBindXY(DriverNameComplaint, TotalComplaints);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;


                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Complaints For Drivers";

                        //        MainChart.Titles[0].Text = "Complaints For Drivers" + DateStatus;

                        //    }
                        //    else if (ReportType == "COMPLAINT_CONTROLLER")
                        //    {
                        //        int?[] TotalComplaints = Value.Select(c => c.TotalCompaintsForController).ToArray();

                        //        string[] OperatorNameComplaint = Value.Select(c => c.CompalintForController).ToArray();
                        //        MainChart.Series[0].Name = "Complaints For Operators";
                        //        MainChart.Series[0].Points.DataBindXY(OperatorNameComplaint, TotalComplaints);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;


                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Complaints For Operators";


                        //        MainChart.Titles[0].Text = "Complaints For Operators" + DateStatus;
                        //    }
                        //    else if (ReportType == "DRIVER_TOTAL_EARNING")
                        //    {
                        //        decimal?[] TotalEarning = Value.Select(c => c.DriverTotalEarning).ToArray();

                        //        string[] DriverName = Value.Select(c => c.EarningDriverName).ToArray();
                        //        MainChart.Series[0].Name = "Top 3 Driver(Earning)";
                        //        MainChart.Series[0].Points.DataBindXY(DriverName, TotalEarning);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;


                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }

                        //        MainChart.Series[1].Enabled = false;
                        //        lblTop.Text = "Driver Earning";


                        //        MainChart.Titles[0].Text = "Driver Earning" + DateStatus;
                        //    }
                        //    else if (ReportType == "MONTHLY_BOOKINGS")
                        //    {

                        //        int?[] Totalbookings = Value.Select(c => c.MonthlyBookings).ToArray();
                        //        string[] MonthName = Value.Select(c => c.Bookingmonth).ToArray();
                        //        MainChart.Series[0].Name = "Monthly Jobs";

                        //        MainChart.Series[0].Points.DataBindXY(MonthName, Totalbookings);
                        //        MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;

                        //        for (int i = 0; i < MainChart.Series[0].Points.Count; i++)
                        //        {
                        //            MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr();
                        //            MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold);
                        //        }
                        //        MainChart.Series[0].Points[0].Color = Color.Orange;
                        //        //  MainChart.Series[0].Points[1].Color = Color.Orange;
                        //        MainChart.Series[1].Name = "History Average";
                        //        MainChart.Series[1].Color = Color.Orange;
                        //        lblTop.Text = "Monthly Jobs";

                        //        MainChart.Titles[0].Text = "Monthly Jobs" + DateStatus;
                        //    }
                        //}
                        //else
                        //{
                        //    ENUtils.ShowMessage("Data Not found..");
                        //     _cond = false;

                        //    //frmShowGraphs frm = new frmShowGraphs();
                        //    //DockWindow doc = UI.MainMenuForm.MainMenuFrm.GetDockByName("frmShowGraphs1");

                        //    //if (doc == null)
                        //    //{
                        //    //    doc.Close();
                        //    //}
                        //    //MainMenuForm.MainMenuFrm.ShowForm(frm);
                        //}
                    }
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowErrorMessage(ex.Message);
            }
        }
示例#18
0
        private void PopulateInbox()
        {
            try
            {
                grdInbox.Rows.Clear();
                //var list = (from a in General.GetQueryable<InternalMessaging>(null)
                //            join b in General.GetQueryable<UM_User>(null)
                //            on a.ReceiveTo equals b.Id
                //            orderby a.AddOn ascending
                //            select new
                //            {
                //                Id = a.Id,
                //                Reciever = b.UserName,
                //                MessageText = a.MessageText,
                //                DateTime = string.Format("{0:MM/dd/yyyy HH:mm:ss tt}", a.AddOn.Value)
                //            }).ToList();

                using (TaxiDataContext db = new TaxiDataContext())
                {
                    var list = (from a in db.InternalMessagings
                                join b in db.UM_Users
                                on a.ReceiveTo equals b.Id
                                where a.ReceiveTo == AppVars.LoginObj.LuserId
                                orderby a.AddOn descending
                                select new
                    {
                        Id = a.Id,
                        Reciever = a.SenderName,
                        MessageText = a.MessageText,
                        DateTime = a.AddOn             //!= null ? string.Format("{0:MM/dd/yyyy HH:mm:ss tt}", a.AddOn.Value) : ""
                    }).ToList();


                    int cnt = list.Count;

                    int minRows = 8;

                    if (cnt < minRows)
                    {
                        for (int i = 0; i < minRows - cnt; i++)
                        {
                            // list.Add(new vu_Invoice { Id = data.Id, BookingId = data.BookingId, HasBookedBy = data.HasBookedBy, HasOrderNo = data.HasOrderNo, HasPupilNo = data.HasPupilNo });
                            list.Add(null);
                        }
                    }
                    int rowCount = list.Count;
                    grdInbox.RowCount = rowCount;
                    for (int i = 0; i < rowCount; i++)
                    {
                        if (list[i] != null)
                        {
                            grdInbox.Rows[i].Cells[COLS.Id].Value          = list[i].Id;
                            grdInbox.Rows[i].Cells[COLS.DateTime].Value    = list[i].DateTime;
                            grdInbox.Rows[i].Cells[COLS.Reciever].Value    = list[i].Reciever != null ? list[i].Reciever : "";
                            grdInbox.Rows[i].Cells[COLS.MessageText].Value = list[i].MessageText != null ? list[i].MessageText : "";
                        }
                    }
                    grdInbox.MultiSelect          = false;
                    this.grdInbox.CellBorderStyle = DataGridViewCellBorderStyle.None;
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
示例#19
0
        public override void PopulateData()
        {
            try
            {
                string searchTxt = txtSearch.Text.ToLower().Trim();
                string col       = ddlColumns.Text.Trim().ToLower();



                bool col_name     = false;
                bool col_phone    = false;
                bool col_mobileno = false;
                bool col_address  = false;
                bool col_doorno   = false;

                if (col == "name")
                {
                    col_name = true;
                }

                else if (col == "phone")
                {
                    col_phone = true;
                }

                else if (col == "mobileno")
                {
                    col_mobileno = true;
                }

                else if (col == "address")
                {
                    col_address = true;
                }
                else if (col == "doorno")
                {
                    col_doorno = true;
                }


                if (searchTxt.Length < 3 && col != "doorno")
                {
                    searchTxt = string.Empty;
                }


                DateTime dtBefore = DateTime.Now;


                using (TaxiDataContext db = new TaxiDataContext())
                {
                    var data1 = db.GetTable <Customer>();

                    int cnt = data1.Count();
                    if (skip + pageSize > cnt && cnt - pageSize > 0)
                    {
                        skip = cnt - pageSize;
                    }
                    else if (cnt <= pageSize)
                    {
                        skip = 0;
                    }

                    var query = from a in data1

                                where
                                (col_name && (a.Name != null && a.Name.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) ||
                                (col_phone && (a.TelephoneNo != null && a.TelephoneNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) ||
                                (col_mobileno && (a.MobileNo != null && a.MobileNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) ||
                                (col_address && (a.Address1 != null && a.Address1.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) ||
                                (col_doorno && (a.DoorNo.ToStr().ToLower().Contains(searchTxt) || searchTxt == string.Empty))

                                orderby a.Name
                                select new
                    {
                        Id         = a.Id,
                        Name       = a.Name,
                        Phone      = a.TelephoneNo,
                        MobileNo   = a.MobileNo,
                        Email      = a.Email,
                        Address    = a.DoorNo != null && a.DoorNo != string.Empty ? a.DoorNo + " - " + a.Address1 : a.Address1,
                        Doorno     = a.DoorNo,
                        BlackList  = a.BlackList,
                        DisableIVR = a.AccountNo
                    };



                    this.grdLister.TableElement.BeginUpdate();

                    if (excludeSkip == false)
                    {
                        grdLister.DataSource = query.Skip(skip).Take(pageSize).ToList();
                    }
                    else
                    {
                        grdLister.DataSource = query.ToList();
                    }

                    this.grdLister.TableElement.EndUpdate();

                    var secs = DateTime.Now.Subtract(dtBefore).TotalMilliseconds;

                    lblTotal.Text = "Total Customers : " + cnt.ToStr();
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
示例#20
0
        private void Login()
        {
            try
            {
                TaxiDataContext db = new TaxiDataContext();

                UM_User obj = db.UM_Users.FirstOrDefault(c => (c.IsActive == true) && (c.UserName.ToLower() == txtUserName.Text.Trim().ToLower() && c.Passwrd.ToLower() == txtPassword.Text.Trim().ToLower()));


                if (obj == null)
                {
                    RadMessageBox.Show("Invalid UserName or Password.", "EuroSoftTech", MessageBoxButtons.OK, RadMessageIcon.Error);
                    txtUserName.Focus();
                    db.Dispose();
                    return;
                }
                else
                {
                    AppVars.objSubCompany = db.Gen_SubCompanies.FirstOrDefault(c => c.Id == obj.SubcompanyId);

                    if (AppVars.objSubCompany == null)
                    {
                        db.Dispose();

                        ENUtils.ShowMessage("This user is not created properly" + Environment.NewLine
                                            + "Define Subcompany for that user in Users Menu.");
                        return;
                    }


                    AppVars.DefaultSubCompanyId = AppVars.objSubCompany.Id;
                }

                if (this.InvokeRequired)
                {
                    DisplayProgressBar d = new DisplayProgressBar(ShowLoadingImage);
                    this.BeginInvoke(d);
                }
                else
                {
                    ShowLoadingImage();
                }


                frmMainMenu frm = new frmMainMenu();


                if (IsAutoLogin)
                {
                    frm.showWarning = false;
                }

                frm.ObjLoginUser        = new DAL.LoginUser();
                frm.ObjLoginUser.SysGen = obj.UM_SecurityGroup.SysGen.ToBool();

                frm.ObjLoginUser.LgroupId  = obj.SecurityGroupId.ToInt();
                frm.ObjLoginUser.LoginName = obj.UserName;
                frm.ObjLoginUser.LuserId   = obj.Id;
                frm.ObjLoginUser.UserName  = obj.UserName;
                frm.ObjLoginUser.Email     = obj.Email;
                frm.ObjLoginUser.Password  = obj.Passwrd;

                frm.ObjLoginUser.LsessionId = db.stp_ControlerLogins(frm.ObjLoginUser.LuserId.ToInt(), null, null, Environment.MachineName).FirstOrDefault().Id.ToInt();



                frm.ObjLoginUser.IsAdmin = obj.ConfirmPasswrd.ToStr() == "1"?true:false;
                AppVars.LoginObj         = frm.ObjLoginUser;


                AppVars.AppTheme    = obj.ThemeName;
                frm.CurrentTheme    = obj.ThemeName;
                frm.ShowAllBookings = obj.ShowAllBookings.ToBool();

                frm.ShowAllDrivers = obj.ShowAllDrivers.ToBool();

                frm.ShowDriverFilter    = obj.ShowDriverFilter.ToBool();
                frm.ShowBookingFilter   = obj.ShowBookingFilter.ToBool();
                AppVars.ShowAllBookings = obj.ShowAllBookings.ToBool();
                AppVars.CanTransferJob  = obj.TransferBooking.ToBool();

                AppVars.IsTelephonist = obj.Fax.ToStr() == "1" ? true : false;

                frm.Show();



                this.ShowInTaskbar = false;

                this.Hide();

                frmLoading.Close();

                db.Dispose();



                // Close();
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
        private void UpdateDriverRent()
        {
            try
            {
                if (RentId == 0)
                {
                    ENUtils.ShowMessage("Driver Rent is not Generated");
                    return;
                }



                if (chkOther.Checked)
                {
                    ddlRentPayReason.SelectedValue = null;
                }

                decimal RentDue        = lblRentDue.Text.ToDecimal();
                decimal RentPay        = spnRentPay.Value.ToDecimal();
                decimal RentPaid       = (RentPay + RentDue);
                decimal CurrentBalance = numCurrBalance.Value.ToDecimal();

                int?   rentPayReasonId   = ddlRentPayReason.SelectedValue.ToIntorNull();
                string rentPayReasonText = txtReason.Text.Trim();
                bool   IsNewReason       = false;



                using (TaxiDataContext db = new TaxiDataContext())
                {
                    if (rentPayReasonId == null && !string.IsNullOrEmpty(rentPayReasonText))
                    {
                        try
                        {
                            DriverRentPayReason objRentPayReason = new DriverRentPayReason();
                            rentPayReasonId             = db.DriverRentPayReasons.OrderByDescending(c => c.Id).FirstOrDefault().Id + 1;
                            objRentPayReason.Id         = rentPayReasonId.ToInt();
                            objRentPayReason.RentReason = rentPayReasonText;


                            db.DriverRentPayReasons.InsertOnSubmit(objRentPayReason);
                            db.SubmitChanges();

                            IsNewReason = true;
                        }
                        catch
                        {
                        }
                    }



                    db.stp_UpdateDriverRentWithReason(RentId, CurrentBalance, RentPay, rentPayReasonId);
                }



                if (IsNewReason)
                {
                    ComboFunctions.FillRentPayReasonCombo(ddlRentPayReason);
                }

                //else
                //{

                //    DriverRentBO rentBo = new DriverRentBO();
                //    rentBo.GetByPrimaryKey(RentId);

                //    if (rentBo.Current != null)
                //    {
                //        rentBo.Current.RentPayReasonId = ddlRentPayReason.SelectedValue.ToIntorNull();
                //        rentBo.Current.Balance

                //    }

                //}

                DisplayRecord();
                //   this.Close();
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
        public void GenerateReport(decimal VAT)
        {
            try
            {
                if (optFullDetail.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
                {
                    DisplayCriteriaType = "";
                }
                else if (optAccountJobs.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
                {
                    DisplayCriteriaType = "account_";
                }
                else if (optSummaryDetails.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
                {
                    DisplayCriteriaType = "summary_";
                }
                reportViewer1.LocalReport.EnableExternalImages = true;

                if (objSubcompany == null)
                {
                    objSubcompany = AppVars.objSubCompany;
                }

                //Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[27];

                Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[28];
                string address = objSubcompany.Address;
                string telNo   = string.Empty;

                string sortCode     = objSubcompany.SortCode.ToStr();
                string accountNo    = objSubcompany.AccountNo.ToStr();
                string accountTitle = objSubcompany.AccountTitle.ToStr();
                string bank         = objSubcompany.BankName.ToStr();

                string hasBankDetails = "1";
                if (string.IsNullOrEmpty(sortCode) && string.IsNullOrEmpty(accountNo) && string.IsNullOrEmpty(accountTitle) &&
                    string.IsNullOrEmpty(bank))
                {
                    hasBankDetails = "0";
                }

                if (!string.IsNullOrEmpty(sortCode))
                {
                    sortCode = "Sort Code : " + sortCode;
                }


                if (!string.IsNullOrEmpty(accountTitle))
                {
                    accountTitle = "Account Title : " + accountTitle;
                }


                string website = objSubcompany.WebsiteUrl.ToStr();
                if (!string.IsNullOrEmpty(website))
                {
                    website += " , ";
                }

                website += "Email:" + objSubcompany.EmailAddress.ToStr();


                string companyNumber = objSubcompany.CompanyNumber.ToStr();
                if (!string.IsNullOrEmpty(companyNumber))
                {
                    companyNumber = "Company Number: " + companyNumber;
                }

                string vatNumber = objSubcompany.CompanyVatNumber.ToStr();


                param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address);

                param[18] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Footer", objSubcompany.WebsiteUrl.ToStr());

                param[14] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_MobileNo", "Mobile: " + objSubcompany.EmergencyNo.ToStr());
                param[15] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Website", website);
                param[16] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Email", "Email: " + objSubcompany.EmailAddress.ToStr());

                param[20] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CompanyNumber", companyNumber);
                param[21] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_VATNumber", vatNumber);


                param[7]  = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_SortCode", sortCode);
                param[9]  = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_AccountTitle", accountTitle);
                param[10] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Bank", bank);



                List <ClsLogo> objLogo = new List <ClsLogo>();
                objLogo.Add(new ClsLogo {
                    ImageInBytes = objSubcompany.CompanyLogo != null ? objSubcompany.CompanyLogo.ToArray() : null
                });
                ReportDataSource imageDataSource = new ReportDataSource("Taxi_AppMain_Classes_ClsLogo", objLogo);
                this.reportViewer1.LocalReport.DataSources.Add(imageDataSource);

                string path = @"File:";
                param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Path", path);
                param[6] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CompanyHeader", objSubcompany.CompanyName.ToStr());

                param[22] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CompanyHeading", objSubcompany.CompanyName.ToStr());



                int?driverId = this.DataSource.FirstOrDefault().DefaultIfEmpty().DriverId;

                var data = this.DataSource.FirstOrDefault().DefaultIfEmpty();



                telNo = "Tel No. " + objSubcompany.TelephoneNo;

                if (!string.IsNullOrEmpty(accountNo))
                {
                    accountNo = "Account No : " + accountNo;
                }



                //var objTemplate = General.GetObject<UM_Form_Template>(c => c.UM_Form.FormName == this.Name && c.IsDefault == true);

                //string className = "Taxi_AppMain.ReportDesigns.";
                //if (objTemplate!=null)
                //{

                //    if (objTemplate.TemplateName == "Template1")
                //    {

                //        this.reportViewer1.LocalReport.ReportEmbeddedResource = className + "rptDriverRentTrasaction.rdlc";
                //    }
                //    else if (objTemplate.TemplateName == "Template2")
                //    {
                //        this.reportViewer1.LocalReport.ReportEmbeddedResource = className + "rptDriverRentTrasaction2.rdlc";


                //    }

                //    else if (objTemplate.TemplateName == "Template3")
                //    {
                //        this.reportViewer1.LocalReport.ReportEmbeddedResource = className + "rptDriverRentTrasaction3.rdlc";
                //    }

                //    else if (objTemplate.TemplateName == "Template4")
                //    {
                //        this.reportViewer1.LocalReport.ReportEmbeddedResource = className + "rptDriverRentTrasaction4.rdlc";
                //    }

                //}


                param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo);


                param[8] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_AccountNo", accountNo);



                string  vat            = "0";
                decimal discountAmount = 0.00m;
                decimal valueAddedTax  = VAT;



                string discount = string.Format("{0:c}", discountAmount);
                discount = discount.Substring(1);

                string grandTotal = "";

                param[17] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Discount", discount);


                param[3] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_InvoiceTotal", grandTotal);

                param[4] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_HasVat", vat);

                param[5]  = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_VAT", valueAddedTax.ToStr());
                param[11] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_HasDepartment", "0");

                param[12] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Net", "0");



                param[19] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_HasBankDetails", hasBankDetails);



                int cnt = this.DataSource.Count;
                //NC
                //decimal JobTotal = 0;
                //   string AccountBooking = string.Empty;
                //  string CashBooking = string.Empty;

                //    AccountBooking = string.Format("{0:£ #.##}", this.DataSource.Where(c => c.CompanyId != null).Sum(c => c.FareRate.ToDecimal()));
                //    CashBooking = string.Format("{0:£ #.##}", this.DataSource.Where(c => c.CompanyId == null).Sum(c => c.FareRate.ToDecimal()));
                //    JobTotal = this.DataSource.Sum(c => c.FareRate.Value.ToDecimal()+ c.WaitingCharges.ToDecimal());



                //param[22] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_AccountJobTotal", AccountBooking);
                //param[23] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CashJobTotal", CashBooking);



                //comment


                //string BalanceType = string.Empty;
                //int DriverId = this.DataSource.FirstOrDefault().DefaultIfEmpty().DriverId.ToInt();
                //int Id = this.DataSource.FirstOrDefault().DefaultIfEmpty().Id.ToInt(); ;
                //var query=General.GetObject<DriverRent>(c=>c.DriverId==DriverId && c.Id<Id);

                //string StatementDate = string.Empty;
                //if (query == null)
                //{
                //    BalanceType = "Initial Balance";
                //    StatementDate = string.Format("{0:dd/MM}", this.DataSource.FirstOrDefault().DefaultIfEmpty().TransDate);
                //}
                //else
                //{
                //    BalanceType = "Balance from statement "+query.TransNo;
                //    StatementDate = string.Format("{0:dd/MM}", query.TransDate);
                //}

                //param[23] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_jobCount", cnt.ToStr());
                //param[24] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_BalanceType", BalanceType);
                //param[25] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_StatementDate", StatementDate);


                // string balance=string.Empty;

                //decimal bal=this.DataSource.FirstOrDefault().DefaultIfEmpty().Balance.ToDecimal();


                //if(bal>=0)
                //{

                //    balance = "You are due to Pay £" + string.Format("{0:f2}", bal);
                //}
                //else
                //{
                //    balance = "You are due to receive £" + string.Format("{0:f2}", bal);

                //    balance = balance.Replace("-", "").Trim();

                //}


                //param[26] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Balance", balance);
                //reportViewer1.LocalReport.SetParameters(param);
                ////this.vu_DriverRentBindingSource.DataSource = this.DataSource;
                //this.vu_DriverRentExpenseBindingSource.DataSource = this.DataSource;
                //this.vu_FleetDriverRentExpenseBindingSource.DataSource = this.DataSource2;
                //this.reportViewer1.ZoomPercent = 100;
                //this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
                //this.reportViewer1.RefreshReport();


                string BalanceType    = string.Empty;
                int    DriverId       = 0;
                string oldBalanceDate = string.Empty;
                if (this.DataSource.Count > 0)
                {
                    DriverId = this.DataSource.FirstOrDefault().DriverId.ToInt();
                    int Id = this.DataSource.FirstOrDefault().Id.ToInt();;
                    // var query = General.GetObject<DriverRent>(c => c.DriverId == DriverId && c.Id < Id);

                    string StatementDate = string.Empty;
                    //if (query == null)
                    //{
                    //    BalanceType = "Initial Balance";
                    //    StatementDate = string.Format("{0:dd/MM}", this.DataSource.FirstOrDefault().TransDate);
                    //}
                    //else
                    //{
                    //    BalanceType = "Balance from statement " + query.TransNo;
                    //    StatementDate = string.Format("{0:dd/MM}", query.TransDate);
                    //}

                    using (TaxiDataContext db = new TaxiDataContext())
                    {
                        var query = db.DriverRents.Where(c => c.DriverId == driverId && c.Id < Id).OrderByDescending(c => c.Id).FirstOrDefault();


                        if (query == null)
                        {
                            BalanceType   = "Initial Balance";
                            StatementDate = string.Format("{0:dd/MM}", this.DataSource.FirstOrDefault().TransDate);
                        }
                        else
                        {
                            BalanceType   = "Balance from statement " + query.TransNo.ToStr();
                            StatementDate = string.Format("{0:dd/MM}", this.DataSource.FirstOrDefault().TransDate);

                            try
                            {
                                oldBalanceDate = string.Format("{0:dd/MM}", query.TransDate.ToDate());
                            }
                            catch
                            {
                                oldBalanceDate = StatementDate;
                            }
                        }
                    }



                    //  string Commision = (JobTotal * DriverCommision / 100).ToStr();


                    param[13] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_HasCostCenter", oldBalanceDate);
                    param[23] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_jobCount", cnt.ToStr());
                    param[24] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_BalanceType", BalanceType);
                    // param[28] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_AccountExpenses", AccountExpenses.ToStr());
                    param[25] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_StatementDate", StatementDate);

                    //decimal AccountTotal = (this.DataSource.Sum(c => c.AccountJobsTotal)).ToDecimal();
                    //decimal AccountCommision=(25*AccountTotal/100);
                    //decimal CashTotal = (this.DataSource.Sum(c => c.CashJobsTotal)).ToDecimal();
                    //decimal CashCommision=(25*CashTotal/100);
                    //decimal TotalDebit = this.DataSource2.Sum(c => c.Debit).ToDecimal();
                    //decimal TotalCredit = this.DataSource2.Sum(c=>c.Credit).ToDecimal();



                    decimal bal = this.DataSource.FirstOrDefault().DefaultIfEmpty().Balance.ToDecimal();

                    string balance = "Balance Due £" + string.Format("{0:f2}", bal);

                    //if (bal >= 0)
                    //{

                    //    balance = "You are due to Pay £" + string.Format("{0:f2}", bal);
                    //}
                    //else
                    //{
                    //    balance = "You are due to receive £" + string.Format("{0:f2}", bal);

                    //    balance = balance.Replace("-", "").Trim();

                    //}


                    param[26] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Balance", balance);
                }
                else
                {
                    param[23] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_jobCount", cnt.ToStr());
                    param[24] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_BalanceType", BalanceType);
                    // param[28] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_AccountExpenses", AccountExpenses.ToStr());
                    param[25] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_StatementDate", "");
                    param[26] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Balance", "");
                }
                param[27] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_DisplayType", this.DisplayCriteriaType);



                if (templateName.ToStr().Length == 0)
                {
                    using (TaxiDataContext db = new TaxiDataContext())
                    {
                        templateName = db.UM_Form_Templates.Where(c => c.UM_Form.FormName == "frmDriverRentDebitCredit3" && c.IsDefault == true).Select(c => c.TemplateName).FirstOrDefault();


                        if (templateName.ToStr().Trim().Length > 0)
                        {
                            templateName = templateName + "_";
                        }
                    }
                }

                if (templateName.ToStr().Trim().Length == 0)
                {
                    templateName = " ";
                }

                this.reportViewer1.LocalReport.ReportEmbeddedResource = "Taxi_AppMain.ReportDesigns." + templateName.ToStr().Trim() + "rptDriverRentExpenses3.rdlc";



                reportViewer1.LocalReport.SetParameters(param);
                //this.vu_DriverRentBindingSource.DataSource = this.DataSource;
                this.vu_DriverRentExpenseBindingSource.DataSource      = this.DataSource;
                this.vu_FleetDriverRentExpenseBindingSource.DataSource = this.DataSource2;
                this.reportViewer1.ZoomPercent = 100;
                this.reportViewer1.ZoomMode    = Microsoft.Reporting.WinForms.ZoomMode.Percent;
                this.reportViewer1.RefreshReport();
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
        private void UpdateDriverCommission()
        {
            try
            {
                if (CommissionId == 0)
                {
                    ENUtils.ShowMessage("Driver Commission is not Generated");
                    return;
                }



                if (chkOther.Checked)
                {
                    ddlCommissionPayReason.SelectedValue = null;
                }

                decimal CommissionDue  = lblCommissionDue.Text.ToDecimal();
                decimal CommissionPay  = spnCommissionPay.Value.ToDecimal();
                decimal CommissionPaid = (CommissionPay + CommissionDue);
                decimal CurrentBalance = numCurrBalance.Value.ToDecimal();

                int?   CommissionPayReasonId   = ddlCommissionPayReason.SelectedValue.ToIntorNull();
                string CommissionPayReasonText = txtReason.Text.Trim();
                bool   IsNewReason             = false;



                using (TaxiDataContext db = new TaxiDataContext())
                {
                    if (CommissionPayReasonId == null && !string.IsNullOrEmpty(CommissionPayReasonText))
                    {
                        try
                        {
                            //DriverRentPayReason objRentPayReason = new DriverRentPayReason();
                            //rentPayReasonId = db.DriverRentPayReasons.OrderByDescending(c => c.Id).FirstOrDefault().Id + 1;
                            //objRentPayReason.Id = rentPayReasonId.ToInt();
                            //objRentPayReason.RentReason = rentPayReasonText;


                            //db.DriverRentPayReasons.InsertOnSubmit(objRentPayReason);
                            //db.SubmitChanges();

                            DriverCommissionPayReason objCommissionPayReason = new DriverCommissionPayReason();
                            CommissionPayReasonId     = db.DriverCommissionPayReasons.OrderByDescending(c => c.Id).FirstOrDefault().Id + 1;
                            objCommissionPayReason.Id = CommissionPayReasonId.ToInt();
                            objCommissionPayReason.CommissionReason = CommissionPayReasonText;
                            db.DriverCommissionPayReasons.InsertOnSubmit(objCommissionPayReason);
                            db.SubmitChanges();
                            IsNewReason = true;
                        }
                        catch
                        {
                        }
                    }


                    db.stp_UpdateDriverCommissionWithReason(CommissionId, CurrentBalance, CommissionPay, CommissionPayReasonId);
                }

                if (IsNewReason)
                {
                    ComboFunctions.FillCommissionReasonCombo(ddlCommissionPayReason);
                }



                spnCommissionPay.Value = 0.00m;

                DisplayRecord();
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
        private void Save()
        {
            try
            {
                int      defaultAllocationLimit = AppVars.objPolicyConfiguration.AllocateDrvPreExistJobLimit.ToInt();
                int?     driverId          = ddl_Driver.SelectedValue.ToIntorNull();
                int?     oldDriverId       = null;
                string   oldDriverNo       = string.Empty;
                long     jobId             = 0;
                bool     cancelJob         = false;
                DateTime?pickupDateAndTime = ObjMaster.Current.PickupDateTime.ToDateTimeorNull();


                //if (driverId != null && defaultAllocationLimit>0 &&
                //    General.GetQueryable<Booking>(null).Count(c => c.DriverId == driverId && c.Id!=ObjMaster.Current.Id
                //         && (c.BookingStatusId==Enums.BOOKINGSTATUS.WAITING || c.BookingStatusId==Enums.BOOKINGSTATUS.PENDING)
                //         &&

                //         (
                //         (c.PickupDateTime.Value<=pickupDateAndTime
                //         && (c.PickupDateTime.Value >= pickupDateAndTime.Value.AddMinutes(-defaultAllocationLimit)) )

                //              || (c.PickupDateTime.Value >= pickupDateAndTime
                //         && (c.PickupDateTime.Value <= pickupDateAndTime.Value.AddMinutes(defaultAllocationLimit)))
                //         )


                //         ) > 0)
                //{

                //    if (DialogResult.No == MessageBox.Show("This driver already have a Job Allocated at this time "+
                //         Environment.NewLine + "Do you still want to Allocate it ? ", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
                //    {
                //        return;

                //    }

                //}


                if (driverId != null)
                {
                    var ObjDriver = General.GetObject <Fleet_Driver>(c => c.Id == driverId);

                    if (ObjDriver != null)
                    {
                        allocateDrvNo = ObjDriver.DriverNo.ToStr().Trim();
                        if (ObjDriver.VehicleTypeId != null)
                        {
                            if (ObjMaster.Current.AttributeValues.ToStr().Trim().Length > 0)
                            {
                                string[] bookingAttrs  = ObjMaster.Current.AttributeValues.ToStr().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                                string   drvAttributes = ObjDriver.AttributeValues.ToStr() + "," + ObjDriver.Fleet_VehicleType.AttributeValues;

                                int      totalAttr          = bookingAttrs.Count();
                                int      matchCnt           = 0;
                                string   unmatchedAttrValue = string.Empty;
                                string[] drvAttrsArr        = drvAttributes.ToStr().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);

                                foreach (var item in bookingAttrs)
                                {
                                    if (drvAttrsArr.Count(c => c.ToLower() == item.ToLower()) > 0)
                                    {
                                        matchCnt++;
                                    }
                                    else
                                    {
                                        unmatchedAttrValue += item + ",";
                                    }
                                }

                                if (matchCnt != totalAttr)
                                {
                                    if (unmatchedAttrValue.EndsWith(","))
                                    {
                                        unmatchedAttrValue = unmatchedAttrValue.Substring(0, unmatchedAttrValue.LastIndexOf(","));
                                    }

                                    MessageBox.Show(("Driver : " + ObjDriver.DriverNo + " doesn't have attributes (" + unmatchedAttrValue + ")"), "Warning");
                                    return;
                                }
                            }

                            if (AppVars.listUserRights.Count(c => c.functionId == "RESTRICT ON DESPATCH JOB TO INVALID VEHICLE DRIVER") > 0)
                            {
                                string vehAttributes = ObjMaster.Current.Fleet_VehicleType.DefaultIfEmpty().AttributeValues.ToStr().Trim();

                                if (vehAttributes.Length > 0)
                                {
                                    bool MatchedAttr = false;
                                    foreach (var item in vehAttributes.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries))
                                    {
                                        if (ObjDriver.VehicleTypeId.ToInt() == item.ToInt())
                                        {
                                            MatchedAttr = true;
                                            break;
                                        }
                                    }



                                    if (MatchedAttr == false)
                                    {
                                        MessageBox.Show("This Job is for " + ObjMaster.Current.Fleet_VehicleType.VehicleType.ToStr() + " Vehicle" + Environment.NewLine +
                                                        "and Driver no " + ObjDriver.DriverNo + " have " + ObjDriver.Fleet_VehicleType.VehicleType + ".");

                                        return;
                                    }
                                }
                                else
                                {
                                    if (ObjDriver.Fleet_VehicleType.NoofPassengers.ToInt() < ObjMaster.Current.Fleet_VehicleType.NoofPassengers.ToInt())
                                    {
                                        MessageBox.Show("This Job is for " + ObjMaster.Current.Fleet_VehicleType.VehicleType.ToStr() + " Vehicle" + Environment.NewLine +
                                                        "and Driver no " + ObjDriver.DriverNo + " have " + ObjDriver.Fleet_VehicleType.VehicleType + ".");


                                        return;
                                    }
                                }
                            }
                            else
                            {
                                if (ObjDriver.Fleet_VehicleType.NoofPassengers.ToInt() < ObjMaster.Current.Fleet_VehicleType.NoofPassengers.ToInt())
                                {
                                    if (DialogResult.No == MessageBox.Show("This Job is for " + ObjMaster.Current.Fleet_VehicleType.VehicleType.ToStr() + " Vehicle" + Environment.NewLine +
                                                                           "and Driver no " + ObjDriver.DriverNo + " have " + ObjDriver.Fleet_VehicleType.VehicleType + "." + Environment.NewLine
                                                                           + "Do you still want to Allocate this Job to that Driver " + ObjDriver.DriverNo + " ?", "Despatch", MessageBoxButtons.YesNo))
                                    {
                                        return;
                                    }
                                }
                            }
                        }
                    }

                    try
                    {
                        if ((driverId != null && ObjMaster.Current.DriverId == null) || (driverId != null && ObjMaster.Current.DriverId != null && driverId != ObjMaster.Current.DriverId))
                        {
                            if (IsDriverDocumentExpired(driverId.ToInt(), ObjDriver))
                            {
                                return;
                            }
                        }
                    }
                    catch
                    {
                    }
                }



                if (ObjMaster.Current != null)
                {
                    if (driverId != null || (ObjMaster.Current.DriverId != null && ObjMaster.Current.BookingStatusId.ToInt() == Enums.BOOKINGSTATUS.WAITING))
                    {
                        //if ((driverId != null && ObjMaster.Current.DriverId == null) || (driverId!=null && ObjMaster.Current.DriverId!=null && driverId!=ObjMaster.Current.DriverId))
                        //{

                        //   if  (IsDriverDocumentExpired(driverId.ToInt()))
                        //       return;

                        //}


                        if (driverId == null && ObjMaster.Current.DriverId != null)
                        {
                            oldDriverNo = ObjMaster.Current.Fleet_Driver.DriverNo.ToStr();
                        }


                        if (ObjMaster.Current.DriverId != null)
                        {
                            oldDriverId = ObjMaster.Current.DriverId;
                        }


                        ObjMaster.CheckDataValidation = false;

                        ObjMaster.Edit();

                        ObjMaster.Current.DriverId = driverId;

                        ObjMaster.Current.IsConfirmedDriver = driverId != null ? chkConfirmed.Checked:false;



                        if (ObjMaster.Current.BookingStatusId.ToInt() == Enums.BOOKINGSTATUS.NOTACCEPTED)
                        {
                            ObjMaster.Current.BookingStatusId = Enums.BOOKINGSTATUS.WAITING;
                        }



                        if (driverId == null || (oldDriverId != null && oldDriverId != driverId && ObjMaster.Current.BookingStatusId != Enums.BOOKINGSTATUS.WAITING))
                        {
                            ObjMaster.Current.BookingStatusId = Enums.BOOKINGSTATUS.WAITING;
                            cancelJob = true;
                        }


                        jobId          = ObjMaster.Current.Id;
                        allocatedJobId = jobId;

                        ObjMaster.CheckCustomerValidation = false;
                        ObjMaster.DisableUpdateReturnJob  = true;

                        ObjMaster.Save();


                        if (ObjMaster.Current.BookingTypeId.ToInt() == Enums.BOOKING_TYPES.THIRDPARTY && ObjMaster.Current.OnlineBookingId != null)
                        {
                            General.UpdateThirdPartyJobStatus(null, jobId, "allocated");
                        }

                        this.Close();


                        if (IsOpenFrom == 1)
                        {
                            RefreshTodayBookingsDashboard();
                        }
                        else
                        {
                            RefreshTodayAndPreBookingsDashboard();
                            //  AppVars.frmMDI.RefreshTodayAnPreDashboard();
                        }

                        string Msg = string.Empty;


                        if (driverId != null)
                        {
                            if (chkConfirmed.Checked)
                            {
                                Msg = "Job is Allocated and confirmed to Driver (" + ObjMaster.Current.Fleet_Driver.DriverNo.ToStr() + ")";
                            }
                            else
                            {
                                Msg = "Job is Allocated  to Driver (" + ObjMaster.Current.Fleet_Driver.DriverNo.ToStr() + ")";
                            }
                        }
                        else if (driverId == null && !string.IsNullOrEmpty(oldDriverNo))
                        {
                            Msg = "Job is De-Allocated from Driver (" + oldDriverNo + ")";
                        }

                        using (TaxiDataContext db = new TaxiDataContext())
                        {
                            db.stp_BookingLog(ObjMaster.Current.Id, AppVars.LoginObj.UserName.ToStr(), Msg);


                            if (cancelJob)
                            {
                                if (AppVars.objPolicyConfiguration.DespatchOfflineJobs.ToBool())
                                {
                                    db.stp_DeleteDrvOfflineJob(ObjMaster.Current.Id, oldDriverId);
                                }
                            }
                        }



                        if (cancelJob)
                        {
                            //For TCP Connection
                            if (AppVars.objPolicyConfiguration.IsListenAll.ToBool())
                            {
                                new Thread(delegate()
                                {
                                    General.SendMessageToPDA("request pda=" + oldDriverId + "=" + jobId + "=Cancelled Pre Job>>" + jobId + "=2");
                                }).Start();
                            }
                        }
                    }
                    else
                    {
                        ENUtils.ShowMessage("Required: Driver");
                    }
                }
            }
            catch (Exception ex)
            {
            }
        }
        private void GenerateReport()
        {
            try
            {
                int VehicleId = ddlCompanyVehicle.SelectedValue.ToInt();



                if (dtpFromDate.Value != null && dtpFromDate.Value.Value.Year == 1753)
                {
                    dtpFromDate.Value = null;
                }

                if (dtpTillDate.Value != null && dtpTillDate.Value.Value.Year == 1753)
                {
                    dtpTillDate.Value = null;
                }

                DateTime?fromDate = dtpFromDate.Value.ToDateorNull();
                DateTime?tillDate = dtpTillDate.Value.ToDateorNull();

                string Error = string.Empty;
                if (fromDate.Value == null)
                {
                    Error = "Required : From Date";
                }
                if (tillDate.Value == null)
                {
                    if (string.IsNullOrEmpty(Error))
                    {
                        Error = "Required : To Date";
                    }
                    else
                    {
                        Error += Environment.NewLine + "Required : To Date";
                    }
                }

                if (!string.IsNullOrEmpty(Error))
                {
                    ENUtils.ShowMessage(Error);
                    return;
                }
                if (tillDate != null)
                {
                    tillDate = tillDate + TimeSpan.Parse("23:59:59");
                }



                using (TaxiDataContext db = new TaxiDataContext())
                {
                    var list = db.stp_GetVehicleLoginHistory(fromDate.Value, tillDate.Value, VehicleId).ToList();


                    if (ddlDriver.SelectedValue.ToInt() != 0)
                    {
                        list = list.Where(c => c.DriverId == ddlDriver.SelectedValue.ToInt()).ToList();
                    }

                    var list2 = (list.AsEnumerable().OrderBy(item => item.DriverNo, new NaturalSortComparer <string>())).ToList();
                    this.stp_GetVehicleLoginHistoryResultBindingSource.DataSource = list2;
                }


                Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[4];

                string address = AppVars.objSubCompany.Address;
                string telNo   = "Tel No. " + AppVars.objSubCompany.TelephoneNo;

                param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Heading", AppVars.objSubCompany.CompanyName.ToStr());
                param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address);
                param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo);
                //Report_Parameter_AverageJobsPerDay
                string heading = string.Empty;
                if (fromDate != null && tillDate != null)
                {
                    heading = "Period: " + string.Format("{0:dd/MM/yyyy}", fromDate) + " to " + string.Format("{0:dd/MM/yyyy}", tillDate);
                }
                param[3] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Criteria", heading);
                //param[4] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_AverageJobsPerDay", s.ToStr());
                //param[5] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_AverageWorkingPerDay", sWorking);


                reportViewer1.LocalReport.SetParameters(param);



                this.reportViewer1.ZoomPercent = 100;
                this.reportViewer1.ZoomMode    = Microsoft.Reporting.WinForms.ZoomMode.Percent;
                this.reportViewer1.RefreshReport();
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
示例#26
0
        private void DeletePaymentHistory()
        {
            try
            {
                string Error = string.Empty;
                if (grdLister.Rows.Count() > 0 && grdLister.Rows.Count(c => c.Cells["Check"].Value.ToBool() == true) == 0)
                {
                    Error = "Please select record to delete";
                }

                if (!string.IsNullOrEmpty(Error))
                {
                    ENUtils.ShowMessage(Error);
                    return;
                }

                int  Id      = 0;
                int  TransId = 0;
                long TranId  = 0;
                if (grdLister.Rows.Count(c => c.Cells["Check"].Value.ToBool() == true) > 0)
                {
                    if (DialogResult.Yes == RadMessageBox.Show("Are you sure you want to delete this Record ?", "", MessageBoxButtons.YesNo, RadMessageIcon.Question))
                    {
                        foreach (var item in grdLister.Rows.Where(c => c.Cells["Check"].Value.ToBool() == true))
                        {
                            //long TranId = row.Cells["TranId"].Value.ToLong();
                            Id      = item.Cells["Id"].Value.ToInt();
                            TransId = item.Cells["TransId"].Value.ToInt();
                            TranId  = item.Cells["TransId"].Value.ToLong();
                            if (TranId > 0)
                            {
                                try
                                {
                                    //int Id = row.Cells["Id"].Value.ToInt();
                                    //int TransId = row.Cells["TranId"].Value.ToInt();
                                    using (TaxiDataContext db = new TaxiDataContext())
                                    {
                                        if (db.GetTable <Fleet_DriverWeeklyRentHistory_Detail>().Count(c => c.TransId == TransId) == 1)
                                        {
                                            Fleet_DriverWeeklyRentHistory objHistory = db.GetTable <Fleet_DriverWeeklyRentHistory>().FirstOrDefault(c => (c.Id == TranId));
                                            if (objHistory != null)
                                            {
                                                db.Fleet_DriverWeeklyRentHistories.DeleteOnSubmit(objHistory);
                                                db.SubmitChanges();
                                            }
                                        }
                                        else
                                        {
                                            Fleet_DriverWeeklyRentHistory_Detail objDetail = db.Fleet_DriverWeeklyRentHistory_Details.FirstOrDefault(c => c.Id == Id);
                                            if (objDetail != null)
                                            {
                                                db.Fleet_DriverWeeklyRentHistory_Details.DeleteOnSubmit(objDetail);
                                                db.SubmitChanges();
                                            }
                                        }
                                    }
                                }
                                catch (Exception ex)
                                {
                                    ENUtils.ShowMessage(ex.Message);
                                }
                            }
                        }
                        PopulateData();
                    }
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
示例#27
0
 public RidesController(TaxiDataContext dbContext)
 {
     DbContext = dbContext;
 }
示例#28
0
        public override void PopulateData()
        {
            try
            {
                int    RangeId  = ddlDateRange.SelectedValue.ToInt();
                int    DriverId = ddlDriver.SelectedValue.ToInt();
                string Error    = string.Empty;
                if (RangeId == 0)
                {
                    Error = "Required: Date Range";
                }

                if (!string.IsNullOrEmpty(Error))
                {
                    ENUtils.ShowMessage(Error);
                    return;
                }
                int idx = 0;
                int val = 0;


                int driverTypeId = optRent.Checked ? Enums.DRIVERTYPES.RENT : Enums.DRIVERTYPES.COMMISSION;

                using (TaxiDataContext db = new TaxiDataContext())
                {
                    var list = (from a in db.stp_GetDriverWeeklyRentHistory(RangeId, DriverId)
                                select new
                    {
                        a.Id,
                        a.TransId,
                        a.Active,
                        a.AccountBookings,
                        a.RentComm,
                        //  a.DriverName,
                        a.DriverNo,
                        a.DriverToPay,
                        a.OfficeToPay,
                        a.PreviousBalance,
                        IsPaid = a.IsPaid,
                        Paid = a.IsPaid != null && a.IsPaid == true ? "Paid" : "",
                        a.FromDate,
                        ToDate = a.TillDate,
                        PaidValue = a.IsPaid != null && a.IsPaid == true ? 1 : 0
                    }).ToList();
                    //var list = (from a in db.stp_DriverPaymentAccountBookings(driverTypeId, 115.00m)
                    //            select new
                    //              {
                    //                  a.Id,
                    //                  a.TransId,
                    //                  a.Active,
                    //                  a.AccountBookings,
                    //                  a.TotalRentCommission,
                    //                  a.DriverName,
                    //                  a.DriverNo,
                    //                  a.DriverToPay,
                    //                  a.OfficeToPay,
                    //                  a.PreviousBalance,
                    //                  IsPaid = a.IsWeeklyPaid,
                    //                  Paid = a.IsWeeklyPaid != null && a.IsWeeklyPaid == true ? "Paid" : "",
                    //                  a.FromDate,
                    //                  a.ToDate,
                    //                  PaidValue=a.IsWeeklyPaid != null && a.IsWeeklyPaid == true ?1:0

                    //              }).ToList();
                    if (list.Count == 0)
                    {
                        grdLister.RowCount = 0;
                        return;
                    }
                    var list2 = (list.AsEnumerable().OrderBy(item => item.DriverNo, new NaturalSortComparer <string>())).ToList();

                    idx = grdLister.CurrentRow != null ? grdLister.CurrentRow.Cells["Id"].Value.ToInt() : -1;
                    val = grdLister.TableElement.VScrollBar.Value;

                    grdLister.BeginUpdate();
                    grdLister.RowCount = list2.Count;
                    for (int i = 0; i < list2.Count; i++)
                    {
                        grdLister.Rows[i].Cells["Id"].Value       = list2[i].Id;
                        grdLister.Rows[i].Cells["TransId"].Value  = list2[i].TransId;
                        grdLister.Rows[i].Cells["Active"].Value   = list2[i].Active;
                        grdLister.Rows[i].Cells["DriverNo"].Value = list2[i].DriverNo;

                        grdLister.Rows[i].Cells["AccountBookings"].Value     = list2[i].AccountBookings;
                        grdLister.Rows[i].Cells["PaidAccountBookings"].Value = list2[i].IsPaid.ToBool() ? list2[i].AccountBookings : 0.00m;


                        grdLister.Rows[i].Cells["TotalRentCommission"].Value     = list2[i].RentComm;
                        grdLister.Rows[i].Cells["PaidTotalRentCommission"].Value = list2[i].IsPaid.ToBool() ? list2[i].RentComm : 0.00m;

                        grdLister.Rows[i].Cells["OfficeToPay"].Value     = list2[i].OfficeToPay;
                        grdLister.Rows[i].Cells["PaidOfficeToPay"].Value = list2[i].IsPaid.ToBool() ? list2[i].OfficeToPay : 0.00m;


                        grdLister.Rows[i].Cells["DriverToPay"].Value     = list2[i].DriverToPay;
                        grdLister.Rows[i].Cells["PaidDriverToPay"].Value = list2[i].IsPaid.ToBool() ? list2[i].DriverToPay : 0.00m;

                        grdLister.Rows[i].Cells["PreviousBalance"].Value     = list2[i].PreviousBalance.ToDecimal();
                        grdLister.Rows[i].Cells["PaidPreviousBalance"].Value = list2[i].IsPaid.ToBool() && list2[i].PreviousBalance.ToDecimal() < 0 ? list2[i].PreviousBalance.ToDecimal() : 0.00m;


                        grdLister.Rows[i].Cells["IsPaid"].Value = list2[i].IsPaid.ToBool();

                        grdLister.Rows[i].Cells["Paid"].Value = list2[i].Paid.ToStr();

                        grdLister.Rows[i].Cells["FromDate"].Value  = list2[i].FromDate.ToDate();
                        grdLister.Rows[i].Cells["ToDate"].Value    = list2[i].ToDate.ToDate();
                        grdLister.Rows[i].Cells["PaidValue"].Value = list2[i].PaidValue.ToInt();
                        grdLister.Rows[i].Cells["Check"].Value     = false;
                    }


                    grdLister.EndUpdate();
                }



                SetDefaultColumnSettings();


                AddSummaries();
                UpdatePeriod();


                if (idx > 0)
                {
                    grdLister.CurrentRow = grdLister.Rows.FirstOrDefault(c => c.Cells["Id"].Value.ToInt() == idx);
                }


                if (grdLister.TableElement.VScrollBar.Maximum >= val)
                {
                    grdLister.TableElement.VScrollBar.Value = val;
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
示例#29
0
 public override void PopulateData()
 {
     try
     {
         string FromPostCode = null;
         string ToPostCode   = null;
         int    FromLocId    = 0;
         int    ToLocId      = 0;
         int    FromZoneId   = 0;
         int    ToZoneId     = 0;
         if (rbtnPostCode.IsChecked == true)
         {
             string PostCode = txtPostCode.Text.Trim();
             if (string.IsNullOrEmpty(PostCode))
             {
                 ENUtils.ShowMessage("Requierd : Post Code");
                 return;
             }
             if (rbtnPickup.IsChecked == true)
             {
                 FromPostCode = PostCode;
             }
             else if (rbtnDestination.IsChecked == true)
             {
                 ToPostCode = PostCode;
             }
             else
             {
                 FromPostCode = PostCode;
                 ToPostCode   = PostCode;
             }
         }
         else if (rbtnLocation.IsChecked == true)
         {
             int LocationId = ddlLocation.SelectedValue.ToInt();
             if (LocationId == 0)
             {
                 ENUtils.ShowMessage("Requierd : Loaction Code");
                 return;
             }
             if (rbtnPickup.IsChecked == true)
             {
                 FromLocId = LocationId;
             }
             else if (rbtnDestination.IsChecked == true)
             {
                 ToLocId = LocationId;
             }
             else
             {
                 ToLocId   = LocationId;
                 FromLocId = LocationId;
             }
         }
         else
         {
             int ZoneId = ddlArea.SelectedValue.ToInt();
             if (ZoneId == 0)
             {
                 ENUtils.ShowMessage("Requierd : Area Code");
                 return;
             }
             if (rbtnPickup.IsChecked == true)
             {
                 FromZoneId = ZoneId;
             }
             else if (rbtnDestination.IsChecked == true)
             {
                 ToZoneId = ZoneId;
             }
             else
             {
                 FromZoneId = ZoneId;
                 ToZoneId   = ZoneId;
             }
         }
         using (TaxiDataContext db = new TaxiDataContext())
         {
             var list = db.stp_JobStatistics(FromPostCode, ToPostCode, FromLocId, ToLocId, FromZoneId, ToZoneId, fromDate.Value.ToDate(), tillDate.Value.ToDate()).ToList();
             if (list.Count() > 0)
             {
                 grdJobsStatistics.Columns.Clear();
                 grdJobsStatistics.DataSource = list;
                 grdJobsStatistics.Columns["BookingNo"].Width           = 150;
                 grdJobsStatistics.Columns["PickupDateTime"].Width      = 145;
                 grdJobsStatistics.Columns["VehicleType"].Width         = 130;
                 grdJobsStatistics.Columns["FromAddress"].Width         = 280;
                 grdJobsStatistics.Columns["ToAddress"].Width           = 280;
                 grdJobsStatistics.Columns["DriverName"].Width          = 130;
                 grdJobsStatistics.Columns["StatusName"].Width          = 130;
                 grdJobsStatistics.Columns["BookingNo"].HeaderText      = "Booking No";
                 grdJobsStatistics.Columns["PickupDateTime"].HeaderText = "Pickup Date Time";
                 grdJobsStatistics.Columns["VehicleType"].HeaderText    = "Vehicle Type";
                 grdJobsStatistics.Columns["FromAddress"].HeaderText    = "From Address";
                 grdJobsStatistics.Columns["ToAddress"].HeaderText      = "To Address";
                 grdJobsStatistics.Columns["DriverName"].HeaderText     = "Driver Name";
                 grdJobsStatistics.Columns["StatusName"].HeaderText     = "Status";
             }
             else
             {
                 grdJobsStatistics.Columns.Clear();
                 grdJobsStatistics.Rows.Clear();
                 FormatGrid();
             }
             lblTotalJobs.Text = "Total Jobs : " + grdJobsStatistics.Rows.Count();
         }
     }
     catch (Exception ex)
     {
         ENUtils.ShowMessage(ex.Message);
     }
 }
示例#30
0
        void menu_showJobs_Click(object sender, EventArgs e)
        {
            try
            {
                RadMenuItem     item = (RadMenuItem)sender;
                GridViewRowInfo row  = grdLister.CurrentRow;

                using (TaxiDataContext db = new TaxiDataContext())
                {
                    db.DeferredLoadingEnabled = false;

                    if (row != null && row is GridViewDataRowInfo)
                    {
                        string   mobileNo = row.Cells["MobileNo"].Value.ToString();
                        string   name     = row.Cells["Name"].Value.ToString();
                        DateTime?fromDate = DateTime.Now.ToDate();
                        DateTime?tillDate = DateTime.Now.ToDate();

                        List <Booking> list = null;


                        if (rdAll.ToggleState == ToggleState.On)
                        {
                            fromDate = null;
                            tillDate = null;

                            // list = db.stp_AppUsers(fromDate, tillDate, 1).ToList(); // .Where(c => (c.CustomerMobileNo == mobileNo || c.CustomerPhoneNo == mobileNo) && c.CustomerName == name).ToList();
                            list = db.Bookings.Where(c => (c.CustomerMobileNo == mobileNo) && (c.CustomerName == name)).ToList();
                        }
                        else if (rdRegular.ToggleState == ToggleState.On)
                        {
                            fromDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month - 1, DateTime.Now.Day);
                            tillDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);

                            list = db.Bookings.Where(c => (c.CustomerMobileNo == mobileNo) && (c.CustomerName == name) &&
                                                     (c.BookingDate.Value >= fromDate && c.BookingDate.Value <= tillDate)
                                                     ).ToList();
                        }
                        else if (rdDateTime.ToggleState == ToggleState.On)
                        {
                            fromDate = dtpFromDate.Value.ToDateTimeorNull();
                            tillDate = dtpToDate.Value.ToDateTimeorNull();

                            if (fromDate != null && dtpFromTime.Value != null && dtpFromTime.Value.Value != null)
                            {
                                fromDate = (fromDate.Value.ToDate() + dtpFromTime.Value.Value.TimeOfDay).ToDateTime();
                            }

                            if (tillDate != null && dtptilltime.Value != null && dtptilltime.Value.Value != null)
                            {
                                tillDate = (tillDate.Value.ToDate() + dtptilltime.Value.Value.TimeOfDay).ToDateTime();
                            }


                            //list = General.GetQueryable<Booking>(c => (c.BookingDate.Value >= fromDate && c.BookingDate.Value <= tillDate)
                            //         && (c.CustomerMobileNo == mobileNo)).ToList();
                            //  list = db.Bookings.Where(c => c.CustomerMobileNo == mobileNo || c.CustomerPhoneNo == mobileNo).ToList();
                            list = db.Bookings.Where(c => (c.CustomerMobileNo == mobileNo) && (c.CustomerName == name)).ToList();
                        }

                        if (list.Count > 0)
                        {
                            frmDriverJobs frmDrvJobs = new frmDriverJobs(list, row.Cells["Name"].Value.ToStr(), "Customer");
                            frmDrvJobs.StartPosition = FormStartPosition.CenterScreen;
                            frmDrvJobs.ShowDialog();
                            frmDrvJobs.Dispose();
                        }
                        else
                        {
                            MessageBox.Show("No Booking(s) Found");
                        }
                    }
                }
            }
            catch
            {
            }
        }