Exemplo n.º 1
0
        public static ProjectsEntity CreateProject(int createUserID, ISystemDateTime datetimeProvider)
        {
            ProjectsEntity model = new ProjectsEntity();

            model.ID         = 0;
            model.CreatedBy  = createUserID;
            model.CreatedOn  = datetimeProvider.Now;
            model.ModifiedBy = createUserID;
            model.ModifiedOn = datetimeProvider.Now;

            model.Billable            = false;
            model.BugNeedApproved     = false;
            model.CompanyID           = 0;
            model.Description         = string.Empty;
            model.EndDate             = datetimeProvider.Now;
            model.FreeHour            = 0;
            model.IsOverFreeTime      = false;
            model.PMID                = 0;
            model.Priority            = string.Empty;
            model.ProjectCode         = string.Empty;
            model.ProjectID           = 0;
            model.RequestNeedApproved = false;
            model.StartDate           = datetimeProvider.Now;
            model.Status              = ProjectStatus.Open;
            model.TestLinkURL         = string.Empty;
            model.TestPassword        = string.Empty;
            model.TestUserName        = string.Empty;
            model.Title               = string.Empty;

            return(model);
        }
Exemplo n.º 2
0
        /// <summary>
        /// Bind IDataReader to Entity
        /// </summary>
        public static ProjectsEntity ReaderBind(IDataReader dataReader)
        {
            ProjectsEntity model = new ProjectsEntity();
            object         ojb;

            ojb = dataReader["ProjectID"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.ProjectID = (int)ojb;
                model.ID        = model.ProjectID;
            }
            ojb = dataReader["CompanyID"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.CompanyID = (int)ojb;
            }
            model.ProjectCode = dataReader["ProjectCode"].ToString();
            model.Title       = dataReader["Title"].ToString();
            model.Description = dataReader["Description"].ToString();
            ojb = dataReader["StartDate"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.StartDate = (DateTime)ojb;
            }
            ojb = dataReader["EndDate"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.EndDate = (DateTime)ojb;
            }
            ojb = dataReader["Status"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.Status = (ProjectStatus)ojb;
            }
            ojb = dataReader["CreatedBy"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.CreatedBy = (int)ojb;
            }
            ojb = dataReader["CreatedOn"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.CreatedOn = (DateTime)ojb;
            }
            ojb = dataReader["ModifiedBy"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.ModifiedBy = (int)ojb;
            }
            ojb = dataReader["ModifiedOn"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.ModifiedOn = (DateTime)ojb;
            }
            ojb = dataReader["PMID"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.PMID = (int)ojb;
            }
            model.Priority = dataReader["Priority"].ToString();
            ojb            = dataReader["Billable"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.Billable = (bool)ojb;
            }
            model.TestLinkURL  = dataReader["TestLinkURL"].ToString();
            model.TestUserName = dataReader["TestUserName"].ToString();
            model.TestPassword = dataReader["TestPassword"].ToString();
            ojb = dataReader["FreeHour"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.FreeHour = (int)ojb;
            }
            ojb = dataReader["BugNeedApproved"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.BugNeedApproved = (bool)ojb;
            }
            ojb = dataReader["RequestNeedApproved"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.RequestNeedApproved = (bool)ojb;
            }
            ojb = dataReader["IsOverFreeTime"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.IsOverFreeTime = (bool)ojb;
            }
            ojb = dataReader["TotalHours"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.TotalHours = float.Parse(ojb.ToString());
            }
            ojb = dataReader["MaintenancePlanOption"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.MaintenancePlanOption = (string)ojb;
            }
            return(model);
        }