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); }