public static Stage GetStage(string p)
{
Stage stage = new Stage();
DbDataReader reader = Database.GetData("SELECT * FROM tbl_stage WHERE ID=@id",Database.AddParameter("@id",Convert.ToInt32(p)));
foreach (IDataRecord db in reader)
{
stage=(Create(db));
}
return stage;
}
public static string DeleteStage(Stage SelectedStage)
{
DbDataReader reader = Database.GetData("SELECT * FROM tbl_lineup WHERE Stage=@id", Database.AddParameter("@id", Convert.ToInt32(SelectedStage.ID)));
if (reader.HasRows)
{
return "Gelieve eerste alle bands uit de line up van deze stage te verwijderen";
}
else
{
Database.ModifyData("DELETE FROM tbl_stage WHERE ID=@id", Database.AddParameter("@id", Convert.ToInt32(SelectedStage.ID)));
}
return null;
}
public static string AddLineUp(Band SelectedBandAdd, string StartTime, string EndTime, Stage SelectedStage, DateTime SelectedDatum)
{
string error = "";
error = CheckTime(StartTime, EndTime, SelectedStage,SelectedDatum);
if (error == null)
{
error = CheckBand(StartTime, EndTime, SelectedStage, SelectedBandAdd,SelectedDatum);
if (error == null)
{
Database.ModifyData("INSERT INTO tbl_lineup (DatePreformance,FromTime,UntilTime,Stage,Band) VALUES (@date,@from,@until,@stage,@band)",
Database.AddParameter("@date", SelectedDatum),
Database.AddParameter("@from", StartTime),
Database.AddParameter("@until", EndTime),
Database.AddParameter("@stage", Convert.ToInt32(SelectedStage.ID)),
Database.AddParameter("@band", Convert.ToInt32(SelectedBandAdd.ID))
);
}
else
{
return error;
}
}
return error;
}
public static void EditStage(string TxtStage,Stage SelectedStage)
{
Database.ModifyData("UPDATE tbl_stage SET StageName=@name WHERE ID=@id", Database.AddParameter("@name", TxtStage), Database.AddParameter("@id",Convert.ToInt32(SelectedStage.ID)));
}
private static LineUp Create(IDataRecord db, Stage SelectedStage)
{
return new LineUp()
{
ID = db["ID"].ToString(),
Date = Convert.ToDateTime(db["DatePreformance"]),
From = db["FromTime"].ToString(),
Until = db["UntilTime"].ToString(),
Stage = SelectedStage,
Band = Band.GetBands(db["Band"].ToString()),
};
}
private static string CheckTime(string StartTime, string EndTime, Stage SelectedStage,DateTime SelectedDatum)
{
string[] strEndtime = EndTime.Split(':');
string EndTimecom = strEndtime[0] + strEndtime[1];
string[] strStarttime = StartTime.Split(':');
string StartTimecom = strStarttime[0] + strStarttime[1];
if (Convert.ToInt32(StartTimecom) >= Convert.ToInt32(EndTimecom))
{
return "De eindtijd moet groter zijn dan de starttijd";
}
else
{
DbDataReader reader = Database.GetData("SELECT * FROM tbl_lineup WHERE Stage=@stage AND DatePreformance=@date",
Database.AddParameter("@stage", Convert.ToInt32(SelectedStage.ID)),
Database.AddParameter("@date", SelectedDatum)
);
foreach (IDataRecord db in reader)
{
string[] strStartToCheck = db["FromTime"].ToString().Split(':');
string[] strEndToCheck = db["UntilTime"].ToString().Split(':');
if (Between(Convert.ToInt32(strStartToCheck[0] + strStartToCheck[1]), Convert.ToInt32(StartTimecom), Convert.ToInt32(EndTimecom)) || Between(Convert.ToInt32(strEndToCheck[0] + strEndToCheck[1]), Convert.ToInt32(StartTimecom), Convert.ToInt32(EndTimecom)))
{
return "Deze tijden zijn al in gebruikt";
}
}
}
return null;
}
public static ObservableCollection<LineUp> GetLineUp(DateTime SelectedDatum, Stage SelectedStage)
{
ObservableCollection<LineUp> lineups = new ObservableCollection<LineUp>();
if (SelectedStage != null && SelectedDatum != null)
{
DbDataReader reader = Database.GetData("SELECT tbl_lineup.ID as ID,DatePreformance,FromTime,UntilTime,Band FROM tbl_lineup WHERE Stage=@stageid AND DatePreformance=@date ORDER BY FromTime",
Database.AddParameter("@stageid", Convert.ToInt32(SelectedStage.ID)),
Database.AddParameter("@date", Convert.ToDateTime(SelectedDatum))
);
foreach (IDataRecord db in reader)
{
lineups.Add(Create(db, SelectedStage));
}
}
return lineups;
}
public static string EditLineUp(Band SelectedBandAdd, string StartTime, string EndTime,Stage SelectedStage, DateTime SelectedDatum,string ID)
{
string error = "";
error = CheckTime(StartTime, EndTime, SelectedStage,SelectedDatum);
if (error == null)
{
error = CheckBand(StartTime, EndTime, SelectedStage, SelectedBandAdd,SelectedDatum);
if (error == null)
{
Database.ModifyData("UPDATE tbl_lineup SET DatePreformance=@date,FromTime=@from,UntilTime=@until,Stage=@stage,Band=@band WHERE ID=@id",
Database.AddParameter("@date", SelectedDatum),
Database.AddParameter("@from", StartTime),
Database.AddParameter("@until", EndTime),
Database.AddParameter("@stage", Convert.ToInt32(SelectedStage.ID)),
Database.AddParameter("@id", Convert.ToInt32(ID)),
Database.AddParameter("@band", Convert.ToInt32(SelectedBandAdd.ID))
);
}
else
{
return error;
}
}
return error;
}