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 FW_Clients(int mode)
{
InitializeComponent();
this.Loaded += new RoutedEventHandler(EV_Start);
db = new AgileManagerDB();
viewClients = new Model.VW_Clients();
this.mode = mode;
DG_Clients.MouseLeftButtonUp += new MouseButtonEventHandler(ClientSelected_Event);
DG_Clients.MouseDoubleClick += new MouseButtonEventHandler(EV_ClientOpen);
}
private void EV_Start(object sender, RoutedEventArgs e)
{
db = new AgileManagerDB();
employee = new Employee();
List <Employee> employees = db.Employees.OrderBy(emp => emp.Code).ToList();
foreach (Employee emp in employees)
{
ComboBoxItem temp = new ComboBoxItem();
temp.Content = $"{emp.Code} - {emp.Name}";
temp.Name = $"employee{emp.EmployeeID}";
CB_User.Items.Add(temp);
}
}
public void UpdateTable(AgileManagerDB db)
{
clients = db.Clients.Include(c => c.dealer).ToList();
dt.Clear();
foreach (Client item in clients)
{
if (item.dealer != null)
{
dt.Rows.Add(item.ClientID, item.Code, item.Name, item.dealer.Name);
}
else
{
dt.Rows.Add(item.ClientID, item.Code, item.Name, "");
}
}
}
public WorkingBoardController()
{
InitializeComponent();
db = new AgileManagerDB();
Information = new Dictionary <string, int>();
Information.Add("mode", 1);
Information.Add("oldmode", 1);
Information.Add("controller", 0);
Information.Add("oldcontroller", 0);
Information.Add("option", 2);
if (db.Files.Where(f => f.state.Name == "En Progreso" && f.EmployeeID == ((MainWindow)System.Windows.Application.Current.MainWindow).employee.EmployeeID).ToList().Count > 0)
{
fileInProgress = db.Files.Last(f => f.state.Name == "En Progreso" && f.EmployeeID == ((MainWindow)System.Windows.Application.Current.MainWindow).employee.EmployeeID);
}
this.Loaded += new RoutedEventHandler(EV_Start);
}
public WB_NewFileController(Client client)
{
InitializeComponent();
Information = new Dictionary <string, int>();
Information.Add("mode", 2);
Information.Add("oldmode", 2);
Information.Add("controller", 0);
Information.Add("oldcontroller", 0);
Information.Add("option", 3);
db = new AgileManagerDB();
file = new File();
file.client = client;
file.ClientID = client.ClientID;
reports = new List <Report>();
interventions = new List <Intervention>();
reports.Add(new Report
{
Date = DateTime.Now,
EmployeeID = ((MainWindow)System.Windows.Application.Current.MainWindow).employee.EmployeeID,
file = file,
Description = ""
});
interventions.Add(new Intervention
{
Date = DateTime.Now,
EmployeeID = ((MainWindow)System.Windows.Application.Current.MainWindow).employee.EmployeeID,
file = file,
Description = ""
});
licenses = db.Licenses.Where(c => c.ClientID == client.ClientID).Include(c => c.application).ToList();
dealer = client.dealer;
this.Loaded += new RoutedEventHandler(EV_Start);
}
public WB_WorkFileController(File file)
{
InitializeComponent();
Information = new Dictionary <string, int>();
Information.Add("mode", 3);
Information.Add("oldmode", 3);
Information.Add("controller", 0);
Information.Add("oldcontroller", 0);
Information.Add("option", 4);
db = new AgileManagerDB();
this.file = new File();
this.file = db.Files.Where(f => f.FileID == file.FileID)
.Include(f => f.client).Include(f => f.client.dealer).Include(f => f.priority)
.Include(f => f.issue).Include(f => f.employee).First();
reports = db.Reports.Where(r => r.FileID == file.FileID).ToList();
reports.Add(new Report
{
Date = DateTime.Now,
EmployeeID = ((MainWindow)System.Windows.Application.Current.MainWindow).employee.EmployeeID,
FileID = file.FileID
});
interventions = db.Interventions.Where(r => r.FileID == file.FileID).ToList();
interventions.Add(new Intervention
{
Date = DateTime.Now,
EmployeeID = ((MainWindow)System.Windows.Application.Current.MainWindow).employee.EmployeeID,
FileID = file.FileID,
Description = ""
});
licenses = db.Licenses.Where(c => c.ClientID == this.file.client.ClientID).Include(c => c.application).ToList();
dealer = this.file.client.dealer;
this.Loaded += new RoutedEventHandler(EV_Start);
}
public VW_Lines()
{
db = new AgileManagerDB();
employees = db.Employees.Where(e => e.DepartmentID == ((MainWindow)System.Windows.Application.Current.MainWindow).employee.DepartmentID).ToList();
}
public IEnumerable GetTable(AgileManagerDB db)
{
UpdateTable(db);
return(dt.DefaultView);
}
public VW_Files(int mode)
{
this.mode = mode;
db = new AgileManagerDB();
dt = new DataTable();
switch (mode)
{
case 1:
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Código", typeof(string));
dt.Columns.Add("Cliente", typeof(string));
dt.Columns.Add("Fecha", typeof(string));
dt.Columns.Add("Prioridad", typeof(string));
dt.Columns.Add("Problema", typeof(string));
break;
case 3:
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Código", typeof(string));
dt.Columns.Add("Cliente", typeof(string));
dt.Columns.Add("Fecha", typeof(string));
dt.Columns.Add("Prioridad", typeof(string));
dt.Columns.Add("Problema", typeof(string));
break;
case 5:
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Código", typeof(string));
dt.Columns.Add("Cliente", typeof(string));
dt.Columns.Add("Fecha Inicio", typeof(string));
dt.Columns.Add("Fecha Finalización", typeof(string));
dt.Columns.Add("Prioridad", typeof(string));
dt.Columns.Add("Problema", typeof(string));
break;
case 11:
Window mainWindow = System.Windows.Application.Current.MainWindow;
var a = (MainWindow)mainWindow;
WorkingBoard.Controller.FileController CT = (WorkingBoard.Controller.FileController)a.MainFrame.Content;;
client = CT.file.client;
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Código", typeof(string));
dt.Columns.Add("Licencia", typeof(string));
dt.Columns.Add("Técnico", typeof(string));
dt.Columns.Add("Fecha Inicio", typeof(string));
dt.Columns.Add("Fecha Finalización", typeof(string));
dt.Columns.Add("Estado", typeof(string));
dt.Columns.Add("Prioridad", typeof(string));
dt.Columns.Add("Problema", typeof(string));
break;
default:
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Código", typeof(string));
dt.Columns.Add("Cliente", typeof(string));
dt.Columns.Add("Fecha", typeof(string));
dt.Columns.Add("Prioridad", typeof(string));
dt.Columns.Add("Problema", typeof(string));
break;
}
}
