/// <summary>
/// Bind IDataReader to Entity
/// </summary>
public static ExpandTimeSheetsEntity ReaderBind(IDataReader dataReader)
{
TimeSheetsEntity model = TimeSheetsEntity.ReaderBind(dataReader);
ExpandTimeSheetsEntity expandModel = (ExpandTimeSheetsEntity)model;
expandModel.TicketDescription = dataReader["TicketDescription"].ToString();
return(expandModel);
}
public static TimeSheetsEntity CreateTimeSheet(int createUserID, ISystemDateTime datetimeProvider)
{
TimeSheetsEntity model = new TimeSheetsEntity();
model.ID = 0;
model.CreatedBy = createUserID;
model.CreatedOn = datetimeProvider.Now;
model.ModifiedBy = createUserID;
model.ModifiedOn = datetimeProvider.Now;
model.Description = string.Empty;
model.Hours = 0;
model.IsMeeting = false;
model.IsSubmitted = false;
model.Percentage = 0;
model.ProjectID = 0;
model.SheetDate = datetimeProvider.Now;
model.TicketID = 0;
model.UserID = 0;
return(model);
}
/// <summary>
/// Bind IDataReader to Entity
/// </summary>
public static TimeSheetsEntity ReaderBind(IDataReader dataReader)
{
TimeSheetsEntity model = new TimeSheetsEntity();
object ojb;
ojb = dataReader["ID"];
if (ojb != null && ojb != DBNull.Value)
{
model.ID = (int)ojb;
}
ojb = dataReader["SheetDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.SheetDate = (DateTime)ojb;
}
ojb = dataReader["ProjectID"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProjectID = (int)ojb;
}
ojb = dataReader["TicketID"];
if (ojb != null && ojb != DBNull.Value)
{
model.TicketID = (int)ojb;
}
ojb = dataReader["UserID"];
if (ojb != null && ojb != DBNull.Value)
{
model.UserID = (int)ojb;
}
ojb = dataReader["Hours"];
if (ojb != null && ojb != DBNull.Value)
{
model.Hours = (decimal)ojb;
}
ojb = dataReader["Percentage"];
if (ojb != null && ojb != DBNull.Value)
{
model.Percentage = (decimal)ojb;
}
model.Description = dataReader["Description"].ToString();
ojb = dataReader["IsSubmitted"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsSubmitted = (bool)ojb;
}
ojb = dataReader["CreatedOn"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreatedOn = (DateTime)ojb;
}
ojb = dataReader["CreatedBy"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreatedBy = (int)ojb;
}
ojb = dataReader["ModifiedOn"];
if (ojb != null && ojb != DBNull.Value)
{
model.ModifiedOn = (DateTime)ojb;
}
ojb = dataReader["ModifiedBy"];
if (ojb != null && ojb != DBNull.Value)
{
model.ModifiedBy = (int)ojb;
}
ojb = dataReader["IsMeeting"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsMeeting = (bool)ojb;
}
ojb = dataReader["EventID"];
if (ojb != null && ojb != DBNull.Value)
{
model.EventID = (int)ojb;
}
return(model);
}