public static void DeleteSave(Guid idOfSave)
{
using (SqlConnection cn = WorkWithSaves.DbConnectionFactory())
{
SqlTransaction tx = null;
try
{
tx = cn.BeginTransaction();
WorkWithSaves.DeleteSave(idOfSave, cn, tx);
tx.Commit();
}
catch (Exception e)
{
tx.Rollback();
throw;
}
}
}
public void Update()
{
ListOfSaves.Items.Clear();
using (SqlConnection cn = WorkWithSaves.DbConnectionFactory())
{
var command = cn.CreateCommand();
command.CommandText = $@"Select
Saves.Id AS IdOfSave,
Saves.[Name] AS NameOfSave,
Saves.DateOfCreation AS DateOfCreation
From
[dbo].[Saves] AS Saves
Order By
DateOfCreation DESC" ;
command.CommandType = CommandType.Text;
command.Connection = cn;
bool startOfReading = true;
using (var dr = command.ExecuteReader())
{
while (dr.Read())
{
ListOfSaves.Items.Add(new SavePresentation()
{
NameOfSave = (string)dr["NameOfSave"],
GuidOfSave = (Guid)dr["IdOfSave"],
DateOfCreation = (DateTime)dr["DateOfCreation"]
});
//var val1 = (string)dr["FieldName"];
}
}
}
}
