public void UpdateStaffAttendance(StaffAttendance entity, StaffAttendance model)
{
entity.StaffId = model.StaffId;
entity.AttendanceDate = model.AttendanceDate;
entity.ComingTime = model.ComingTime;
entity.ClosingTime = model.ClosingTime;
}
public async Task <IActionResult> Edit(int id, StaffAttendance staffAttendance)
{
if (string.IsNullOrEmpty(HttpContext.Session.GetString("UserName")))
{
return(RedirectToAction("Login", "Home"));
}
if (id != staffAttendance.StaffAttendanceId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(staffAttendance);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StaffAttendanceExists(staffAttendance.StaffAttendanceId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["StaffId"] = new SelectList(_context.Staffs, "StaffId", "StaffId", staffAttendance.StaffId);
return(View(staffAttendance));
}
public ActionResult Create(StaffAttendance staffAttendance)
{
staffAttendance.StaffAttName = "Trevolin";
staffAttendance.GetDate = DateTime.Now;
db.StaffAttendances.Add(staffAttendance);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
StaffAttendance staffAttendance = db.StaffAttendances.Find(id);
db.StaffAttendances.Remove(staffAttendance);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "StaffAttendanceId,StaffAttName,Staffrecord,GetDate")] StaffAttendance staffAttendance)
{
if (ModelState.IsValid)
{
db.Entry(staffAttendance).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(staffAttendance));
}
public ActionResult Create(StaffAttendance staffAttendance)
{
if (ModelState.IsValid)
{
db.StaffAttendances.Add(staffAttendance);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(staffAttendance));
}
public async Task <IActionResult> Create(StaffAttendance staffAttendance)
{
if (ModelState.IsValid)
{
_context.Add(staffAttendance);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["StaffId"] = new SelectList(_context.Staffs.Where(s => s.IsActive == true), "StaffId", "Name", staffAttendance.StaffId);
return(View(staffAttendance));
}
// GET: StaffAttendances/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StaffAttendance staffAttendance = db.StaffAttendances.Find(id);
if (staffAttendance == null)
{
return(HttpNotFound());
}
return(View(staffAttendance));
}
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)
{
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();
}
}