private void btnSearch_Click(object sender, EventArgs e)
{
using (var db = new TailorEntities())
{
var query = db.StaffAttendances.Where(a => a.Date >= dtpFromDate.Value.Date && a.Date <= dtpUntillDate.Value.Date).OrderByDescending(a => a.Date).ToList();
dgvList.Rows.Clear();
foreach (var a in query)
{
dgvList.Rows.Add("", a.StaffCode, a.Staff.NameKh, a.Staff.Gender.Description, a.Date.ToShortDateString(), a.Status, a.Remark);
}
TailorService.GenerateRowNumber(dgvList);
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
using (var context = new TailorEntities())
{
var query = context.Staffs.ToList().Where(s => s.NameKh.Contains(txtSearch.Text.Trim()) || s.Code.ToLower().Contains(txtSearch.Text.Trim().ToLower()) && s.IsActive);
dgvList.Rows.Clear();
foreach (var s in query)
{
dgvList.Rows.Add("", s.Code, s.NameKh, s.Gender.Description, s.DateOfBirth, s.NationalId, s.Phone, s.BasicSalary);
}
TailorService.GenerateRowNumber(dgvList);
}
}
private void txtSeach_TextChanged(object sender, EventArgs e)
{
using (var db = new TailorEntities())
{
var query = db.StaffAttendances.Where(a => a.Staff.NameKh.Contains(txtSeach.Text.Trim()) || a.StaffCode.ToLower().Contains(txtSeach.Text.Trim().ToLower())).OrderByDescending(a => a.Date).ToList();
dgvList.Rows.Clear();
foreach (var a in query)
{
dgvList.Rows.Add("", a.StaffCode, a.Staff.NameKh, a.Staff.Gender.Description, a.Date, a.Status, a.Remark);
}
TailorService.GenerateRowNumber(dgvList);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
using (var db = new TailorEntities())
{
var query = db.Staffs.Where(s => s.IsActive).ToList();
var attendances = db.StaffAttendances.Where(a => a.Date.Month == dtpAttendanceDate.Value.Month).ToList();
foreach (var s in query)
{
int isExist = 0;
foreach (var a in attendances)
{
if (s.Code == a.Staff.Code && a.Date == dtpAttendanceDate.Value.Date)
{
isExist = 1;
}
}
if (isExist == 0)
{
var attendance = new StaffAttendance()
{
StaffCode = s.Code,
Date = dtpAttendanceDate.Value,
Status = "W",
ComputerCode = TailorService.GetComputerCode(),
ComputeTime = TailorService.GetComputerTime()
};
db.StaffAttendances.Add(attendance);
}
}
int action = db.SaveChanges();
if (action >= 1)
{
progressBar1.Value = 100;
lblFinished.Visible = true;
}
}
if (view != null)
{
view.LoadStaffAttendance();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cboCode.SelectedIndex < 0)
{
cboCode.Focus();
error.SetError(cboCode, null);
return;
}
if (cboStaff.SelectedIndex < 0)
{
cboStaff.Focus();
error.SetError(cboStaff, null);
return;
}
if (string.IsNullOrEmpty(txtAmount.Text.Trim()))
{
txtAmount.Focus();
error.SetError(txtAmount, null);
return;
}
using (var db = new TailorEntities())
{
StaffBonu bonus = new StaffBonu()
{
StaffCode = cboStaff.SelectedValue.ToString(),
Date = dtpDate.Value,
Amount = decimal.Parse(txtAmount.Text),
Remark = txtReason.Text,
ComputerCode = TailorService.GetComputerCode(),
ComputeTime = TailorService.GetComputerTime()
};
db.StaffBonus.Add(bonus);
int action = db.SaveChanges();
if (action >= 1)
{
lblFinished.Visible = true;
}
}
}
public void LoadStaffAttendance()
{
using (var db = new TailorEntities())
{
var query = db.StaffAttendances.Where(s => s.Date == DateTime.Today).ToList();
dgvList.Rows.Clear();
foreach (var a in query)
{
dgvList.Rows.Add("", a.StaffCode, a.Staff.NameKh, a.Staff.Gender.Description, a.Date, a.Status, a.Remark);
}
TailorService.GenerateRowNumber(dgvList);
foreach (DataGridViewColumn col in dgvList.Columns)
{
col.SortMode = DataGridViewColumnSortMode.NotSortable;
}
dgvList.Columns[4].DefaultCellStyle.Format = "dd/MM/yyyy";
}
}
public void LoadData()
{
using (var context = new TailorEntities())
{
var query = context.Staffs.Where(s => s.IsActive).ToList();
dgvList.Rows.Clear();
foreach (var s in query)
{
dgvList.Rows.Add("", s.Code, s.NameKh, s.Gender.Description, s.DateOfBirth, s.NationalId, s.Phone, s.BasicSalary);
}
TailorService.GenerateRowNumber(dgvList);
}
//disable sort in datagridview
foreach (DataGridViewColumn col in dgvList.Columns)
{
col.SortMode = DataGridViewColumnSortMode.NotSortable;
}
//format cell with currency
dgvList.Columns[7].DefaultCellStyle.Format = "c";
dgvList.Columns[4].DefaultCellStyle.Format = "dd/MM/yyyy";
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cboCode.SelectedIndex < 0)
{
error.SetError(cboCode, null);
cboCode.Focus();
return;
}
if (cboStaff.SelectedIndex < 0)
{
error.SetError(cboStaff, null);
cboStaff.Focus();
return;
}
if (dtpUntillDate.Value < dtpFromDate.Value)
{
error.SetError(dtpUntillDate, null);
dtpUntillDate.Focus();
return;
}
string status = rbtnA.Checked ? "A" : "P";
DateTime startDate = dtpFromDate.Value;
DateTime endDate = dtpUntillDate.Value;
if (edit)
{
using (var db = new TailorEntities())
{
var query = db.StaffAttendances.SingleOrDefault(a => a.StaffCode == code && a.Date == date);
query.Status = status;
query.Remark = txtReason.Text;
int action = db.SaveChanges();
if (action >= 1)
{
lblFinished.Visible = true;
}
}
}
else
{
using (var db = new TailorEntities())
{
var query = db.StaffAttendances.Where(a => a.Date.Month == dtpFromDate.Value.Month || a.Date.Month == dtpUntillDate.Value.Month).ToList();
for (DateTime date = startDate.Date; date <= endDate.Date; date = date.AddDays(1))
{
int isExist = 0;
foreach (var a in query)
{
if (a.StaffCode == cboCode.SelectedValue.ToString() && a.Date.Date == date)
{
isExist = 1;
}
}
if (isExist == 0)
{
StaffAttendance attendance = new StaffAttendance()
{
StaffCode = cboCode.SelectedValue.ToString(),
Date = date,
Status = status,
Remark = txtReason.Text,
ComputerCode = TailorService.GetComputerCode(),
ComputeTime = TailorService.GetComputerTime()
};
db.StaffAttendances.Add(attendance);
}
}
int action = db.SaveChanges();
if (action >= 1)
{
lblFinished.Visible = true;
}
}
}
if (AttendanceView != null)
{
AttendanceView.LoadStaffAttendance();
AttendanceView.LoadAttendanceInfo();
}
}
