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 Create(AppUser user) { string cmdStr = "INSERT INTO appuser(email, title, firstname, lastname, active) VALUES(@email, @title, @firstname, @lastname, @active)"; await using MySqlCommand cmd = await db.CreateCommand(cmdStr); cmd.Parameters.Add(new MySqlParameter("email", user.Email)); cmd.Parameters.Add(new MySqlParameter("title", user.Title)); cmd.Parameters.Add(new MySqlParameter("firstname", user.Firstname)); cmd.Parameters.Add(new MySqlParameter("lastname", user.Lastname)); cmd.Parameters.Add(new MySqlParameter("active", false)); await cmd.ExecuteNonQueryAsync(); }