Esempio n. 1
0
        public atriumDB.AppointmentDataTable Load()
        {
            this.sqlDa.SelectCommand = sqlSelectAll;

            atriumDB.AppointmentDataTable dt = new atriumDB.AppointmentDataTable();
            Fill(dt);
            return(dt);
        }
Esempio n. 2
0
        public atriumDB.AppointmentDataTable LoadByOrigApptRecurrenceId(int ApptRecurrenceId)
        {
            this.sqlDa.SelectCommand = sqlSelect;
            this.sqlSelect.Parameters.Clear();
            this.sqlSelect.CommandText = "[AppointmentSelectByOrigApptRecurrenceId]";
            this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
            this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ApptRecurrenceId", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
            this.sqlSelect.Parameters["@ApptRecurrenceId"].Value = ApptRecurrenceId;

            atriumDB.AppointmentDataTable dt = new atriumDB.AppointmentDataTable();
            Fill(dt);
            return(dt);
        }
Esempio n. 3
0
        internal AppointmentBE(FileManager pBEMng)
            : base(pBEMng, pBEMng.DB.Appointment)
        {
            myA             = pBEMng;
            myAppointmentDT = (atriumDB.AppointmentDataTable)myDT;

            myTimelineDT = myA.DB.TimeLine;

            if (!myA.AtMng.AppMan.UseService && myODAL == null)
            {
                myODAL = myA.AtMng.DALMngr.GetAppointment();
            }

            this.myAppointmentDT.StartDateColumn.ExtendedProperties.Add("format", "f");
            this.myAppointmentDT.StartDateLocalColumn.ExtendedProperties.Add("format", "f");
            this.myAppointmentDT.EndDateColumn.ExtendedProperties.Add("format", "f");
            this.myAppointmentDT.EndDateLocalColumn.ExtendedProperties.Add("format", "f");
        }