public void LoadData()
{
if (this.searchBar.Text == "" || this.searchBar.Text == null)
{
lstStaffOT = data.fnDisplayOT_AmountOTStaffOfMonth("", this.MonthYear.Value).ToList();
}
else
{
lstStaffOT = data.fnDisplayOT_AmountOTStaffOfMonth(this.searchBar.Text, this.MonthYear.Value).ToList();
}
this.bunifuCustomDataGrid1.Rows.Clear();
for (int i = 0; i < this.lstStaffOT.Count; i++)
{
this.bunifuCustomDataGrid1.Rows.Add(i + 1,
this.lstStaffOT[i].HoVaTen,
(this.lstStaffOT[i].C17h___21h.HasValue) ? this.lstStaffOT[i].C17h___21h.Value.ToString() : "0",
(this.lstStaffOT[i].C21h___5h.HasValue) ? this.lstStaffOT[i].C21h___5h.Value.ToString() : "0",
(this.lstStaffOT[i].Saturday___Sunday.HasValue) ? this.lstStaffOT[i].Saturday___Sunday.Value.ToString() : "0",
(this.lstStaffOT[i].Total_hours.HasValue) ? this.lstStaffOT[i].Total_hours.Value.ToString() : "0",
(this.lstStaffOT[i].Amount_17h___21h.HasValue) ? this.lstStaffOT[i].Amount_17h___21h.Value.ToString("#,##0") : "0",
(this.lstStaffOT[i].Amount_21h___5h.HasValue) ? this.lstStaffOT[i].Amount_21h___5h.Value.ToString("#,##0") : "0",
(this.lstStaffOT[i].Amount_Saturday___Sunday.HasValue) ? this.lstStaffOT[i].Amount_Saturday___Sunday.Value.ToString("#,##0") : "0",
(this.lstStaffOT[i].TotalWithoutTax.HasValue) ? this.lstStaffOT[i].TotalWithoutTax.Value.ToString("#,##0") : "0",
(this.lstStaffOT[i].Tax.HasValue) ? this.lstStaffOT[i].Tax.Value.ToString("#,##0") : "0",
(this.lstStaffOT[i].TotalAmountWithTax.HasValue) ? this.lstStaffOT[i].TotalAmountWithTax.Value.ToString("#,##0") : "0");
}
if (lstStaffOT.Count == 0)
{
this.lbNoData.Show();
}
else
{
this.lbNoData.Hide();
}
}
private void LoadData()
{
StringBuilder queryRangeTimeOT = new StringBuilder();
queryRangeTimeOT.Append("SELECT");
queryRangeTimeOT.Append(" * ");
queryRangeTimeOT.Append("FROM");
queryRangeTimeOT.Append(" TYPE_RANGE_HOURS_OT ");
this.RangeTimeOT.DataSource = data.TYPE_RANGE_HOURS_OT.SqlQuery(queryRangeTimeOT.ToString()).ToList();
this.RangeTimeOT.DisplayMember = "RangeHours";
this.RangeTimeOT.ValueMember = "ID";
StringBuilder queryStaffOT = new StringBuilder();
queryStaffOT.Append("SELECT");
queryStaffOT.Append(" *");
queryStaffOT.Append("FROM");
queryStaffOT.Append(" NHANVIEN_OT ");
queryStaffOT.Append("WHERE");
queryStaffOT.Append(" ID_NhanVien = " + this.ID);
queryStaffOT.Append(" AND ");
queryStaffOT.Append(" MONTH(DateDangKy) = " + this.dateSelected.Month);
queryStaffOT.Append(" AND ");
queryStaffOT.Append(" YEAR(DateDangKy) = " + this.dateSelected.Year);
lstDateOTOfStaffInMonth = data.NHANVIEN_OT.SqlQuery(queryStaffOT.ToString()).ToList();
this.lbName.Text = data.NHANSUs.Find(this.ID).HoVaTen;
this.lbUserName.Text = data.NHANSUs.Find(this.ID).UserName;
this.lbMonth.Text = this.dateSelected.ToString("MM - yyyy");
this.lbTotalOTInMonth.Text = (data.fnDisplayOT_AmountOTStaffOfMonth(data.NHANSUs.Find(this.ID).HoVaTen, this.dateSelected).FirstOrDefault().Total_hours.HasValue) ?
data.fnDisplayOT_AmountOTStaffOfMonth(data.NHANSUs.Find(this.ID).HoVaTen, this.dateSelected).FirstOrDefault().Total_hours.Value.ToString("#,##0") : "0";
this.lbAmountOTWithoutTax.Text = (data.fnDisplayOT_AmountOTStaffOfMonth(data.NHANSUs.Find(this.ID).HoVaTen, this.dateSelected).FirstOrDefault().TotalWithoutTax.HasValue) ?
data.fnDisplayOT_AmountOTStaffOfMonth(data.NHANSUs.Find(this.ID).HoVaTen, this.dateSelected).FirstOrDefault().TotalWithoutTax.Value.ToString("#,##0") : "0";
this.lbTax.Text = (data.fnDisplayOT_AmountOTStaffOfMonth(data.NHANSUs.Find(this.ID).HoVaTen, this.dateSelected).FirstOrDefault().Tax.HasValue) ?
data.fnDisplayOT_AmountOTStaffOfMonth(data.NHANSUs.Find(this.ID).HoVaTen, this.dateSelected).FirstOrDefault().Tax.Value.ToString("#,##0") : "0";
this.lbAmountOTWithTax.Text = (data.fnDisplayOT_AmountOTStaffOfMonth(data.NHANSUs.Find(this.ID).HoVaTen, this.dateSelected).FirstOrDefault().TotalAmountWithTax.HasValue) ?
data.fnDisplayOT_AmountOTStaffOfMonth(data.NHANSUs.Find(this.ID).HoVaTen, this.dateSelected).FirstOrDefault().TotalAmountWithTax.Value.ToString("#,##0") : "0";
this.bunifuCustomDataGrid1.Rows.Clear();
for (int i = 0; i < lstDateOTOfStaffInMonth.Count; i++)
{
this.bunifuCustomDataGrid1.Rows.Add(i + 1,
lstDateOTOfStaffInMonth[i].TYPE_RANGE_HOURS_OT.ID,
lstDateOTOfStaffInMonth[i].SoGioOT,
lstDateOTOfStaffInMonth[i].DateDangKy.ToString("dd - MM - yyyy"));
}
if (lstDateOTOfStaffInMonth.Count == 0)
{
this.lbNoData.Show();
}
else
{
this.lbNoData.Hide();
}
}
