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