private void updateRowChanges()
{
try
{
Employee oldRow = VM.row[0];
Employee newRow = (Employee)RowView.Items[0];
newRow.CalculateIsError();
newRow.IsManuallyChanged = 1;
windowBack.VM.Logs.ToList().ForEach((e) => { if (e.ID == oldRow.ID && e.Date == oldRow.Date)
{
e = newRow;
}
});
VM.inter.UpdateLog(newRow);
windowBack.VM.Emp.logs = (Employee[])windowBack.VM.Logs;
LogsHolder newEmp = windowBack.VM.Emp;
newEmp.CalculateAll();
windowBack.VM.Emp = newEmp;
windowBack.LogsView.ItemsSource = windowBack.VM.Emp.logs;
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("אירעה תקלה בעדכון השורה. אנא צור קשר. " + ex.Message);
}
}
public EmpPrint(LogsHolder holder, string timing, string empName)
{
this.Holder = holder;
this.Timing = timing;
this.EmpName = empName;
InitializeComponent();
this.LogsView.ItemsSource = Holder.logs;
this.TheDate.Content = Timing;
this.TheName.Content = EmpName;
}
public LogsHolder GetLogsByMonthYearAndName(int month, int year, string name)
{
if (month == 0 || year == 0 || name == null)
{
throw new NullReferenceException();
}
try
{
LogsHolder result = null;
if (name != null)
{
Employee[] logs = null;
List <Employee> newLogs = new List <Employee>();
logs = GetLogsByMonthAndYear(month, year);
for (int i = 0; i < logs.Count(); i++)
{
if (logs[i].Name.ToLower() == name.ToLower())
{
newLogs.Add(logs[i]);
}
}
foreach (Employee log in logs)
{
log.CalculateIsError();
}
result = new LogsHolder(newLogs.ToArray());
result.CalculateAll();
}
return(result);
}
catch (Exception ex)
{
if (ex is NullReferenceException)
{
MessageBox.Show("תאריך או עובד לא נבחרו");
}
else
{
MessageBox.Show("אירעה תקלה: " + ex.Message);
}
return(null);
}
}
public LogsHolder GetLogsByEmpName(string name)
{
if (name == null)
{
throw new NullReferenceException();
}
try
{
LogsHolder result = null;
using (MyEntity entity = new MyEntity())
{
List <Employee> logs = new List <Employee>();
logs =
(from Employee in entity.Employees
where Employee.Name.ToLower() == name.ToLower()
orderby Employee.Date ascending
select Employee).ToList();
foreach (Employee log in logs)
{
log.CalculateIsError();
}
result = new LogsHolder(logs.ToArray());
result.CalculateAll();
}
return(result);
}
catch (Exception ex)
{
if (ex is NullReferenceException)
{
MessageBox.Show("לא נבחר עובד.");
}
else
{
MessageBox.Show("אירעה תקלה:" + ex.Message);
}
return(null);
}
}
public LogsForEmpVM(LogsHolder empLogs, UserInterface inter)
{
try
{
this.Emp = empLogs;
EmpName = Emp.logs[0].Name;
string month = Emp.logs[0].Date.Month.ToString();
string year = Emp.logs[0].Date.Year.ToString();
MonthAndYear = $"{month}/{year}";
this.Inter = inter;
this.Logs = emp.logs;
}
catch (Exception ex)
{
MessageBox.Show("תקלה. אנא נסה שנית או צור קשר" + ex.Message);
}
}
public LogsForEmpView(LogsHolder empLogs, UserInterface inter, int year, int month)
{
this.YearSel = year;
this.MonthSel = month;
if (empLogs == null)
{
throw new NullReferenceException("לא נבחר עובד.");
}
else
{
InitializeComponent();
this.inter = inter;
VM = new LogsForEmpVM(empLogs, inter);
this.DataContext = VM;
LogsView.ItemsSource = VM.Logs.ToList();
}
}
private void exportButton_Click(object sender, RoutedEventArgs e)
{
try
{
//choose a path
FolderBrowserDialog f = new FolderBrowserDialog();
f.ShowDialog();
string fileName;
string month;
string year;
if (VM.MonthAndYear.Length > 6)
{
month = VM.MonthAndYear.Substring(0, 2);
year = VM.MonthAndYear.Substring(3);
fileName = $"{month}_{year}";
}
else
{
month = VM.MonthAndYear.Substring(0, 1);
year = VM.MonthAndYear.Substring(2);
fileName = $"{month}_{year}";
}
string path = f.SelectedPath + $"\\{fileName}.xls";
List <LogsHolder> allHolders = new List <LogsHolder>();
for (int i = 0; i < Hidden.EmpList.Items.Count; i++)
{
LogsHolder holder = inter.GetByEmpMonthYear(Convert.ToInt32(month), Convert.ToInt32(year), Hidden.viewModel.Names[i]);
allHolders.Add(holder);
}
inter.Export(allHolders.ToArray(), path, VM.MonthAndYear);
}
catch (Exception ex)
{
MessageBox.Show($"אירעה תקלה בייצוא: {ex.Message}");
}
}
