//public IEnumerable<TeaserEntityDL> GetAllTeasers()
//{
// using (SqlConnection connection = new SqlConnection(ConnectionString))
// {
// connection.Open();
// using (SqlCommand command = new SqlCommand("SELECT iD, Title, Text, Date FROM Teaser", connection))
// {
// SqlDataReader reader = command.ExecuteReader();
// while (reader.Read())
// {
// yield return GetTeaserEntity(reader);
// }
// }
// }
//}
public TeaserEntityDL GetTeaserData(int iDteaser)
{
try
{
using (EntityFramework accessToDB = new EntityFramework())
{
return(accessToDB.TeaserEntityDLTable.Where(x => x.Id == iDteaser).SingleOrDefault());
}
}
catch (Exception ex)
{
TeaserEntityDL error = new TeaserEntityDL();
error.Title = $"Der Artikel Id={iDteaser} wurde nicht eingelesen";
error.Text = "Fehlerbeschreibung:";
error.ImageName = $"{ex.Message.ToString()}";
return(error);
}
//using (SqlConnection connection = new SqlConnection(ConnectionString))
//{
// connection.Open();
// using (SqlCommand command = new SqlCommand("SELECT iD, Title, Text, Date FROM Teaser WHERE iD=@iDteaser", connection))
// {
// command.Parameters.AddWithValue("@iDteaser", iDteaser);
// SqlDataReader reader = command.ExecuteReader();
// if (!reader.Read())
// {
// return null;
// }
// return GetTeaserEntity(reader);
// }
//}
}
public string UpdateTeaserData(TeaserEntityDL teaserToDB)
{
try
{
using (EntityFramework accessToDB = new EntityFramework())
{
accessToDB.Entry(teaserToDB).State = EntityState.Modified;
accessToDB.SaveChanges();
return("Die Anforderung wurde erfüllt");
}
}
catch (Exception ex)
{
string error = $"Die Anforderung wurde nicht erfüllt. Unten Fehlerbeschreibung:\n {ex.Message.ToString()}";
return(error);
}
//using (SqlConnection connection = new SqlConnection(ConnectionString))
//{
// connection.Open();
// using (SqlCommand command = new SqlCommand("UPDATE Teaser SET Title=@Title, Text=@Text , Date=@Date WHERE id=@IdTeaser", connection))
// {
// command.Parameters.AddWithValue("@Title", teaserToDB.Title);
// command.Parameters.AddWithValue("@Text", teaserToDB.Text);
// command.Parameters.AddWithValue("@Date", teaserToDB.DateOfTeaser);
// command.Parameters.AddWithValue("@IdTeaser", teaserToDB.Id);
// command.ExecuteNonQuery();
// }
//}
}
// TEASER
//private TeaserEntityDL GetTeaserEntity(SqlDataReader reader)
//{
// TeaserEntityDL teaserFromDB = new TeaserEntityDL();
// teaserFromDB.Id = reader.GetInt32(reader.GetOrdinal("iD"));
// teaserFromDB.Title = reader.GetString(reader.GetOrdinal("Title"));
// teaserFromDB.Text = reader.GetString(reader.GetOrdinal("Text")) ?? string.Empty;
// teaserFromDB.DateOfTeaser = reader.GetDateTime(reader.GetOrdinal("Date"));
// return teaserFromDB;
//}
// Teasers
public List <TeaserEntityDL> GetAllTeasers()
{
try
{
using (EntityFramework accessToDB = new EntityFramework())
{
return(accessToDB.TeaserEntityDLTable.ToList());
}
}
catch (Exception ex)
{
List <TeaserEntityDL> error = new List <TeaserEntityDL>();
TeaserEntityDL error1 = new TeaserEntityDL();
error1.ImageName = "Die Artikel wurden nicht eingelesen";
error1.Text = "Unten Fehlerbeschreibung: \n";
error1.ImageName = ex.Message.ToString();
error.Add(error1);
return(error);
}
}
