public static ExpandTicketsEntity ExReaderBind(IDataReader dataReader)
{
ExpandTicketsEntity model = (ExpandTicketsEntity)ExpandTicketsEntity.ReaderBindExpand(dataReader);
try
{
object ojb = dataReader["Percentage"];
if (ojb != null && ojb != DBNull.Value)
{
model.Percentage = Convert.ToDecimal(ojb.ToString());
}
else
{
model.Percentage = 0;
}
model.ProjectTitle = dataReader["ProjectTitle"].ToString();
ojb = dataReader["OrderNum"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrderNum = int.Parse(ojb.ToString());
}
else
{
model.OrderNum = 0;
}
model.FirstName = dataReader["FirstName"].ToString();
model.LastName = dataReader["LastName"].ToString();
model.FullDescription = model.Description;
int maxLength = 150;
if (model.Description.Length > maxLength)
{
model.Description = model.Description.Substring(0, maxLength);
}
}
catch
{
}
return(model);
}
private static TicketsEntity ReaderBindExpand(IDataReader dataReader)
{
TicketsEntity model = new ExpandTicketsEntity();
object ojb;
ojb = dataReader["TicketID"];
if (ojb != null && ojb != DBNull.Value)
{
model.ID = (int)ojb;
model.TicketID = (int)ojb;
}
ojb = dataReader["CompanyID"];
if (ojb != null && ojb != DBNull.Value)
{
model.CompanyID = (int)ojb;
}
ojb = dataReader["ProjectID"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProjectID = (int)ojb;
}
model.Title = dataReader["Title"].ToString();
model.TicketCode = dataReader["TicketCode"].ToString();
ojb = dataReader["TicketType"];
if (ojb != null && ojb != DBNull.Value)
{
model.TicketType = (TicketsType)Enum.Parse(typeof(TicketsType), ojb.ToString());
}
model.Description = dataReader["Description"].ToString();
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["PublishDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.PublishDate = (DateTime)ojb;
}
ojb = dataReader["ClientPublished"];
if (ojb != null && ojb != DBNull.Value)
{
model.ClientPublished = (bool)ojb;
}
ojb = dataReader["StartDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.StartDate = (DateTime)ojb;
}
ojb = dataReader["DeliveryDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.DeliveryDate = (DateTime)ojb;
}
ojb = dataReader["ContinueDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.ContinueDate = (int)ojb;
}
model.URL = dataReader["URL"].ToString();
ojb = dataReader["Priority"];
if (ojb != null && ojb != DBNull.Value)
{
model.Priority = (PriorityState)ojb;
}
ojb = dataReader["Status"];
if (ojb != null && ojb != DBNull.Value)
{
model.Status = (TicketsState)ojb;
}
ojb = dataReader["ConvertDelete"];
if (ojb != null && ojb != DBNull.Value)
{
model.ConvertDelete = (CovertDeleteState)ojb;
}
ojb = dataReader["IsInternal"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsInternal = (bool)ojb;
}
ojb = dataReader["CreateType"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateType = (int)ojb;
}
ojb = dataReader["SourceTicketID"];
if (ojb != null && ojb != DBNull.Value)
{
model.SourceTicketID = (int)ojb;
}
ojb = dataReader["IsEstimates"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsEstimates = (bool)ojb;
}
ojb = dataReader["InitialTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.InitialTime = (decimal)ojb;
}
ojb = dataReader["FinalTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.FinalTime = (decimal)ojb;
}
ojb = dataReader["Star"];
if (ojb != null && ojb != DBNull.Value)
{
model.Star = (int)ojb;
}
ojb = dataReader["IsRead"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsRead = (TicketIsRead)ojb;
}
if (dataReader.Contains("CreatedByFirstName"))
{
model.CreatedByFirstName = dataReader["CreatedByFirstName"].ToString();
}
if (dataReader.Contains("CreatedByLastName"))
{
model.CreatedByLastName = dataReader["CreatedByLastName"].ToString();
}
return(model);
}
