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