public ActionResult Edit(int id) { if (!isAuthenticated() || !loggedUser.isAdmin) return new HttpUnauthorizedResult(); else { ActivityViewModel model = new ActivityViewModel(); Activity activity = new Activity().get(id, loggedUser.Unit); model.Id = activity.Id; model.Name = activity.Name; model.Date = activity.Date; model.Place = activity.Place; model.Obs = activity.Obs; return View(model); } }
public ActionResult Edit(ActivityViewModel model, string hour, string minute) { if (!isAuthenticated() || !loggedUser.isAdmin) return new HttpUnauthorizedResult(); else { if (ModelState.IsValid) { Activity activity = new Activity(); Result result = activity.update(model.Id, model.Name, new DateTime(model.Date.Year, model.Date.Month, model.Date.Day, new Common().convertNumber(hour), new Common().convertNumber(minute), 0), model.Place, model.Obs, loggedUser.Unit); if (result.Success) return RedirectToAction("Index"); else ModelState.AddModelError("", "Ocorreu um erro ao atualizar atividade"); } return View(model); } }
public List<Activity> getAll(int unitId) { List<Activity> list = new List<Activity>(); foreach (List<string> data in database.retrieveData("select id, name, " + common.formatDate("scheduled_by") + ", place, obs from lds_activity where unit_id = @unit_id order by scheduled_by asc", unitId)) { Activity activity = new Activity(); activity.Id = common.convertNumber(data[0]); activity.Name = data[1]; activity.Date = common.convertDate(data[2]); activity.Place = data[3]; activity.Obs = data[4]; list.Add(activity); } return list; }
public Activity get(int id, int unitId) { Activity activity = null; foreach (List<string> data in database.retrieveData("select id, name, " + common.formatDate("scheduled_by") + ", place, obs from lds_activity where id = @id and unit_id = @unit_id", id, unitId)) { activity = new Activity(); activity.Id = common.convertNumber(data[0]); activity.Name = data[1]; activity.Date = common.convertDate(data[2]); activity.Place = data[3]; activity.Obs = data[4]; } return activity; }
public List<Activity> getNextNMonths(int nInterval, int unitId) { List<Activity> list = new List<Activity>(); foreach (List<string> data in database.retrieveData("select id, name, " + common.formatDate("scheduled_by") + ", place, obs from lds_activity where scheduled_by >= date_sub(curdate(), interval 1 day) and scheduled_by < DATE_ADD(curdate(), INTERVAL " + nInterval + " MONTH) and unit_id = @unit_id order by scheduled_by asc", unitId)) { Activity activity = new Activity(); activity.Id = common.convertNumber(data[0]); activity.Name = data[1]; activity.Date = common.convertDate(data[2]); activity.Place = data[3]; activity.Obs = data[4]; list.Add(activity); } return list; }