private void btnFetch_Click(object sender, RoutedEventArgs e)
{
ctx = new RadiographyContext();
busyIndicator.IsBusy = true;
ctx.Load(ctx.GetEnergiesQuery()).Completed += new EventHandler(FilmConsumptionReport_Completed);
}
private void btnFetch_Click(object sender, RoutedEventArgs e)
{
ctx = new RadiographyContext();
busyIndicator.IsBusy = true;
ctx.Load(ctx.GetEnergiesQuery()).Completed += new EventHandler(FilmConsumptionReport_Completed);
}
void FilmConsumptionReport_Completed(object sender, EventArgs e)
{
int foundryId = cmbFoundry.SelectedIndex == -1 ? -1 : ((Foundry)cmbFoundry.SelectedItem).ID;
ctx.Load(ctx.GetFilmConsumptionReportQuery(foundryId, (DateTime)fromDatePicker.SelectedDate,
(DateTime)toDatePicker.SelectedDate)).Completed += loadCompleted;
}
private void loadUsers()
{
busyIndicator.IsBusy = true;
userRegistrationContext.GetUsers(OnLoadUsers, null);
radiologyContext.Load(radiologyContext.GetFoundriesQuery()).Completed += Foundries_Loaded;
radiologyContext.GetRoles(Roles_Loaded, null);
}
/// <summary>
/// when the foundry combo box changed load customer combo box for selected foundry
/// </summary>
/// <param name="sender">The event sender.</param>
/// <param name="e">The event arguments.</param>
private void foundryComboboxSelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (this.roleCombobox.SelectedValue != null)
if (this.roleCombobox.SelectedValue.ToString().ToLower() != "customer")
this.customerCombobox.IsEnabled = false;
radiologyContext.Load(radiologyContext.GetCustomersFilteredQuery(foundryCombobox.SelectedValue.ToString())).Completed += CustomerOfFoundry_Loaded;
}
private void filmSizeLoaded(object sender, EventArgs e)
{
//if checkbox is checked then get all technicians else only selected technician
int technicianId = (bool)cmbAllTechnicians.IsChecked ? -1:
(cmbTechnicians.SelectedIndex == -1 ? -1 : ((Technician)cmbTechnicians.SelectedItem).ID);
ctx.Load(ctx.GetShiftWisePerformanceReportQuery((DateTime)fromDatePicker.SelectedDate,
(DateTime)toDatePicker.SelectedDate, technicianId)).Completed += loadCompleted;
}
private void btnFetch_Click(object sender, RoutedEventArgs e)
{
ctx = new RadiographyContext();
busyIndicator.IsBusy = true;
int foundryId = cmbFoundry.SelectedIndex == -1 ? -1 : ((Foundry)cmbFoundry.SelectedItem).ID;
ctx.Load(ctx.GetRetakeReasonReportsQuery(foundryId, (DateTime?)fromDatePicker.SelectedDate,
(DateTime?)toDatePicker.SelectedDate)).Completed += loadCompleted;
}
private void btnFetch_Click(object sender, RoutedEventArgs e)
{
ctx = new RadiographyContext();
busyIndicator.IsBusy = true;
int foundryId = cmbFoundry.SelectedIndex == -1 ? -1 : ((Foundry)cmbFoundry.SelectedItem).ID;
var coverageId =cmbCoverage.SelectedValue==null?-1: ((Coverage)cmbCoverage.SelectedValue).ID;
ctx.Load(ctx.GetRTStatusQuery(foundryId, (DateTime?)fromDatePicker.SelectedDate,
(DateTime?)toDatePicker.SelectedDate, txtRTNo.Text, txtHeatNo.Text, txtFPNo.Text, coverageId)).Completed += loadCompleted;
}
private void btnFetch_Click(object sender, RoutedEventArgs e)
{
ctx = new RadiographyContext();
busyIndicator.IsBusy = true;
int foundryId = cmbFoundry.SelectedIndex == -1 ? -1 : ((Foundry)cmbFoundry.SelectedItem).ID;
var coverageId = cmbCoverage.SelectedValue == null?-1: ((Coverage)cmbCoverage.SelectedValue).ID;
ctx.Load(ctx.GetRTStatusQuery(foundryId, (DateTime?)fromDatePicker.SelectedDate,
(DateTime?)toDatePicker.SelectedDate, txtRTNo.Text, txtHeatNo.Text, txtFPNo.Text, coverageId)).Completed += loadCompleted;
}
private void btnFetch_Click(object sender, RoutedEventArgs e)
{
ctx = new RadiographyContext();
busyIndicator.IsBusy = true;
int foundryId = cmbFoundry.SelectedIndex == -1 ? -1 : ((Foundry)cmbFoundry.SelectedItem).ID;
int retakeReasonId = cmbRetakeReason.SelectedIndex == -1 ? -1 : ((RetakeReason)cmbRetakeReason.SelectedItem).ID;
ctx.Load(ctx.GetRetakeReasonReportsQuery(foundryId, (DateTime?)fromDatePicker.SelectedDate,
(DateTime?)toDatePicker.SelectedDate, retakeReasonId)).Completed += loadCompleted;
}
private void btnFetch_Click(object sender, RoutedEventArgs e)
{
ctx = new RadiographyContext();
busyIndicator.IsBusy = true;
ctx.Load(ctx.GetFilmSizesQuery()).Completed += filmSizeLoaded;
}
void FilmConsumptionReport_Completed(object sender, EventArgs e)
{
int foundryId = cmbFoundry.SelectedIndex == -1 ? -1 : ((Foundry)cmbFoundry.SelectedItem).ID;
List <FilmConsumptionReportRow> FilmConsumptionReportRowList = new List <FilmConsumptionReportRow>();
EntityQuery <FilmConsumptionReportRow> query = ctx.GetCastingHandledReportQuery(foundryId, (DateTime)fromDatePicker.SelectedDate,
(DateTime)toDatePicker.SelectedDate);
LoadOperation <FilmConsumptionReportRow> loadOp = ctx.Load(query, loadOpN =>
{
foreach (var filmConsumptionReportRow in loadOpN.Entities)
{
FilmConsumptionReportRowList.Add(filmConsumptionReportRow);
}
if (FilmConsumptionReportRowList.Count > 0)
{
reportTable = new DataTable("Report");
var cols = reportTable.Columns;
var rows = reportTable.Rows;
var headerRow = new DataRow();
rows.Add(headerRow);
var subHeaderRow = new DataRow();
rows.Add(subHeaderRow);
AddTextColumn(reportTable, "ReportNo", "Report No");
AddTextColumn(reportTable, "ReportDate", "Report Date");
AddTextColumn(reportTable, "DateOfTest", "Date of Test");
AddTextColumn(reportTable, "RTNo", "RT No");
headerRow["ReportNo"] = "Report No";
headerRow["ReportDate"] = "Report Date";
headerRow["DateOfTest"] = "Date of Test";
headerRow["RTNo"] = "RT No";
subHeaderRow["ReportNo"] = "";
subHeaderRow["ReportDate"] = "";
subHeaderRow["DateOfTest"] = "";
subHeaderRow["RTNo"] = "";
int highestNoOfRepair = FilmConsumptionReportRowList.Select(p => p.ReshootNo).Max();
int rowIndexForFresh = 0;
foreach (var row in ctx.Energies)
{
var colName = "Fresh" + row.Name;
headerRow[colName] = rowIndexForFresh == 0 ? "Fresh " : string.Empty;
AddTextColumn(reportTable, colName, colName);
subHeaderRow[colName] = row.Name;
rowIndexForFresh++;
}
//Repair columns
for (int i = 0; i < highestNoOfRepair; i++)
{
int rowIndex = 0;
foreach (var row in ctx.Energies)
{
var colName = "Repair" + (i + 1) + row.Name;
AddTextColumn(reportTable, colName, colName);
headerRow[colName] = rowIndex == 0 ? "Repair " + (i + 1) : string.Empty;
subHeaderRow[colName] = row.Name;
rowIndex++;
}
}
//Reshoot columns
for (int i = 0; i < highestNoOfRepair; i++)
{
int rowIndex = 0;
foreach (var row in ctx.Energies)
{
var colName = "Reshoot" + (i + 1) + row.Name;
AddTextColumn(reportTable, colName, colName);
headerRow[colName] = rowIndex == 0 ? "Reshoot " + (i + 1) : string.Empty;
subHeaderRow[colName] = row.Name;
rowIndex++;
}
}
//Retake columns
for (int i = 0; i < highestNoOfRepair; i++)
{
int rowIndex = 0;
foreach (var row in ctx.Energies)
{
var colName = "Retake" + (i + 1) + row.Name;
AddTextColumn(reportTable, colName, colName);
headerRow[colName] = rowIndex == 0 ? "Retake " + (i + 1) : string.Empty;
subHeaderRow[colName] = row.Name;
rowIndex++;
}
}
//Retake columns
for (int i = 0; i < highestNoOfRepair; i++)
{
int rowIndex = 0;
foreach (var row in ctx.Energies)
{
var colName = "Checkshot" + (i + 1) + row.Name;
AddTextColumn(reportTable, colName, colName);
headerRow[colName] = rowIndex == 0 ? "Checkshot " + (i + 1) : string.Empty;
subHeaderRow[colName] = row.Name;
rowIndex++;
}
}
int countForInnerLoop = 0;
int noOfInnerLoops = FilmConsumptionReportRowList.Where(p => p.ReshootNo != 0).Count();
List <RGReport> rgReportList = new List <RGReport>();
foreach (var filmConsumptionReportRow in FilmConsumptionReportRowList)
{
if (filmConsumptionReportRow.ReshootNo == 0)
{
}
else
{
EntityQuery <RGReport> queryInner = ctx.GetRGReportsOnRtNoAndReshootNoForReportQuery(filmConsumptionReportRow.RTNo,
(filmConsumptionReportRow.ReshootNo - 1));
LoadOperation <RGReport> loadOpInner = ctx.Load(queryInner, loadOpNInner =>
{
countForInnerLoop++;
foreach (var rgReport in loadOpNInner.Entities)
{
rgReportList.Add(rgReport);
}
if (noOfInnerLoops == countForInnerLoop)
{
foreach (var filmConsumptionReportRowInner in FilmConsumptionReportRowList)
{
string prevReportNo = "";
DataRow dataRow = null;
string prevEnergy = String.Empty;
if (filmConsumptionReportRowInner.ReportNo != prevReportNo)
{
if (filmConsumptionReportRowInner.ReshootNo == 0)
{
dataRow = new DataRow();
dataRow["ReportNo"] = prevReportNo = filmConsumptionReportRowInner.ReportNo; //set prevReportNo for next time
dataRow["ReportDate"] = filmConsumptionReportRowInner.Date;
dataRow["DateOfTest"] = filmConsumptionReportRowInner.DateOfTest;
dataRow["RTNo"] = filmConsumptionReportRowInner.RTNo;
dataRow["FreshCo 60"] = filmConsumptionReportRowInner.AreaInCo;
dataRow["FreshIr 192"] = filmConsumptionReportRowInner.AreaInIr;
rows.Add(dataRow);
}
else
{
RGReport rgReport = rgReportList.Where(p => p.RTNo == filmConsumptionReportRowInner.RTNo &&
p.ReshootNo == (filmConsumptionReportRowInner.ReshootNo - 1)).FirstOrDefault();
float repairAreaCo = 0;
float reshootAreaCo = 0;
float retakeAreaCo = 0;
float checkshotAreaCo = 0;
float repairAreaIr = 0;
float reshootAreaIr = 0;
float retakeAreaIr = 0;
float checkshotAreaIr = 0;
if (rgReport != null)
{
foreach (RGReportRow reportRow in rgReport.RGReportRows)
{
if (reportRow.RemarkID == 1)
{
if (reportRow.EnergyID == 1)
{
repairAreaCo += reportRow.FilmSize.Area * reportRow.FilmCount;
}
else
{
repairAreaIr += reportRow.FilmSize.Area * reportRow.FilmCount;
}
}
else if (reportRow.RemarkID == 3)
{
if (reportRow.EnergyID == 1)
{
reshootAreaCo += reportRow.FilmSize.Area * reportRow.FilmCount;
}
else
{
reshootAreaIr += reportRow.FilmSize.Area * reportRow.FilmCount;
}
}
else if (reportRow.RemarkID == 4)
{
if (reportRow.EnergyID == 1)
{
retakeAreaCo += reportRow.FilmSize.Area * reportRow.FilmCount;
}
else
{
retakeAreaIr += reportRow.FilmSize.Area * reportRow.FilmCount;
}
}
else if (reportRow.RemarkID == 5)
{
if (reportRow.EnergyID == 1)
{
checkshotAreaCo += reportRow.FilmSize.Area * reportRow.FilmCount;
}
else
{
checkshotAreaIr += reportRow.FilmSize.Area * reportRow.FilmCount;
}
}
}
}
dataRow = new DataRow();
dataRow["ReportNo"] = prevReportNo = filmConsumptionReportRowInner.ReportNo; //set prevReportNo for next time
dataRow["ReportDate"] = filmConsumptionReportRowInner.Date;
dataRow["DateOfTest"] = filmConsumptionReportRowInner.DateOfTest;
dataRow["RTNo"] = filmConsumptionReportRowInner.RTNo;
dataRow["FreshCo 60"] = filmConsumptionReportRowInner.AreaInCo;
dataRow["FreshIr 192"] = filmConsumptionReportRowInner.AreaInIr;
foreach (var row in ctx.Energies)
{
if (row.ID == 1)
{
dataRow["Repair" + (filmConsumptionReportRowInner.ReshootNo) + row.Name] = repairAreaCo;
dataRow["Reshoot" + (filmConsumptionReportRowInner.ReshootNo) + row.Name] = reshootAreaCo;
dataRow["Retake" + (filmConsumptionReportRowInner.ReshootNo) + row.Name] = retakeAreaCo;
dataRow["Checkshot" + (filmConsumptionReportRowInner.ReshootNo) + row.Name] = checkshotAreaCo;
}
else if (row.ID == 2)
{
dataRow["Repair" + (filmConsumptionReportRowInner.ReshootNo) + row.Name] = repairAreaIr;
dataRow["Reshoot" + (filmConsumptionReportRowInner.ReshootNo) + row.Name] = reshootAreaIr;
dataRow["Retake" + (filmConsumptionReportRowInner.ReshootNo) + row.Name] = retakeAreaIr;
dataRow["Checkshot" + (filmConsumptionReportRowInner.ReshootNo) + row.Name] = checkshotAreaIr;
rows.Add(dataRow);
}
}
}
}
}
//totals row
var totalRow = new DataRow();
totalRow["FreshCo 60"] = rows.Select(p => (p["FreshCo 60"] as float?) ?? 0).Sum();
totalRow["FreshIr 192"] = rows.Select(p => (p["FreshIr 192"] as float?) ?? 0).Sum();
//Repair columns
for (int i = 0; i < highestNoOfRepair; i++)
{
int rowIndex = 0;
foreach (var row in ctx.Energies)
{
var colName = "Repair" + (i + 1) + row.Name;
totalRow[colName] = rows.Select(p => (p[colName] as float?) ?? 0).Sum();
rowIndex++;
}
}
//Reshoot columns
for (int i = 0; i < highestNoOfRepair; i++)
{
int rowIndex = 0;
foreach (var row in ctx.Energies)
{
var colName = "Reshoot" + (i + 1) + row.Name;
totalRow[colName] = rows.Select(p => (p[colName] as float?) ?? 0).Sum();
rowIndex++;
}
}
//Retake columns
for (int i = 0; i < highestNoOfRepair; i++)
{
int rowIndex = 0;
foreach (var row in ctx.Energies)
{
var colName = "Retake" + (i + 1) + row.Name;
totalRow[colName] = rows.Select(p => (p[colName] as float?) ?? 0).Sum();
rowIndex++;
}
}
//checkshot columns
for (int i = 0; i < highestNoOfRepair; i++)
{
int rowIndex = 0;
foreach (var row in ctx.Energies)
{
var colName = "Checkshot" + (i + 1) + row.Name;
totalRow[colName] = rows.Select(p => (p[colName] as float?) ?? 0).Sum();
rowIndex++;
}
}
rows.Add(totalRow);
var ds = new DataSet("ReportDataSet");
ds.Tables.Add(reportTable);
reportGrid.DataSource = ds;
reportGrid.DataMember = "Report";
reportGrid.DataBind();
busyIndicator.IsBusy = false;
}
}, false);
}
}
if (noOfInnerLoops == 0)
{
DataRow dataRow = null;
foreach (var filmConsumptionReportRowInner in FilmConsumptionReportRowList)
{
dataRow = new DataRow();
dataRow["ReportNo"] = filmConsumptionReportRowInner.ReportNo; //set prevReportNo for next time
dataRow["ReportDate"] = filmConsumptionReportRowInner.Date;
dataRow["DateOfTest"] = filmConsumptionReportRowInner.DateOfTest;
dataRow["RTNo"] = filmConsumptionReportRowInner.RTNo;
dataRow["FreshCo 60"] = filmConsumptionReportRowInner.AreaInCo;
dataRow["FreshIr 192"] = filmConsumptionReportRowInner.AreaInIr;
rows.Add(dataRow);
}
var totalRow = new DataRow();
totalRow["FreshCo 60"] = rows.Select(p => (p["FreshCo 60"] as float?) ?? 0).Sum();
totalRow["FreshIr 192"] = rows.Select(p => (p["FreshIr 192"] as float?) ?? 0).Sum();
rows.Add(totalRow);
var ds = new DataSet("ReportDataSet");
ds.Tables.Add(reportTable);
reportGrid.DataSource = ds;
reportGrid.DataMember = "Report";
reportGrid.DataBind();
busyIndicator.IsBusy = false;
}
}
else
{
var ds = new DataSet("ReportDataSet");
reportTable = new DataTable("Report");
ds.Tables.Add(reportTable);
reportGrid.DataSource = ds;
reportGrid.DataMember = "Report";
reportGrid.DataBind();
MessageBox.Show("No records found!!");
busyIndicator.IsBusy = false;
return;
}
}, false);
}
private void btnFetch_Click(object sender, RoutedEventArgs e)
{
ctx = new RadiographyContext();
busyIndicator.IsBusy = true;
ctx.Load(ctx.GetFixedPatternPerformanceReportQuery(txtFPNo.Text, (bool)chkLike.IsChecked)).Completed += loadCompleted;
}
private void btnFetch_Click(object sender, RoutedEventArgs e)
{
ctx = new RadiographyContext();
busyIndicator.IsBusy = true;
ctx.Load(ctx.GetFixedPatternPerformanceReportQuery(txtFPNo.Text, (bool)chkLike.IsChecked)).Completed += loadCompleted;
}
private void btnFetch_Click(object sender, RoutedEventArgs e)
{
ctx = new RadiographyContext();
busyIndicator.IsBusy = true;
ctx.Load(ctx.GetFilmSizesQuery()).Completed += filmSizeLoaded;
}
