public string UpdateDateEndOfMovieAndDeleteEmptyScreenings(string MovieID, string DateEnd)//checked
{
string msg1 = "no effects";
DateTime dend = DateTime.Parse(DateEnd);
DateTime today = DateTime.Now;
DataTable dt = Invitation.LastScreeningDateWithInvitationsForMovieID(MovieID);
if (dend < today)
{
msg1 = "Date End can't Be In The Past";
}
else
{
if (dt.Rows.Count == 0)
{
msg1 = "Updated";
Screening.DeleteAllEmptyScreenings(MovieID, DateEnd);
Movies.UpdateDateEnd(MovieID, DateEnd);
}
else
{
DateTime lastdate = DateTime.Parse(dt.Rows[0][0].ToString());
if (dend <= lastdate)
{
msg1 = "Date End Of Movie Can't Be Earlier Than The Last Screening Date With invitations";
}
else
if (dend > lastdate)
{
msg1 = "Updated";
Screening.DeleteAllEmptyScreenings(MovieID, DateEnd);
Movies.UpdateDateEnd(MovieID, DateEnd);
}
}
}
return(msg1);
}
