public ActionResult EditTimeClockEntry(int guid) { TimeClockEntry model = CarraraSQL.TimeClockEntries.Find(guid); RouteValueDictionary parameters = Request.QueryString.ToRouteValues(); if (model == null) { return(Content(string.Concat("Whoops…Unable to Locate Time Clock Entry with Id ", guid.ToString(), "!"), "text/plain")); } return(PartialView("_TimeClockEntry", model)); }
public ActionResult AddTimeClockEntry(TimeClockEntry model) { try { CarraraSQL.TimeClockEntries.Add(model); CarraraSQL.SaveChanges(); return(Content("OK", "text/plain")); } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message = ex.InnerException.Message; } return(Content(string.Concat("Whoops…", message), "text/plain")); } }
public ActionResult EditTimeClockEntry(TimeClockEntry model) { if (ModelState.IsValid) { TimeClockEntry entity = CarraraSQL.TimeClockEntries.Find(model.TimeClockEntryID); if (!entity.Approved && model.Approved) { entity.ApprovedBy = AspNetUser.FullName; entity.ApprovedDateTime = DateTime.Now; } else if (!model.Approved) { entity.ApprovedBy = string.Empty; entity.ApprovedDateTime = null; } try { string converted = model.ClockInDate.Value.ToString("MM/dd/yy") + " " + model.ClockInTime.Value.ToString("h:mm:ss tt"); DateTime convertedDate = Convert.ToDateTime(converted); entity.ClockIn = convertedDate; } catch { } try { string converted = model.ClockOutDate.Value.ToString("MM/dd/yy") + " " + model.ClockOutDate.Value.ToString("h:mm:ss tt"); DateTime convertedDate = Convert.ToDateTime(converted); entity.ClockOut = convertedDate; } catch { } entity.HoursWorked = model.HoursWorked; entity.CostCenterID = model.CostCenterID; entity.DrivenVehicleID = model.DrivenVehicleID; entity.Lunch = model.Lunch; entity.Notes = model.Notes; CarraraSQL.SaveChanges(); return(Content(string.Concat( "<td>", entity.Employee.LastName, ", ", entity.Employee.FirstName, "</td>", "<td class=\"numeric\">", entity.StartTime.HasValue ? entity.StartTime.Value.ToShortTimeString() : string.Empty, "</td>", "<td class=\"numeric\">", entity.DayOfWeek, "</td>", "<td class=\"numeric\">", entity.ClockIn, "</td>", "<td class=\"numeric\">", entity.OriginalClockIn, "</td>", "<td class=\"numeric\">", entity.Lunch ? string.Concat("<input checked=\"checked\" id=\"lunch_", entity.TimeClockEntryID, "\" name=\"lunch_", entity.TimeClockEntryID, "\" readonly=\"readonly\" type=\"checkbox\" />") : string.Concat("<input id=\"lunch_", entity.TimeClockEntryID, "\" name=\"lunch_", entity.TimeClockEntryID, "\" readonly=\"readonly\" type=\"checkbox\" />"), "</td>", "<td class=\"numeric\">", entity.ClockOut, "</td>", "<td class=\"numeric\">", entity.OriginalClockOut, "</td>", "<td class=\"numeric\">", entity.HoursWorked.HasValue ? entity.HoursWorked.Value.ToString("F2") : string.Empty, "</td>", "<td>", entity.Employee.DepartmentID.HasValue ? entity.Employee.Department.DepartmentName : string.Empty, " - ", entity.CostCenterID, "</td>", "<td>", entity.DrivenVehicleID.HasValue ? entity.Vehicle.VehicleCode : string.Empty, "</td>", "<td class=\"numeric\">", entity.ApprovedDateTime.HasValue ? string.Concat("<input checked=\"checked\" id=\"approved_", entity.TimeClockEntryID, "\" name=\"approved_", entity.TimeClockEntryID, "\" readonly=\"readonly\" type=\"checkbox\" />") : string.Concat("<input id=\"approved_", entity.TimeClockEntryID, "\" name=\"approved_", entity.TimeClockEntryID, "\" readonly=\"readonly\" type=\"checkbox\" />"), "</td>", "<td class=\"numeric\">", entity.ApprovedDateTime, "</td>", "<td>", entity.ApprovedBy, "</td>", "<td class=\"numeric\">", entity.Notes, "</td>", "<td class=\"numeric error\">", entity.Status, "</td>" ), "text/plain")); } return(ReturnError()); }