protected ProjectViewModel Map(IDataReader reader)
        {
            var project = new ProjectViewModel()
            {
                ID                        = NullHandler.GetInt32(reader, "Id"),
                Title                     = NullHandler.GetString(reader, "Title"),
                ProjectNumber             = NullHandler.GetString(reader, "ProjectNumber"),
                ProjectStatusID           = (short)NullHandler.GetInt32(reader, "ProjectStatusID"),
                ProjectPriorityID         = NullHandler.GetByte(reader, "ProjectPriorityID"),
                PlanName                  = NullHandler.GetString(reader, "PlanName"),
                PlanNumber                = NullHandler.GetString(reader, "PlanNumber"),
                StartDate                 = NullHandler.GetDateTime(reader, "StartDate"),
                DueDate                   = NullHandler.GetDateTime(reader, "DueDate"),
                JobAddress                = NullHandler.GetString(reader, "JobAddress"),
                JobCity                   = NullHandler.GetString(reader, "JobCity"),
                JobState                  = NullHandler.GetString(reader, "JobState"),
                JobZipAddress             = NullHandler.GetString(reader, "JobZipAddress"),
                DWGFileLocation           = NullHandler.GetString(reader, "DWGFIleLocation"),
                ProjectTypeNotes          = NullHandler.GetString(reader, "ProjectTypeNotes"),
                CustomerID                = NullHandler.GetInt32(reader, "CustomerID"),
                ReviewedByID              = NullHandler.GetInt32(reader, "ReviewedByID"),
                ProjectTypeID             = NullHandler.GetInt32(reader, "ProjectTypeID"),
                IsFoundation              = NullHandler.GetBoolean(reader, "IsFoundation"),
                FoundationTypeID          = NullHandler.GetInt32(reader, "FoundationTypeID"),
                CrawlSpaceJoist           = NullHandler.GetString(reader, "CrawlSpaceJoist"),
                IsHaveSoilsReport         = NullHandler.GetBoolean(reader, "IsHaveSoilsReport"),
                How_WhenSending           = NullHandler.GetString(reader, "How_WhenSending"),
                IsFraming                 = NullHandler.GetBoolean(reader, "IsFraming"),
                TypeOfFloorJoist          = NullHandler.GetString(reader, "TypeOfFloorJoist"),
                MaxFloorJoistSpacing      = NullHandler.GetString(reader, "MaxFloorJoistSpacing"),
                TypeOfCeilingJoist        = NullHandler.GetString(reader, "TypeOfCeilingJoist"),
                RoofingMaterials          = NullHandler.GetString(reader, "RoofingMaterials"),
                WeightOfRoofingMaterials  = NullHandler.GetString(reader, "WeightOfRoofingMaterials"),
                ProjectMaterialNotes      = NullHandler.GetString(reader, "ProjectMaterialNotes"),
                CouriertoWhom             = NullHandler.GetString(reader, "CouriertoWhom"),
                CouriertoAddress          = NullHandler.GetString(reader, "CouriertoAddress"),
                IsHaveCourierPlans        = NullHandler.GetBoolean(reader, "IsHaveCourierPlans"),
                IsHaveEmail               = NullHandler.GetBoolean(reader, "IsHaveEmail"),
                EmailAddress              = NullHandler.GetString(reader, "EmailAddress"),
                IsCustomerWillPickup      = NullHandler.GetBoolean(reader, "IsCustomerWillPickup"),
                PickupByPersonName        = NullHandler.GetString(reader, "PickupByPersonName"),
                PickupByPersonPhoneNumber = NullHandler.GetString(reader, "PickupByPersonPhoneNumber"),
                NumberOfCopies            = NullHandler.GetInt32(reader, "NumberOfCopies"),
                ProjectHoldNotes          = NullHandler.GetString(reader, "ProjectHoldNotes"),
                CustomerData              = NullHandler.GetString(reader, "CustomerData"),
                Invoice                   = NullHandler.GetString(reader, "Invoice"),
                ProjectStatusName         = NullHandler.GetString(reader, "ProjectStatusName"),
                ProjectPriorityTitle      = NullHandler.GetString(reader, "ProjectPriorityTitle"),
                CustomerName              = NullHandler.GetString(reader, "CustomerName"),
                ReviewedByName            = NullHandler.GetString(reader, "ReviewedByName"),
                ProjectTypeName           = NullHandler.GetString(reader, "ProjectTypeName"),
                FoundationTypeName        = NullHandler.GetString(reader, "FoundationTypeName"),
            };

            return(project);
        }
예제 #2
0
        protected ProjectPriority Map(IDataReader reader)
        {
            var ProjectPriority = new ProjectPriority()
            {
                ID            = NullHandler.GetInt32(reader, "ID"),
                PriorityTitle = NullHandler.GetString(reader, "PriorityTitle"),
            };

            return(ProjectPriority);
        }
        protected FoundationType Map(IDataReader reader)
        {
            var FoundationType = new FoundationType()
            {
                ID = NullHandler.GetInt32(reader, "ID"),
                FoundationTypeTitle = NullHandler.GetString(reader, "FoundationTypeTitle"),
            };

            return(FoundationType);
        }
예제 #4
0
        protected ProjectType Map(IDataReader reader)
        {
            var ProjectType = new ProjectType()
            {
                ID = NullHandler.GetInt32(reader, "ID"),
                ProjectTypeTitle = NullHandler.GetString(reader, "ProjectTypeTitle"),
            };

            return(ProjectType);
        }
        protected TaskStatus Map(IDataReader reader)
        {
            var taskStatus = new TaskStatus()
            {
                ID          = NullHandler.GetInt32(reader, "ID"),
                StatusTitle = NullHandler.GetString(reader, "StatusTitle"),
            };

            return(taskStatus);
        }
예제 #6
0
        protected Note Map(IDataReader reader)
        {
            var Note = new Note()
            {
                ID                  = NullHandler.GetInt32(reader, "ID"),
                Comment             = NullHandler.GetString(reader, "Comment"),
                TaskId              = NullHandler.GetInt32(reader, "TaskId"),
                CreatedDate         = NullHandler.GetDateTime(reader, "CreatedDate"),
                CreatedByEmployeeId = NullHandler.GetInt32(reader, "CreatedByEmployeeId"),
            };

            return(Note);
        }
예제 #7
0
        protected Customer Map(IDataReader reader)
        {
            var Customer = new Customer()
            {
                ID        = NullHandler.GetInt32(reader, "ID"),
                Title     = NullHandler.GetString(reader, "Title"),
                KeyPerson = NullHandler.GetString(reader, "KeyPerson"),
                Address   = NullHandler.GetString(reader, "Address"),
                City      = NullHandler.GetString(reader, "City"),
                State     = NullHandler.GetString(reader, "State"),
                Zip       = NullHandler.GetString(reader, "Zip"),
                Phone     = NullHandler.GetString(reader, "Phone"),
                Email     = NullHandler.GetString(reader, "Email"),
            };

            return(Customer);
        }
예제 #8
0
        protected Proposal Map(IDataReader reader)
        {
            var Proposal = new Proposal()
            {
                ID                                    = NullHandler.GetInt32(reader, "ID"),
                Name                                  = NullHandler.GetString(reader, "Name"),
                Address                               = NullHandler.GetString(reader, "Address"),
                City                                  = NullHandler.GetString(reader, "City"),
                State                                 = NullHandler.GetString(reader, "State"),
                Zip                                   = NullHandler.GetString(reader, "zip"),
                Details                               = NullHandler.GetString(reader, "Details"),
                InitialContractDate                   = NullHandler.GetDateTime(reader, "InitialContractDate"),
                SubmittalDate                         = NullHandler.GetDateTime(reader, "SubmittalDate"),
                RevisionDate                          = NullHandler.GetDateTime(reader, "RevisionDate"),
                ProposalType                          = NullHandler.GetString(reader, "ProposalType"),
                DailyType                             = NullHandler.GetString(reader, "DailyType"),
                ProjectType                           = NullHandler.GetString(reader, "ProjectType"),
                ProjectOtherTypeValue                 = NullHandler.GetString(reader, "ProjectOtherTypeValue"),
                FoundationTypeValue                   = NullHandler.GetString(reader, "FoundationTypeValue"),
                FoundationSlabTypeValue               = NullHandler.GetString(reader, "FoundationSlabTypeValue"),
                FoundationPierTypeValue               = NullHandler.GetString(reader, "FoundationPierTypeValue"),
                FoundationPierRemiedialTypeValue      = NullHandler.GetString(reader, "FoundationPierRemiedialTypeValue"),
                FoundationPierRemiedialOtherTypeValue = NullHandler.GetString(reader, "FoundationPierRemiedialOtherTypeValue"),
                FoundationOtherTypeValue              = NullHandler.GetString(reader, "FoundationOtherTypeValue"),
                FrameTypeValue                        = NullHandler.GetString(reader, "FrameTypeValue"),
                FrameResidentialValue                 = NullHandler.GetString(reader, "FrameResidentialValue"),
                FrameResidentialOtherValue            = NullHandler.GetString(reader, "FrameResidentialOtherValue"),
                FrameExteriorValue                    = NullHandler.GetString(reader, "FrameExteriorValue"),
                FrameExteriorOtherValue               = NullHandler.GetString(reader, "FrameExteriorOtherValue"),
                FrameRoofTypeValue                    = NullHandler.GetString(reader, "FrameRoofTypeValue"),
                FrameRoofTypeOtherValue               = NullHandler.GetString(reader, "FrameRoofTypeOtherValue"),
                RetainingWallValue                    = NullHandler.GetString(reader, "RetainingWallValue"),
                RetainingWallTypeValue                = NullHandler.GetString(reader, "RetainingWallTypeValue"),
                RetainingWallTypeWallValue            = NullHandler.GetString(reader, "RetainingWallTypeWallValue"),
                RetainingWallTypeWallOtherValue       = NullHandler.GetString(reader, "RetainingWallTypeWallOtherValue"),
                PoolValue                             = NullHandler.GetString(reader, "PoolValue"),
                PoolCompnayDesignValue                = NullHandler.GetString(reader, "PoolCompnayDesignValue"),
                ClientID                              = NullHandler.GetInt32(reader, "ClientID"),
            };

            return(Proposal);
        }
예제 #9
0
        protected Employee Map(IDataReader reader)
        {
            var Employee = new Employee()
            {
                ID                     = NullHandler.GetInt32(reader, "ID"),
                Name                   = NullHandler.GetString(reader, "Name"),
                FirstName              = NullHandler.GetString(reader, "FirstName"),
                LastName               = NullHandler.GetString(reader, "LastName"),
                Designation            = NullHandler.GetString(reader, "Designation"),
                Phone                  = NullHandler.GetString(reader, "Phone"),
                Email                  = NullHandler.GetString(reader, "Email"),
                Zip                    = NullHandler.GetString(reader, "Zip"),
                State                  = NullHandler.GetString(reader, "State"),
                City                   = NullHandler.GetString(reader, "City"),
                Address                = NullHandler.GetString(reader, "Address"),
                HasReviewAuthorization = NullHandler.GetBoolean(reader, "HasReviewAuthorization"),
                IsInManagement         = NullHandler.GetBoolean(reader, "IsInManagement"),
                IsInDirectorPanel      = NullHandler.GetBoolean(reader, "IsInDirectorPanel")
            };

            return(Employee);
        }
        protected TaskVM Map(IDataReader reader)
        {
            var TaskVM = new TaskVM()
            {
                ID                 = NullHandler.GetInt32(reader, "ID"),
                TaskName           = NullHandler.GetString(reader, "TaskName"),
                ProjectID          = NullHandler.GetInt32(reader, "ProjectID"),
                ProjectName        = NullHandler.GetString(reader, "ProjectName"),
                TaskStatusID       = NullHandler.GetInt32(reader, "TaskStatusID"),
                TaskStatus         = NullHandler.GetString(reader, "TaskStatus"),
                DesignByEmployeeID = NullHandler.GetInt32(reader, "DesignByEmployeeID"),
                DesignByEmployee   = NullHandler.GetString(reader, "DesignByEmployee"),
                Deadline           = NullHandler.GetDateTime(reader, "Deadline"),
                ShortDescription   = NullHandler.GetString(reader, "ShortDescription"),
                FullDescription    = NullHandler.GetString(reader, "FullDescription"),
                NewReviewNotes     = NullHandler.GetString(reader, "NewReviewNotes"),
                ReviewNotes        = NullHandler.GetString(reader, "ReviewNotes"),
                TaskForProject     = NullHandler.GetBoolean(reader, "TaskForProject")
            };

            return(TaskVM);
        }