void grid_CustomUnboundColumnData(object sender, GridColumnDataEventArgs e) { if (e.IsGetData) { int price = Convert.ToInt32(e.GetListSourceFieldValue("UnitPrice")); int unitsOnOrder = Convert.ToInt32(e.GetListSourceFieldValue("Quantity")); e.Value = price * unitsOnOrder; } }
public static void GetSnapShotErrorColumns(GridColumnDataEventArgs e) { if (e.IsGetData) { switch (e.Column.FieldName) { case "SnapShotErrorIndicator": string errorMessage = e.GetListSourceFieldValue("SnapShotError").ToString(); if (errorMessage.Length > 0) { if (errorMessage.Equals("Connection Failure Exception")) { e.Value = GetImage("OrangeBall.png"); } else { e.Value = GetImage("RedBall.png"); } } else { e.Value = GetImage("GreenBall.png"); } break; } } }
protected virtual void OnCustomUnboundColumnData(object sender, GridColumnDataEventArgs e) { if (KeyExpression == null) { return; } SelectorColumn column = e.Column as SelectorColumn; if (column == null) { return; } var key = e.GetListSourceFieldValue(KeyExpression); if (e.IsGetData) { bool value; e.Value = Values.TryGetValue(key, out value) ? value : false; } if (e.IsSetData) { Values[key] = (bool)e.Value; } }
private void grid_CustomUnboundColumnData(object sender, GridColumnDataEventArgs e) { if (e.Column.FieldName == "Chart") { double key = (int)e.GetListSourceFieldValue("Number"); if (e.IsGetData) { e.Value = (double)key; } } }
void grid_CustomUnboundColumnData(object sender, GridColumnDataEventArgs e) { int sum = 0; foreach (GridColumn column in grid.Columns) { if (column.FieldName != "Employee" && column.FieldName != "Total") { sum += (int)e.GetListSourceFieldValue(column.FieldName); } } e.Value = sum; }
private void grid_CustomUnboundColumnData(object sender, GridColumnDataEventArgs e) { if (e.Column.FieldName == "Selected") { Guid key = (Guid)e.GetListSourceFieldValue("Id"); if (e.IsGetData) { e.Value = GetIsSelected(key); } if (e.IsSetData) { SetIsSelected(key, (bool)e.Value); } } }
private void OnCustomUnboundColumnData(object sender, GridColumnDataEventArgs e) { if (Equals(e.Column.Tag, ColUnboundMethodsFieldName)) { var key = e.Column.FieldName; var row = PmGridControl.GetRowByListIndex(e.ListSourceRowIndex) as PmConfiguratorData; var isvalid = _vm != null && row != null && _vm.ValidatePmMethods(key, row); var methods = (IDictionary <string, EditableBusinessObjectCollection <object> >) e.GetListSourceFieldValue(PmConfiguratorData.PmMethodCodesPropertyName); if (e.IsGetData) { var values = GetTrueMethods(key, methods).ToList(); if (!isvalid) { values.Insert(0, Properties.Resources.PmMethodIsUnavailable); } e.Value = values; } if (e.IsSetData && isvalid) { var pms = GetTrueMethods(key, methods); pms.Clear(); if (e.Value != null) { foreach (var p in (List <object>)e.Value) { pms.Add(p); } } row.PmMethodCodesPropertyChanged(); } } }
public static void GetEnvironmentInstanceDatabaseColumns(GridColumnDataEventArgs e) { if (e.IsGetData) { //Guid database_ID; //Guid instance_ID; //string instance_ID_String = null; switch (e.Column.FieldName) { case "ADDomain": if (e.GetListSourceFieldValue("Instance_ID") != null) { //instance_ID = Guid.Parse(e.GetListSourceFieldValue("Instance_ID").ToString()); //var instance = Common.ApplicationDS.Instances.Where(ins => ins.ID == instance_ID).First(); //e.Value = instance.ADDomain; } else if (e.GetListSourceFieldValue("Database_ID") != null) { //database_ID = Guid.Parse(e.GetListSourceFieldValue("Database_ID").ToString()); //var database1 = Common.ApplicationDS.Databases.Where(db => db.ID == database_ID).First(); //var instance1 = Common.ApplicationDS.Instances.Where(ins => ins.ID == database1.Instance_ID).First(); //e.Value = instance1.ADDomain; } else { // TODO(crhodes): Who is sending us here> } break; case "Environment": if (e.GetListSourceFieldValue("Instance_ID") != null) { //instance_ID = Guid.Parse(e.GetListSourceFieldValue("Instance_ID").ToString()); //var instance = Common.ApplicationDS.Instances.Where(ins => ins.ID == instance_ID).First(); //e.Value = instance.Environment; } else if (e.GetListSourceFieldValue("Database_ID") != null) { //database_ID = Guid.Parse(e.GetListSourceFieldValue("Database_ID").ToString()); //var database1 = Common.ApplicationDS.Databases.Where(db => db.ID == database_ID).First(); //var instance1 = Common.ApplicationDS.Instances.Where(ins => ins.ID == database1.Instance_ID).First(); //e.Value = instance1.Environment; } else { // TODO(crhodes): Who is sending us here> } break; case "IsMonitored_Instance": if (e.GetListSourceFieldValue("Instance_ID") != null) { //instance_ID = Guid.Parse(e.GetListSourceFieldValue("Instance_ID").ToString()); //var instance = Common.ApplicationDS.Instances.Where(ins => ins.ID == instance_ID).First(); //e.Value = instance.IsIsMonitoredNull() ? false : instance.IsMonitored; } else { // TODO(crhodes): Who is sending us here> } break; case "Name_Database": if (e.GetListSourceFieldValue("Database_ID") != null) { //database_ID = Guid.Parse(e.GetListSourceFieldValue("Database_ID").ToString()); //var database = Common.ApplicationDS.Databases.Where(db => db.ID == database_ID).First(); //e.Value = database.Name_Database; } else { // TODO(crhodes): Who is sending us here> } break; case "Name_Instance": if (e.GetListSourceFieldValue("Database_ID") != null) { //database_ID = Guid.Parse(e.GetListSourceFieldValue("Database_ID").ToString()); //var database2 = Common.ApplicationDS.Databases.Where(db => db.ID == database_ID).First(); //var instance2 = Common.ApplicationDS.Instances.Where(ins => ins.ID == database2.Instance_ID).First(); //e.Value = instance2.Name_Instance; } else { // TODO(crhodes): Who is sending us here> } break; case "Notes_Instance": if (e.GetListSourceFieldValue("Instance_ID") != null) { //instance_ID = Guid.Parse(e.GetListSourceFieldValue("Instance_ID").ToString()); //var instance = Common.ApplicationDS.Instances.Where(ins => ins.ID == instance_ID).First(); //e.Value = instance.IsNotesNull() ? "" : instance.Notes; } else { // TODO(crhodes): Who is sending us here> } break; case "SecurityZone": if (e.GetListSourceFieldValue("Instance_ID") != null) { //instance_ID = Guid.Parse(e.GetListSourceFieldValue("Instance_ID").ToString()); //var instance = Common.ApplicationDS.Instances.Where(ins => ins.ID == instance_ID).First(); //e.Value = instance.IsSecurityZoneNull() ? "" : instance.SecurityZone; //e.Value = instance.SecurityZone; } else if (e.GetListSourceFieldValue("Database_ID") != null) { //database_ID = Guid.Parse(e.GetListSourceFieldValue("Database_ID").ToString()); //var database1 = Common.ApplicationDS.Databases.Where(db => db.ID == database_ID).First(); //var instance1 = Common.ApplicationDS.Instances.Where(ins => ins.ID == database1.Instance_ID).First(); //e.Value = instance1.IsSecurityZoneNull() ? "" : instance1.SecurityZone; //e.Value = instance1.SecurityZone; } else { // TODO(crhodes): Who is sending us here> } break; case "SnapShotErrorIndicator": if (e.GetListSourceFieldValue("Instance_ID") != null) { //instance_ID = Guid.Parse(e.GetListSourceFieldValue("Instance_ID").ToString()); //var instance = Common.ApplicationDS.Instances.Where(ins => ins.ID == instance_ID).First(); //string errorMessage = instance.SnapShotError; //if (errorMessage.Length > 0) //{ // if (errorMessage.Equals("Connection Failure Exception")) // { // e.Value = GetImage("OrangeBall.png"); // } // else // { // e.Value = GetImage("RedBall.png"); // } //} //else //{ // e.Value = GetImage("GreenBall.png"); //} } else { // TODO(crhodes): Who is sending us here> } break; case "Total_DB_Data": if (e.GetListSourceFieldValue("ID") != null) { //instance_ID = Guid.Parse(e.GetListSourceFieldValue("ID").ToString()); //var instance = Common.ApplicationDS.Instances.Where(ins => ins.ID == instance_ID).First(); //var calculation = Common.ApplicationDS.Databases // .Where(inst => inst.Instance_ID == instance_ID) // .Select(inst => inst.DataSpaceUsage) // .Sum(); //e.Value = calculation.ToString(); } else { // TODO(crhodes): Who is sending us here> } break; case "Total_DB_Index": if (e.GetListSourceFieldValue("ID") != null) { //instance_ID = Guid.Parse(e.GetListSourceFieldValue("ID").ToString()); //var instance = Common.ApplicationDS.Instances.Where(ins => ins.ID == instance_ID).First(); //var calculation = Common.ApplicationDS.Databases // .Where(inst => inst.Instance_ID == instance_ID) // .Select(inst => inst.IndexSpaceUsage) // .Sum(); //e.Value = calculation.ToString(); } else { // TODO(crhodes): Who is sending us here> } break; case "Total_DB_Size": if (e.GetListSourceFieldValue("ID") != null) { //instance_ID = Guid.Parse(e.GetListSourceFieldValue("ID").ToString()); //var instance = Common.ApplicationDS.Instances.Where(ins => ins.ID == instance_ID).First(); //var calculation = Common.ApplicationDS.Databases // .Where(inst => inst.Instance_ID == instance_ID) // .Select(inst => inst.Size) // .Sum(); //e.Value = calculation.ToString(); } else { // TODO(crhodes): Who is sending us here> } break; case "Total_DB_SpaceAvailable": if (e.GetListSourceFieldValue("ID") != null) { //instance_ID = Guid.Parse(e.GetListSourceFieldValue("ID").ToString()); //var instance = Common.ApplicationDS.Instances.Where(ins => ins.ID == instance_ID).First(); //var calculation = Common.ApplicationDS.Databases // .Where(inst => inst.Instance_ID == instance_ID) // .Select(inst => inst.SpaceAvailable) // .Sum(); //e.Value = calculation.ToString(); } else { // TODO(crhodes): Who is sending us here> } break; } } }
public override void ReadValue(GridControl gridControl, GridColumnDataEventArgs e) { e.Value = Convert(e.GetListSourceFieldValue(FieldName)); }
// CustomUnboundColumnData Event for BrandAxe GridControl private void grdBrandAxes_CustomUnboundColumnData(object sender, GridColumnDataEventArgs e) { Guid id = (Guid)e.GetListSourceFieldValue("ID"); if (e.Column.FieldName == "AddBrand") { if (e.IsGetData) { e.Value = GetIsSelected(id); } if (e.IsSetData) { SetIsSelected(id, (bool)e.Value); if (chkSelectAll.IsChecked == true && selectedBrands.Count != BrandAxeData.Count) chkSelectAll.IsChecked = null; if (chkSelectAll.IsChecked == false && selectedBrands.Count != BrandAxeData.Count) chkSelectAll.IsChecked = null; } } else if (e.Column.FieldName == "RetailSales") { if (e.IsGetData) { e.Value = Math.Round(GetRetailSales(id)); } } }
private void grdRetailSales_CustomUnboundColumnData(object sender, GridColumnDataEventArgs e) { if (e.Column.FieldName == "BrandAxe.Name") { if (e.IsGetData) { Guid idBrandAxe = (Guid)e.GetListSourceFieldValue("IDBrandAxe"); e.Value = BrandAxeData.Single(b => b.ID == idBrandAxe).Name; } } else if (e.Column.FieldName == "RetailSales") { if (e.IsGetData) { Guid idBrandAxe = (Guid)e.GetListSourceFieldValue("IDBrandAxe"); DateTime monthDate = (DateTime)e.GetListSourceFieldValue("Date"); retailSalesToAdd[e.ListSourceRowIndex].RetailSalesFromBenchmark = Math.Round(GetRetailSaleForBrandAxeFromBenchmark(monthDate, idBrandAxe)); e.Value = Math.Round(retailSalesToAdd[e.ListSourceRowIndex].RetailSalesFromBenchmark); } } }