Inheritance: System.Data.Objects.DataClasses.EntityObject
Exemple #1
0
 /// <summary>
 /// Deprecated Method for adding a new object to the PARTICIPANTS EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToPARTICIPANTS(PARTICIPANT pARTICIPANT)
 {
     base.AddObject("PARTICIPANTS", pARTICIPANT);
 }
Exemple #2
0
        /// <summary>
        /// Create Participant and try to migrate some details from user table.
        /// </summary>
        public void createParticipant(int userid,int sessionid)
        {
            try
            {
                USER userData = (from user in dbpollContext.USERS
                                where user.USER_ID == userid
                                select user).First<USER>();

                var participants = from part in dbpollContext.PARTICIPANTS
                               join data in dbpollContext.PARTICIPANT_DATA on part.PARTICIPANT_ID equals data.PARTICIPANT_ID
                               where part.USER_ID == userData.USER_ID
                               select new participantModel
                               {
                                   userweight = (int)data.USER_WEIGHT,
                                   name = data.NAME,
                                   address = data.ADDRESS,
                                   city = data.CITY,
                                   postcode = data.POSTCODE,
                                   state = data.STATE,
                                   country = data.COUNTRY,
                                   department = data.DEPARTMENT,
                                   company = data.COMPANY,
                                   email = data.EMAIL,
                                   fax = data.FAX,
                                   phone = data.PHONE,
                                   title = data.TITLE

                               };

                PARTICIPANT p = new PARTICIPANT();
                PARTICIPANT_DATA partdata = new PARTICIPANT_DATA();

                p.PARTICIPANT_ID = getMaxParticipantID() + 1;
                p.USER_ID = userid;
                p.SESSION_ID = sessionid;

                partdata.DATA_ID = getMaxDataID() + 1;
                partdata.PARTICIPANT_ID = p.PARTICIPANT_ID;
                partdata.NAME = userData.NAME;

                // See if we can set data from a previous participant entry
                if (participants.ToArray().Length > 0)
                {
                    participantModel participant = participants.First<participantModel>();

                    partdata.USER_WEIGHT = participant.userweight;
                    partdata.ADDRESS = participant.address;
                    partdata.CITY = participant.city;
                    partdata.POSTCODE = participant.postcode;
                    partdata.STATE = participant.state;
                    partdata.COUNTRY = participant.country;
                    partdata.DEPARTMENT =participant.department;
                    partdata.COMPANY = partdata.COMPANY;
                    partdata.EMAIL = partdata.EMAIL;
                    partdata.FAX = participant.fax;
                    partdata.PHONE= participant.phone;
                    partdata.TITLE= participant.title;

                }

                dbpollContext.AddToPARTICIPANTS(p);
                dbpollContext.AddToPARTICIPANT_DATA(partdata);
                dbpollContext.SaveChanges();
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
Exemple #3
0
 /// <summary>
 /// Create a new PARTICIPANT object.
 /// </summary>
 /// <param name="pARTICIPANT_ID">Initial value of the PARTICIPANT_ID property.</param>
 /// <param name="cREATED_AT">Initial value of the CREATED_AT property.</param>
 /// <param name="uSER_ID">Initial value of the USER_ID property.</param>
 /// <param name="sESSION_ID">Initial value of the SESSION_ID property.</param>
 public static PARTICIPANT CreatePARTICIPANT(global::System.Int32 pARTICIPANT_ID, global::System.DateTime cREATED_AT, global::System.Int32 uSER_ID, global::System.Int32 sESSION_ID)
 {
     PARTICIPANT pARTICIPANT = new PARTICIPANT();
     pARTICIPANT.PARTICIPANT_ID = pARTICIPANT_ID;
     pARTICIPANT.CREATED_AT = cREATED_AT;
     pARTICIPANT.USER_ID = uSER_ID;
     pARTICIPANT.SESSION_ID = sESSION_ID;
     return pARTICIPANT;
 }