public frmCommisionList4() { InitializeComponent(); grdLister.CellDoubleClick += new GridViewCellEventHandler(grdLister_CellDoubleClick); grdLister.RowsChanging += new Telerik.WinControls.UI.GridViewCollectionChangingEventHandler(Grid_RowsChanging); objMaster = new DriverCommisionBO(); this.SetProperties((INavigation)objMaster); grdLister.ShowRowHeaderColumn = false; this.Shown += new EventHandler(frmCompanyInvoiceList_Shown); grdLister.CommandCellClick += new CommandCellClickEventHandler(grid_CommandCellClick); }
public frmDriverCommisionList5() { InitializeComponent(); grdLister.CellDoubleClick += new GridViewCellEventHandler(grdLister_CellDoubleClick); grdLister.RowsChanging += new Telerik.WinControls.UI.GridViewCollectionChangingEventHandler(Grid_RowsChanging); objMaster = new DriverCommisionBO(); this.SetProperties((INavigation)objMaster); grdLister.ShowRowHeaderColumn = false; this.Shown += new EventHandler(frmCompanyInvoiceList_Shown); grdLister.CommandCellClick += new CommandCellClickEventHandler(grid_CommandCellClick); // for menus grdLister.ContextMenuOpening += new ContextMenuOpeningEventHandler(grdLister_ContextMenuOpening); AddCommisionItems = new RadDropDownMenu(); AddCommisionItems.BackColor = Color.Orange; RadMenuItem AddCommisionItems1 = new RadMenuItem("Add Driver Commision"); AddCommisionItems1.ForeColor = Color.DarkBlue; AddCommisionItems1.BackColor = Color.Orange; AddCommisionItems1.Font = new Font("Tahoma", 10, FontStyle.Bold); AddCommisionItems1.Click += new EventHandler(AddCommisionItems1_Click); AddCommisionItems.Items.Add(AddCommisionItems1); RadMenuItem AddCommisionItems3 = new RadMenuItem("Edit Last Statement"); AddCommisionItems3.ForeColor = Color.DarkBlue; AddCommisionItems3.BackColor = Color.Orange; AddCommisionItems3.Font = new Font("Tahoma", 10, FontStyle.Bold); AddCommisionItems3.Click += new EventHandler(AddCommisionItems3_Click); AddCommisionItems.Items.Add(AddCommisionItems3); RadMenuItem AddCommisionItems2 = new RadMenuItem("Driver Commision List"); AddCommisionItems2.ForeColor = Color.DarkBlue; AddCommisionItems2.BackColor = Color.Orange; AddCommisionItems2.Font = new Font("Tahoma", 10, FontStyle.Bold); AddCommisionItems2.Click += new EventHandler(AddCommisionItems2_Click); AddCommisionItems.Items.Add(AddCommisionItems2); //RadMenuItem AddCommisionItems3 = new RadMenuItem("Driver Commis"); }
void Grid_RowsChanging(object sender, GridViewCollectionChangingEventArgs e) { if (e.Action == Telerik.WinControls.Data.NotifyCollectionChangedAction.Remove) { objMaster = new DriverCommisionBO(); try { objMaster.GetByPrimaryKey(grdLister.CurrentRow.Cells["Id"].Value.ToInt()); string Transaction = grdLister.CurrentRow.Cells["TransNo"].Value.ToStr(); int DriverId = grdLister.CurrentRow.Cells["DriverID"].Value.ToInt(); var query = General.GetQueryable <Fleet_DriverCommision>(c => c.DriverId == DriverId).OrderByDescending(c => c.Id).FirstOrDefault(); if (query != null) { string Transno = query.TransNo.ToStr(); if (Transno == Transaction) { objMaster.Delete(objMaster.Current); } else { ENUtils.ShowMessage("You Can not delete a record.."); } } } catch (Exception ex) { if (objMaster.Errors.Count > 0) { ENUtils.ShowMessage(objMaster.ShowErrors()); } else { ENUtils.ShowMessage(ex.Message); } e.Cancel = true; } } }
private bool OnSave(int DriverId, decimal oldBalance, decimal DriverCommissionPerBooking, decimal pdaCommission, decimal InitialBalance, decimal CommissionPayValue, ref decimal accJobs, ref long transId, ref decimal rentDue, ref decimal currBalance) { bool IsSaved = false; try { bool RentForProcessedJobs = AppVars.objPolicyConfiguration.RentForProcessedJobs.ToBool(); var CommissionList = General.GetGeneralList <Fleet_DriverCommision_Charge>(c => c.BookingId != null && c.TransId != null); Expression <Func <Booking, bool> > _exp = null; if (AppVars.objPolicyConfiguration.PickBookingOnInvoicingType.ToInt() == 2) { _exp = c => ((c.PaymentTypeId != Enums.PAYMENT_TYPES.CASH && c.BookingStatusId == Enums.BOOKINGSTATUS.NOPICKUP) || c.BookingStatusId == Enums.BOOKINGSTATUS.DISPATCHED) && (c.FareRate != null) && ((RentForProcessedJobs == true && (c.IsProcessed != null && c.IsProcessed == true)) || (RentForProcessedJobs == false && (c.IsProcessed == null || c.IsProcessed == false))) && (c.DriverId == DriverId) && (c.PickupDateTime.Value.Date >= dtpFromDate.Value.Value.Date && c.PickupDateTime.Value.Date <= dtpTillDate.Value.Value.Date); } else { _exp = c => c.BookingStatusId == Enums.BOOKINGSTATUS.DISPATCHED && (c.FareRate != null) && ((RentForProcessedJobs == true && (c.IsProcessed != null && c.IsProcessed == true)) || (RentForProcessedJobs == false && (c.IsProcessed == null || c.IsProcessed == false))) && (c.DriverId == DriverId) && (c.PickupDateTime.Value.Date >= dtpFromDate.Value.Value.Date && c.PickupDateTime.Value.Date <= dtpTillDate.Value.Value.Date); } var list2 = (from a in General.GetGeneralList <Booking>(_exp) join b in CommissionList on a.Id equals b.BookingId into table2 from b in table2.DefaultIfEmpty() where (b == null) select new { Id = a.Id, TotalFare = a.FareRate.ToDecimal(), CompanyId = a.CompanyId, AccountTypeId = a.Gen_Company != null ? a.Gen_Company.AccountTypeId : a.PaymentTypeId, DriverCommissionAmount = a.DriverCommission, DriverCommissionType = a.DriverCommissionType, IsCommissionWise = a.IsCommissionWise, AgentCommission = a.AgentCommission }).ToList(); if (list2.Count > 0) { objMaster = new DriverCommisionBO(); objMaster.New(); List <Fleet_DriverCommision_Charge> ListDetail = (from a in list2 select new Fleet_DriverCommision_Charge { //Id = a.Id, TransId = objMaster.Current.Id, BookingId = a.Id, CommissionPerBooking = (a.TotalFare * DriverCommissionPerBooking) / 100 //CommissionPerBooking=a.DriverCommissionAmount }).ToList(); decimal Total = list2.Sum(c => c.TotalFare).ToDecimal(); decimal ACCJobsTotal = list2.Where(c => c.CompanyId != null).Sum(c => c.TotalFare).ToDecimal(); double totalWeeks = (dtpTillDate.Value.ToDate().Subtract(dtpFromDate.Value.ToDate()).TotalDays) / 7; if (totalWeeks <= 0) { totalWeeks = 1; } decimal TotalPDARent = (pdaCommission * totalWeeks.ToInt()); decimal AgentCommission = list2.Sum(c => c.AgentCommission).ToDecimal(); decimal DriverCommissionTotal = 0; DriverCommissionTotal = ((Total - AgentCommission) * DriverCommissionPerBooking / 100); decimal owed = ((AgentCommission + TotalPDARent + DriverCommissionTotal) - ACCJobsTotal); rentDue = owed; objMaster.Current.AccJobsTotal = ACCJobsTotal; objMaster.Current.DriverOwed = rentDue; objMaster.Current.CommissionTotal = DriverCommissionTotal; objMaster.Current.JobsTotal = Total; objMaster.Current.AgentFeesTotal = AgentCommission; objMaster.Current.CommisionPay = CommissionPayValue.ToDecimal(); objMaster.Current.Balance = (rentDue + oldBalance);//RentPay - DriverRent; objMaster.Current.DriverCommision = DriverCommissionPerBooking; // add pda rent objMaster.Current.PDARent = pdaCommission; objMaster.Current.AddBy = AppVars.LoginObj.LuserId.ToInt(); objMaster.Current.AddLog = AppVars.LoginObj.LoginName.ToStr(); objMaster.Current.AddOn = DateTime.Now; objMaster.Current.TransDate = DateTime.Now; //dtpTransactionDate.Value.ToDateTime(); objMaster.Current.DriverId = DriverId; //ddlDriver.SelectedValue.ToIntorNull(); objMaster.Current.OldBalance = oldBalance; // (CurrentBalance - RentPay); objMaster.Current.FromDate = dtpFromDate.Value.ToDate(); objMaster.Current.ToDate = dtpTillDate.Value.ToDate(); objMaster.Current.TransFor = "Weekly";//ddlDayWise.SelectedText.ToStr(); objMaster.Current.Fuel = 0; //Fuel.ToDecimal(); objMaster.Current.Extra = 0; // Extra.ToDecimal(); string[] skipProperties = { "Fleet_DriverCommision", "Booking" }; IList <Fleet_DriverCommision_Charge> savedList = objMaster.Current.Fleet_DriverCommision_Charges; var list = objMaster.Current.Fleet_DriverCommision_Charges.ToList(); Utils.General.SyncChildCollection(ref savedList, ref ListDetail, "Id", skipProperties); objMaster.Save(); currBalance = objMaster.Current.Balance.ToDecimal(); IsSaved = true; transId = objMaster.Current.Id; } } catch (Exception ex) { if (objMaster.Errors.Count > 0) { ENUtils.ShowMessage(objMaster.ShowErrors()); } else { ENUtils.ShowMessage(ex.Message); } } return(IsSaved); }
public void GetDrivers() { try { objMaster = new DriverCommisionBO(); //DateTime OneMonthBefore = DateTime.Now; //OneMonthBefore = OneMonthBefore.A(-1); GridViewCheckBoxColumn col = new GridViewCheckBoxColumn(); col.Width = 40; col.AutoSizeMode = BestFitColumnMode.None; col.HeaderText = ""; col.Name = "Check"; // col.ReadOnly = true; grdDriverCommission.Columns.Add(col); GridViewTextBoxColumn tbcol = new GridViewTextBoxColumn(); tbcol.Name = COLS.Id; tbcol.IsVisible = false; grdDriverCommission.Columns.Add(tbcol); tbcol = new GridViewTextBoxColumn(); tbcol.Name = COLS.CommissionId; tbcol.IsVisible = false; grdDriverCommission.Columns.Add(tbcol); tbcol = new GridViewTextBoxColumn(); tbcol.Name = COLS.DriverNo; tbcol.HeaderText = "Driver"; tbcol.Width = 160; tbcol.ReadOnly = true; grdDriverCommission.Columns.Add(tbcol); tbcol = new GridViewTextBoxColumn(); tbcol.Name = COLS.DriverEmail; tbcol.IsVisible = false; grdDriverCommission.Columns.Add(tbcol); //tbcol = new GridViewTextBoxColumn(); //tbcol.Name = COLS.TransNo; //tbcol.HeaderText = "Transaction No"; //tbcol.Width = 110; //tbcol.ReadOnly = true; //grdDriverRent.Columns.Add(tbcol); //tbcol = new GridViewTextBoxColumn(); GridViewDecimalColumn dcol = new GridViewDecimalColumn(); dcol.Name = COLS.DriverCommission; dcol.Width = 70; dcol.ReadOnly = true; dcol.DecimalPlaces = 2; dcol.HeaderText = "Comm:";//ission"; grdDriverCommission.Columns.Add(dcol); dcol = new GridViewDecimalColumn(); dcol.Name = COLS.DriverPDARent; dcol.Width = 70; dcol.ReadOnly = true; dcol.DecimalPlaces = 2; dcol.HeaderText = "PDA Rent";//ission"; grdDriverCommission.Columns.Add(dcol); dcol = new GridViewDecimalColumn(); dcol.Name = COLS.OldBalance; dcol.Width = 100; dcol.DecimalPlaces = 2; dcol.HeaderText = "Old Balance"; dcol.ReadOnly = true; grdDriverCommission.Columns.Add(dcol); //tbcol = new GridViewTextBoxColumn(); //GridViewDecimalColumn dcol = new GridViewDecimalColumn(); dcol.Name = COLS.InitialBalance; dcol.HeaderText = "Initial Balance"; dcol.DecimalPlaces = 2; dcol.IsVisible = false; grdDriverCommission.Columns.Add(dcol); dcol = new GridViewDecimalColumn(); dcol.Name = COLS.DriverCommissionPerBooking; // dcol.HeaderText = "Initial Balance"; dcol.DecimalPlaces = 2; dcol.IsVisible = false; grdDriverCommission.Columns.Add(dcol); dcol = new GridViewDecimalColumn(); dcol.Name = COLS.AccountsTotal; dcol.HeaderText = "A/C Total"; dcol.Width = 90; dcol.ReadOnly = true; dcol.DecimalPlaces = 2; grdDriverCommission.Columns.Add(dcol); dcol = new GridViewDecimalColumn(); dcol.Name = COLS.CashTotal; dcol.HeaderText = "Cash Total"; dcol.Width = 90; dcol.ReadOnly = true; dcol.DecimalPlaces = 2; grdDriverCommission.Columns.Add(dcol); dcol = new GridViewDecimalColumn(); dcol.Name = COLS.JobsTotal; dcol.HeaderText = "Jobs Total"; dcol.Width = 90; dcol.ReadOnly = true; dcol.DecimalPlaces = 2; grdDriverCommission.Columns.Add(dcol); dcol = new GridViewDecimalColumn(); dcol.Name = COLS.AgentFees; dcol.HeaderText = "Agent Fees"; dcol.Width = 90; dcol.ReadOnly = true; dcol.DecimalPlaces = 2; grdDriverCommission.Columns.Add(dcol); dcol = new GridViewDecimalColumn(); dcol.Name = COLS.CommissionPay; dcol.HeaderText = "Comm: Pay"; dcol.Width = 90; dcol.DecimalPlaces = 2; dcol.ReadOnly = false; grdDriverCommission.Columns.Add(dcol); dcol = new GridViewDecimalColumn(); dcol.Name = COLS.Owed; dcol.HeaderText = "Owed"; dcol.Width = 90; dcol.ReadOnly = true; dcol.DecimalPlaces = 2; grdDriverCommission.Columns.Add(dcol); dcol = new GridViewDecimalColumn(); dcol.Name = COLS.CurrBalance; dcol.HeaderText = "Current Balance"; dcol.Width = 110; dcol.DecimalPlaces = 2; dcol.ReadOnly = true; grdDriverCommission.Columns.Add(dcol); grdDriverCommission.ShowRowHeaderColumn = false; objCondition.CellForeColor = Color.Red; objCondition.TValue1 = "x"; objCondition.ConditionType = ConditionTypes.NotEqual; grdDriverCommission.Columns[COLS.CurrBalance].ConditionalFormattingObjectList.Add(objCondition); objConditionGeneratedTrans.RowBackColor = Color.LightGreen; objConditionGeneratedTrans.TValue1 = "0"; objConditionGeneratedTrans.ApplyToRow = true; objConditionGeneratedTrans.ConditionType = ConditionTypes.Greater; grdDriverCommission.Columns[COLS.CommissionId].ConditionalFormattingObjectList.Add(objConditionGeneratedTrans); RefreshCommissionView(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }