private void Update(int resource_id, DateTime myDate, FormCollection coll) { timedb.DeleteTimesheet(resource_id, myDate); List <day> myEntries = new List <day>(); foreach (var item in coll) { if (item.ToString().Contains("r")) { if (coll[item.ToString()] != string.Empty) { myEntries.Add(new day { Day = int.Parse(item.ToString().Replace("r", "")), Year = myDate.Year, Month = myDate.Month, HoursWorked = decimal.Parse(coll[item.ToString()].ToString()) }); } } } foreach (var h in myEntries) { tbl_TimeSheet mytime = new tbl_TimeSheet(); mytime.Resource_ID = resource_id; mytime.Date = new DateTime(h.Year, h.Month, h.Day); mytime.Hours = (decimal)h.HoursWorked; timedb.Add(mytime); } timedb.Save(); }
public ActionResult DeleteConfirmed(int id) { tbl_TimeSheet tbl_TimeSheet = db.tbl_TimeSheet.Find(id); db.tbl_TimeSheet.Remove(tbl_TimeSheet); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: User/TimeSheet/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_TimeSheet tbl_TimeSheet = db.tbl_TimeSheet.Find(id); if (tbl_TimeSheet == null) { return(HttpNotFound()); } return(View(tbl_TimeSheet)); }
public ActionResult Edit([Bind(Include = "id,FKprojectid,FKtaskid,FKuserid,startdate,enddate,actualhours,comments,createdby,createddate,modifiedby,modifieddate")] tbl_TimeSheet tbl_TimeSheet) { if (ModelState.IsValid) { var mail = Convert.ToString(Session["useremail"]); tbl_TimeSheet.createdby = mail; tbl_TimeSheet.createddate = DateTime.Now; db.Entry(tbl_TimeSheet).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.FKprojectid = new SelectList(db.tbl_ManageProjects, "projectid", "projectname", tbl_TimeSheet.FKprojectid); ViewBag.FKtaskid = new SelectList(db.tbl_ManageTask, "taskid", "taskname", tbl_TimeSheet.FKtaskid); ViewBag.FKuserid = new SelectList(db.tbl_ManageUsers, "userid", "username"); return(View(tbl_TimeSheet)); }
// GET: User/TimeSheet/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_TimeSheet tbl_TimeSheet = db.tbl_TimeSheet.Find(id); if (tbl_TimeSheet == null) { return(HttpNotFound()); } ViewBag.FKprojectid = new SelectList(db.tbl_ManageProjects, "projectid", "projectname", tbl_TimeSheet.FKprojectid); ViewBag.FKtaskid = new SelectList(db.tbl_ManageTask, "taskid", "taskname", tbl_TimeSheet.FKtaskid); ViewBag.FKuserid = new SelectList(db.tbl_ManageUsers, "userid", "username"); return(View(tbl_TimeSheet)); }