Example #1
0
        /// <summary>
        /// Find the news by id.
        /// </summary>
        /// <param name="newsId">the news id to find.</param>
        /// <returns></returns>
        private async Task <NewsViewData> FindNews(int newsId)
        {
            NewsViewData newsViewData = new NewsViewData()
            {
                TranslationsList = new List <NewsTranslationItemData>(),
                News             = new NewsItemData()
            };
            NewsRequestData findNewsRequest = new NewsRequestData
            {
                NewsDto = new NewsItemData {
                    NewsId = newsId
                },
                FindNewsDto = FindNewsItemData.NewsId
            };
            NewsResultData resultNews = await WebApiClient.PostFormJsonAsync <NewsRequestData, NewsResultData>(Constant.WebApiControllerNews, Constant.WebApiFindNews, findNewsRequest);

            if (resultNews != null && resultNews.OperationSuccess && resultNews.NewsDto != null)
            {
                newsViewData.News = resultNews.NewsDto;
                NewsTranslationRequestData findNewsTranslationRequest = new NewsTranslationRequestData()
                {
                    NewsTranslationDto = new NewsTranslationItemData {
                        NewsId = newsId
                    },
                    FindNewsTranslationDto = FindNewsTranslationItemData.NewsId
                };
                NewsTranslationResultData resultNewsTranslation = await WebApiClient.PostFormJsonAsync <NewsTranslationRequestData, NewsTranslationResultData>(Constant.WebApiControllerNews, Constant.WebApiFindNewsTranslations, findNewsTranslationRequest);

                if (resultNewsTranslation != null && resultNewsTranslation.OperationSuccess && resultNewsTranslation.NewsTranslationDtoList != null)
                {
                    newsViewData.TranslationsList.Add(resultNewsTranslation.NewsTranslationDtoList.First(t => t.LanguageId == _lang));
                }
            }
            return(newsViewData);
        }
        /// <summary>
        /// Get the news list.
        /// </summary>
        /// <returns></returns>
        private async Task <NewsViewDatas> GetNews()
        {
            NewsResultData newsResultData =
                await WebApiClient.GetAsync <NewsResultData>(Constant.WebApiControllerNews, Constant.WebApiNewsList);

            List <NewsViewData> newsViewDataList = new List <NewsViewData>();

            if (newsResultData == null || !newsResultData.OperationSuccess ||
                newsResultData.NewsDtoList == null)
            {
                return(null);
            }
            foreach (var newsDto in newsResultData.NewsDtoList)
            {
                NewsViewData newsViewData = new NewsViewData
                {
                    TranslationsList = new List <NewsTranslationItemData>(),
                    News             = newsDto
                };
                newsViewData.TranslationsList = await GetNewsTranslations(newsDto.NewsId);

                newsViewDataList.Add(newsViewData);
            }
            NewsViewDatas newlistdatas = new NewsViewDatas {
                NewsViewDataList = newsViewDataList
            };

            return(newlistdatas);
        }
Example #3
0
        public override ActionResult Index()
        {
            var vd = new NewsViewData
            {
                News     = CurrentItem,
                Back     = CurrentItem.Parent,
                Comments = CurrentItem.GetComments()
            };

            return(View("index", vd));
        }
Example #4
0
        public static NewsViewData Load()
        {
            WhereClause   w          = new WhereClause();
            SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true);

            if (!dataReader.Read())
            {
                dataReader.Close();
                throw new FinderException("Load found no rows for NewsView.");
            }
            NewsViewData data = GetDataObjectFromReader(dataReader);

            dataReader.Close();
            return(data);
        }
Example #5
0
        public static void Update(NewsViewData data)
        {
            // Create and execute the command
            NewsViewData oldData = Load();
            string       sql     = "Update " + TABLE + " set ";

            if (!oldData.Title.Equals(data.Title))
            {
                sql = sql + "Title=@Title,";
            }
            if (!oldData.Summary.Equals(data.Summary))
            {
                sql = sql + "Summary=@Summary,";
            }
            if (!oldData.DateStart.Equals(data.DateStart))
            {
                sql = sql + "DateStart=@DateStart,";
            }
            if (!oldData.DateEnd.Equals(data.DateEnd))
            {
                sql = sql + "DateEnd=@DateEnd,";
            }
            if (!oldData.IsPublic.Equals(data.IsPublic))
            {
                sql = sql + "IsPublic=@IsPublic,";
            }
            if (!oldData.DateModified.Equals(data.DateModified))
            {
                sql = sql + "DateModified=@DateModified,";
            }
            if (!oldData.LastModifiedFirstName.Equals(data.LastModifiedFirstName))
            {
                sql = sql + "LastModifiedFirstName=@LastModifiedFirstName,";
            }
            if (!oldData.LastModifiedLastName.Equals(data.LastModifiedLastName))
            {
                sql = sql + "LastModifiedLastName=@LastModifiedLastName,";
            }
            if (!oldData.CreateFirstName.Equals(data.CreateFirstName))
            {
                sql = sql + "CreateFirstName=@CreateFirstName,";
            }
            if (!oldData.CreateLastName.Equals(data.CreateLastName))
            {
                sql = sql + "CreateLastName=@CreateLastName,";
            }
            if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
            {
                sql = sql + "OrgGroupsID=@OrgGroupsID,";
            }
            if (!oldData.NewsImage.Equals(data.NewsImage))
            {
                sql = sql + "NewsImage=@NewsImage,";
            }
            if (!oldData.TemplateType.Equals(data.TemplateType))
            {
                sql = sql + "TemplateType=@TemplateType,";
            }
            if (!oldData.NewsArticlesID.Equals(data.NewsArticlesID))
            {
                sql = sql + "NewsArticlesID=@NewsArticlesID,";
            }
            if (!oldData.Text.Equals(data.Text))
            {
                sql = sql + "Text=@Text,";
            }
            if (!oldData.LastModifiedID.Equals(data.LastModifiedID))
            {
                sql = sql + "LastModifiedID=@LastModifiedID,";
            }
            WhereClause w = new WhereClause();

            sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
            SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);

            //Create the parameters and append them to the command object
            if (!oldData.Title.Equals(data.Title))
            {
                cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Title", DataRowVersion.Proposed, data.Title.DBValue));
            }
            if (!oldData.Summary.Equals(data.Summary))
            {
                cmd.Parameters.Add(new SqlParameter("@Summary", SqlDbType.VarChar, 500, ParameterDirection.Input, false, 0, 0, "Summary", DataRowVersion.Proposed, data.Summary.DBValue));
            }
            if (!oldData.DateStart.Equals(data.DateStart))
            {
                cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue));
            }
            if (!oldData.DateEnd.Equals(data.DateEnd))
            {
                cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue));
            }
            if (!oldData.IsPublic.Equals(data.IsPublic))
            {
                cmd.Parameters.Add(new SqlParameter("@IsPublic", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsPublic", DataRowVersion.Proposed, !data.IsPublic.IsValid ? data.IsPublic.DBValue : data.IsPublic.DBValue.Equals("Y") ? 1 : 0));
            }
            if (!oldData.DateModified.Equals(data.DateModified))
            {
                cmd.Parameters.Add(new SqlParameter("@DateModified", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateModified", DataRowVersion.Proposed, data.DateModified.DBValue));
            }
            if (!oldData.LastModifiedFirstName.Equals(data.LastModifiedFirstName))
            {
                cmd.Parameters.Add(new SqlParameter("@LastModifiedFirstName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "LastModifiedFirstName", DataRowVersion.Proposed, data.LastModifiedFirstName.DBValue));
            }
            if (!oldData.LastModifiedLastName.Equals(data.LastModifiedLastName))
            {
                cmd.Parameters.Add(new SqlParameter("@LastModifiedLastName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "LastModifiedLastName", DataRowVersion.Proposed, data.LastModifiedLastName.DBValue));
            }
            if (!oldData.CreateFirstName.Equals(data.CreateFirstName))
            {
                cmd.Parameters.Add(new SqlParameter("@CreateFirstName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "CreateFirstName", DataRowVersion.Proposed, data.CreateFirstName.DBValue));
            }
            if (!oldData.CreateLastName.Equals(data.CreateLastName))
            {
                cmd.Parameters.Add(new SqlParameter("@CreateLastName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "CreateLastName", DataRowVersion.Proposed, data.CreateLastName.DBValue));
            }
            if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
            {
                cmd.Parameters.Add(new SqlParameter("@OrgGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsID", DataRowVersion.Proposed, data.OrgGroupsID.DBValue));
            }
            if (!oldData.NewsImage.Equals(data.NewsImage))
            {
                cmd.Parameters.Add(new SqlParameter("@NewsImage", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "NewsImage", DataRowVersion.Proposed, data.NewsImage.DBValue));
            }
            if (!oldData.TemplateType.Equals(data.TemplateType))
            {
                cmd.Parameters.Add(new SqlParameter("@TemplateType", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "TemplateType", DataRowVersion.Proposed, data.TemplateType.DBValue));
            }
            if (!oldData.NewsArticlesID.Equals(data.NewsArticlesID))
            {
                cmd.Parameters.Add(new SqlParameter("@NewsArticlesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "NewsArticlesID", DataRowVersion.Proposed, data.NewsArticlesID.DBValue));
            }
            if (!oldData.Text.Equals(data.Text))
            {
                cmd.Parameters.Add(new SqlParameter("@Text", SqlDbType.Text, 0, ParameterDirection.Input, false, 0, 0, "Text", DataRowVersion.Proposed, data.Text.DBValue));
            }
            if (!oldData.LastModifiedID.Equals(data.LastModifiedID))
            {
                cmd.Parameters.Add(new SqlParameter("@LastModifiedID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "LastModifiedID", DataRowVersion.Proposed, data.LastModifiedID.DBValue));
            }

            // Execute the query
            if (cmd.Parameters.Count > 0)
            {
                cmd.ExecuteNonQuery();
            }
        }
Example #6
0
        public static void Insert(NewsViewData data)
        {
            // Create and execute the command
            string sql = "Insert Into " + TABLE + "("
                         + "Title,"
                         + "Summary,"
                         + "DateStart,"
                         + "DateEnd,"
                         + "IsPublic,"
                         + "DateModified,"
                         + "LastModifiedFirstName,"
                         + "LastModifiedLastName,"
                         + "CreateFirstName,"
                         + "CreateLastName,"
                         + "OrgGroupsID,"
                         + "NewsImage,"
                         + "TemplateType,"
                         + "NewsArticlesID,"
                         + "Text,"
                         + "LastModifiedID,"
            ;

            sql = sql.Substring(0, sql.Length - 1) + ") values("
                  + "@Title,"
                  + "@Summary,"
                  + "@DateStart,"
                  + "@DateEnd,"
                  + "@IsPublic,"
                  + "@DateModified,"
                  + "@LastModifiedFirstName,"
                  + "@LastModifiedLastName,"
                  + "@CreateFirstName,"
                  + "@CreateLastName,"
                  + "@OrgGroupsID,"
                  + "@NewsImage,"
                  + "@TemplateType,"
                  + "@NewsArticlesID,"
                  + "@Text,"
                  + "@LastModifiedID,"
            ;
            sql = sql.Substring(0, sql.Length - 1) + ")";
            SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);

            //Create the parameters and append them to the command object
            cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Title", DataRowVersion.Proposed, data.Title.DBValue));
            cmd.Parameters.Add(new SqlParameter("@Summary", SqlDbType.VarChar, 500, ParameterDirection.Input, false, 0, 0, "Summary", DataRowVersion.Proposed, data.Summary.DBValue));
            cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue));
            cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue));
            cmd.Parameters.Add(new SqlParameter("@IsPublic", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsPublic", DataRowVersion.Proposed, !data.IsPublic.IsValid ? data.IsPublic.DBValue : data.IsPublic.DBValue.Equals("Y") ? 1 : 0));
            cmd.Parameters.Add(new SqlParameter("@DateModified", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateModified", DataRowVersion.Proposed, data.DateModified.DBValue));
            cmd.Parameters.Add(new SqlParameter("@LastModifiedFirstName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "LastModifiedFirstName", DataRowVersion.Proposed, data.LastModifiedFirstName.DBValue));
            cmd.Parameters.Add(new SqlParameter("@LastModifiedLastName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "LastModifiedLastName", DataRowVersion.Proposed, data.LastModifiedLastName.DBValue));
            cmd.Parameters.Add(new SqlParameter("@CreateFirstName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "CreateFirstName", DataRowVersion.Proposed, data.CreateFirstName.DBValue));
            cmd.Parameters.Add(new SqlParameter("@CreateLastName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "CreateLastName", DataRowVersion.Proposed, data.CreateLastName.DBValue));
            cmd.Parameters.Add(new SqlParameter("@OrgGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsID", DataRowVersion.Proposed, data.OrgGroupsID.DBValue));
            cmd.Parameters.Add(new SqlParameter("@NewsImage", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "NewsImage", DataRowVersion.Proposed, data.NewsImage.DBValue));
            cmd.Parameters.Add(new SqlParameter("@TemplateType", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "TemplateType", DataRowVersion.Proposed, data.TemplateType.DBValue));
            cmd.Parameters.Add(new SqlParameter("@NewsArticlesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "NewsArticlesID", DataRowVersion.Proposed, data.NewsArticlesID.DBValue));
            cmd.Parameters.Add(new SqlParameter("@Text", SqlDbType.Text, 0, ParameterDirection.Input, false, 0, 0, "Text", DataRowVersion.Proposed, data.Text.DBValue));
            cmd.Parameters.Add(new SqlParameter("@LastModifiedID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "LastModifiedID", DataRowVersion.Proposed, data.LastModifiedID.DBValue));

            // Execute the query
            cmd.ExecuteNonQuery();
        }
Example #7
0
        private static NewsViewData GetDataObjectFromReader(SqlDataReader dataReader)
        {
            NewsViewData data = new NewsViewData();

            if (dataReader.IsDBNull(dataReader.GetOrdinal("Title")))
            {
                data.Title = StringType.UNSET;
            }
            else
            {
                data.Title = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Title")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("Summary")))
            {
                data.Summary = StringType.UNSET;
            }
            else
            {
                data.Summary = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Summary")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("DateStart")))
            {
                data.DateStart = DateType.UNSET;
            }
            else
            {
                data.DateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateStart")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("DateEnd")))
            {
                data.DateEnd = DateType.UNSET;
            }
            else
            {
                data.DateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateEnd")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("IsPublic")))
            {
                data.IsPublic = BooleanType.UNSET;
            }
            else
            {
                data.IsPublic = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsPublic")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("DateModified")))
            {
                data.DateModified = DateType.UNSET;
            }
            else
            {
                data.DateModified = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateModified")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("LastModifiedFirstName")))
            {
                data.LastModifiedFirstName = StringType.UNSET;
            }
            else
            {
                data.LastModifiedFirstName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LastModifiedFirstName")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("LastModifiedLastName")))
            {
                data.LastModifiedLastName = StringType.UNSET;
            }
            else
            {
                data.LastModifiedLastName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LastModifiedLastName")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("CreateFirstName")))
            {
                data.CreateFirstName = StringType.UNSET;
            }
            else
            {
                data.CreateFirstName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("CreateFirstName")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("CreateLastName")))
            {
                data.CreateLastName = StringType.UNSET;
            }
            else
            {
                data.CreateLastName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("CreateLastName")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
            {
                data.OrgGroupsID = IntegerType.UNSET;
            }
            else
            {
                data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("NewsImage")))
            {
                data.NewsImage = StringType.UNSET;
            }
            else
            {
                data.NewsImage = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("NewsImage")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("TemplateType")))
            {
                data.TemplateType = IntegerType.UNSET;
            }
            else
            {
                data.TemplateType = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("TemplateType")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("NewsArticlesID")))
            {
                data.NewsArticlesID = IntegerType.UNSET;
            }
            else
            {
                data.NewsArticlesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("NewsArticlesID")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("Text")))
            {
                data.Text = StringType.UNSET;
            }
            else
            {
                data.Text = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Text")));
            }
            if (dataReader.IsDBNull(dataReader.GetOrdinal("LastModifiedID")))
            {
                data.LastModifiedID = IntegerType.UNSET;
            }
            else
            {
                data.LastModifiedID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("LastModifiedID")));
            }

            return(data);
        }