Example #1
0
        public static WeekList GetWeeksData()
        {
            WeekList weeks = null;

            using (var db = new DataBase("sp_GetWeekData", null))
            {
                var reader = db.ExecuteReader();

                if (reader.HasRows)
                {
                    weeks = new WeekList();

                    while (reader.Read())
                    {
                        var week = new Week();

                        week.Id = reader.GetValueOrDefault<int>("ID");
                        week.YearWeekNumber = reader.GetValueOrDefault<int>("WeekNo");
                        week.Year = reader.GetValueOrDefault<int>("WeekNoYear");
                        week.Month = reader.GetValueOrDefault<int>("WeekNoMonth");
                        week.Day = reader.GetValueOrDefault<int>("WeekNoDay");
                        week.MondayDate = reader.GetValueOrDefault<DateTime>("WeekNoStartDate");

                        weeks.Add(week);
                    }
                }
            }

            return weeks;
        }
Example #2
0
        public static ProjectList GetAllInactive()
        {
            ProjectList projects = null;

            using (var db = new DataBase("sp_GetInActiveProjects_NEW", null))
            {
                var reader = db.ExecuteReader();

                if (reader.HasRows)
                {
                    projects = ConvertReaderDataToProjectList(reader);
                }
            }

            return projects;
        }
Example #3
0
        public static ProjectList GetProjectsByEmployeeID(int employeeID)
        {
            ProjectList projects = null;

            var parms = new Dictionary<string, string>();
            parms.Add("@EmployeeID", employeeID.ToString());

            using (var db = new DataBase("sp_GetProjectsByEmployeeID_NEW", parms))
            {
                var reader = db.ExecuteReader();

                if (reader.HasRows)
                {
                    projects = ConvertReaderDataToProjectList(reader);
                }
            }

            return projects;
        }
Example #4
0
        public static Project GetById(int projectId)
        {
            Project project = null;

            var parms = new Dictionary<string, string>();
            parms.Add("@ProjectId", projectId.ToString());

            using (var db = new DataBase("sp_GetProjectById_NEW", parms))
            {
                var reader = db.ExecuteReader();

                if (reader.HasRows)
                {
                    project = ConvertReaderDataToProjectList(reader)[0];
                }
            }

            return project;
        }
Example #5
0
        public static List<Employee> GetEngineersByProjectId(int projectId)
        {
            List<Employee> employees = null;

            var parms = new Dictionary<string, string>();
            parms.Add("@ProjectId", projectId.ToString());

            using (var db = new DataBase("sp_GetEngineersByProjectID_NEW", parms))
            {
                var reader = db.ExecuteReader();

                if (reader.HasRows)
                {
                    employees = ConvertReaderDataToProjectList(reader);
                }
            }

            return employees;
        }
Example #6
0
        public static Employee GetById(int employeeId)
        {
            Employee employee = null;

            var parms = new Dictionary<string, string>();
            parms.Add("EmployeeID", employeeId.ToString());

            using (var db = new DataBase("sp_GetEmployeeByID", parms))
            {
                var reader = db.ExecuteReader();

                if (reader.HasRows)
                {
                    employee = ConvertReaderDataToProjectList(reader)[0];
                }
            }

            return employee;
        }
Example #7
0
        public static ScheduleItemList GetProjectSchedules(ProjectList projects, DateTime startDate, DateTime endDate)
        {
            ScheduleItemList schedules = null;

            if (projects != null && projects.Count > 0)
            {
                var parms = new Dictionary<string, string>();
                parms.Add("@ProjectList", string.Join(",", (from p in projects select p.Id).ToArray()));
                parms.Add("@StartDate", startDate.ToShortDateString());
                parms.Add("@EndDate", endDate.ToShortDateString());

                using (var db = new DataBase("sp_GetProjectSchedules_NEW", parms))
                {
                    var reader = db.ExecuteReader();

                    if (reader.HasRows)
                    {
                        schedules = ConvertReaderDataToScheduleItemList(reader);
                    }
                }
            }
            return schedules;
        }
Example #8
0
        public static bool Insert(Project newProject, int createdByEmployeeId)
        {
            var parms = new Dictionary<string, string>();
            parms.Add("@ProjectNo", newProject.ProjectNumber.ToString());
            parms.Add("@ProjectName", newProject.Name);
            parms.Add("@ClientID", newProject.ClientId.ToString());
            parms.Add("@ProjectLocation", newProject.Location);
            parms.Add("@ConstructionType", newProject.ConstructionType);
            parms.Add("@ProjectType", newProject.ProjectType);
            parms.Add("@PhaseID", newProject.PhaseId.ToString());
            parms.Add("@EstimatedStartDate", newProject.EstimatedStartDate != DateTime.MinValue ? newProject.EstimatedStartDate.ToShortDateString() : DBNull.Value.ToString());
            parms.Add("@EstimatedCompletionDate", newProject.EstimatedCompletionDate != DateTime.MinValue ? newProject.EstimatedCompletionDate.ToShortDateString() : DBNull.Value.ToString());
            parms.Add("@FeeAmount", newProject.FeeAmount.ToString());
            parms.Add("@FeeStructure", newProject.FeeStructure);
            parms.Add("@Comments", newProject.Comments);
            parms.Add("@PIC", newProject.PICId.ToString());
            parms.Add("@PICCode", newProject.PICCode);
            parms.Add("@PM1", newProject.PM1Id.ToString());
            parms.Add("@PM1Code", newProject.PM1Code);
            parms.Add("@EmployeeID", createdByEmployeeId.ToString());

            using (var db = new DataBase("sp_Project_Insert_NEW", parms))
            {
                return db.ExecuteProcedure();
            }
        }