public static void Update(Reservations reservations)
{
var sql = string.Format("Update Reservations set ClientID = '{0}' , HallID = {1}, Date = '{2} Where ResID = {3}", reservations.ClientId, reservations.HallId, reservations.Date, reservations.ReservationId);
MyDB.GetInstance().ExecuteSql(sql);
}