public async Task <ScheduleJobDef> GetScheduleJobDef(int id, int userId) { ScheduleJobDef scheduleJobDef = new ScheduleJobDef(); string cmdStr = ScheduleJobDefSelect + " WHERE id=@id AND appuser_id=@appuser_id"; await using MySqlCommand cmd = await db.CreateCommand(cmdStr); cmd.Parameters.Add(new MySqlParameter("id", id)); cmd.Parameters.Add(new MySqlParameter("appuser_id", userId)); using var odr = await cmd.ExecuteMySqlReaderAsync(); if (await odr.ReadAsync()) { scheduleJobDef = await ReadScheduleJobDefAsync(odr); } return(scheduleJobDef); }
public ScheduleDefViewModel(ScheduleJobDef scheduleJobDef) { if (scheduleJobDef != null) { Id = scheduleJobDef.Id; Name = scheduleJobDef.Name; FriendId = scheduleJobDef.FriendId; FacebookCredentialId = scheduleJobDef.FacebookCredentialId; Type = scheduleJobDef.Type; IntervalType = scheduleJobDef.IntervalType; TimeFrom = scheduleJobDef.TimeFrom; TimeTo = scheduleJobDef.TimeTo; TimeZone = scheduleJobDef.TimeZone; Active = scheduleJobDef.Active; SelectedDaysOfWeek = scheduleJobDef.WeekDayIds.ToList(); } InitializeSelectLists(); }
public async Task AddScheduleJobDef(ScheduleJobDef def) { string cmdStr = @"INSERT INTO schedulejobdef(appuser_id, friend_id, facebookcredential_id, name, type, interval_type, time_from, time_to, timezone_id, active) VALUES(@appuser_id, @friend_id, @facebookcredential_id, @name, @type, @interval_type, @time_from, @time_to, @timezone_id, @active)"; await using MySqlCommand cmd = await db.CreateCommand(cmdStr); cmd.Parameters.Add(new MySqlParameter("appuser_id", def.AppUserId)); cmd.Parameters.Add(new MySqlParameter("friend_id", def.FriendId)); cmd.Parameters.Add(new MySqlParameter("facebookcredential_id", def.FacebookCredentialId)); cmd.Parameters.Add(new MySqlParameter("name", def.Name)); cmd.Parameters.Add(new MySqlParameter("type", def.Type.ToString())); cmd.Parameters.Add(new MySqlParameter("interval_type", def.IntervalType.ToString())); cmd.Parameters.Add(new MySqlParameter("time_from", def.TimeFrom)); cmd.Parameters.Add(new MySqlParameter("time_to", def.TimeTo)); cmd.Parameters.Add(new MySqlParameter("timezone_id", def.TimeZone)); cmd.Parameters.Add(new MySqlParameter("active", def.Active ? 1 : 0)); await cmd.ExecuteNonQueryAsync(); await UpdateScheduleDefJobWeekDays(def); }
public async Task UpdateScheduleJobDef(ScheduleJobDef scheduleJobDef) { string cmdStr = @"UPDATE schedulejobdef SET friend_id=@friend_id, facebookcredential_id=@facebookcredential_id, name=@name, type=@type, interval_type=@interval_type, time_from=@time_from, time_to=@time_to, timezone_id=@timezone_id, active=@active WHERE id=@id and appuser_id=@appuser_id"; await using MySqlCommand cmd = await db.CreateCommand(cmdStr); cmd.Parameters.Add(new MySqlParameter("friend_id", scheduleJobDef.FriendId)); cmd.Parameters.Add(new MySqlParameter("facebookcredential_id", scheduleJobDef.FacebookCredentialId)); cmd.Parameters.Add(new MySqlParameter("name", scheduleJobDef.Name)); cmd.Parameters.Add(new MySqlParameter("type", scheduleJobDef.Type)); cmd.Parameters.Add(new MySqlParameter("interval_type", scheduleJobDef.IntervalType)); cmd.Parameters.Add(new MySqlParameter("time_from", scheduleJobDef.TimeFrom)); cmd.Parameters.Add(new MySqlParameter("time_to", scheduleJobDef.TimeTo)); cmd.Parameters.Add(new MySqlParameter("timezone_id", scheduleJobDef.TimeZone)); cmd.Parameters.Add(new MySqlParameter("id", scheduleJobDef.Id)); cmd.Parameters.Add(new MySqlParameter("active", scheduleJobDef.Active ? 1 : 0)); cmd.Parameters.Add(new MySqlParameter("appuser_id", scheduleJobDef.AppUserId)); await cmd.ExecuteNonQueryAsync(); await UpdateScheduleDefJobWeekDays(scheduleJobDef); }