/
ManageOvertime.xaml.cs
104 lines (92 loc) · 3.58 KB
/
ManageOvertime.xaml.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
using DMSIPayroll.Model;
using MahApps.Metro.Controls;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
namespace DMSIPayroll
{
/// <summary>
/// Interaction logic for ManageOvertime.xaml
/// </summary>
public partial class ManageOvertime : MetroWindow
{
List<DMSIClass._Overtime> lOvertime = new List<DMSIClass._Overtime>();
public int empid;
public ManageOvertime()
{
InitializeComponent();
}
private void GetOvertime()
{
try
{
using (var db = new DMSIPayrollEntities())
{
var overtimes = db.Overtimes.Where(m => m.EmployeID == empid).ToList();
lOvertime = new List<DMSIClass._Overtime>();
foreach (var x in overtimes)
{
DMSIClass._Overtime overtime = new DMSIClass._Overtime();
var overtimetype = db.OvertimeTypes.Where(m => m.OvertimeTypeID == x.OvertimeTypeID).FirstOrDefault();
var emp = db.Employees.Where(m => m.EmployeeID == x.EmployeID).FirstOrDefault();
var position = db.EmployeePositions.Where(m => m.EmployeePositionID == emp.EmployeePositionID).FirstOrDefault();
overtime.OvertimeType = overtimetype.Description;
overtime.OvertimeID = x.OvertimeID;
overtime.OvertimePeriod = x.StDate.ToShortDateString() + " - " + x.ToDate.ToShortDateString();
overtime.Value = x.Value;
overtime.PayrollDate = x.PayrollDate;
overtime.Amount = x.Amount;
overtime.HourlyRate = position.DailyRate / 8;
lOvertime.Add(overtime);
}
datagridview.ItemsSource = lOvertime.OrderByDescending(m => m.OvertimeID);
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
{
GetOvertime();
}
private void button_Click(object sender, RoutedEventArgs e)
{
AddOvertime addOvertime = new AddOvertime();
addOvertime.mode = 1;
addOvertime.empid = empid;
addOvertime.Show();
}
private void btnRefresh_Click(object sender, RoutedEventArgs e)
{
GetOvertime();
}
private void edit_Click(object sender, RoutedEventArgs e)
{
var x = ((DMSIClass._Overtime)datagridview.SelectedItem);
AddOvertime addOvertime = new AddOvertime();
addOvertime.overtimeid = x.OvertimeID;
addOvertime.mode = 2;
addOvertime.empid = empid;
addOvertime.Show();
}
private void datagridview_LoadingRow(object sender, DataGridRowEventArgs e)
{
//if (Convert.ToInt32(((DMSIClass._Overtime)(e.Row.DataContext)).PayrollID) == 0)
//{
// e.Row.Background = new SolidColorBrush(Color.FromRgb(127, 140, 141));
//}
}
}
}