public ActionResult Edit(int EmployeeId, DateTime? piecesDate)
{
db = new EMSEntities12();
int CompanyId = EMSPSSUtilities.GetCompanyId(EmployeeId);
if (piecesDate != null)
{
DateTime weekOf = piecesDate.Value;
while (weekOf.DayOfWeek != DayOfWeek.Monday)
{
weekOf = weekOf.AddDays(-1);
}
foreach (Piece tmp in db.Pieces)
{
if ((tmp.EmployeeRef6Id == EmployeeId) && (tmp.EmployedWith6Id == CompanyId) && (tmp.WeekOf == weekOf))
{
return View(tmp);
}
}
// if it reaches here, the timecard was not found
// create and add it before proceeding
Piece newPiece = new Piece();
newPiece.EmployedWith6Id = CompanyId;
newPiece.EmployeeRef6Id = EmployeeId;
newPiece.WeekOf = weekOf;
newPiece.Mon = null;
newPiece.Tue = null;
newPiece.Wed = null;
newPiece.Thu = null;
newPiece.Fri = null;
newPiece.Sat = null;
newPiece.Sun = null;
db.Pieces.Add(newPiece);
db.SaveChanges();
return View(newPiece);
}
return RedirectToAction("Index", "Pieces", new { EmployeeId = EmployeeId, CompanyId = CompanyId });
}
private float TallyPieces(Piece p)
{
float pieces = 0;
if (p.Mon != null)
{
pieces += (float)p.Mon;
}
if (p.Tue != null)
{
pieces += (float)p.Tue;
}
if (p.Wed != null)
{
pieces += (float)p.Wed;
}
if (p.Thu != null)
{
pieces += (float)p.Thu;
}
if (p.Fri != null)
{
pieces += (float)p.Fri;
}
if (p.Sat != null)
{
pieces += (float)p.Sat;
}
if (p.Sun != null)
{
pieces += (float)p.Sun;
}
return pieces;
}
public ActionResult Edit(Piece piece)
{
db = new EMSEntities12();
if (ModelState.IsValid)
{
db.Entry(piece).State = EntityState.Modified;
db.SaveChanges();
foreach (Employee emp in db.Employees)
{
if (emp.EmployeeId == piece.EmployeeRef6Id)
{
ViewBag.Name = emp.FirstName + " " + emp.LastName;
break;
}
}
foreach (Company cmp in db.Companies)
{
if (cmp.CompanyId == piece.EmployedWith6Id)
{
ViewBag.Company = cmp.CompanyName;
break;
}
}
ViewBag.EmployeeId = piece.EmployeeRef6Id;
ViewBag.CompanyId = piece.EmployedWith6Id;
return RedirectToAction("Index", "Pieces", new { EmployeeId = piece.EmployeeRef6Id, CompanyId = piece.EmployedWith6Id });
}
return View(piece);
}
private Piece GetPiecesEntry(int employeeId)
{
Piece pc = new Piece();
DateTime weekOf = DateTime.Now.Date;
while (weekOf.DayOfWeek != DayOfWeek.Monday)
{
weekOf = weekOf.AddDays(-1);
}
List<Piece> allPCs = db.Pieces.ToList();
foreach (Piece tmp in allPCs)
{
if ((tmp.EmployeeRef6Id == employeeId) && (tmp.WeekOf == weekOf))
{
pc = tmp;
}
}
return pc;
}