/// <summary>
        /// Uebernimmt das Setzen der Parameter und den Prozedur Aufruf auf der DB,
        /// um eine neue Pendenz zu erfassen
        /// </summary>
        /// <param name="sessionId"></param>
        /// <param name="kontaktId"></param>
        /// <param name="model"></param>
        /// <returns>Objekt DbReturnStatus</returns>
        public DbReturnStatus Add(int sessionId, int kontaktId, PendenzModel model)
        {
            string _modus     = "INSERT";
            string _returnMsg = string.Empty;

            try
            {
                ISingleResult <crm_SetPendenzResult> result = dataContext.crm_SetPendenz(
                    sessionId,
                    kontaktId,
                    0,
                    _modus,
                    model.Termin,
                    model.MitarbeiterID,
                    model.Titel,
                    model.Beschreibung
                    );



                DbReturnStatus returnValue = WasActionSuccessful(result.Single());
                return(returnValue);
            }
            catch (Exception)
            {
                throw new ArgumentException(dbErrorConnMessage);
            }
        }
        public override ENTWFTransition Select(int id)
        {
            using (var db = new HRPaidTimeOffDataContext())
            {
                ISingleResult <ENTWFTransition> eNTWFTransition = db.ENTWFTransitionSelectById(id);

                if (eNTWFTransition != null)
                {
                    return(eNTWFTransition.Single());
                }
                return(null);
            }
        }
Exemple #3
0
        }//ctor

        public void ProcessStudent(int id)
        {
            try
            {
                dc = new DataClasses1DataContext(Properties.Settings.Default.MDH2ConnectionString);
                ISingleResult <spGetStudentDetailResult> stu = dc.spGetStudentDetail(id);
                spGetStudentDetailResult student             = stu.Single();
                CurrentStudent = new StudentDetail(student.ID, student.FirstName, student.LastName, student.Gender,
                                                   DateTime.ParseExact(String.IsNullOrEmpty(student.BirthDate) ? "20000101" : student.BirthDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture),
                                                   student.ContactName, student.Address, student.Email, student.CellPhone, student.HomePhone, student.StudentPhone, student.Comment,
                                                   student.UpdateDateTime);
                MainWindowViewModel.Instance.StatusBar = $"Populate StudentDetail for {student.FirstName} {student.LastName}";
            }
            catch (Exception e)
            {
                log.Error("In ScheduleDetailViewModel..ProcessStudent : " + e.Message);
                Environment.Exit(-1);
            }
        }