예제 #1
0
        /// <summary>
        /// AddIssue - Add New Issue
        /// </summary>
        /// <param name="issue">Issue</param>
        /// <returns>bool</returns>
        public static bool AddIssue(Issue issue)
        {
            try
            {
                var returnValue = false;
                var id = 0;

                // wrap in a TransactionScope since we are updating two tables - Issues and IssueAssignments
                using (TransactionScope transaction = new TransactionScope())
                {

                    using (var db = new ProjectManagerEntities())
                    {

                            db.Connection.Open();
                            var i = new IssueDAL();
                            //i.IssueID = -1;
                            i.Subject = issue.Subject;
                            i.ProjectID = issue.ProjectID;
                            i.Priority = issue.CurrentPriority.ToString();
                            i.Status = issue.CurrentStatus.ToString();
                            i.Description = issue.Description;
                            i.IssueCategoryName = issue.IssueCategoryName;
                            i.EntryDate = issue.EntryDate;

                            // save issue.
                            db.IssueDALs.AddObject(i);
                            db.SaveChanges();

                            // get the newly inserted issueid.
                            id = i.IssueID;

                            // save issue assignment.
                            var issueAssignment = new IssueAssignmentDAL();
                            issueAssignment.IssueID = id;
                            issueAssignment.UserID = issue.Assignee.UserId;
                            db.IssueAssignmentDALs.AddObject(issueAssignment);
                            db.SaveChanges();

                        }

                        transaction.Complete();

                        // successfully inserted.
                        returnValue = true;
                }

                return returnValue;

            }
            catch (TransactionAbortedException)
            {
                throw;
            }
            catch (Exception)
            {

                throw;
            }
        }
예제 #2
0
        /// <summary>
        /// GetProjectList
        /// </summary>
        /// <returns>List<IssueModel></returns>
        public static List<Project> GetProjectList()
        {
            List<Project> projects = new List<Project>();

            try
            {
                using (var db = new ProjectManagerEntities())
                {
                    var query = from p in db.ProjectDALs
                                select p;

                    // get the list of projects.
                    foreach (var q in query)
                    {
                        var proj = new Project
                                 (
                                      q.ProjectID,
                                      q.Name,
                                      DateTime.Parse(q.StartDate.ToString()),
                                      DateTime.Parse(q.EndDate.ToString()),
                                      q.Status,
                                      q.Description,
                                      q.ProjectCategoryID.ToString(),
                                      DateTime.Parse(q.DueDate.ToString())
                                 );
                        var issueDals = new IssueDAL();
                        // get the list of issues for the specific projectID.
                        proj.Issues = issueDals.GetIssueList(proj.ProjectID);
                        // add to the project list
                        projects.Add(proj);

                    }

                }

            }
            catch (Exception)
            {
                throw;
            }
            return projects;
        }
 /// <summary>
 /// Create a new IssueDAL object.
 /// </summary>
 /// <param name="issueID">Initial value of the IssueID property.</param>
 /// <param name="subject">Initial value of the Subject property.</param>
 /// <param name="description">Initial value of the Description property.</param>
 /// <param name="projectID">Initial value of the ProjectID property.</param>
 public static IssueDAL CreateIssueDAL(global::System.Int32 issueID, global::System.String subject, global::System.String description, global::System.Int32 projectID)
 {
     IssueDAL issueDAL = new IssueDAL();
     issueDAL.IssueID = issueID;
     issueDAL.Subject = subject;
     issueDAL.Description = description;
     issueDAL.ProjectID = projectID;
     return issueDAL;
 }
 /// <summary>
 /// Deprecated Method for adding a new object to the IssueDALs EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToIssueDALs(IssueDAL issueDAL)
 {
     base.AddObject("IssueDALs", issueDAL);
 }