public CREATE_OFF_DAY(List <int> lstIDNhanVienNgayNghi) { this.lstIDNhanVienNgayNghi = lstIDNhanVienNgayNghi; data = new TinhTienLuongEntities(); InitializeComponent(); this.btnCapNhat.Show(); this.btnTaoNgay.Hide(); this.txtSearchBar.Enabled = false; this.btnSearch.Enabled = false; this.listTitleOFFDay = data.fnDisplayTitleOFFDay().ToList(); this.TitleOFFDay.DataSource = this.listTitleOFFDay; this.TitleOFFDay.DisplayMember = "TenNgayNghi"; this.TitleOFFDay.ValueMember = "ID"; //Show info staff on datagridview int i = 1; foreach (int id in lstIDNhanVienNgayNghi) { this.bunifuCustomDataGrid1.Rows.Add(true, i, data.NHANSUs.Find(data.NHANVIEN_LOAINGAYNGHI.Find(id).ID_NhanVien).UserName, data.NHANSUs.Find(data.NHANVIEN_LOAINGAYNGHI.Find(id).ID_NhanVien).HoVaTen, data.NHANSUs.Find(data.NHANVIEN_LOAINGAYNGHI.Find(id).ID_NhanVien).SoNgayNghiPhep ); this.bunifuCustomDataGrid1.DefaultCellStyle.ForeColor = Color.FromArgb(64, 64, 64); this.lstIDNhanVien.Add((int)data.NHANVIEN_LOAINGAYNGHI.Find(id).ID_NhanVien); i++; } //Khi fill data vao form phải fill TitleOFFDay trước vì TitleOFFDay có sự kiện text change //khi tiltleOFFDay được lựa chọn nó sẽ làm thay đổi các thông tin đã nhập trước đó this.TitleOFFDay.SelectedValue = data.NHANVIEN_LOAINGAYNGHI.Find(lstIDNhanVienNgayNghi[0]).ID_LoaiNgayNghi; this.txtNgayKetThuc.Value = data.NHANVIEN_LOAINGAYNGHI.Find(lstIDNhanVienNgayNghi[0]).NgayKetThuc.GetValueOrDefault(); this.txtNgayBatDau.Value = data.NHANVIEN_LOAINGAYNGHI.Find(lstIDNhanVienNgayNghi[0]).NgayBatDau.GetValueOrDefault(); if (data.LOAINGAYNGHIs.Find(data.NHANVIEN_LOAINGAYNGHI.Find(lstIDNhanVienNgayNghi[0]).ID_LoaiNgayNghi.GetValueOrDefault()).LoaiNgayNghi1.Replace(" ", "") == "CoPhep") { this.TypeOFFDay.SetSelected(0, true); } else { this.TypeOFFDay.SetSelected(1, true); } this.txtNameOfOFFDay.Text = data.NHANVIEN_LOAINGAYNGHI.Find(lstIDNhanVienNgayNghi[0]).LyDo; if ((data.NHANVIEN_LOAINGAYNGHI.Find(lstIDNhanVienNgayNghi[0]).NgayBatDau.GetValueOrDefault().Minute != 00 && data.NHANVIEN_LOAINGAYNGHI.Find(lstIDNhanVienNgayNghi[0]).NgayBatDau.GetValueOrDefault().Hour != 00) || (data.NHANVIEN_LOAINGAYNGHI.Find(lstIDNhanVienNgayNghi[0]).NgayKetThuc.GetValueOrDefault().Minute != 00 && data.NHANVIEN_LOAINGAYNGHI.Find(lstIDNhanVienNgayNghi[0]).NgayKetThuc.GetValueOrDefault().Hour != 00)) { this.checkBoxOFFAllDay.Checked = false; } else { this.checkBoxOFFAllDay.Checked = true; } }
public CREATE_OFF_DAY() { InitializeComponent(); this.btnTaoNgay.Show(); this.btnCapNhat.Hide(); data = new TinhTienLuongEntities(); this.listTitleOFFDay = data.fnDisplayTitleOFFDay().ToList(); this.TitleOFFDay.DataSource = data.LOAINGAYNGHIs.ToList(); this.TitleOFFDay.DisplayMember = "TenNgayNghi"; this.TitleOFFDay.ValueMember = "ID"; ShowInfoEmployee(); }
public Payroll(int IDNhanVien, DateTime ThangNam) { this.data = new TinhTienLuongEntities(); this.ID_NhanVien = IDNhanVien; this.ThangNam = ThangNam; NHANSU staff = data.NHANSUs.Find(this.ID_NhanVien); if (staff != null && staff.ID <= 10) { Calculate val = new Calculate(); this.Wfh = val.CALCULATE(("OTH_33").Split(' '), ID_NhanVien, ThangNam); this.AtWork = val.CALCULATE(("OTH_32").Split(' '), ID_NhanVien, ThangNam); this.LeaveHours = val.CALCULATE(("OTH_32").Split(' '), ID_NhanVien, ThangNam); this.Km = val.CALCULATE(("OTH_37").Split(' '), ID_NhanVien, ThangNam); this.SalaryBasic = val.CALCULATE(("OTH_34").Split(' '), ID_NhanVien, ThangNam); this.OTSalary = val.CALCULATE(("OTH_13").Split(' '), ID_NhanVien, ThangNam); this.Responsi_Japanese = val.CALCULATE(("OTH_3").Split(' '), ID_NhanVien, ThangNam); this.Parking_Gasoline = val.CALCULATE(("OTH_2").Split(' '), ID_NhanVien, ThangNam); this.BenefitWFH = val.CALCULATE(("OTH_1").Split(' '), ID_NhanVien, ThangNam); this.SalaryDeduction = val.CALCULATE(("OTH_5").Split(' '), ID_NhanVien, ThangNam); this.TotalAmount = val.CALCULATE(("OTH_6").Split(' '), ID_NhanVien, ThangNam); this.TotalAmountInVND = val.CALCULATE(("OTH_7").Split(' '), ID_NhanVien, ThangNam); this.SalaryForInsurance = val.CALCULATE(("OTH_17").Split(' '), ID_NhanVien, ThangNam); this.SalaryForUnemployted = val.CALCULATE(("OTH_18").Split(' '), ID_NhanVien, ThangNam); this.HealthyInsuranceStaff = val.CALCULATE(("OTH_19").Split(' '), ID_NhanVien, ThangNam); this.SocialInsuranceStaff = val.CALCULATE(("OTH_20").Split(' '), ID_NhanVien, ThangNam); this.UnemploytedInsuranceStaff = val.CALCULATE(("OTH_21").Split(' '), ID_NhanVien, ThangNam); this.UnemploytedInsuranceEnterprise = val.CALCULATE(("OTH_22").Split(' '), ID_NhanVien, ThangNam); this.HealthyInsuranceEnterprise = val.CALCULATE(("OTH_23").Split(' '), ID_NhanVien, ThangNam); this.SocialInsuranceEnterprise = val.CALCULATE(("OTH_24").Split(' '), ID_NhanVien, ThangNam); this.OTDeduction = val.CALCULATE(("OTH_16").Split(' '), ID_NhanVien, ThangNam); this.PersonalDeduction = val.CALCULATE(("OTH_27").Split(' '), ID_NhanVien, ThangNam); this.AmountDependentPersonalDeduction = val.CALCULATE(("OTH_28").Split(' '), ID_NhanVien, ThangNam); this.TaxableIncome = val.CALCULATE(("OTH_29").Split(' '), ID_NhanVien, ThangNam); this.PITPayment = val.CALCULATE(("OTH_30").Split(' '), ID_NhanVien, ThangNam); } }
public void LoadData() { TinhTienLuongEntities data = new TinhTienLuongEntities(); lsttTitleWorkingHours.DataSource = data.LOAI_GIO_CONG.ToList(); lsttTitleWorkingHours.DisplayMember = "LoaiGioCong"; lsttTitleWorkingHours.ValueMember = "ID"; lstbTitleOFFDAYS.DataSource = data.LOAINGAYNGHIs.ToList(); lstbTitleOFFDAYS.DisplayMember = "TenNgayNghi"; lstbTitleOFFDAYS.ValueMember = "ID"; List <TYPE_RANGE_HOURS_OT> lstOT = data.TYPE_RANGE_HOURS_OT.ToList(); if (lstOT.Count != 0) { for (int i = 0; i < lstOT.Count; i++) { this.bunifuCustomDataGrid1.Rows.Add(i + 1, lstOT[i].RangeHours, lstOT[i].PercentAmountOT.HasValue ? lstOT[i].PercentAmountOT.Value : 0); } } }