public string LoadRoutine(int RoutineID) { AgendaRoutineModel routine = new AgendaRoutineModel(); try { routine.Load(RoutineID); } catch (Exception e) { new EventLogger.EventLogger("Routine Management", "Application").WriteException(e); } return new JavaScriptSerializer().Serialize(Json(routine).Data); }
public static List<AgendaRoutineModel> GetRoutineList() { List<AgendaRoutineModel> rl = new List<AgendaRoutineModel>(); using (SqlServer database = new SqlServer(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { using(DataTable dt = database.GetDataTable("dbo.RoutineListGet", new List<SqlParameter>())) { AgendaRoutineModel r; foreach(DataRow row in dt.Rows) { r = new AgendaRoutineModel(); r.ID = int.Parse(row["ID"].ToString()); r.Name = row["Name"].ToString(); r.Description = row["Description"].ToString(); r.Area = row["AreaName"].ToString(); r.CreatedBy = row["UserName"].ToString(); r.CreatedOn = row["CreatedOn"].ToString(); rl.Add(r); } } } return rl; }
public void SaveScheduledRoutine(AgendaRoutineModel Routine, int ScheduleID) { try { Routine.SaveScheduledRoutine(ScheduleID); } catch (Exception e) { new EventLogger.EventLogger("Routine Management", "Application").WriteException(e); } }
public void SaveRoutine(AgendaRoutineModel Routine) { try { Routine.Save(); } catch (Exception e) { new EventLogger.EventLogger("Routine Management", "Application").WriteException(e); } }