public FW_File(File file)
{
InitializeComponent();
this.Loaded += new RoutedEventHandler(EV_Start);
this.file = file;
db = new AgileManagerDB();
reports = db.Reports.Where(r => r.FileID == file.FileID).Include(r => r.employee).ToList();
interventions = db.Interventions.Where(r => r.FileID == file.FileID).Include(i => i.employee).ToList();
FrameWorkDB.V1.Application app = db.Applications.First(a => a.ApplicationID == file.license.ApplicationID);
TX_License1.Text = app.Name;
TX_License2.Text = $"Versión {app.Version}";
TX_License4.Text = $"Fin mantenimiento {String.Format("{0:dd/MM/yyyy}", file.license.DateEnd)}";
if (file.employee != null)
{
TB_Employee.Text = $"{file.employee.Code} - {file.employee.Name}";
}
TB_State.Text = $"{file.state.Name}";
TB_DateStart.Text = $"{String.Format("{0:dd/MM/yyyy}", file.DateStart)}";
TB_DateEnd.Text = $"{String.Format("{0:dd/MM/yyyy}", file.DateEnd)}";
TB_Issue.Text = $"{file.issue.Name}";
TB_Priority.Text = $"{file.priority.Name}";
}
public void UpdateTable()
{
switch (mode)
{
case 1:
files = db.Files.Where(f => f.StateID == 1 && (f.license.application.DepartmentID == ((MainWindow)System.Windows.Application.Current.MainWindow).employee.DepartmentID || f.EmployeeID == ((MainWindow)System.Windows.Application.Current.MainWindow).employee.EmployeeID || f.EmployeeID == null)).Include(f => f.client).Include(f => f.priority).Include(f => f.issue).Include(f => f.license.application).ToList();
break;
case 3:
files = db.Files.Where(f => (f.StateID == 3 && (f.license.application.DepartmentID == ((MainWindow)System.Windows.Application.Current.MainWindow).employee.DepartmentID || f.EmployeeID == ((MainWindow)System.Windows.Application.Current.MainWindow).employee.EmployeeID)))
.Include(f => f.client).Include(f => f.priority).Include(f => f.issue).ToList();
break;
case 5:
files = db.Files.Where(f => (f.StateID == 5 && (f.license.application.DepartmentID == ((MainWindow)System.Windows.Application.Current.MainWindow).employee.DepartmentID || f.EmployeeID == ((MainWindow)System.Windows.Application.Current.MainWindow).employee.EmployeeID)))
.Include(f => f.client).Include(f => f.priority).Include(f => f.issue).ToList();
break;
case 11:
files = db.Files.Where(f => (f.ClientID == client.ClientID))
.Include(f => f.client).Include(f => f.priority).Include(f => f.issue)
.Include(f => f.license).Include(f => f.employee).Include(f => f.state).ToList();
break;
default:
files = db.Files.Include(f => f.client).ToList();
break;
}
dt.Clear();
foreach (File item in files)
{
switch (mode)
{
case 1:
dt.Rows.Add(item.FileID, item.Code, $"{item.client.Code} {item.client.Name} ({item.license.application.Name})",
$"{String.Format("{0:dd/MM/yyyy}", item.DateStart)}", item.priority.Name, item.issue.Name);
break;
case 3:
dt.Rows.Add(item.FileID, item.Code, $"{item.client.Code} {item.client.Name}",
$"{String.Format("{0:dd/MM/yyyy}", item.DateStart)}", item.priority.Name, item.issue.Name);
break;
case 5:
dt.Rows.Add(item.FileID, item.Code, $"{item.client.Code} {item.client.Name}",
$"{String.Format("{0:dd/MM/yyyy}", item.DateStart)}", $"{String.Format("{0:dd/MM/yyyy}", item.DateEnd)}", item.priority.Name, item.issue.Name);
break;
case 11:
FrameWorkDB.V1.Application app = db.Applications.First(a => a.ApplicationID == item.license.ApplicationID);
if (item.employee != null)
{
dt.Rows.Add(item.FileID, item.Code, $"{item.license.Code} {app.Name} {app.Version}", $"{item.employee.Code} {item.employee.Name}",
$"{String.Format("{0:dd/MM/yyyy}", item.DateStart)}", $"{String.Format("{0:dd/MM/yyyy}", item.DateEnd)}",
item.state.Name, item.priority.Name, item.issue.Name);
}
else
{
dt.Rows.Add(item.FileID, item.Code, $"{item.license.Code} {app.Name} {app.Version}", $"",
$"{String.Format("{0:dd/MM/yyyy}", item.DateStart)}", $"{String.Format("{0:dd/MM/yyyy}", item.DateEnd)}", item.priority.Name, item.issue.Name);
}
break;
default:
dt.Rows.Add(item.FileID, item.Code, $"{item.client.Code} {item.client.Name}",
$"{String.Format("{0:dd/MM/yyyy}", item.DateStart)}", item.priority.Name, item.issue.Name);
break;
}
}
}