/// <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); } }
}//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); } }