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);
}
}
