public virtual List <QtiRowView> SelectAllByTimesheetID(int subscriberID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@TimesheetID", subscriberID)
};
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "_QtiRowViewSelectByTimesheetID", parameters))
{
List <QtiRowView> qtiRowViews = new List <QtiRowView>();
while (dataReader.Read())
{
QtiRowView qtiRowView = MakeQtiRowView(dataReader);
qtiRowViews.Add(qtiRowView);
}
return(qtiRowViews);
}
}
protected virtual QtiRowView MakeQtiRowView(SqlDataReader dataReader)
{
QtiRowView qtiRow = new QtiRowView();
// Table columns
qtiRow.ID = SqlClientUtility.GetInt32(dataReader, "ID", 0);
qtiRow.ID = SqlClientUtility.GetInt32(dataReader, "ID", 0);
qtiRow.TimesheetID = SqlClientUtility.GetInt32(dataReader, "TimesheetID", 0);
qtiRow.TimeFrom = SqlClientUtility.GetDateTime(dataReader, "TimeFrom", DateTime.Now);
qtiRow.TimeTo = SqlClientUtility.GetDateTime(dataReader, "TimeTo", DateTime.Now);
qtiRow.BreakHours = SqlClientUtility.GetDecimal(dataReader, "BreakHours", Decimal.Zero);
qtiRow.Hours = SqlClientUtility.GetDecimal(dataReader, "Hours", Decimal.Zero);
qtiRow.Activity = SqlClientUtility.GetString(dataReader, "Activity", String.Empty);
qtiRow.OvernightStay = SqlClientUtility.GetBoolean(dataReader, "OvernightStay", false);
qtiRow.Comments = SqlClientUtility.GetString(dataReader, "Comments", String.Empty);
qtiRow.ProjectPersonID = SqlClientUtility.GetInt32(dataReader, "ProjectPersonID", 0);
qtiRow.ExpensesAmount = SqlClientUtility.GetDecimal(dataReader, "ExpensesAmount", Decimal.Zero);
qtiRow.Mileage = SqlClientUtility.GetDecimal(dataReader, "Mileage", Decimal.Zero);
qtiRow.FromLocationID = SqlClientUtility.GetInt32(dataReader, "FromLocationID", 0);
qtiRow.ToLocationID = SqlClientUtility.GetInt32(dataReader, "ToLocationID", 0);
qtiRow.InternalComment = SqlClientUtility.GetString(dataReader, "InternalComment", String.Empty);
qtiRow.CreatedBy = SqlClientUtility.GetString(dataReader, "CreatedBy", String.Empty);
qtiRow.CreatedOn = SqlClientUtility.GetDateTime(dataReader, "CreatedOn", DateTime.Now);
qtiRow.AuditActionBy = SqlClientUtility.GetString(dataReader, "AuditActionBy", String.Empty);
qtiRow.AuditActionOn = SqlClientUtility.GetDateTime(dataReader, "AuditActionOn", DateTime.Now);
qtiRow.ExpensesDetails = SqlClientUtility.GetString(dataReader, "ExpensesDetails", String.Empty);
// Extended columns from view
qtiRow.ProjectCode = SqlClientUtility.GetString(dataReader, "ProjectCode", String.Empty);
qtiRow.ProjectName = SqlClientUtility.GetString(dataReader, "ProjectName", String.Empty);
qtiRow.CustomerCode = SqlClientUtility.GetString(dataReader, "CustomerCode", String.Empty);
qtiRow.CustomerName = SqlClientUtility.GetString(dataReader, "CustomerName", String.Empty);
qtiRow.FromLocationName = SqlClientUtility.GetString(dataReader, "FromLocationName", String.Empty);
qtiRow.ToLocationName = SqlClientUtility.GetString(dataReader, "ToLocationName", String.Empty);
qtiRow.MaxDailyHours = SqlClientUtility.GetDecimal(dataReader, "MaxDailyHours", Decimal.Zero);
qtiRow.ProjectFullName = (qtiRow.ProjectCode.Length > 0 ? qtiRow.ProjectCode + " - " : String.Empty) + qtiRow.ProjectName;
qtiRow.CustomerFullName = (qtiRow.CustomerCode.Length > 0 ? qtiRow.CustomerCode + " - " : String.Empty) + qtiRow.CustomerName;
return(qtiRow);
}
