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));
}
