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