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