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(); } }
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; } }
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; } }
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; } }
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); })); }
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; } }
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); }
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; } }
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; } }