/// <summary>
/// Builds an instance of a Component Image from a Sql Data Reader object
/// </summary>
/// <param name="reader"></param>
/// <returns>Instance of a <strong>Component Image</strong></returns>
public static ProjectComponentImages BuildComponentImageModel(SqlDataReader reader)
{
var image = new ProjectComponentImages()
{
Id = DbUtilities.GetInt(reader, "PCImageId"),
ProjectComponentId = DbUtilities.GetInt(reader, "ProjectComponentId"),
ProjectComponentImageUrl = DbUtilities.GetString(reader, "ProjectComponentImageUrl"),
};
return(image);
}
/// <summary>
/// Builds an instance of a SubContractor from a Sql Data Reader object
/// </summary>
/// <param name="reader"></param>
/// <returns>Instance of a <strong>SubContractor</strong></returns>
public static SubContractor BuildSubContractorModel(SqlDataReader reader)
{
var subcontractor = new SubContractor()
{
Id = DbUtilities.GetInt(reader, "SubId"),
UserProfileId = DbUtilities.GetInt(reader, "UserProfileId"),
SubcontractorBusinessName = DbUtilities.GetString(reader, "SubContractorBusinessName"),
SubContractorImageLocation = DbUtilities.GetString(reader, "SubContractorImageUrl"),
};
return(subcontractor);
}
/// <summary>
/// Builds an instance of a ProjectComponent from a Sql Data Reader object
/// </summary>
/// <param name="reader"></param>
/// <returns>Instance of a <strong>ProjectComponent</strong></returns>
public static ProjectComponent BuildProjectComponentModel(SqlDataReader reader)
{
var projectcomponent = new ProjectComponent()
{
Id = DbUtilities.GetInt(reader, "ProjectComponentId"),
ProjectId = DbUtilities.GetInt(reader, "ProjectId"),
ComponentName = DbUtilities.GetString(reader, "ProjectComponentName"),
ComponentDescription = DbUtilities.GetString(reader, "ComponentDescription"),
SubcontractorId = DbUtilities.GetNullableInt(reader, "SubcontractorId"),
DateComplete = DbUtilities.GetNullableDateTime(reader, "PCDateComplete"),
MaterialCost = DbUtilities.GetInt(reader, "MaterialCost"),
};
return(projectcomponent);
}
/// <summary>
/// Builds an instance of a SubContractor from a Sql Data Reader object
/// </summary>
/// <param name="reader"></param>
/// <returns>Instance of a <strong>SubContractor</strong></returns>
public static SubContractorBid BuildSubContractorBidModel(SqlDataReader reader)
{
var subContractorBid = new SubContractorBid()
{
Id = DbUtilities.GetInt(reader, "BidId"),
ProjectComponentId = DbUtilities.GetInt(reader, "ProjectComponentId"),
SubContractorId = DbUtilities.GetInt(reader, "SubContractorId"),
UserProfileId = DbUtilities.GetInt(reader, "UserProfileId"),
Fee = DbUtilities.GetInt(reader, "Fee"),
SubAccepted = DbUtilities.GetNullableDateTime(reader, "SubAccepted"),
OwnerComment = DbUtilities.GetString(reader, "OwnerComment")
};
return(subContractorBid);
}
/// <summary>
/// Builds an instance of a User Profile from a Sql Data Reader object
/// </summary>
/// <param name="reader"></param>
/// <returns>Instance of <strong>UserProfile</strong></returns>
public static UserProfile BuildUserProfileModel(SqlDataReader reader)
{
var user = new UserProfile()
{
Id = DbUtilities.GetInt(reader, "UserId"),
FirstName = DbUtilities.GetString(reader, "FirstName"),
LastName = DbUtilities.GetString(reader, "LastName"),
ScreenName = DbUtilities.GetString(reader, "ScreenName"),
Email = DbUtilities.GetString(reader, "Email"),
FirebaseUserId = DbUtilities.GetString(reader, "FirebaseUserId"),
ImageLocation = DbUtilities.GetString(reader, "ImageLocation"),
IsSubcontractor = DbUtilities.GetBit(reader, "IsSubcontractor")
};
return(user);
}
/// <summary>
/// Builds an instance of a Project from a Sql Data Reader object
/// </summary>
/// <param name="reader"></param>
/// <returns>Instance of a <strong>Project</strong></returns>
public static Project BuildProjectModel(SqlDataReader reader)
{
var project = new Project()
{
Id = DbUtilities.GetInt(reader, "ProjectId"),
UserProfileId = DbUtilities.GetInt(reader, "UserProfileId"),
ProjectName = DbUtilities.GetString(reader, "ProjectName"),
LocationName = DbUtilities.GetString(reader, "LocationName"),
LocationAddress = DbUtilities.GetString(reader, "LocationAddress"),
ProjectDescription = DbUtilities.GetString(reader, "ProjectDescription"),
Budget = DbUtilities.GetInt(reader, "Budget"),
DateComplete = DbUtilities.GetNullableDateTime(reader, "DateComplete"),
ImageLocation = DbUtilities.GetString(reader, "ProjectImage"),
Components = new List <ProjectComponent>()
};
return(project);
}
/// <summary>
/// Builds an instance of a SubContractorJob ('Is a' ProjectComponent) from a Sql Data Reader object
/// </summary>
/// <param name="reader"></param>
/// <returns>Instance of a <strong>SubContractorJob</strong></returns>
public static SubContractorJob BuildSubcontractorJobModel(SqlDataReader reader)
{
var job = new SubContractorJob()
{
Id = DbUtilities.GetInt(reader, "ProjectComponentId"),
ProjectId = DbUtilities.GetInt(reader, "ProjectId"),
ComponentName = DbUtilities.GetString(reader, "ProjectComponentName"),
ComponentDescription = DbUtilities.GetString(reader, "ComponentDescription"),
SubcontractorId = DbUtilities.GetNullableInt(reader, "SubcontractorId"),
DateComplete = DbUtilities.GetNullableDateTime(reader, "PCDateComplete"),
MaterialCost = DbUtilities.GetInt(reader, "MaterialCost"),
OwnerScreenName = DbUtilities.GetString(reader, "ScreenName"),
OwnerImageUrl = DbUtilities.GetString(reader, "ImageLocation"),
ProjectName = DbUtilities.GetString(reader, "ProjectName"),
LocationName = DbUtilities.GetString(reader, "LocationName"),
LocationAddress = DbUtilities.GetString(reader, "LocationAddress"),
SubcontractorFee = DbUtilities.GetInt(reader, "Fee"),
};
return(job);
}