private void Editing_performance_Load(object sender, EventArgs e)
{
changed_performance = db.GetTable <TAfisha>().Where(k => k.Id == performance_id).First();
panel_Images_Load();
panel_Text_Load();
panel_Dates_Load();
button1.PerformClick();
}
public static int Update(int ID, TAfisha performance)
{
DataContext db = new DataContext(DB_connection.connectionString);
TAfisha perf = db.GetTable <TAfisha>().Where(k => k.Id == ID).First();
perf = performance;
try
{
db.SubmitChanges();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(1);
}
return(0);
}
public static int Delete(int ID)
{
DataContext db = new DataContext(DB_connection.connectionString);
IQueryable <TAfisha_dates> dates = db.GetTable <TAfisha_dates>().Where(k => k.Id_performance == ID && k.Date > DateTime.Now);
foreach (TAfisha_dates d in dates)
{
d.Cancelled = true;
}
TAfisha performance = db.GetTable <TAfisha>().Where(k => k.Id == ID).First();
performance.Is_relevant = false;
try
{
db.SubmitChanges();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(1);
}
return(0);
}
