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