public AssessmentLabour(String argConnection, Int32 argAssessmentLabourId)
{
mConnection = argConnection;
string pstrSql = "SELECT * FROM AssessmentLabour WHERE AssessmentLabourId=" + argAssessmentLabourId;
SqlDataReader dr = SqlHelper.ExecuteReader(Connection, CommandType.Text, pstrSql);
if (dr.Read())
{
mAssessmentLabourId = (System.Int32)dr["AssessmentLabourId"];
mAssessment = new Assessment(Connection, (int)dr["AssessmentId"]);
mSrNo = (System.String)dr["SrNo"];
mClaimId = (System.Int32)dr["ClaimId"];
mDescClaimed = dr["DescClaimed"].GetType() == typeof(System.DBNull) ? "" : (System.String)dr["DescClaimed"];
mClaimed = (System.Double)dr["Claimed"];
mPart = new Part(Connection, (int)dr["PartId"]);
mDescAssessed = dr["DescAssessed"].GetType() == typeof(System.DBNull) ? "" : (System.String)dr["DescAssessed"];
mAssessedRR = (System.Double)dr["AssessedRR"];
mAssessedDB = (System.Double)dr["AssessedDB"];
mPaintType = new PaintType(Connection, (int)dr["PaintTypeId"]);
mAssessedPT = (System.Double)dr["AssessedPT"];
mNetAssessed = System.Double.Parse(dr["NetAssessed"].ToString());
mWorkshop = new Workshop(Connection, dr.GetInt32(dr.GetOrdinal("WorkshopId")));
mEstimate = new Estimate(Connection, dr.GetInt32(dr.GetOrdinal("EstimateId")));
}
else
{
Exception ex = new Exception("Identifier does not exist.");
ex.Source = "AssessmentLabour.AssessmentLabour()";
throw ex;
}
dr.Close();
}
public AssessmentPart(String argConnection, Int32 argAssessmentPartId)
{
TransactionType = enumDBTransaction.spNull;
mConnection = argConnection;
string pstrSql = "SELECT * FROM AssessmentPart WHERE AssessmentPartId=" + argAssessmentPartId;
SqlDataReader dr = SqlHelper.ExecuteReader(Connection, CommandType.Text, pstrSql);
if (dr.Read())
{
mAssessmentPartId = (System.Int32)dr["AssessmentPartId"];
mSrNo = (System.String)dr["SrNo"];
mPart = new Part(Connection, (int)dr["PartId"]);
mDescription = (System.String)dr["Description"];
mClaimed = (System.Single)dr["Claimed"];
mAssessed = (System.Single)dr["Assessed"];
mVATRate = (System.Single)dr["VATRate"];
mVAT = float.Parse(dr["VAT"].ToString());
mDepreciationRate = (System.Single)dr["DepreciationRate"];
mDepreciation = (System.Single)dr["Depreciation"];
mNetAssessed = (System.Single)dr["NetAssessed"];
mWorkshop = new Workshop(Connection, dr.GetInt32(dr.GetOrdinal("WorkshopId")));
mEstimate = new Estimate(Connection, dr.GetInt32(dr.GetOrdinal("EstimateId")));
}
else
{
Exception ex = new Exception("Identifier does not exist.");
ex.Source = "AssessmentPart.AssessmentPart()";
throw ex;
}
dr.Close();
}
public PartEstimate(Estimate estimate, Workshop workshop, AssessmentParts assessmentParts)
{
this.Estimate = estimate;
this.Workshop = workshop;
this.AssessmentParts = assessmentParts;
}
public LabourEstimate(Estimate estimate, Workshop workshop, AssessmentLabours assessmentParts)
{
this.Estimate = estimate;
this.Workshop = workshop;
this.AssessmentLabours = assessmentParts;
}