internal static int UpdateSettings() { n = 0; try { daSettings = new TblSettingsTableAdapter(); dtSettings = new DsLiveOutlook.TblSettingsDataTable(); daSettings.FillByID(dtSettings, SettingsInfo.ADay); drwSettings = dtSettings[0]; drwSettings.BeginEdit(); drwSettings.MaxAppointments = SettingsInfo.MaxAppointments; drwSettings.EndEdit(); n = daSettings.Update(dtSettings); return(n); } catch (Exception ex) { Interactive.LInfoError(ex.Message, "Record was not saved !"); return(n); } }
internal static int DeleteSettings() { n = 0; try { daSettings = new TblSettingsTableAdapter(); n = daSettings.Delete1(SettingsInfo.ADay); return(n); } catch (Exception ex) { Interactive.LInfoError(ex.Message, "Record was not Deleted!"); return(n); } }
internal static DataTable GetAllSettingssByID() { try { SettingsInfo.Recs = false; dt = new DataTable(); daSettings = new TblSettingsTableAdapter(); dtSettings = new DsLiveOutlook.TblSettingsDataTable(); daSettings.FillByID(dtSettings, SettingsInfo.ADay); dt = dtSettings; if (dt.Rows.Count > 0) { SettingsInfo.Recs = true; } } catch (Exception ex) { Interactive.LInfoError("Could not load Settings Information\n" + ex.Message, "Database connection failure"); } return(dt); }
internal static bool WorkingDayOK(string ageunit, int age) { n = 0; try { dt = new DataTable(); daSettings = new TblSettingsTableAdapter(); n = Convert.ToInt32(daSettings.GetCapacity(AppointmentInfo.Appointment.ToString("dddd"))); // System.Windows.Forms.MessageBox.Show(AppointmentInfo.Appointment.ToString("dd/MM/yyy") + "\n" + "Capacity" + AppointmentInfo.Appointment.ToString("dddd") + " :" + n.ToString()); } catch (Exception ex) { Interactive.LInfoError("Could not load Reserve Information\n" + ex.Message, "Database connection failure"); } if (AppointmentInfo.Capacity() > n) { return(false); } else { return(true); } }