public static void AddSheduleToProfile(long profileId, SheduleJobModel shedule) { var date = shedule.Date.ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture); string selectedDaysString = string.Empty; if (shedule.SelectedDays != null) selectedDaysString = String.Join(",", shedule.SelectedDays); var sql = "INSERT IGNORE INTO " + TblSheduleJobs + " (`ProfileID`, `Name`, `Date`, `Daily`,`SelectedDays`)" + "VALUES('" + profileId + "', '" + shedule.Name + "', '" + date + "', " + shedule.IsDaily + ", '" + selectedDaysString + "');COMMIT;"; DoSql(sql); }
private void AddSchedule(SheduleJobModel schdueModel) { _schedulas.Add(schdueModel); elementContainerControl1.AddElement(schdueModel.Name); }
private static IEnumerable<SheduleJobModel> GetShedulesForProfile(int profileId) { var sheduleList = new List<SheduleJobModel>(); var sql = "SELECT * FROM " + TblSheduleJobs + " WHERE ProfileID = '" + profileId + "';"; var reader = GetReader(sql); if (reader != null) { try { while (reader.Read()) { var shedule = new SheduleJobModel { Id = reader.GetInt32(0), ProfileId = reader.GetInt32(1), Name = reader.GetString(2), Date = reader.GetDateTime(3), IsDaily = reader.GetBoolean(4), SelectedDays = new List<int>() }; var selectedDays = reader.GetString(5).Split(','); if (selectedDays.Count() != 1 || selectedDays[0] != String.Empty) foreach (var day in selectedDays) { shedule.SelectedDays.Add(Convert.ToInt32(day)); } sheduleList.Add(shedule); } } finally { reader.Close(); } } return sheduleList; }
private void AddSchedule(string fname) { var item = new SheduleJobModel { Name = fname, IsDaily = false, ProfileId = ProfilesManager.CurrentProfile.Parameters.ProfileId, Date = DateTime.Now, SelectedDays = new List<int>() }; AddSchedule(item); }