Esempio n. 1
0
        public void Insert(ref DBHelper objdbhelper, IStateNews objNews, IImageDetail objImageDetail, IUsers user)
        {
            var objNewsDB = StateNewsDB.Instance;

            try
            {
                objNews.EditorID     = "1";
                objNews.DisplayOrder = 1;
                objNews.IsActive     = 0;
                objNews.IsApproved   = 0;
                objNews.LanguageID   = 1;
                //objNews.StateCode = "BR";

                objImageDetail.IsActive = 0;
                objImageDetail.IsFirst  = 1;


                StateNewsDB.Instance.Insert(ref objdbhelper, objNews, objImageDetail, user);
            }
            catch (Exception objExp)
            {
                throw objExp;
            }
            finally
            {
                objdbhelper.Dispose();
                objNewsDB.Dispose();
            }
        }
Esempio n. 2
0
        public void Update(ref DBHelper dbHelper, ITopNews news, IImageDetail image, IUsers user)
        {
            try
            {
                dbHelper.AddInParameter("@TopNewsID", news.TopNewsID, DbType.String);
                dbHelper.AddInParameter("@EditorID", news.EditorID, DbType.String);
                dbHelper.AddInParameter("@DisplayOrder", news.DisplayOrder, DbType.Int32);
                dbHelper.AddInParameter("@Heading", news.Heading, DbType.String);
                dbHelper.AddInParameter("@ShortDescription", news.ShortDescription, DbType.String);
                dbHelper.AddInParameter("@NewsDescription", news.NewsDescription, DbType.String);
                dbHelper.AddInParameter("@LanguageID", news.LanguageID, DbType.Int32);
                dbHelper.AddInParameter("@IsActive", news.IsActive, DbType.Int32);
                dbHelper.AddInParameter("@IsApproved", news.IsApproved, DbType.Int32);
                dbHelper.AddInParameter("@ImageUrl", image.ImageUrl, DbType.String);
                dbHelper.AddInParameter("@Caption", image.Caption, DbType.String);
                dbHelper.AddInParameter("@ImageType", image.ImageType, DbType.Int32);
                dbHelper.AddInParameter("@IsFirst", image.IsFirst, DbType.Int32);
                dbHelper.AddInParameter("@IsActieImage", image.IsActive, DbType.Int32);
                dbHelper.AddInParameter("@UserID", user.UserID, DbType.Int64);

                dbHelper.ExecuteNonQuery(ProcedureName.UpdateLatestNews, CommandType.StoredProcedure);
            }
            catch (Exception objExp)
            {
                throw objExp;
            }
        }
Esempio n. 3
0
        public void Insert(ref DBHelper dbInstance, IStateNews objNews, IImageDetail objImageDetail, IUsers user)
        {
            try
            {
                dbInstance.ClearAllParameters();
                dbInstance.AddInParameter("@EditorID", objNews.EditorID, DbType.String);
                dbInstance.AddInParameter("@DisplayOrder", objNews.DisplayOrder, DbType.Int32);
                dbInstance.AddInParameter("@Heading", objNews.Heading, DbType.String);
                dbInstance.AddInParameter("@ShortDescription", objNews.ShortDescription, DbType.String);
                dbInstance.AddInParameter("@NewsDescription", objNews.NewsDescription, DbType.String);
                dbInstance.AddInParameter("@LanguageID", objNews.LanguageID, DbType.Int32);
                dbInstance.AddInParameter("@StateCode", objNews.StateCode, DbType.String);
                dbInstance.AddInParameter("@IsTopNews", objNews.IsTopNews, DbType.Int32);
                dbInstance.AddInParameter("@ImageUrl", objImageDetail.ImageUrl, DbType.String);
                dbInstance.AddInParameter("@Caption", objImageDetail.Caption, DbType.String);
                dbInstance.AddInParameter("@CaptionLink", objImageDetail.CaptionLink, DbType.String);
                dbInstance.AddInParameter("@ImageType", objImageDetail.ImageType, DbType.Int32);
                dbInstance.AddInParameter("@IsFirst", objImageDetail.IsFirst, DbType.Int32);
                dbInstance.AddInParameter("@UserID", user.UserID, DbType.Int64);

                dbInstance.ExecuteNonQuery(ProcedureName.InsertStateNews, CommandType.StoredProcedure);
            }
            catch (Exception objExp)
            {
                throw objExp;
            }
        }
Esempio n. 4
0
        public void Insert(ref DBHelper dbInstance, IStateNews objNews, IImageDetail objImageDetail, IUsers user)
        {
            try
            {
                dbInstance.ClearAllParameters();
                dbInstance.AddInParameter("@EditorID", objNews.EditorID, DbType.String);
                dbInstance.AddInParameter("@DisplayOrder", objNews.DisplayOrder, DbType.Int32);
                dbInstance.AddInParameter("@Heading", objNews.Heading, DbType.String);
                dbInstance.AddInParameter("@ShortDescription", objNews.ShortDescription, DbType.String);
                dbInstance.AddInParameter("@NewsDescription", objNews.NewsDescription, DbType.String);
                dbInstance.AddInParameter("@LanguageID", objNews.LanguageID, DbType.Int32);
                dbInstance.AddInParameter("@StateCode", objNews.StateCode, DbType.String);
                dbInstance.AddInParameter("@IsTopNews", objNews.IsTopNews, DbType.Int32);
                dbInstance.AddInParameter("@ImageUrl", objImageDetail.ImageUrl, DbType.String);
                dbInstance.AddInParameter("@Caption", objImageDetail.Caption, DbType.String);
                dbInstance.AddInParameter("@CaptionLink", objImageDetail.CaptionLink, DbType.String);
                dbInstance.AddInParameter("@ImageType", objImageDetail.ImageType, DbType.Int32);
                dbInstance.AddInParameter("@IsFirst", objImageDetail.IsFirst, DbType.Int32);
                dbInstance.AddInParameter("@UserID", user.UserID, DbType.Int64);

                dbInstance.ExecuteNonQuery(ProcedureName.InsertStateNews, CommandType.StoredProcedure);
            }
            catch (Exception objExp)
            {
                throw objExp;
            }
        }
Esempio n. 5
0
 public void UpdateNews(ref DBHelper dbHelper, ITopNews news, IImageDetail image, IUsers user)
 {
     try
     {
         news.EditorID = news.EditorID == null ? String.Empty : news.EditorID;
         TopNewsDB.Instance.Update(ref dbHelper, news, image, user);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 6
0
        public async Task <ActionResult> UpdateNews(string NewsID)
        {
            return(await Task.Run(() =>
            {
                ViewBag.Message = "Update new news.";
                UpdateNews newForUpdate = null;
                var news = StateNewsBL.Instance.Select(NewsID);
                if (news != null)
                {
                    var imgList = ImageDetailBL.Instance.StateNewsImageList(NewsID);
                    IImageDetail image = null;
                    if (imgList != null && imgList.Count() > 0)
                    {
                        image = imgList.FirstOrDefault(v => v.IsActive == 1 && v.IsFirst == 1);
                    }

                    newForUpdate = new UpdateNews
                    {
                        NewsID = news.NewsID,
                        Heading = news.Heading,
                        StateCode = news.StateCode,
                        ShortDesc = news.ShortDescription,
                        Description = news.NewsDescription,
                        Image = null,
                        ImageUrl = " ",
                        Caption = " ",
                        CaptionLink = string.Empty,
                        IsActiveNews = news.IsActive == 1 ? true : false,
                        IsApprovedNews = news.IsApproved == 1 ? true : false,
                        IsTopTenNews = news.IsTopNews == 1 ? true : false
                    };

                    if (image != null)
                    {
                        newForUpdate.ImageUrl = string.IsNullOrEmpty(image.ImageUrl) ? " " : image.ImageUrl;
                        newForUpdate.Caption = news.ImageCaption;
                        newForUpdate.CaptionLink = news.ImageCaptionLink;
                    }
                }
                return View(newForUpdate);
            }));
        }
Esempio n. 7
0
        public void Insert(ref DBHelper objdbhelper, ITopNews objTopNews, IImageDetail objImageDetail, IUsers user)
        {
            try
            {
                objTopNews.EditorID     = "1";
                objTopNews.DisplayOrder = 1;
                objTopNews.IsActive     = 0;
                objTopNews.IsApproved   = 0;
                objTopNews.LanguageID   = 1;

                objImageDetail.IsActive = 0;
                objImageDetail.IsFirst  = 1;


                TopNewsDB.Instance.Insert(ref objdbhelper, objTopNews, objImageDetail, user);
            }
            catch (Exception objExp)
            {
                throw objExp;
            }
        }
Esempio n. 8
0
        public void Insert(ref DBHelper objdbhelper, ITopNews objTopNews, IImageDetail objImageDetail, IUsers user)
        {
            try
            {
              
                objTopNews.EditorID = "1";
                objTopNews.DisplayOrder = 1;
                objTopNews.IsActive = 0;
                objTopNews.IsApproved = 0;
                objTopNews.LanguageID = 1;

                objImageDetail.IsActive = 0;
                objImageDetail.IsFirst = 1;


                TopNewsDB.Instance.Insert(ref objdbhelper, objTopNews, objImageDetail, user);
            }
            catch (Exception objExp)
            {
                throw objExp;
            }
        }
Esempio n. 9
0
        public IEnumerable <IImageDetail> SelectImageList(string NewsID)
        {
            IDataReader         objDataReader      = null;
            List <IImageDetail> objImageDetailList = null;
            IImageDetail        objImageDetail     = null;

            var dbHelper = DBHelper.Instance;

            try
            {
                dbHelper.AddInParameter("@NewsID", NewsID, DbType.String);
                objDataReader = dbHelper.ExecuteDataReader(ProcedureName.SelectTopNewsImageDetail, CommandType.StoredProcedure);

                if (objDataReader != null)
                {
                    objImageDetailList = new List <IImageDetail>();
                    do
                    {
                        while (objDataReader.Read())
                        {
                            objImageDetail = new ImageDetail();

                            if (!objDataReader.IsDBNull(0))
                            {
                                objImageDetail.ImageID = objDataReader.GetString(0);
                            }

                            if (!objDataReader.IsDBNull(1))
                            {
                                objImageDetail.ImageUrl = objDataReader.GetString(1);
                            }

                            if (!objDataReader.IsDBNull(2))
                            {
                                objImageDetail.ImageType = objDataReader.GetInt32(2);
                            }

                            if (!objDataReader.IsDBNull(3))
                            {
                                objImageDetail.IsFirst = objDataReader.GetInt32(3);
                            }

                            if (!objDataReader.IsDBNull(4))
                            {
                                objImageDetail.IsActive = objDataReader.GetInt32(4);
                            }

                            if (!objDataReader.IsDBNull(5))
                            {
                                objImageDetail.DttmCreated = objDataReader.GetDateTime(5);
                            }

                            if (!objDataReader.IsDBNull(6))
                            {
                                objImageDetail.DttmModified = objDataReader.GetDateTime(6);
                            }


                            objImageDetailList.Add(objImageDetail);
                        }
                    }while (objDataReader.NextResult());
                }

                if (!objDataReader.IsClosed)
                {
                    objDataReader.Close();
                }
            }
            catch (Exception objExp)
            {
                throw objExp;
            }
            finally
            {
                dbHelper.ClearAllParameters();
                dbHelper.CloseConnection();
                dbHelper.Dispose();
            }

            return(objImageDetailList);
        }
Esempio n. 10
0
 public void UpdateNews(ref DBHelper dbHelper, IStateNews news, IImageDetail image, IUsers user)
 {
     try
     {
         news.EditorID = news.EditorID == null ? String.Empty : news.EditorID;
         StateNewsDB.Instance.Update(ref dbHelper, news, image, user);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 11
0
        public void Insert(ref DBHelper objdbhelper, IStateNews objNews, IImageDetail objImageDetail, IUsers user)
        {
            var objNewsDB = StateNewsDB.Instance;
            try
            {
                objNews.EditorID = "1";
                objNews.DisplayOrder = 1;
                objNews.IsActive = 0;
                objNews.IsApproved = 0;
                objNews.LanguageID = 1;
                //objNews.StateCode = "BR";

                objImageDetail.IsActive = 0;
                objImageDetail.IsFirst = 1;

                StateNewsDB.Instance.Insert(ref objdbhelper, objNews, objImageDetail, user);
            }
            catch (Exception objExp)
            {
                throw objExp;
            }
            finally
            {
                objdbhelper.Dispose();
                objNewsDB.Dispose();
            }
        }
Esempio n. 12
0
        internal void Update(ref DBHelper dbHelper, IStateNews news, IImageDetail image, IUsers user)
        {
            try
            {
                dbHelper.ClearAllParameters();
                dbHelper.AddInParameter("@NewsID", news.NewsID, DbType.String);
                dbHelper.AddInParameter("@EditorID", news.EditorID, DbType.String);
                dbHelper.AddInParameter("@DisplayOrder", news.DisplayOrder, DbType.Int32);
                dbHelper.AddInParameter("@Heading", news.Heading, DbType.String);
                dbHelper.AddInParameter("@ShortDescription", news.ShortDescription, DbType.String);
                dbHelper.AddInParameter("@NewsDescription", news.NewsDescription, DbType.String);
                dbHelper.AddInParameter("@LanguageID", news.LanguageID, DbType.Int32);
                dbHelper.AddInParameter("@StateCode", news.StateCode, DbType.String);
                dbHelper.AddInParameter("@IsActive", news.IsActive, DbType.Int32);
                dbHelper.AddInParameter("@IsApproved", news.IsApproved, DbType.Int32);
                dbHelper.AddInParameter("@IsTopNews", news.IsTopNews, DbType.Int32);
                dbHelper.AddInParameter("@ImageUrl", image.ImageUrl, DbType.String);
                dbHelper.AddInParameter("@Caption", image.Caption, DbType.String);
                dbHelper.AddInParameter("@CaptionLink", image.CaptionLink, DbType.String);
                dbHelper.AddInParameter("@ImageType", image.ImageType, DbType.Int32);
                dbHelper.AddInParameter("@IsFirst", image.IsFirst, DbType.Int32);
                dbHelper.AddInParameter("@IsActieImage", image.IsActive, DbType.Int32);
                dbHelper.AddInParameter("@UserID", user.UserID, DbType.Int64);

                dbHelper.ExecuteNonQuery(ProcedureName.UpdateStateNews, CommandType.StoredProcedure);
            }
            catch (Exception objExp)
            {
                throw objExp;
            }
        }