private void frmDictamenSustitucion_Load(object sender, EventArgs e)
{
try {
lblfecha.Text = DateTime.Now.ToLongDateString();
GroupDescriptor Entidades = new GroupDescriptor();
Entidades.GroupNames.Add("ENT_Nombre", ListSortDirection.Ascending);
this.gvDatos.GroupDescriptors.Add(Entidades);
GroupDescriptor Grupo = new GroupDescriptor();
Grupo.GroupNames.Add("ENT_Nombre", ListSortDirection.Ascending);
this.gvDictamen.GroupDescriptors.Add(Grupo);
ConditionalFormattingObject obj = new ConditionalFormattingObject("MyCondition", ConditionTypes.Greater, "30", "", true);
obj.CellForeColor = Color.White;
obj.CellBackColor = Color.RoyalBlue;
obj.ApplyOnSelectedRows = true;
this.gvDatos.Columns["Estado"].ConditionalFormattingObjectList.Add(obj);
LimpiarCampos();
CargarSolicitudes();
this.docSustitucion.Select();
} catch (Exception) {
throw;
}
}
private void MyTimer_Tick(object sender, EventArgs e)
{
this.ProductsRadGridView.TableElement.Text = string.Empty;
this.ProductsRadGridView.TableElement.BackgroundImage = null;
FillProductsRadGridView();
if (ProductsRadGridView.Rows.Count == 0)
{
this.ProductsRadGridView.TableElement.Text = "Producto(s) no encontrado(s)..";
}
this.MyTimer.Stop();
ConditionalFormattingObject objFormat =
new ConditionalFormattingObject("MyCondiction", ConditionTypes.Equal, "0", "", true);
objFormat.CellForeColor = Color.Red;
objFormat.RowBackColor = Color.SkyBlue;
this.ProductsRadGridView.Columns["Stock"]
.ConditionalFormattingObjectList
.Add(objFormat);
GridViewSummaryItem summaryItem = new GridViewSummaryItem("ProductCode", "Producto(s) Reg. {0}", GridAggregateFunction.Count);
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
summaryRowItem.Add(summaryItem);
ProductsRadGridView.SummaryRowsTop.Add(summaryRowItem);
}
private void SetConditions()
{
ConditionalFormattingObject c1 = new ConditionalFormattingObject("Light Sea Green, applied to entire row", ConditionTypes.Less, "0", "", true);
c1.RowBackColor = Color.LawnGreen;
radGridView1.Columns["K100"].ConditionalFormattingObjectList.Add(c1);
ConditionalFormattingObject c3 = new ConditionalFormattingObject("Light Sea Green, applied to entire row", ConditionTypes.Less, "0", "", true);
c3.RowBackColor = Color.LawnGreen;
radGridView1.Columns["K98"].ConditionalFormattingObjectList.Add(c3);
//Pecah
ConditionalFormattingObject c2 = new ConditionalFormattingObject("Light Sea Green, applied to cell only", ConditionTypes.Greater, "0", "", false);
c2.CellBackColor = Color.LightCoral;
radGridView1.Columns["PECAH"].ConditionalFormattingObjectList.Add(c2);
//Sumbing
ConditionalFormattingObject c4 = new ConditionalFormattingObject("Corn Flower Blue, applied to cell only", ConditionTypes.Greater, "0", "", false);
c4.CellBackColor = Color.CornflowerBlue;
radGridView1.Columns["SUMBING"].ConditionalFormattingObjectList.Add(c4);
//Total
ConditionalFormattingObject c5 = new ConditionalFormattingObject("Corn Flower Blue, applied to cell only", ConditionTypes.Greater, "0", "", false);
c5.CellBackColor = Color.LightBlue;
radGridView2.Columns["Total"].ConditionalFormattingObjectList.Add(c5);
}
public static void SetRadGridViewStyle(RadGridView gridView, int setType, int colIndex, double threshold, double curVal)
{
ConditionalFormattingObject obj = null;
if (setType == 1)//正常颜色
{
obj = new ConditionalFormattingObject("myCondition", ConditionTypes.None, "", "", true);
obj.TextAlignment = ContentAlignment.MiddleCenter;
}
else//错误提示
{
if (threshold > curVal)
{
obj = new ConditionalFormattingObject("myCondition", ConditionTypes.Less, $"{threshold}", "", true);
obj.CellBackColor = Color.Red;
obj.TextAlignment = ContentAlignment.MiddleCenter;
}
else
{
obj = new ConditionalFormattingObject("myCondition", ConditionTypes.None, "", "", true);
obj.TextAlignment = ContentAlignment.MiddleCenter;
}
}
gridView.Columns[colIndex].ConditionalFormattingObjectList.Add(obj);
}
private void SetConditions()
{
//Tukar
ConditionalFormattingObject c2 = new ConditionalFormattingObject("Light Sea Green, applied to entire row", ConditionTypes.Equal, "1", "", true);
c2.RowBackColor = Color.LightSeaGreen;
radGridView5.Columns["statusid"].ConditionalFormattingObjectList.Add(c2);
}
private void SetConditions()
{
//Keluar
ConditionalFormattingObject c2 = new ConditionalFormattingObject("Light Salmon, applied to entire row", ConditionTypes.Equal, "0", "", true);
c2.RowBackColor = Color.LightSalmon;
radGridView1.Columns["category"].ConditionalFormattingObjectList.Add(c2);
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
ConditionalFormattingObject c1 = new ConditionalFormattingObject("Green, applied to entire row", ConditionTypes.Equal, "", "", true);
c1.RowBackColor = Color.LightBlue;
c1.CellBackColor = Color.LightBlue;
radGridViewExtended.Columns["Column1"].ConditionalFormattingObjectList.Add(c1);
}
private void SetConditions()
{
//Kemarin
ConditionalFormattingObject c4 = new ConditionalFormattingObject("Light Blue, applied to entire row", ConditionTypes.Less, dtpTanggal.Value.ToString("dd MMM yy"), "", true);
c4.RowBackColor = Color.LightBlue;
radGridView1.Columns["created"].ConditionalFormattingObjectList.Clear();
radGridView1.Columns["created"].ConditionalFormattingObjectList.Add(c4);
}
public static void SetRadGridViewStyle(RadGridView gridView, int columnCount, GridViewRecordEnum viewRecordEnum)
{
ConditionalFormattingObject obj = null;
if (viewRecordEnum == GridViewRecordEnum.Normal)
{
obj = new ConditionalFormattingObject("myCondition", ConditionTypes.Equal, "", "", true);
obj.TextAlignment = ContentAlignment.MiddleCenter;
}
else if (viewRecordEnum == GridViewRecordEnum.Qualification)
{
obj = new ConditionalFormattingObject("myCondition", ConditionTypes.Equal, "合格", "", true);
obj.CellBackColor = Color.LawnGreen;
obj.TextAlignment = ContentAlignment.MiddleCenter;
}
else if (viewRecordEnum == GridViewRecordEnum.Disqualification)
{
obj = new ConditionalFormattingObject("myCondition", ConditionTypes.Equal, "不合格", "", true);
obj.CellBackColor = Color.Red;
obj.TextAlignment = ContentAlignment.MiddleCenter;
}
else if (viewRecordEnum == GridViewRecordEnum.Conduction)
{
obj = new ConditionalFormattingObject("myCondition", ConditionTypes.Equal, "导通", "", true);
obj.CellBackColor = Color.LawnGreen;
obj.TextAlignment = ContentAlignment.MiddleCenter;
}
else if (viewRecordEnum == GridViewRecordEnum.UnConduction)
{
obj = new ConditionalFormattingObject("myCondition", ConditionTypes.Equal, "不导通", "", true);
obj.CellBackColor = Color.Red;
obj.TextAlignment = ContentAlignment.MiddleCenter;
}
else if (viewRecordEnum == GridViewRecordEnum.OpenCircuit)
{
obj = new ConditionalFormattingObject("myCondition", ConditionTypes.Equal, "开路", "", true);
obj.CellBackColor = Color.OrangeRed;
obj.TextAlignment = ContentAlignment.MiddleCenter;
}
else if (viewRecordEnum == GridViewRecordEnum.CurrentRow)
{
obj = new ConditionalFormattingObject("myCondition", ConditionTypes.NotEqual, "", "", true);
obj.CellBackColor = Color.Red;
obj.TextAlignment = ContentAlignment.MiddleCenter;
for (int i = 0; i < gridView.ColumnCount; i++)
{
gridView.Columns[i].ConditionalFormattingObjectList.Add(obj);
}
}
gridView.Columns[columnCount].ConditionalFormattingObjectList.Add(obj);
}
private void SetConditions()
{
//add a couple of sample formatting objects
ConditionalFormattingObject c1 = new ConditionalFormattingObject("Red", ConditionTypes.Equal, "London", "", true);
c1.RowBackColor = Color.FromArgb(255, 153, 0);
c1.RowForeColor = Color.Black;
radGridView1.Columns["City"].ConditionalFormattingObjectList.Add(c1);
ConditionalFormattingObject c2 = new ConditionalFormattingObject("Green", ConditionTypes.Equal, "Berlin", "", true);
c2.RowBackColor = Color.FromArgb(165, 244, 36);
c2.RowForeColor = Color.Black;
radGridView1.Columns["City"].ConditionalFormattingObjectList.Add(c2);
}
private void frmNuevoPuesto_Load(object sender, EventArgs e)
{
try {
LimpiarCampos();
CargarDeptos();
CargarEntidades();
CargarNuevosPuestos();
ConditionalFormattingObject obj = new ConditionalFormattingObject("MyCondition", ConditionTypes.Greater, "30", "", true);
obj.CellForeColor = Color.White;
obj.CellBackColor = Color.RoyalBlue;
obj.ApplyOnSelectedRows = true;
this.gvDatos.Columns["Estado"].ConditionalFormattingObjectList.Add(obj);
} catch (Exception) {
throw;
}
}
private void frmDictamenNuevoP_Load(object sender, EventArgs e)
{
try {
CargarNuevosPuestos();
lblfecha.Text = DateTime.Now.ToLongDateString();
ConditionalFormattingObject obj = new ConditionalFormattingObject("MyCondition", ConditionTypes.Greater, "30", "", true);
obj.CellForeColor = Color.White;
obj.CellBackColor = Color.RoyalBlue;
obj.ApplyOnSelectedRows = true;
this.gvDatos.Columns["Estado"].ConditionalFormattingObjectList.Add(obj);
this.DockNuevoP.Select();
} catch (Exception) {
throw;
}
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
if (this.DesignMode)
{
return;
}
fieldInfo.FillData();
RefreshData();
ConditionalFormattingObject c1 = new ConditionalFormattingObject("Green, applied to entire row", ConditionTypes.Equal, "14", "", true);
c1.RowBackColor = Color.FromArgb(219, 251, 91);
c1.CellBackColor = Color.FromArgb(219, 251, 91);
radGridView.Columns["FieldTypeCode"].ConditionalFormattingObjectList.Add(c1);
}
public static void SetGridViewRowStyle(RadGridView gridView, int colIndex, string content)
{
foreach (var rowInfo in gridView.Rows)
{
if (rowInfo.Cells[colIndex].Value.ToString() == content)
{
ConditionalFormattingObject obj = new ConditionalFormattingObject("myCondition", ConditionTypes.Equal, content, "", true);
obj.CellBackColor = Color.LawnGreen;
obj.TextAlignment = ContentAlignment.MiddleCenter;
for (int i = 0; i < gridView.ColumnCount; i++)
{
gridView.Columns[i].ConditionalFormattingObjectList.Add(obj);//多线程中使用时，要释放已添加的对象，否则会导致内存增加问题
}
}
}
}
private void SetConditions()
{
//Mesin
ConditionalFormattingObject c2 = new ConditionalFormattingObject("Light Sea Green, applied to entire row", ConditionTypes.Equal, "6", "", true);
c2.RowBackColor = Color.LightSeaGreen;
radGridView1.Columns["status"].ConditionalFormattingObjectList.Add(c2);
//Borongan
ConditionalFormattingObject c3 = new ConditionalFormattingObject("Light Yellow, applied to entire row", ConditionTypes.Equal, "7", "", true);
c3.RowBackColor = Color.LightSteelBlue;
radGridView1.Columns["status"].ConditionalFormattingObjectList.Add(c3);
//Meja
ConditionalFormattingObject c4 = new ConditionalFormattingObject("Corn Flower Blue, applied to entire row", ConditionTypes.Equal, "8", "", true);
c4.RowBackColor = Color.CornflowerBlue;
radGridView1.Columns["status"].ConditionalFormattingObjectList.Add(c4);
}
private void SetConditions()
{
//add a couple of sample formatting objects
ConditionalFormattingObject c1 = new ConditionalFormattingObject("Orange, applied to entire row", ConditionTypes.Equal, "Germany", "", true);
c1.RowBackColor = Color.FromArgb(255, 209, 140);
c1.CellBackColor = Color.FromArgb(255, 209, 140);
//c1.RowForeColor = Color.Black;
radGridView1.Columns["Country"].ConditionalFormattingObjectList.Add(c1);
ConditionalFormattingObject c2 = new ConditionalFormattingObject("Green, applied to cells only", ConditionTypes.Equal, "France", "", false);
c2.RowBackColor = Color.FromArgb(219, 251, 91);
//c2.RowForeColor = Color.Black;
c2.CellBackColor = Color.FromArgb(219, 251, 91);
radGridView1.Columns["Country"].ConditionalFormattingObjectList.Add(c2);
//update the grid view for the conditional formatting to take effect
//radGridView1.TableElement.Update(false);
}
private void SetConditions()
{
ConditionalFormattingObject c3 = new ConditionalFormattingObject("Grey, applied to cell", ConditionTypes.NotEqual, "Germany", "", false);
c3.RowBackColor = Color.FromArgb(169, 183, 201);
c3.CellBackColor = Color.FromArgb(169, 183, 201);
this.radGridView.Columns["Country"].ConditionalFormattingObjectList.Add(c3);
ConditionalFormattingObject c1 = new ConditionalFormattingObject("Blue , applied to cell", ConditionTypes.Equal, "Germany", "", false);
c1.RowBackColor = Color.FromArgb(163, 191, 226);
c1.CellBackColor = Color.FromArgb(163, 191, 226);
this.radGridView.Columns["Country"].ConditionalFormattingObjectList.Add(c1);
ConditionalFormattingObject c2 = new ConditionalFormattingObject("LightPurple, applied to cell", ConditionTypes.Equal, "France", "", false);
c2.RowBackColor = Color.FromArgb(212, 210, 241);
c2.CellBackColor = Color.FromArgb(212, 210, 241);
this.radGridView.Columns["Country"].ConditionalFormattingObjectList.Add(c2);
}
private void frmSolicitud_Load(object sender, EventArgs e)
{
try {
GroupDescriptor Entidades = new GroupDescriptor();
Entidades.GroupNames.Add("ENT_Nombre", ListSortDirection.Ascending);
this.gvDatos.GroupDescriptors.Add(Entidades);
ConditionalFormattingObject obj = new ConditionalFormattingObject("MyCondition", ConditionTypes.Greater, "30", "", true);
obj.CellForeColor = Color.White;
obj.CellBackColor = Color.RoyalBlue;
obj.ApplyOnSelectedRows = true;
this.gvDatos.Columns["Estado"].ConditionalFormattingObjectList.Add(obj);
LimpiarCampos();
CargarEntidades();
CargarTiposContrato();
CargarSolicitudes();
} catch (Exception ex) {
RadMessageBox.Show("Ocurrio un error al cargar la pantalla\n" + ex.Message, this.Text, MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
private void SetConditions()
{
//Pecah
ConditionalFormattingObject c2 = new ConditionalFormattingObject("Light Sea Green, applied to entire row", ConditionTypes.Equal, "2", "", true);
c2.RowBackColor = Color.LightSeaGreen;
radGridView1.Columns["status"].ConditionalFormattingObjectList.Add(c2);
//Rusak
ConditionalFormattingObject c3 = new ConditionalFormattingObject("Light Yellow, applied to entire row", ConditionTypes.Equal, "3", "", true);
c3.RowBackColor = Color.LightSteelBlue;
radGridView1.Columns["status"].ConditionalFormattingObjectList.Add(c3);
//Sumbing
ConditionalFormattingObject c4 = new ConditionalFormattingObject("Corn Flower Blue, applied to entire row", ConditionTypes.Equal, "4", "", true);
c4.RowBackColor = Color.CornflowerBlue;
radGridView1.Columns["status"].ConditionalFormattingObjectList.Add(c4);
//Expire
ConditionalFormattingObject c5 = new ConditionalFormattingObject("Purple, applied to entire row", ConditionTypes.Equal, "5", "", true);
c5.RowBackColor = Color.MediumPurple;
radGridView1.Columns["status"].ConditionalFormattingObjectList.Add(c5);
}
private void SetConditions()
{
//Pecah
ConditionalFormattingObject c1 = new ConditionalFormattingObject("Yellow, applied to entire row", ConditionTypes.Equal, "2", "", true);
c1.RowBackColor = Color.Yellow;
c1.CellBackColor = Color.Yellow;
//c1.RowForeColor = Color.Black;
radGridView1.Columns["status"].ConditionalFormattingObjectList.Add(c1);
//Rusak
ConditionalFormattingObject c2 = new ConditionalFormattingObject("Green, applied to entire row", ConditionTypes.Equal, "3", "", true);
c2.RowBackColor = Color.Red;
//c2.RowForeColor = Color.Black;
c2.CellBackColor = Color.Red;
radGridView1.Columns["status"].ConditionalFormattingObjectList.Add(c2);
ConditionalFormattingObject c3 = new ConditionalFormattingObject("Orange, applied to entire row", ConditionTypes.Equal, "5", "", true);
c3.RowBackColor = Color.Orange;
//c2.RowForeColor = Color.Black;
c3.CellBackColor = Color.Orange;
radGridView1.Columns["status"].ConditionalFormattingObjectList.Add(c3);
//update the grid view for the conditional formatting to take effect
}
public static void SetRadGridViewProperty(RadGridView gridView, bool allowAddNewRow, bool IsReadOnly, int columnCount)
{
gridView.EnableGrouping = false;
gridView.AllowDrop = true;
gridView.AllowRowReorder = true;
//显示新行
gridView.AddNewRowPosition = SystemRowPosition.Bottom;
gridView.ShowRowHeaderColumn = true;
gridView.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
//radGridView.AutoSizeRows = true;
//gridView.MasterTemplate.BestFitColumns();
//gridView.ColumnChooserSortOrder = RadSortOrder.Ascending;
//dgv.AllowRowHeaderContextMenu = false;
gridView.ShowGroupPanel = false;
gridView.MasterTemplate.EnableGrouping = false;
gridView.MasterTemplate.AllowAddNewRow = allowAddNewRow;
gridView.EnableHotTracking = true;
gridView.MasterTemplate.SelectLastAddedRow = false;
gridView.ReadOnly = IsReadOnly;
//radRadioDataReader.ToggleState = Telerik.WinControls.Enumerations.ToggleState.On;
//this.radGridView1.CurrentRow = this.radGridView1.Rows[0];//设置某行为当前行
//radGridView.Rows[0].Cells[0].Style.ForeColor;
//gridView.AutoScroll = true;
ConditionalFormattingObject obj = new ConditionalFormattingObject("myCondition", ConditionTypes.NotEqual, "", "", true);
//obj.CellBackColor = Color.DeepSkyBlue;
//obj.CellForeColor = Color.Red;
obj.TextAlignment = ContentAlignment.MiddleCenter;
if (columnCount > 0)
{
for (int i = 0; i < columnCount; i++)
{
gridView.Columns[i].ConditionalFormattingObjectList.Add(obj);
}
}
}
private void FormatGrid()
{
GridViewCheckBoxColumn cb = new GridViewCheckBoxColumn();
cb.Name = "Check";
cb.Width = 80;
cb.ReadOnly = false;
grdLister.Columns.Add(cb);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.Id;
col.IsVisible = false;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.TranId;
col.IsVisible = false;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.Active;
col.HeaderText = "Active/Off";
col.Width = 110;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.DriverNo;
col.HeaderText = "Driver";
col.Width = 100;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.DriverName;
col.IsVisible = false;
grdLister.Columns.Add(col);
// Rent/Comm Column
GridViewDecimalColumn dcol = new GridViewDecimalColumn();
dcol.Name = COLS.Rent;
dcol.HeaderText = "Rent/Comm";
dcol.Width = 100;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
grdLister.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.PaidRent;
dcol.HeaderText = "Paid Rent/Comm";
dcol.Width = 100;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
dcol.IsVisible = false;
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
grdLister.Columns.Add(dcol);
// Prev Rent/Comm Column
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.PreviousBalance;
dcol.HeaderText = "Prev Rent/Comm";
dcol.Width = 160;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
grdLister.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.PaidPreviousBalance;
dcol.HeaderText = "Paid Prev Rent/Comm";
dcol.Width = 160;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
dcol.IsVisible = false;
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
grdLister.Columns.Add(dcol);
// Collection Column
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.Collection;
dcol.HeaderText = COLS.Collection;
dcol.Width = 100;
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
grdLister.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.PaidCollection;
dcol.HeaderText = COLS.PaidCollection;
dcol.Width = 120;
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
dcol.IsVisible = false;
grdLister.Columns.Add(dcol);
// Old Collection Column
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.OldCollection;
dcol.HeaderText = "Prev Collection";
dcol.Width = 120;
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
grdLister.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.OldPaidCollection;
dcol.HeaderText = COLS.OldPaidCollection;
dcol.Width = 120;
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
dcol.IsVisible = false;
grdLister.Columns.Add(dcol);
// Agent Commission Column
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.AgentCommission;
dcol.HeaderText = "Agent Comm";
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
dcol.Width = 110;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
grdLister.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.PaidAgentCommission;
dcol.HeaderText = "Paid Agent Comm";
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
dcol.Width = 140;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
dcol.IsVisible = false;
grdLister.Columns.Add(dcol);
// Previous Agent Commission Column
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.OldAgentBalance;
dcol.HeaderText = "Prev Agent Comm";
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
dcol.Width = 150;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
grdLister.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.PaidOldAgentBalance;
dcol.HeaderText = "Paid Prev Agent Comm";
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
dcol.Width = 170;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
dcol.IsVisible = false;
grdLister.Columns.Add(dcol);
// Adjustments Column
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.Adjustment;
dcol.HeaderText = "Adjustment";
dcol.Width = 100;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = false;
grdLister.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.PaidAdjustment;
dcol.HeaderText = "Paid Adjustment";
dcol.Width = 100;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = false;
dcol.IsVisible = false;
grdLister.Columns.Add(dcol);
// old adjustments column
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.OldAdjustment;
dcol.HeaderText = "Prev Adj.";
dcol.Width = 70;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = false;
grdLister.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.OldPaidAdjustment;
dcol.HeaderText = "Prev Paid Adjustment";
dcol.Width = 100;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = false;
dcol.IsVisible = false;
grdLister.Columns.Add(dcol);
// Total COlumn
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.Total;
dcol.HeaderText = "Total";
dcol.Width = 100;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
grdLister.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.PaidTotal;
dcol.HeaderText = "Paid Total";
dcol.Width = 100;
dcol.DecimalPlaces = 2;
dcol.ReadOnly = true;
dcol.IsVisible = false;
dcol.ExcelExportType = DisplayFormatType.Text;
dcol.ExcelExportFormatString = "{0:d}";
grdLister.Columns.Add(dcol);
GridViewCheckBoxColumn cbcol = new GridViewCheckBoxColumn();
cbcol.Name = COLS.IsPaid;
cbcol.HeaderText = "Paid";
cbcol.Width = 100;
grdLister.Columns.Add(cbcol);
col = new GridViewTextBoxColumn();
col.Name = COLS.Paid;
col.HeaderText = COLS.Paid;
col.Width = 100;
col.ReadOnly = true;
grdLister.Columns.Add(col);
GridViewDateTimeColumn dtCol = new GridViewDateTimeColumn();
dtCol.Name = COLS.FromDate;
dtCol.HeaderText = COLS.FromDate;
dtCol.Width = 120;
dtCol.ReadOnly = true;
dtCol.IsVisible = false;
grdLister.Columns.Add(dtCol);
dtCol = new GridViewDateTimeColumn();
dtCol.Name = COLS.ToDate;
dtCol.HeaderText = COLS.ToDate;
dtCol.Width = 120;
dtCol.ReadOnly = true;
dtCol.IsVisible = false;
grdLister.Columns.Add(dtCol);
GridViewCommandColumn cmdcol = new GridViewCommandColumn();
cmdcol.Width = 80;
cmdcol.Name = "btnDelete";
cmdcol.UseDefaultText = true;
cmdcol.ImageLayout = System.Windows.Forms.ImageLayout.Center;
cmdcol.DefaultText = "Delete";
cmdcol.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
grdLister.Columns.Add(cmdcol);
ConditionalFormattingObject obj = new ConditionalFormattingObject();
obj.RowBackColor = Color.LightGreen;
obj.TValue1 = "Paid";
obj.ConditionType = ConditionTypes.Equal;
obj.TValue2 = string.Empty;
obj.RowForeColor = Color.Black;
obj.ApplyToRow = true;
grdLister.Columns[COLS.Paid].ConditionalFormattingObjectList.Add(obj);
ConditionalFormattingObject obj2 = new ConditionalFormattingObject();
obj2.TValue1 = "(C)";
obj2.ConditionType = ConditionTypes.EndsWith;
obj2.TValue2 = string.Empty;
obj2.CellForeColor = Color.White;
obj2.CellBackColor = Color.Red;
obj2.ApplyToRow = false;
grdLister.Columns[COLS.DriverNo].ConditionalFormattingObjectList.Add(obj2);
}
private void FormatGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = "BookingReference";
col.HeaderText = " Ref #";
col.FieldName = "Booking Reference";
col.WrapText = true;
col.Width = 70;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.ID;
col.IsVisible = false;
grdBookings.Columns.Add(col);
GridViewDateTimeColumn colDate = new GridViewDateTimeColumn();
colDate.Name = "PickupDateTime";
colDate.WrapText = true;
colDate.HeaderText = "Pickup Date-Time";
colDate.Width = 140;
colDate.FieldName = "Pickup Time";
colDate.CustomFormat = "dd/MM/yyyy HH:mm";
colDate.FormatString = "{0:dd/MM/yyyy HH:mm}";
grdBookings.Columns.Add(colDate);
GridViewComboBoxColumn colCombo = new GridViewComboBoxColumn();
colCombo.Name = "VehicleType";
colCombo.HeaderText = "Vehicle";
colCombo.FieldName = "Vehicle Class";
colCombo.DataSource = General.GetQueryable <Fleet_VehicleType>(null).OrderBy(c => c.OrderNo).ToList();
colCombo.DisplayMember = "VehicleType";
colCombo.ValueMember = "Id";
colCombo.Width = 80;
col.WrapText = true;
grdBookings.Columns.Add(colCombo);
col = new GridViewTextBoxColumn();
col.Name = "PhoneNo";
col.HeaderText = "Phone No";
col.Width = 120;
col.WrapText = true;
col.FieldName = "Phone";
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Passenger";
col.HeaderText = "Passenger";
col.FieldName = "Passenger Name";
col.WrapText = true;
col.Width = 100;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "From";
col.HeaderText = "Pickup Point";
col.FieldName = "0";
col.WrapText = true;
col.Width = 130;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "To";
col.WrapText = true;
col.HeaderText = "Destination";
col.Width = 130;
col.FieldName = "1";
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Notes";
col.WrapText = true;
col.FieldName = "Driver Notes";
col.HeaderText = "Notes";
col.Width = 120;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Account";
col.HeaderText = "Account";
col.FieldName = "Booking Account";
col.WrapText = true;
col.Width = 120;
grdBookings.Columns.Add(col);
//GridViewDecimalColumn colDec = new GridViewDecimalColumn();
//colDec.Name = "Fare";
//colDec.FieldName = "Pricing";
//colDec.DecimalPlaces = 2;
//colDec.Minimum = 0;
//colDec.Maximum = 999999;
//colDec.HeaderText = "Fare";
//colDec.Width = 60;
//grdBookings.Columns.Add(colDec);
//col = new GridViewTextBoxColumn();
//col.Name = "PaymentType";
//col.WrapText = true;
//col.FieldName = "Card";
//col.HeaderText = "Payment";
//col.Width = 100;
//grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Via";
col.WrapText = true;
col.FieldName = "Via";
col.HeaderText = "Via Point";
col.Width = 100;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "FlightNo";
col.WrapText = true;
col.FieldName = "FlightNo";
col.HeaderText = "Flight No";
col.Width = 100;
grdBookings.Columns.Add(col);
ConditionalFormattingObject objSave = new ConditionalFormattingObject();
objSave.ApplyToRow = true;
objSave.RowBackColor = Color.LightGreen;
objSave.ConditionType = ConditionTypes.Greater;
objSave.TValue1 = "0";
grdBookings.Columns[COLS.ID].ConditionalFormattingObjectList.Add(objSave);
ConditionalFormattingObject objError = new ConditionalFormattingObject();
objError.ApplyToRow = true;
objError.RowBackColor = Color.Pink;
objError.ConditionType = ConditionTypes.Equal;
objError.TValue1 = "0";
grdBookings.Columns[COLS.ID].ConditionalFormattingObjectList.Add(objError);
grdBookings.AddDeleteColumn();
grdBookings.Columns["btnDelete"].PinPosition = PinnedColumnPosition.Right;
grdBookings.Columns["btnDelete"].IsPinned = true;
grdBookings.Columns["btnDelete"].Width = 70;
grdBookings.CommandCellClick += new CommandCellClickEventHandler(grdBookings_CommandCellClick);
}
private void FormatCell()
{
// Order No
ConditionalFormattingObject objOrderNo = new ConditionalFormattingObject("OrderNoCondition", ConditionTypes.NotEqual, "", "", false);
objOrderNo.CellForeColor = Color.Blue;
this.radGridView.Columns[0].ConditionalFormattingObjectList.Add(objOrderNo);
// Order Status
ConditionalFormattingObject objOrderStatus1 = new ConditionalFormattingObject("objOrderStatus1", ConditionTypes.Equal,
Constants.OrderStatusDraft, string.Empty, false);
objOrderStatus1.CellBackColor = Color.Red;
objOrderStatus1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderStatus2 = new ConditionalFormattingObject("objOrderStatus2", ConditionTypes.Equal,
Constants.OrderStatusDelivered, string.Empty, false);
objOrderStatus2.CellBackColor = Color.Green;
objOrderStatus2.CellForeColor = Color.White;
this.radGridView.Columns[3].ConditionalFormattingObjectList.Add(objOrderStatus1);
this.radGridView.Columns[3].ConditionalFormattingObjectList.Add(objOrderStatus2);
// Order SMS
ConditionalFormattingObject objOrderSms1 = new ConditionalFormattingObject("objOrderSms1", ConditionTypes.Equal,
Constants.OrderSms1, string.Empty, false);
objOrderSms1.CellBackColor = Color.Orange;
objOrderSms1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderSms2 = new ConditionalFormattingObject("objOrderSms2", ConditionTypes.Equal,
Constants.OrderSms2, string.Empty, false);
objOrderSms2.CellBackColor = Color.Green;
objOrderSms2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderSms3 = new ConditionalFormattingObject("objOrderSms3", ConditionTypes.Equal,
Constants.OrderSms3, string.Empty, false);
objOrderSms3.CellBackColor = Color.Red;
objOrderSms3.CellForeColor = Color.White;
this.radGridView.Columns[6].ConditionalFormattingObjectList.Add(objOrderSms1);
this.radGridView.Columns[6].ConditionalFormattingObjectList.Add(objOrderSms2);
this.radGridView.Columns[6].ConditionalFormattingObjectList.Add(objOrderSms3);
// Order Email
ConditionalFormattingObject objOrderEmail1 = new ConditionalFormattingObject("objOrderEmail1", ConditionTypes.Equal,
Constants.OrderEmail1, string.Empty, false);
objOrderEmail1.CellBackColor = Color.Orange;
objOrderEmail1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderEmail2 = new ConditionalFormattingObject("objOrderEmail2", ConditionTypes.Equal,
Constants.OrderEmail2, string.Empty, false);
objOrderEmail2.CellBackColor = Color.Green;
objOrderEmail2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderEmail3 = new ConditionalFormattingObject("objOrderEmail3", ConditionTypes.Equal,
Constants.OrderEmail3, string.Empty, false);
objOrderEmail3.CellBackColor = Color.Red;
objOrderEmail3.CellForeColor = Color.White;
this.radGridView.Columns[5].ConditionalFormattingObjectList.Add(objOrderEmail1);
this.radGridView.Columns[5].ConditionalFormattingObjectList.Add(objOrderEmail2);
this.radGridView.Columns[5].ConditionalFormattingObjectList.Add(objOrderEmail3);
// Order Report
ConditionalFormattingObject objOrderReport1 = new ConditionalFormattingObject("objOrderReport1", ConditionTypes.Equal,
Constants.OrderReport1, string.Empty, false);
objOrderReport1.CellBackColor = Color.Orange;
objOrderReport1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderReport2 = new ConditionalFormattingObject("objOrderReport2", ConditionTypes.Equal,
Constants.OrderReport2, string.Empty, false);
objOrderReport2.CellBackColor = Color.Green;
objOrderReport2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderReport3 = new ConditionalFormattingObject("objOrderReport3", ConditionTypes.Equal,
Constants.OrderReport3, string.Empty, false);
objOrderReport3.CellBackColor = Color.Red;
objOrderReport3.CellForeColor = Color.White;
this.radGridView.Columns[7].ConditionalFormattingObjectList.Add(objOrderReport1);
this.radGridView.Columns[7].ConditionalFormattingObjectList.Add(objOrderReport2);
this.radGridView.Columns[7].ConditionalFormattingObjectList.Add(objOrderReport3);
}
private void PopulateData(long groupId, long selectedJobId)
{
try
{
var objGroup = General.GetObject <BookingGroup>(c => c.Id == groupId);
if (objGroup != null)
{
if (grdGroupDetails.Rows.Count == 0)
{
grdGroupDetails.Rows.AddNew();
}
grdGroupDetails.Rows[0].Cells["Id"].Value = objGroup.Id;
grdGroupDetails.Rows[0].Cells["GroupName"].Value = objGroup.GroupName;
grdGroupDetails.Rows[0].Cells["FlightDeparture"].Value = objGroup.FlightDepartureDate;
grdGroupDetails.Rows[0].Cells["Destination"].Value = objGroup.Gen_Location.DefaultIfEmpty().LocationName;
grdGroupDetails.Rows[0].Cells["DestinationId"].Value = objGroup.DestinationId;
grdGroupDetails.Rows[0].Cells["Zone"].Value = objGroup.Gen_ShuttleZone.DefaultIfEmpty().ZoneName.ToStr();
grdGroupDetails.Rows[0].Cells["TotalSeats"].Value = objGroup.NoOfSeats.ToInt();
grdGroupDetails.Rows[0].Cells["AvailSeats"].Value = objGroup.NoOfSeats.ToInt() - objGroup.Bookings.Sum(c => c.NoofPassengers).ToInt();
grdGroupDetails.Rows[0].Cells["TotalJobs"].Value = objGroup.Bookings.Count;
grdGroupDetails.Rows[0].Cells["Status"].Value = objGroup.BookingTripStatus.DefaultIfEmpty().StatusName.ToStr();
if (objGroup.FlightDepartureDate == null)
{
grdGroupDetails.Columns["FlightDeparture"].IsVisible = false;
grdGroupDetails.Columns["Destination"].Width = 420;
}
var jobs = (from a in General.GetQueryable <Booking>(c => c.GroupJobId == groupId)
select new
{
Id = a.Id,
RefNo = a.BookingNo,
Passenger = a.CustomerName,
PickupDateTime = a.PickupDateTime,
PickupPoint = a.FromAddress,
Status = a.BookingStatus.StatusName,
Drv = a.Fleet_Driver != null ? a.Fleet_Driver.DriverNo : "",
TotalPax = a.NoofPassengers
}
).ToList();
grdJobDetails.RowCount = jobs.Count;
for (int i = 0; i < grdJobDetails.RowCount; i++)
{
grdJobDetails.Rows[i].Cells["Id"].Value = jobs[i].Id;
grdJobDetails.Rows[i].Cells["Passenger"].Value = jobs[i].Passenger.ToStr();
grdJobDetails.Rows[i].Cells["PickupDateTime"].Value = jobs[i].PickupDateTime;
grdJobDetails.Rows[i].Cells["PickupPoint"].Value = jobs[i].PickupPoint;
grdJobDetails.Rows[i].Cells["NoOfPax"].Value = jobs[i].TotalPax.ToInt();
grdJobDetails.Rows[i].Cells["Drv"].Value = jobs[i].Drv;
grdJobDetails.Rows[i].Cells["Status"].Value = jobs[i].Status;
}
if (grdJobDetails.RowCount > 0 && this.SelectedJobId > 0)
{
ConditionalFormattingObject objCondition = new ConditionalFormattingObject();
objCondition.ApplyToRow = true;
objCondition.RowBackColor = Color.LightGreen;
objCondition.ConditionType = ConditionTypes.Equal;
objCondition.TValue1 = selectedJobId.ToStr();
grdJobDetails.Columns["Id"].ConditionalFormattingObjectList.Add(objCondition);
grdJobDetails.ContextMenuOpening += new ContextMenuOpeningEventHandler(grdJobDetails_ContextMenuOpening);
}
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
private void FormatCell()
{
// Order No
ConditionalFormattingObject objOrderNo = new ConditionalFormattingObject("OrderNoCondition", ConditionTypes.NotEqual, "", "", false);
objOrderNo.CellForeColor = Color.Blue;
this.radGridView.Columns[0].ConditionalFormattingObjectList.Add(objOrderNo);
// Order Status
ConditionalFormattingObject objOrderStatus1 = new ConditionalFormattingObject("objOrderStatus1", ConditionTypes.Equal,
Constants.OrderStatusDraft, string.Empty, false);
objOrderStatus1.CellBackColor = Color.Red;
objOrderStatus1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderStatus2 = new ConditionalFormattingObject("objOrderStatus2", ConditionTypes.Equal,
Constants.OrderStatusDelivered, string.Empty, false);
objOrderStatus2.CellBackColor = Color.Green;
objOrderStatus2.CellForeColor = Color.White;
this.radGridView.Columns[3].ConditionalFormattingObjectList.Add(objOrderStatus1);
this.radGridView.Columns[3].ConditionalFormattingObjectList.Add(objOrderStatus2);
// Order SMS
ConditionalFormattingObject objOrderSms1 = new ConditionalFormattingObject("objOrderSms1", ConditionTypes.Equal,
Constants.OrderSms1, string.Empty, false);
objOrderSms1.CellBackColor = Color.Orange;
objOrderSms1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderSms2 = new ConditionalFormattingObject("objOrderSms2", ConditionTypes.Equal,
Constants.OrderSms2, string.Empty, false);
objOrderSms2.CellBackColor = Color.Green;
objOrderSms2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderSms3 = new ConditionalFormattingObject("objOrderSms3", ConditionTypes.Equal,
Constants.OrderSms3, string.Empty, false);
objOrderSms3.CellBackColor = Color.Red;
objOrderSms3.CellForeColor = Color.White;
this.radGridView.Columns[6].ConditionalFormattingObjectList.Add(objOrderSms1);
this.radGridView.Columns[6].ConditionalFormattingObjectList.Add(objOrderSms2);
this.radGridView.Columns[6].ConditionalFormattingObjectList.Add(objOrderSms3);
// Order Email
ConditionalFormattingObject objOrderEmail1 = new ConditionalFormattingObject("objOrderEmail1", ConditionTypes.Equal,
Constants.OrderEmail1, string.Empty, false);
objOrderEmail1.CellBackColor = Color.Orange;
objOrderEmail1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderEmail2 = new ConditionalFormattingObject("objOrderEmail2", ConditionTypes.Equal,
Constants.OrderEmail2, string.Empty, false);
objOrderEmail2.CellBackColor = Color.Green;
objOrderEmail2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderEmail3 = new ConditionalFormattingObject("objOrderEmail3", ConditionTypes.Equal,
Constants.OrderEmail3, string.Empty, false);
objOrderEmail3.CellBackColor = Color.Red;
objOrderEmail3.CellForeColor = Color.White;
this.radGridView.Columns[5].ConditionalFormattingObjectList.Add(objOrderEmail1);
this.radGridView.Columns[5].ConditionalFormattingObjectList.Add(objOrderEmail2);
this.radGridView.Columns[5].ConditionalFormattingObjectList.Add(objOrderEmail3);
// Order Report
ConditionalFormattingObject objOrderReport1 = new ConditionalFormattingObject("objOrderReport1", ConditionTypes.Equal,
Constants.OrderReport1, string.Empty, false);
objOrderReport1.CellBackColor = Color.Orange;
objOrderReport1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderReport2 = new ConditionalFormattingObject("objOrderReport2", ConditionTypes.Equal,
Constants.OrderReport2, string.Empty, false);
objOrderReport2.CellBackColor = Color.Green;
objOrderReport2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderReport3 = new ConditionalFormattingObject("objOrderReport3", ConditionTypes.Equal,
Constants.OrderReport3, string.Empty, false);
objOrderReport3.CellBackColor = Color.Red;
objOrderReport3.CellForeColor = Color.White;
this.radGridView.Columns[7].ConditionalFormattingObjectList.Add(objOrderReport1);
this.radGridView.Columns[7].ConditionalFormattingObjectList.Add(objOrderReport2);
this.radGridView.Columns[7].ConditionalFormattingObjectList.Add(objOrderReport3);
}
private void FormatDataGrid()
{
try
{
Telerik.WinControls.UI.Localization.RadGridLocalizationProvider.CurrentProvider = new Infrastructure.WinForms.Controls.MySpanishRadGridLocalizationProvider();
this.grdItems.Columns.Clear();
this.grdItems.AllowAddNewRow = false;
Telerik.WinControls.UI.GridViewCheckBoxColumn _Seleccionar = new Telerik.WinControls.UI.GridViewCheckBoxColumn();
_Seleccionar.Name = "Seleccionar";
_Seleccionar.HeaderText = "Seleccionar";
_Seleccionar.FieldName = "Seleccionar";
_Seleccionar.ReadOnly = false;
this.grdItems.Columns.Add(_Seleccionar);
this.grdItems.Columns["Seleccionar"].ReadOnly = false;
this.grdItems.Columns.Add("TIPO_TDO", "Tipo", "TIPO_TDO");
this.grdItems.Columns.Add("CCCT_Serie", "Serie", "CCCT_Serie");
this.grdItems.Columns.Add("CCCT_Numero", "Número", "CCCT_Numero");
this.grdItems.Columns.Add("CCCT_FechaEmision", "Fecha Emisión", "CCCT_FechaEmision");
this.grdItems.Columns.Add("OV_OP", "OV / OP", "OV_OP");
this.grdItems.Columns.Add("FEmbarque", "Fecha de Embarque / Zarpe", "FEmbarque");
this.grdItems.Columns.Add("FechaETA", "Fecha ETA", "FechaETA");
this.grdItems.Columns.Add("NAVE_Nombre", "Nave Viaje", "NAVE_Nombre");
this.grdItems.Columns.Add("DOOV_MBL", "MBL", "DOOV_MBL");
this.grdItems.Columns.Add("DOOV_HBL", "HBL", "DOOV_HBL");
this.grdItems.Columns.Add("UNegocio", "Uni. Negocio", "UNegocio");
this.grdItems.Columns.Add("TIPO_MND", "Moneda", "TIPO_MND");
this.grdItems.Columns.Add("CCCT_Pendiente_Cargo", "Ingreso", "CCCT_Pendiente_Cargo");
this.grdItems.Columns.Add("CCCT_Pendiente_Abono", "Egreso", "CCCT_Pendiente_Abono");
Telerik.WinControls.UI.GridViewCheckBoxColumn _conciliado = new Telerik.WinControls.UI.GridViewCheckBoxColumn();
_conciliado.Name = "Conciliado";
_conciliado.HeaderText = "Conciliado";
_conciliado.FieldName = "Conciliado";
this.grdItems.Columns.Add(_conciliado);
this.grdItems.Columns.Add("CONC_FecConciliacion", "Fec. Conciliación", "CONC_FecConciliacion");
this.grdItems.Columns.Add("CCCT_Codigo", "Transacción", "CCCT_Codigo");
this.grdItems.Columns.Add("ObservacionesConciliacion", "Observaciones", "ObservacionesConciliacion");
this.grdItems.Columns.Add("ConciliadoError", "Conciliacion", "ConciliadoError");
this.grdItems.Columns.Add("PagoMNDOriginal", "Monto Referencial", "PagoMNDOriginal");
this.grdItems.Columns["CCCT_FechaEmision"].FormatString = "{0:dd/MM/yyyy}";
this.grdItems.Columns["FEmbarque"].FormatString = "{0:dd/MM/yyyy}";
this.grdItems.Columns["FechaETA"].FormatString = "{0:dd/MM/yyyy}";
this.grdItems.Columns["CCCT_Pendiente_Cargo"].FormatString = "{0:#,###,##0.00}";
this.grdItems.Columns["CCCT_Pendiente_Abono"].FormatString = "{0:#,###,##0.00}";
this.grdItems.Columns["CCCT_Pendiente_Cargo"].TextAlignment = ContentAlignment.MiddleRight;
this.grdItems.Columns["CCCT_Pendiente_Abono"].TextAlignment = ContentAlignment.MiddleRight;
this.grdItems.Columns["PagoMNDOriginal"].TextAlignment = ContentAlignment.MiddleRight;
this.grdItems.Columns["TIPO_TDO"].ReadOnly = true;
this.grdItems.Columns["CCCT_Serie"].ReadOnly = true;
this.grdItems.Columns["CCCT_Numero"].ReadOnly = true;
this.grdItems.Columns["CCCT_FechaEmision"].ReadOnly = true;
this.grdItems.Columns["OV_OP"].ReadOnly = true;
this.grdItems.Columns["FEmbarque"].ReadOnly = true;
this.grdItems.Columns["FechaETA"].ReadOnly = true;
this.grdItems.Columns["NAVE_Nombre"].ReadOnly = true;
this.grdItems.Columns["DOOV_MBL"].ReadOnly = true;
this.grdItems.Columns["DOOV_HBL"].ReadOnly = true;
this.grdItems.Columns["UNegocio"].ReadOnly = true;
this.grdItems.Columns["TIPO_MND"].ReadOnly = true;
this.grdItems.Columns["Conciliado"].ReadOnly = true;
this.grdItems.Columns["Conciliado"].IsVisible = false;
this.grdItems.Columns["CONC_FecConciliacion"].ReadOnly = true;
this.grdItems.Columns["CONC_FecConciliacion"].IsVisible = false;
this.grdItems.Columns["UNegocio"].IsVisible = false;
this.grdItems.Columns["CCCT_Pendiente_Cargo"].ReadOnly = true;
this.grdItems.Columns["CCCT_Pendiente_Abono"].IsVisible = true;
this.grdItems.Columns["CCCT_Pendiente_Cargo"].ReadOnly = true;
this.grdItems.Columns["CCCT_Pendiente_Abono"].IsVisible = true;
this.grdItems.Columns["ObservacionesConciliacion"].ReadOnly = true;
this.grdItems.Columns["ObservacionesConciliacion"].IsVisible = false;
this.grdItems.Columns["ObservacionesConciliacion"].Width = 200;
this.grdItems.Columns["ConciliadoError"].IsVisible = false;
this.grdItems.Columns["PagoMNDOriginal"].ReadOnly = true;
ConditionalFormattingObject c1 = new ConditionalFormattingObject("Orange, applied to entire row", ConditionTypes.Equal, "true", "", true);
c1.RowBackColor = Color.DarkBlue; // FromArgb(255, 91, 15, 2);
c1.CellBackColor = Color.DarkBlue;
c1.RowForeColor = Color.White;
grdItems.Columns["ConciliadoError"].ConditionalFormattingObjectList.Add(c1);
Infrastructure.WinForms.Controls.GridAutoFit.Fit(grdItems);
//grdItems.BestFitColumns();
grdItems.Columns["Seleccionar"].Width = 90;
grdItems.Columns["Seleccionar"].ReadOnly = false;
//grdItems.ReadOnly = false;
//grdItems.ShowFilteringRow = false;
//grdItems.EnableFiltering = false;
//grdItems.MasterTemplate.EnableFiltering = false;
//grdItems.EnableGrouping = false;
//grdItems.MasterTemplate.EnableGrouping = false;
//grdItems.EnableSorting = false;
//grdItems.MasterTemplate.EnableCustomSorting = false;
//grdItems.AllowColumnHeaderContextMenu = false;
//grdItems.AllowCellContextMenu = false;
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, Infrastructure.Aspect.Constants.Mensajes.FormatDataGridView, ex); }
}
private void ViewReport()
{
try
{
DataSource = FillDataSource();
var list = (from a in DataSource
select new
{
Sno = a.Sno,
Name = a.Name,
PhoneNumber = a.PhoneNo,
CallDateTime = a.CallDateTime,
Line = a.Line,
STN = a.STN,
Duration = a.Duration,
IsMissed = a.IsMissed,
Company = a.CompanyName
}).ToList();
lblTotalAnsweredCalls.Text = "Total Answered Calls : " + list.Where(c => c.STN.Length > 0).Count();
lblTotalMissedCalls.Text = "Total Missed Calls : " + list.Where(c => (c.STN == null || c.STN == "")).Count();
lblTotalBookings.Text = "Total Bookings : " + 0;
grdCalls.DataSource = list;
if (this.objCLISettings.IsAnalog.ToBool())
{
grdCalls.Columns["Line"].IsVisible = true;
grdCalls.Columns["Line"].Width = 50;
grdCalls.Columns["CallDateTime"].Width = 150;
grdCalls.Columns["Name"].Width = 160;
}
else
{
grdCalls.Columns["Line"].IsVisible = false;
grdCalls.Columns["CallDateTime"].Width = 140;
grdCalls.Columns["Name"].Width = 180;
}
if (this.objCLISettings.DigitalCLIType.ToInt() == 2)
{
grdCalls.Columns["Line"].IsVisible = true;
grdCalls.Columns["Line"].Width = 40;
grdCalls.Columns["CallDateTime"].Width = 140;
grdCalls.Columns["Name"].Width = 140;
grdCalls.Columns["Duration"].Width = 120;
if (IsDataLoaded == false)
{
this.Width = this.Width + 190;
}
// btnMissedCalls.Visible = true;
}
else
{
grdCalls.Columns["Sno"].IsVisible = false;
grdCalls.Columns["STN"].IsVisible = false;
grdCalls.Columns["Duration"].IsVisible = false;
}
if (this.objCLISettings.VOIPCLIType.ToInt() == 2 || this.objCLISettings.VOIPCLIType.ToInt() == 4)
{
grdCalls.Columns["Line"].IsVisible = true;
grdCalls.Columns["Duration"].IsVisible = false;
// grdCalls.Columns["Recording"].IsVisible = true;
}
grdCalls.Columns["Sno"].Width = 60;
grdCalls.Columns["Company"].Width = 140;
//grdCalls.Columns["CompanyName"].HeaderText = "Company";
grdCalls.Columns["STN"].IsVisible = true;
grdCalls.Columns["PhoneNumber"].Width = 120;
grdCalls.Columns["PhoneNumber"].HeaderText = "Phone Number";
(grdCalls.Columns["CallDateTime"] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy";
grdCalls.Columns["CallDateTime"].HeaderText = "Call Date Time";
grdCalls.Columns["IsMissed"].IsVisible = false;
if (grdCalls.Columns["IsMissed"].ConditionalFormattingObjectList.Count == 0)
{
ConditionalFormattingObject objMissedCondition = new ConditionalFormattingObject();
objMissedCondition.TValue1 = "1";
objMissedCondition.ApplyToRow = true;
objMissedCondition.RowBackColor = Color.LightPink;
objMissedCondition.ConditionType = ConditionTypes.Equal;
grdCalls.Columns["IsMissed"].ConditionalFormattingObjectList.Add(objMissedCondition);
}
if (this.objCLISettings != null && this.objCLISettings.VOIPCLIType.ToInt() == 4 && File.Exists(Application.StartupPath + "\\CabTreasureEmeraldCallRecording.exe"))
{
btnMissedCalls.Visible = true;
}
IsDataLoaded = true;
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
public override void PopulateData()
{
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 phone = txtPhone.Text.Trim();
string name = ddlCustomer.Text.Trim().ToLower();
string line = txtLine.Text.Trim();
string stn = txtSTN.Text.Trim();
bool MissedCalls = optMissedCalls.Checked;
string SubCompanyNo = string.Empty;
int SubCompanyId = ddlSubCompanyId.SelectedValue.ToInt();
if (SubCompanyId > 0)
{
using (TaxiDataContext dbX = new TaxiDataContext())
{
SubCompanyNo = dbX.Gen_SubCompanies.FirstOrDefault(c => c.Id == SubCompanyId).ConnectionString;
}
if (string.IsNullOrEmpty(SubCompanyNo))
{
grdCalls.Rows.Clear();;
MessageBox.Show("Sub Company CallerId Number is not defined");
return;
// SubCompanyNo = null;
}
}
else
{
SubCompanyNo = string.Empty;
}
TaxiDataContext db = new TaxiDataContext();
var list = (from a in db.CallHistories
join b in db.Gen_SubCompanies on a.CalledToNumber equals b.ConnectionString into table2
from b in table2.DefaultIfEmpty()
where (fromDate == null || a.CallDateTime.Value.Date >= fromDate) &&
(tillDate == null || a.CallDateTime.Value.Date <= tillDate) &&
(name == string.Empty || a.Name.Trim().ToLower() == name) &&
(MissedCalls == false || (a.STN == null || a.STN == "")) &&
(phone == string.Empty || a.PhoneNumber.Trim() == phone) &&
(line == string.Empty || (a.Line != null && a.Line.Trim() == line)) &&
(stn == string.Empty || (a.STN != null && a.STN.Trim() == stn)) &&
(IsAccepted == true || (a.IsAccepted != null && a.IsAccepted == true)) &&
(SubCompanyNo == string.Empty || (a.CalledToNumber != null && a.CalledToNumber.Trim() == SubCompanyNo))
orderby a.CallDateTime descending
select new
{
Sno = a.Sno,
Name = a.Name,
PhoneNumber = a.PhoneNumber,
CallDateTime = a.CallDateTime,
Line = a.Line,
STN = a.STN,
Duration = a.CallDuration,
IsMissed = (a.IsAccepted != null && a.IsAccepted == true) ? "1" : "0",
Company = b != null && b.CompanyName != "" ? b.CompanyName : a.CalledToNumber
}).ToList();
//foreach (var item in list)
//{
// //objTempCallHistory.Add(new TempCallHistory { Name = item.Name, PhoneNo = item.PhoneNumber, CallDateTime = item.CallDateTime, STN = item.STN, Line = item.Line, CompanyName = item.Company });
//}
db.Dispose();
//var list2 = (from a in General.GetQueryable<CallHistory>(null)
// where (fromDate == null || a.CallDateTime.Value.Date >= fromDate)
// && (tillDate == null || a.CallDateTime.Value.Date <= tillDate)
// && (name == string.Empty || a.Name.ToStr().Trim().ToLower() == name)
// && (phone == string.Empty || a.PhoneNumber.Trim() == phone)
// && (line == string.Empty || (a.Line != null && a.Line.Trim() == line))
// && (stn == string.Empty || (a.STN != null && a.STN.Trim() == stn))
// && (IsAccepted == true || (a.IsAccepted != null && a.IsAccepted == true))
// orderby a.CallDateTime descending
// select new
// {
// Sno = a.Sno,
// Name = a.Name,
// PhoneNumber = a.PhoneNumber,
// CallDateTime = a.CallDateTime,
// Line = a.Line,
// STN = a.STN,
// Duration = a.CallDuration,
// IsMissed = (a.IsAccepted != null && a.IsAccepted == true) ? "1" : "0"
// }).ToList();
lblTotalAnsweredCalls.Text = "Total Answered Calls : " + list.Where(c => c.STN.Length > 0).Count();
lblTotalMissedCalls.Text = "Total Missed Calls : " + list.Where(c => (c.STN == null || c.STN == "")).Count();
lblTotalBookings.Text = "Total Bookings : " + 0;
grdCalls.DataSource = list;
if (this.objCLISettings.IsAnalog.ToBool())
{
grdCalls.Columns["Line"].IsVisible = true;
grdCalls.Columns["Line"].Width = 50;
grdCalls.Columns["CallDateTime"].Width = 160;
grdCalls.Columns["Name"].Width = 140;
}
else
{
grdCalls.Columns["Line"].IsVisible = false;
grdCalls.Columns["CallDateTime"].Width = 180;
grdCalls.Columns["Name"].Width = 140;
}
if (this.objCLISettings.DigitalCLIType.ToInt() == 2)
{
grdCalls.Columns["Line"].IsVisible = true;
grdCalls.Columns["Line"].Width = 40;
grdCalls.Columns["CallDateTime"].Width = 160;
grdCalls.Columns["Name"].Width = 140;
grdCalls.Columns["Duration"].Width = 120;
if (IsDataLoaded == false)
{
this.Width = this.Width + 190;
}
// btnMissedCalls.Visible = true;
}
else
{
grdCalls.Columns["Sno"].IsVisible = false;
grdCalls.Columns["STN"].IsVisible = false;
grdCalls.Columns["Duration"].IsVisible = false;
}
if (this.objCLISettings.VOIPCLIType.ToInt() == 2 || this.objCLISettings.VOIPCLIType.ToInt() == 4)
{
grdCalls.Columns["Line"].IsVisible = true;
grdCalls.Columns["Duration"].IsVisible = false;
grdCalls.Columns["Recording"].IsVisible = true;
}
grdCalls.Columns["Sno"].Width = 60;
grdCalls.Columns["CompanyName"].Width = 140;
grdCalls.Columns["CompanyName"].HeaderText = "Company";
grdCalls.Columns["STN"].IsVisible = true;
grdCalls.Columns["PhoneNumber"].Width = 120;
grdCalls.Columns["PhoneNumber"].HeaderText = "Phone Number";
(grdCalls.Columns["CallDateTime"] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy";
grdCalls.Columns["CallDateTime"].HeaderText = "Call Date Time";
grdCalls.Columns["IsMissed"].IsVisible = false;
if (grdCalls.Columns["IsMissed"].ConditionalFormattingObjectList.Count == 0)
{
ConditionalFormattingObject objMissedCondition = new ConditionalFormattingObject();
objMissedCondition.TValue1 = "1";
objMissedCondition.ApplyToRow = true;
objMissedCondition.RowBackColor = Color.LightPink;
objMissedCondition.ConditionType = ConditionTypes.Equal;
grdCalls.Columns["IsMissed"].ConditionalFormattingObjectList.Add(objMissedCondition);
}
if (this.objCLISettings != null && this.objCLISettings.VOIPCLIType.ToInt() == 4 && File.Exists(Application.StartupPath + "\\CabTreasureEmeraldCallRecording.exe"))
{
btnMissedCalls.Visible = true;
}
IsDataLoaded = true;
}
private void FormatCell()
{
// Delivery
ConditionalFormattingObject objDeliveryNo = new ConditionalFormattingObject("DeliveryNoCondition", ConditionTypes.NotEqual, "", "", false);
objDeliveryNo.CellForeColor = Color.Blue;
this.radGridView.MasterTemplate.Columns["DeliveryNo"].ConditionalFormattingObjectList.Add(objDeliveryNo);
ConditionalFormattingObject objDeliveryStatus1 = new ConditionalFormattingObject("DeliveryStatusCondition1", ConditionTypes.Equal,
ECommon.Constants.DeliveryStatusDraft, string.Empty, false);
objDeliveryStatus1.CellBackColor = Color.Orange;
objDeliveryStatus1.CellForeColor = Color.White;
ConditionalFormattingObject objDeliveryStatus2 = new ConditionalFormattingObject("DeliveryStatusCondition2", ConditionTypes.Equal,
ECommon.Constants.DeliveryStatusDelivered, string.Empty, false);
objDeliveryStatus2.CellBackColor = Color.Green;
objDeliveryStatus2.CellForeColor = Color.White;
this.radGridView.MasterTemplate.Columns["Status"].ConditionalFormattingObjectList.Add(objDeliveryStatus1);
this.radGridView.MasterTemplate.Columns["Status"].ConditionalFormattingObjectList.Add(objDeliveryStatus2);
// Order
var template = this.radGridView.Templates[0];
ConditionalFormattingObject objOrderNo = new ConditionalFormattingObject("OrderNoCondition", ConditionTypes.NotEqual, "", "", false);
objOrderNo.CellForeColor = Color.Blue;
template.Columns["OrderNo"].ConditionalFormattingObjectList.Add(objOrderNo);
// Order Status
ConditionalFormattingObject objOrderStatus1 = new ConditionalFormattingObject("objOrderStatus1", ConditionTypes.Equal,
ECommon.Constants.OrderStatusDraft, string.Empty, false);
objOrderStatus1.CellBackColor = Color.Red;
objOrderStatus1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderStatus2 = new ConditionalFormattingObject("objOrderStatus2", ConditionTypes.Equal,
ECommon.Constants.OrderStatusDelivered, string.Empty, false);
objOrderStatus2.CellBackColor = Color.Green;
objOrderStatus2.CellForeColor = Color.White;
template.Columns["Status"].ConditionalFormattingObjectList.Add(objOrderStatus1);
template.Columns["Status"].ConditionalFormattingObjectList.Add(objOrderStatus2);
// Order SMS
ConditionalFormattingObject objOrderSms1 = new ConditionalFormattingObject("objOrderSms1", ConditionTypes.Equal,
ECommon.Constants.OrderSms1, string.Empty, false);
objOrderSms1.CellBackColor = Color.Orange;
objOrderSms1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderSms2 = new ConditionalFormattingObject("objOrderSms2", ConditionTypes.Equal,
ECommon.Constants.OrderSms2, string.Empty, false);
objOrderSms2.CellBackColor = Color.Green;
objOrderSms2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderSms3 = new ConditionalFormattingObject("objOrderSms3", ConditionTypes.Equal,
ECommon.Constants.OrderSms3, string.Empty, false);
objOrderSms3.CellBackColor = Color.Red;
objOrderSms3.CellForeColor = Color.White;
template.Columns["SendMessage"].ConditionalFormattingObjectList.Add(objOrderSms1);
template.Columns["SendMessage"].ConditionalFormattingObjectList.Add(objOrderSms2);
template.Columns["SendMessage"].ConditionalFormattingObjectList.Add(objOrderSms3);
// Order Email
ConditionalFormattingObject objOrderEmail1 = new ConditionalFormattingObject("objOrderEmail1", ConditionTypes.Equal,
ECommon.Constants.OrderEmail1, string.Empty, false);
objOrderEmail1.CellBackColor = Color.Orange;
objOrderEmail1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderEmail2 = new ConditionalFormattingObject("objOrderEmail2", ConditionTypes.Equal,
ECommon.Constants.OrderEmail2, string.Empty, false);
objOrderEmail2.CellBackColor = Color.Green;
objOrderEmail2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderEmail3 = new ConditionalFormattingObject("objOrderEmail3", ConditionTypes.Equal,
ECommon.Constants.OrderEmail3, string.Empty, false);
objOrderEmail3.CellBackColor = Color.Red;
objOrderEmail3.CellForeColor = Color.White;
template.Columns["SendEmail"].ConditionalFormattingObjectList.Add(objOrderEmail1);
template.Columns["SendEmail"].ConditionalFormattingObjectList.Add(objOrderEmail2);
template.Columns["SendEmail"].ConditionalFormattingObjectList.Add(objOrderEmail3);
// Order Report
ConditionalFormattingObject objOrderReport1 = new ConditionalFormattingObject("objOrderReport1", ConditionTypes.Equal,
ECommon.Constants.OrderReport1, string.Empty, false);
objOrderReport1.CellBackColor = Color.Orange;
objOrderReport1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderReport2 = new ConditionalFormattingObject("objOrderReport2", ConditionTypes.Equal,
ECommon.Constants.OrderReport2, string.Empty, false);
objOrderReport2.CellBackColor = Color.Green;
objOrderReport2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderReport3 = new ConditionalFormattingObject("objOrderReport3", ConditionTypes.Equal,
ECommon.Constants.OrderReport3, string.Empty, false);
objOrderReport3.CellBackColor = Color.Red;
objOrderReport3.CellForeColor = Color.White;
template.Columns["SendReport"].ConditionalFormattingObjectList.Add(objOrderReport1);
template.Columns["SendReport"].ConditionalFormattingObjectList.Add(objOrderReport2);
template.Columns["SendReport"].ConditionalFormattingObjectList.Add(objOrderReport3);
}
private void FormatChargesGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.InvoiceId;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.PaymentTypeId;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.BookingId;
grdLister.Columns.Add(col);
GridViewDateTimeColumn colDt = new GridViewDateTimeColumn();
colDt.Name = "PickupDate";
colDt.ReadOnly = true;
colDt.HeaderText = "Pickup Date-Time";
grdLister.Columns.Add(colDt);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Job #";
col.Name = "RefNumber";
grdLister.Columns.Add(col);
//col = new GridViewTextBoxColumn();
// col.IsVisible = false;
//col.HeaderText = "Order No";
//col.Name = "OrderNo";
//grdLister.Columns.Add(col);
//col = new GridViewTextBoxColumn();
//col.IsVisible = false;
//col.HeaderText = "Pupil No";
//col.Name = "PupilNo";
//grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.HeaderText = "Vehicle";
col.Name = "Vehicle";
col.ReadOnly = true;
grdLister.Columns.Add(col);
//col = new GridViewTextBoxColumn();
//// col.IsVisible = false;
//col.ReadOnly = true;
//col.Name = COLS.Account;
//col.HeaderText = COLS.Account;
//grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = false;
col.HeaderText = "Pickup Point";
col.Name = "PickupPoint";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = false;
col.HeaderText = "Destination";
col.Name = "Destination";
grdLister.Columns.Add(col);
GridViewDecimalColumn colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Charges";
colD.Name = "Charges";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Parking";
colD.Name = "Parking";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Waiting";
colD.Name = "Waiting";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Extra Drop";
colD.Name = "ExtraDrop";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Meet and Greet";
colD.Name = "MeetAndGreet";
colD.IsVisible = false;
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Congestion";
colD.Name = "CongtionCharge";
colD.Maximum = 9999999;
colD.IsVisible = false;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Total";
colD.Name = "Total";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
// colD.Expression = "Charges+Parking+Waiting+ExtraDrop+MeetAndGreet+CongtionCharge";
colD.Expression = "Charges+Parking+Waiting+ExtraDrop";
grdLister.Columns.Add(colD);
// grdLister.Columns["Id"].IsVisible = false;
(grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
(grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
grdLister.Columns["PickUpDate"].Width = 105;
grdLister.Columns["RefNumber"].Width = 40;
grdLister.Columns["Vehicle"].Width = 50;
// grdLister.Columns[COLS.Account].Width = 60;
grdLister.Columns["PickUpPoint"].Width = 170;
grdLister.Columns["Destination"].Width = 170;
grdLister.Columns["Charges"].Width = 50;
grdLister.Columns["Parking"].Width = 45;
grdLister.Columns["Waiting"].Width = 50;
grdLister.Columns["ExtraDrop"].Width = 60;
grdLister.Columns["MeetAndGreet"].Width = 50;
grdLister.Columns["CongtionCharge"].Width = 60;
grdLister.Columns["Total"].Width = 45;
// grdLister.Columns["OrderNo"].Width = 55;
grdLister.Columns["PickUpDate"].HeaderText = "Pickup Date-Time";
grdLister.Columns["RefNumber"].HeaderText = "Ref #";
grdLister.Columns["PickUpPoint"].HeaderText = "Pickup Point";
grdLister.Columns["ExtraDrop"].HeaderText = "Congestion";
grdLister.Columns["MeetAndGreet"].HeaderText = "M & G";
grdLister.Columns["CongtionCharge"].HeaderText = "Congestion";
//grdLister.Columns["MeetAndGreet"].ReadOnly = false;
//grdLister.Columns["CongtionCharge"].ReadOnly = false;
//grdLister.Columns["Charge"].ReadOnly = false;
//grdLister.Columns["Parking"].ReadOnly = false;
//grdLister.Columns["Waiting"].ReadOnly = false;
//grdLister.Columns["ExtraDrop"].ReadOnly = false;
AddUpdateColumn(grdLister);
ConditionalFormattingObject objPaid = new ConditionalFormattingObject();
objPaid.ApplyToRow = true;
objPaid.RowBackColor = Color.LightGreen;
objPaid.ConditionType = ConditionTypes.Equal;
objPaid.TValue1 = "6";
objPaid.TValue2 = "2";
grdLister.Columns["PaymentTypeId"].ConditionalFormattingObjectList.Add(objPaid);
}
private void FormatCell()
{
// Delivery
ConditionalFormattingObject objDeliveryNo = new ConditionalFormattingObject("DeliveryNoCondition", ConditionTypes.NotEqual, "", "", false);
objDeliveryNo.CellForeColor = Color.Blue;
this.radGridView.MasterTemplate.Columns["DeliveryNo"].ConditionalFormattingObjectList.Add(objDeliveryNo);
ConditionalFormattingObject objDeliveryStatus1 = new ConditionalFormattingObject("DeliveryStatusCondition1", ConditionTypes.Equal,
ECommon.Constants.DeliveryStatusDraft, string.Empty, false);
objDeliveryStatus1.CellBackColor = Color.Orange;
objDeliveryStatus1.CellForeColor = Color.White;
ConditionalFormattingObject objDeliveryStatus2 = new ConditionalFormattingObject("DeliveryStatusCondition2", ConditionTypes.Equal,
ECommon.Constants.DeliveryStatusDelivered, string.Empty, false);
objDeliveryStatus2.CellBackColor = Color.Green;
objDeliveryStatus2.CellForeColor = Color.White;
this.radGridView.MasterTemplate.Columns["Status"].ConditionalFormattingObjectList.Add(objDeliveryStatus1);
this.radGridView.MasterTemplate.Columns["Status"].ConditionalFormattingObjectList.Add(objDeliveryStatus2);
// Order
var template = this.radGridView.Templates[0];
ConditionalFormattingObject objOrderNo = new ConditionalFormattingObject("OrderNoCondition", ConditionTypes.NotEqual, "", "", false);
objOrderNo.CellForeColor = Color.Blue;
template.Columns["OrderNo"].ConditionalFormattingObjectList.Add(objOrderNo);
// Order Status
ConditionalFormattingObject objOrderStatus1 = new ConditionalFormattingObject("objOrderStatus1", ConditionTypes.Equal,
ECommon.Constants.OrderStatusDraft, string.Empty, false);
objOrderStatus1.CellBackColor = Color.Red;
objOrderStatus1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderStatus2 = new ConditionalFormattingObject("objOrderStatus2", ConditionTypes.Equal,
ECommon.Constants.OrderStatusDelivered, string.Empty, false);
objOrderStatus2.CellBackColor = Color.Green;
objOrderStatus2.CellForeColor = Color.White;
template.Columns["Status"].ConditionalFormattingObjectList.Add(objOrderStatus1);
template.Columns["Status"].ConditionalFormattingObjectList.Add(objOrderStatus2);
// Order SMS
ConditionalFormattingObject objOrderSms1 = new ConditionalFormattingObject("objOrderSms1", ConditionTypes.Equal,
ECommon.Constants.OrderSms1, string.Empty, false);
objOrderSms1.CellBackColor = Color.Orange;
objOrderSms1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderSms2 = new ConditionalFormattingObject("objOrderSms2", ConditionTypes.Equal,
ECommon.Constants.OrderSms2, string.Empty, false);
objOrderSms2.CellBackColor = Color.Green;
objOrderSms2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderSms3 = new ConditionalFormattingObject("objOrderSms3", ConditionTypes.Equal,
ECommon.Constants.OrderSms3, string.Empty, false);
objOrderSms3.CellBackColor = Color.Red;
objOrderSms3.CellForeColor = Color.White;
template.Columns["SendMessage"].ConditionalFormattingObjectList.Add(objOrderSms1);
template.Columns["SendMessage"].ConditionalFormattingObjectList.Add(objOrderSms2);
template.Columns["SendMessage"].ConditionalFormattingObjectList.Add(objOrderSms3);
// Order Email
ConditionalFormattingObject objOrderEmail1 = new ConditionalFormattingObject("objOrderEmail1", ConditionTypes.Equal,
ECommon.Constants.OrderEmail1, string.Empty, false);
objOrderEmail1.CellBackColor = Color.Orange;
objOrderEmail1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderEmail2 = new ConditionalFormattingObject("objOrderEmail2", ConditionTypes.Equal,
ECommon.Constants.OrderEmail2, string.Empty, false);
objOrderEmail2.CellBackColor = Color.Green;
objOrderEmail2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderEmail3 = new ConditionalFormattingObject("objOrderEmail3", ConditionTypes.Equal,
ECommon.Constants.OrderEmail3, string.Empty, false);
objOrderEmail3.CellBackColor = Color.Red;
objOrderEmail3.CellForeColor = Color.White;
template.Columns["SendEmail"].ConditionalFormattingObjectList.Add(objOrderEmail1);
template.Columns["SendEmail"].ConditionalFormattingObjectList.Add(objOrderEmail2);
template.Columns["SendEmail"].ConditionalFormattingObjectList.Add(objOrderEmail3);
// Order Report
ConditionalFormattingObject objOrderReport1 = new ConditionalFormattingObject("objOrderReport1", ConditionTypes.Equal,
ECommon.Constants.OrderReport1, string.Empty, false);
objOrderReport1.CellBackColor = Color.Orange;
objOrderReport1.CellForeColor = Color.White;
ConditionalFormattingObject objOrderReport2 = new ConditionalFormattingObject("objOrderReport2", ConditionTypes.Equal,
ECommon.Constants.OrderReport2, string.Empty, false);
objOrderReport2.CellBackColor = Color.Green;
objOrderReport2.CellForeColor = Color.White;
ConditionalFormattingObject objOrderReport3 = new ConditionalFormattingObject("objOrderReport3", ConditionTypes.Equal,
ECommon.Constants.OrderReport3, string.Empty, false);
objOrderReport3.CellBackColor = Color.Red;
objOrderReport3.CellForeColor = Color.White;
template.Columns["SendReport"].ConditionalFormattingObjectList.Add(objOrderReport1);
template.Columns["SendReport"].ConditionalFormattingObjectList.Add(objOrderReport2);
template.Columns["SendReport"].ConditionalFormattingObjectList.Add(objOrderReport3);
}
