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;
using (TaxiDataContext db = new TaxiDataContext())
{
//var list = (from a in db.stp_PaymentCollection()
// select new
// {
// Id = a.Id,
// Active = a.Active,
// DriverNo = a.DriverNo,
// DriverName = a.DriverName,
// Rent = a.Rent,
// Collection = a.PDA,
// AgentCommission = a.AgentCommission,
// OldAgentBalance = a.OldAgentBalance,
// PerviousBalance = a.BalanceDue,
// Adjustments=a.Adjustments,
// Total = a.Total,
// IsPaid = a.IsPaid,
// TranId=a.TransId,
// FromDate= a.FromDate,
// ToDate= a.ToDate,
// Paid=a.IsPaid!=null && a.IsPaid==true ? "Paid" : ""
// }).ToList();
//var list =(from a in db.stp_GetDriverCommissionCollectionHistory(RangeId, DriverId)
// select new
// {
// Id = a.Id,
// Active = a.Active,
// DriverNo = a.DriverNo,
// //DriverName = a.DriverName,
// Rent = a.RentComm,
// Collection = a.DriverCollection,
// AgentCommission = a.AgentCommission,
// OldAgentBalance = a.PreviousAgentCommission,
// PerviousBalance = a.PrevRentComm,
// Adjustments = a.Adjustment,
// Total = a.Total,
// IsPaid = a.IsPaid,
// TranId = a.TransId,
// FromDate = a.FromDate,
// ToDate = a.TillDate,
// Paid = a.IsPaid != null && a.IsPaid == true ? "Paid" : ""
// }).ToList();
var list = (db.stp_GetDriverCommissionCollectionHistory(RangeId, DriverId)).ToList();
if (list.Count == 0)
{
grdLister.RowCount = 0;
return;
}
var list2 = (from a in list.AsEnumerable().OrderBy(item => item.DriverNo, new NaturalSortComparer <string>())
select new
{
Id = a.Id,
Paid = a.IsPaid != null && a.IsPaid == true ? "Paid" : "",
IsPaid = a.IsPaid,
PreviousAgentCommission = a.PreviousAgentCommission,
PrevRentComm = a.PrevRentComm,
RentComm = a.RentComm,
TillDate = a.TillDate,
Total = a.Total,
TransId = a.TransId,
FromDate = a.FromDate,
DriverNo = a.DriverNo,
DriverCollection = a.DriverCollection,
PrevDriverCollection = a.PrevDriverCollection,
AgentCommission = a.AgentCommission,
Adjustment = a.Adjustment,
PrevAdjustment = a.PrevAdjustment,
Active = a.Active,
}).ToList();
idx = grdLister.CurrentRow != null ? grdLister.CurrentRow.Cells[COLS.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[COLS.Id].Value = list2[i].Id;
grdLister.Rows[i].Cells[COLS.Active].Value = list2[i].Active;
grdLister.Rows[i].Cells[COLS.DriverNo].Value = list2[i].DriverNo;
//grdLister.Rows[i].Cells[COLS.DriverName].Value = list2[i].DriverName;
grdLister.Rows[i].Cells[COLS.Rent].Value = list2[i].RentComm;
grdLister.Rows[i].Cells[COLS.PaidRent].Value = list2[i].IsPaid.ToBool() && list2[i].RentComm.ToDecimal() > 0 ? list2[i].RentComm.ToDecimal() : 0.00m;
grdLister.Rows[i].Cells[COLS.Collection].Value = list2[i].DriverCollection;
grdLister.Rows[i].Cells[COLS.PaidCollection].Value = list2[i].IsPaid.ToBool() ? list2[i].DriverCollection.ToDecimal() : 0.00m;
grdLister.Rows[i].Cells[COLS.OldCollection].Value = list2[i].PrevDriverCollection.ToDecimal();
grdLister.Rows[i].Cells[COLS.OldPaidCollection].Value = list2[i].IsPaid.ToBool() ? list2[i].PrevDriverCollection.ToDecimal() : 0.00m;
grdLister.Rows[i].Cells[COLS.AgentCommission].Value = list2[i].AgentCommission;
grdLister.Rows[i].Cells[COLS.PaidAgentCommission].Value = list2[i].IsPaid.ToBool() ? list2[i].AgentCommission.ToDecimal() : 0.00m;
grdLister.Rows[i].Cells[COLS.OldAgentBalance].Value = list2[i].PreviousAgentCommission.ToDecimal();
grdLister.Rows[i].Cells[COLS.PaidOldAgentBalance].Value = list2[i].IsPaid.ToBool() ? list2[i].PreviousAgentCommission.ToDecimal() : 0.00m;
grdLister.Rows[i].Cells[COLS.PreviousBalance].Value = list2[i].PrevRentComm;
grdLister.Rows[i].Cells[COLS.PaidPreviousBalance].Value = list2[i].IsPaid.ToBool() && list2[i].PrevRentComm.ToDecimal() > 0 ? list2[i].PrevRentComm.ToDecimal() : 0.00m;
grdLister.Rows[i].Cells[COLS.Adjustment].Value = list2[i].Adjustment.ToDecimal();
grdLister.Rows[i].Cells[COLS.PaidAdjustment].Value = list2[i].IsPaid.ToBool() ? list2[i].Adjustment.ToDecimal() : 0.00m;
grdLister.Rows[i].Cells[COLS.OldAdjustment].Value = list2[i].PrevAdjustment.ToDecimal();
grdLister.Rows[i].Cells[COLS.OldPaidAdjustment].Value = list2[i].IsPaid.ToBool() ? list2[i].PrevAdjustment.ToDecimal() : 0.00m;
grdLister.Rows[i].Cells[COLS.Total].Value = list2[i].Total;
grdLister.Rows[i].Cells[COLS.PaidTotal].Value = list2[i].IsPaid.ToBool() ? list2[i].Total.ToDecimal() : 0.00m;
grdLister.Rows[i].Cells[COLS.IsPaid].Value = list2[i].IsPaid;
grdLister.Rows[i].Cells[COLS.TranId].Value = list2[i].TransId;
grdLister.Rows[i].Cells[COLS.Paid].Value = list2[i].Paid;
grdLister.Rows[i].Cells[COLS.FromDate].Value = list2[i].FromDate;
grdLister.Rows[i].Cells[COLS.ToDate].Value = list2[i].TillDate;
grdLister.Rows[i].Cells["Check"].Value = false;
}
grdLister.EndUpdate();
}
grdLister.Columns["FromDate"].IsVisible = false;
grdLister.Columns["ToDate"].IsVisible = false;
grdLister.Columns["IsPaid"].IsVisible = false;
AddSummaries();
UpdatePeriod();
if (idx > 0)
{
grdLister.CurrentRow = grdLister.Rows.FirstOrDefault(c => c.Cells[COLS.Id].Value.ToInt() == idx);
}
if (grdLister.TableElement.VScrollBar.Maximum >= val)
{
grdLister.TableElement.VScrollBar.Value = val;
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}