Пример #1
0
        public override bool Load(int RowId)
        {
            CurrentConnection = new DatabaseDataContext();
            var q = from x in CurrentConnection.tasks_calls where x.id.Equals(RowId) select x;
            CurrentRow = q.FirstOrDefault();

            return true;
        }
Пример #2
0
        /// <summary>
        /// Create a new binding between a task and a call
        /// </summary>
        /// <param name="TaskId">Task ID</param>
        /// <param name="CallId">Call ID</param>
        /// <returns>Insert ID of the new row</returns>
        public int New(int TaskId, int CallId)
        {
            // Check that there exists no identical binding
            using (DatabaseDataContext db = new DatabaseDataContext())
            {
                var row = from x in db.tasks_calls where x.call_id == CallId && x.task_id == TaskId select id;
                if (row.Count() > 0)
                {
                    return -1;
                }
            }
            // Create a new mapping
            base.New();
            CurrentRow = new tasks_call();

            CurrentRow.task_id = TaskId;
            CurrentRow.call_id = CallId;

            try
            {
                CurrentConnection.tasks_calls.InsertOnSubmit(CurrentRow);
                CurrentConnection.SubmitChanges();
            }
            catch (Exception)
            {
                return -1;
            }
            return Save();
        }