public static TTEntry Load(IDataRecord reader)
{
TTEntry ret = new TTEntry();
ret._timeSheetId = (int)reader["TimeSheetId"];
ret._weekTimeSheetId = (int)reader["WeekTimeSheetId"];
ret._objectTypeId = (int)reader["ObjectTypeId"];
ret._objectId = (int)reader["ObjectId"];
ret._day1 = (int)reader["Day1"];
ret._day2 = (int)reader["Day2"];
ret._day3 = (int)reader["Day3"];
ret._day4 = (int)reader["Day4"];
ret._day5 = (int)reader["Day5"];
ret._day6 = (int)reader["Day6"];
ret._day7 = (int)reader["Day7"];
ret._totalApproved = (int)reader["TotalApproved"];
ret._rate = (decimal)reader["Rate"];
ret._userComments = reader["UserComments"].ToString();
ret._actualId = Helper.NullToInt32(reader["ActualId"]);
return ret;
}
public static TTEntry Load(IDataRecord reader)
{
TTEntry ret = new TTEntry();
ret._timeSheetId = (int)reader["TimeSheetId"];
ret._weekTimeSheetId = (int)reader["WeekTimeSheetId"];
ret._objectTypeId = (int)reader["ObjectTypeId"];
ret._objectId = (int)reader["ObjectId"];
ret._day1 = (int)reader["Day1"];
ret._day2 = (int)reader["Day2"];
ret._day3 = (int)reader["Day3"];
ret._day4 = (int)reader["Day4"];
ret._day5 = (int)reader["Day5"];
ret._day6 = (int)reader["Day6"];
ret._day7 = (int)reader["Day7"];
ret._totalApproved = (int)reader["TotalApproved"];
ret._rate = (decimal)reader["Rate"];
ret._userComments = reader["UserComments"].ToString();
ret._actualId = Helper.NullToInt32(reader["ActualId"]);
return(ret);
}
public static IDictionary <int, TTEntry> LoadList(DBHelper source)
{
Dictionary <int, TTEntry> ret = new Dictionary <int, TTEntry>();
using (IDataReader reader = source.RunTextDataReader("SELECT * FROM [TIMESHEETS]"))
{
while (reader.Read())
{
TTEntry item = Load(reader);
if (!ret.ContainsKey(item._timeSheetId))
{
ret.Add(item._timeSheetId, item);
}
}
}
foreach (TTEntry entry in ret.Values)
{
string table = null;
string field = null;
switch (entry._objectTypeId)
{
case 3:
table = "PROJECTS";
field = "ProjectId";
break;
case 4:
table = "EVENTS";
field = "EventId";
break;
case 5:
table = "TASKS";
field = "TaskId";
break;
case 6:
table = "TODO";
field = "ToDoId";
break;
case 7:
table = "INCIDENTS";
field = "IncidentId";
break;
case 11:
table = "TIMESHEET_TODO";
field = "TimeSheetToDoId";
break;
case 16:
table = "DOCUMENTS";
field = "DocumentId";
break;
}
if (table != null && field != null)
{
object title = source.RunTextScalar(string.Format(CultureInfo.InvariantCulture, "SELECT [Title] FROM [{0}] WHERE [{1}] = @p1", table, field), DBHelper.MP("@p1", SqlDbType.Int, entry._objectId));
if (title != null && title != DBNull.Value)
{
entry._title = title.ToString();
}
else
{
entry._objectTypeId = -1;
entry._objectId = -1;
entry._title = string.Format(CultureInfo.InvariantCulture, "#{0}", entry._timeSheetId);
}
}
}
return(ret);
}
