public async Task Create(DBPage newValue) { try { await connection.OpenAsync(); StringBuilder stringBuilder = new StringBuilder(); var cmd = new MySqlCommand(); cmd.Connection = connection; stringBuilder.AppendLine("Insert INTO Page(IdFichier, Ordre,Element) "); stringBuilder.AppendLine($"Values({newValue.IDFichier},{newValue.Ordre},@ele) "); MySqlParameter Imgparam = new MySqlParameter("@ele", MySqlDbType.LongBlob); Imgparam.Value = newValue.Element; cmd.Parameters.Add(Imgparam); cmd.CommandText = stringBuilder.ToString(); await cmd.ExecuteNonQueryAsync(); } catch (Exception ex) { throw ex; } finally { connection.Close(); } }
public async Task <bool> Delete(DBPage valueToDelete) { try { await connection.OpenAsync(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendLine("DELETE FROM Page "); stringBuilder.AppendLine($"WHERE ID ={valueToDelete.ID}"); var cmd = new MySqlCommand(); cmd.Connection = connection; cmd.CommandText = stringBuilder.ToString(); int result = await cmd.ExecuteNonQueryAsync(); return(Convert.ToBoolean(result)); } catch (Exception ex) { throw ex; } finally { connection.Close(); } }
public async Task <DBPage> Get(int Id) { try { DBPage page = new DBPage(); await connection.OpenAsync(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendLine("SELECT Id, IdFichier, Ordre,Element"); stringBuilder.AppendLine("FROM Page "); stringBuilder.AppendLine($"WHERE Id = {Id}"); var cmd = new MySqlCommand(); cmd.Connection = connection; cmd.CommandText = stringBuilder.ToString(); var result = await cmd.ExecuteReaderAsync(); if (result.HasRows) { if (await result.ReadAsync()) { page = ExtractDataFromDataReader(result); } } return(page); } catch (Exception ex) { throw ex; } finally { connection.Close(); } }
public async Task Update(DBPage newValue) { try { await connection.OpenAsync(); var cmd = new MySqlCommand(); cmd.Connection = connection; StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendLine("Update Page "); stringBuilder.AppendLine($"SET IdFichier = {newValue.IDFichier} "); stringBuilder.AppendLine($",Ordre = {newValue.Ordre} "); stringBuilder.AppendLine($",Element = @ele "); stringBuilder.AppendLine($"WHERE Id = {newValue.ID}"); MySqlParameter Imgparam = new MySqlParameter("@ele", MySqlDbType.LongBlob); Imgparam.Value = newValue.Element; cmd.Parameters.Add(Imgparam); cmd.CommandText = stringBuilder.ToString(); await cmd.ExecuteNonQueryAsync(); } catch (Exception ex) { throw ex; } finally { connection.Close(); } }
private static DBPage ExtractDataFromDataReader(System.Data.Common.DbDataReader result) { DBPage dbPage = new DBPage(); dbPage.ID = result.GetInt32(0); dbPage.IDFichier = result.GetInt32(1); dbPage.Ordre = result.GetInt32(2); if (!string.IsNullOrEmpty(result.GetValue(3).ToString()) && !string.IsNullOrWhiteSpace(result.GetValue(3).ToString())) { dbPage.Element = ReadToEnd(result.GetStream(3)); } return(dbPage); }