public bool Delete(ScheduleBase model, string id) { Stopwatch stopwatch = new Stopwatch(); stopwatch.Start(); try { ScheduleBase scheduleBase = model as ScheduleBase; string day = scheduleBase.day; string query = string.Empty; using (MySqlConnection conn = new MySqlConnection(App.sqlConn)) { conn.Open(); query = $"DELETE FROM schedule WHERE id = '{id}' AND DATE(DAY) = '{day}'"; MySqlCommand command = new MySqlCommand(query, conn); command.ExecuteNonQuery(); conn.Close(); } } catch (Exception) { log.Error("Delete에서 오류 발생"); MessageBox.Show("오류가 발생했습니다. 로그를 확인하세요.", "오류", MessageBoxButton.OK, MessageBoxImage.Warning); return(false); } stopwatch.Stop(); writer = File.AppendText("SqlTime.txt"); writer.WriteLine($"ScheuleDals(Delete) time : " + stopwatch.ElapsedMilliseconds + "ms"); writer.Close(); return(true); }
/// <summary> /// Allows the user to change attributes of a schedule. /// </summary> /// <param name="scheduleId">Id of the Schedule to be updated</param> /// <param name="request">Update Request</param> /// <param name="cancellationToken"></param> /// <returns>A response to a successful PUT request contains confirmation of the arguments passed in. Note: If the new value is too large to return in the response due to internal memory constraints then a value of “Updated.” is returned.</returns> public async Task <List <GenericSuccessResponseItem> > UpdateScheduleAsync(string scheduleId, ScheduleBase request, CancellationToken cancellationToken = default(CancellationToken)) { var json = JsonSerializer.Serialize(request, _jsonSerializerOptions); var requestContent = new StringContent(json, Encoding.UTF8, "application/json"); var response = await _httpClient.PutAsync($"/api/{_userName}/schedules/{scheduleId}", requestContent, cancellationToken); if (response.IsSuccessStatusCode) { var content = await response.Content.ReadAsStringAsync(); return(JsonSerializer.Deserialize <List <GenericSuccessResponseItem> >(content, _jsonSerializerOptions)); } return(null); }
public abstract void DeleteSchedule(ScheduleBase schedule);
public override void DeleteSchedule(ScheduleBase schedule) { throw new NotImplementedException(); }
internal ComputeStartStopSchedule(string id, ProvisioningStatus?provisioningStatus, ComputePowerAction?action, ScheduleBase schedule) { Id = id; ProvisioningStatus = provisioningStatus; Action = action; Schedule = schedule; }