/
ManageHoliday.xaml.cs
104 lines (92 loc) · 3.55 KB
/
ManageHoliday.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 ManageHoliday.xaml
/// </summary>
public partial class ManageHoliday : MetroWindow
{
List<DMSIClass._Holiday> lHoliday = new List<DMSIClass._Holiday>();
public int empid;
public ManageHoliday()
{
InitializeComponent();
}
private void GetHoliday()
{
try
{
using (var db = new DMSIPayrollEntities())
{
var holidays = db.Holidays.Where(m=>m.EmployeeID == empid).ToList();
lHoliday = new List<DMSIClass._Holiday>();
foreach (var x in holidays)
{
DMSIClass._Holiday holiday = new DMSIClass._Holiday();
var holidaytype = db.HolidayTypes.Where(m => m.HolidayTypeID == x.HolidayTypeID).FirstOrDefault();
var emp = db.Employees.Where(m => m.EmployeeID == x.EmployeeID).FirstOrDefault();
var position = db.EmployeePositions.Where(m => m.EmployeePositionID == emp.EmployeePositionID).FirstOrDefault();
holiday.HolidayType = holidaytype.Description;
holiday.HolidayID = x.HolidayID;
holiday.HolidayPeriod = x.StDate.ToShortDateString() + " - " + x.ToDate.ToShortDateString();
holiday.NoOfDays = x.NoOfDays;
holiday.PayrollDate = x.PayrollDate;
holiday.Amount = x.Amount;
holiday.DailyRate = position.DailyRate;
lHoliday.Add(holiday);
}
datagridview.ItemsSource = lHoliday.OrderByDescending(m=>m.HolidayID);
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
{
GetHoliday();
}
private void button_Click(object sender, RoutedEventArgs e)
{
AddHoliday addHoliday = new AddHoliday();
addHoliday.mode = 1;
addHoliday.empid = empid;
addHoliday.Show();
}
private void btnRefresh_Click(object sender, RoutedEventArgs e)
{
GetHoliday();
}
private void edit_Click(object sender, RoutedEventArgs e)
{
var x = ((DMSIClass._Holiday)datagridview.SelectedItem);
AddHoliday addHoliday = new AddHoliday();
addHoliday.holidayid = x.HolidayID;
addHoliday.mode = 2;
addHoliday.empid = empid;
addHoliday.Show();
}
private void datagridview_LoadingRow(object sender, DataGridRowEventArgs e)
{
//if (Convert.ToInt32(((DMSIClass._Adjustment)(e.Row.DataContext)).PayrollID) == 0)
//{
// e.Row.Background = new SolidColorBrush(Color.FromRgb(127, 140, 141));
//}
}
}
}