internal IEnumerable<IInterNews> Select20TopNews()
{
IDataReader objDataReader = null;
List<IInterNews> objNewsList = null;
IInterNews objNews = null;
var dbHelper = DBHelper.Instance;
try
{
objDataReader = dbHelper.ExecuteDataReader(ProcedureName.Select20InterNews, CommandType.StoredProcedure);
if (objDataReader != null)
{
objNewsList = new List<IInterNews>();
do
{
while (objDataReader.Read())
{
objNews = new InterNews();
if (!objDataReader.IsDBNull(0))
objNews.NewsID = objDataReader.GetString(0);
if (!objDataReader.IsDBNull(1))
objNews.EditorID = objDataReader.GetString(1);
if (!objDataReader.IsDBNull(2))
objNews.DisplayOrder = objDataReader.GetInt32(2);
if (!objDataReader.IsDBNull(3))
objNews.Heading = objDataReader.GetString(3);
if (!objDataReader.IsDBNull(4))
objNews.ShortDescription = objDataReader.GetString(4);
if (!objDataReader.IsDBNull(5))
objNews.NewsDescription = objDataReader.GetString(5);
if (!objDataReader.IsDBNull(6))
objNews.LanguageID = objDataReader.GetInt32(6);
if (!objDataReader.IsDBNull(7))
objNews.IsApproved = objDataReader.GetInt32(7);
if (!objDataReader.IsDBNull(8))
objNews.IsActive = objDataReader.GetInt32(8);
if (!objDataReader.IsDBNull(9))
objNews.IsTopNews = objDataReader.GetInt32(9);
if (!objDataReader.IsDBNull(10))
objNews.DttmCreated = objDataReader.GetDateTime(10);
if (!objDataReader.IsDBNull(11))
objNews.DttmModified = objDataReader.GetDateTime(11);
if (!objDataReader.IsDBNull(12))
objNews.ImageUrl = objDataReader.GetString(12);
if (!objDataReader.IsDBNull(13))
objNews.ImageCaption = objDataReader.GetString(13);
objNewsList.Add(objNews);
}
}
while (objDataReader.NextResult());
}
if (!objDataReader.IsClosed)
objDataReader.Close();
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
dbHelper.ClearAllParameters();
dbHelper.CloseConnection();
dbHelper.Dispose();
}
return objNewsList.FindAll(v => v.DttmCreated.Date == DateTime.Now.Date || v.DttmCreated.Date.AddDays(-1) == DateTime.Now.Date.AddDays(-1)); ;
}
public IInterNews Select(string NewsID)
{
IInterNews objNews = null;
IDataReader objDataReader = null;
var dbHelper = DBHelper.Instance;
try
{
dbHelper.AddInParameter("@NewsID", NewsID, DbType.String);
objDataReader = dbHelper.ExecuteDataReader(ProcedureName.SelectInterNews, CommandType.StoredProcedure);
if (objDataReader != null)
{
while (objDataReader.Read())
{
objNews = new InterNews();
if (!objDataReader.IsDBNull(0))
objNews.NewsID = objDataReader.GetString(0);
if (!objDataReader.IsDBNull(1))
objNews.EditorID = objDataReader.GetString(1);
if (!objDataReader.IsDBNull(2))
objNews.DisplayOrder = objDataReader.GetInt32(2);
if (!objDataReader.IsDBNull(3))
objNews.Heading = objDataReader.GetString(3);
if (!objDataReader.IsDBNull(4))
objNews.ShortDescription = objDataReader.GetString(4);
if (!objDataReader.IsDBNull(5))
objNews.NewsDescription = objDataReader.GetString(5);
if (!objDataReader.IsDBNull(6))
objNews.LanguageID = objDataReader.GetInt32(6);
if (!objDataReader.IsDBNull(7))
objNews.IsApproved = objDataReader.GetInt32(7);
if (!objDataReader.IsDBNull(8))
objNews.IsActive = objDataReader.GetInt32(8);
if (!objDataReader.IsDBNull(9))
objNews.IsTopNews = objDataReader.GetInt32(9);
if (!objDataReader.IsDBNull(10))
objNews.DttmCreated = objDataReader.GetDateTime(10);
if (!objDataReader.IsDBNull(11))
objNews.DttmModified = objDataReader.GetDateTime(11);
if (!objDataReader.IsDBNull(12))
objNews.ImageUrl = objDataReader.GetString(12);
if (!objDataReader.IsDBNull(13))
objNews.ImageCaption = objDataReader.GetString(13);
}
}
if (!objDataReader.IsClosed)
objDataReader.Close();
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
dbHelper.ClearAllParameters();
dbHelper.CloseConnection();
dbHelper.Dispose();
}
return objNews;
}
public List<IInterNews> SelectAllForList(Int64? NextPageValue)
{
IDataReader objDataReader = null;
List<IInterNews> objNewsList = null;
IInterNews objNews = null;
DBHelper dbHelper = new DBHelper();
try
{
dbHelper.AddInParameter("@NextPageValue", NextPageValue, DbType.Int64);
objDataReader = dbHelper.ExecuteDataReader(ProcedureName.SelectAllInterForList, CommandType.StoredProcedure);
if (objDataReader != null)
{
objNewsList = new List<IInterNews>();
do
{
while (objDataReader.Read())
{
objNews = new InterNews();
if (!objDataReader.IsDBNull(0))
objNews.NewsID = objDataReader.GetString(0);
if (!objDataReader.IsDBNull(1))
objNews.EditorID = objDataReader.GetString(1);
if (!objDataReader.IsDBNull(2))
objNews.DisplayOrder = objDataReader.GetInt32(2);
if (!objDataReader.IsDBNull(3))
objNews.Heading = objDataReader.GetString(3);
if (!objDataReader.IsDBNull(4))
objNews.ShortDescription = objDataReader.GetString(4);
if (!objDataReader.IsDBNull(5))
objNews.NewsDescription = objDataReader.GetString(5);
if (!objDataReader.IsDBNull(6))
objNews.LanguageID = objDataReader.GetInt32(6);
if (!objDataReader.IsDBNull(7))
objNews.IsApproved = objDataReader.GetInt32(7);
if (!objDataReader.IsDBNull(8))
objNews.IsActive = objDataReader.GetInt32(8);
if (!objDataReader.IsDBNull(9))
objNews.IsTopNews = objDataReader.GetInt32(9);
if (!objDataReader.IsDBNull(10))
objNews.DttmCreated = objDataReader.GetDateTime(10);
if (!objDataReader.IsDBNull(11))
objNews.DttmModified = objDataReader.GetDateTime(11);
if (!objDataReader.IsDBNull(12))
objNews.ImageUrl = objDataReader.GetString(12);
if (!objDataReader.IsDBNull(13))
objNews.ImageCaption = objDataReader.GetString(13);
objNewsList.Add(objNews);
}
}
while (objDataReader.NextResult());
}
if (!objDataReader.IsClosed)
objDataReader.Close();
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
dbHelper.ClearAllParameters();
dbHelper.CloseConnection();
dbHelper.Dispose();
}
return objNewsList;
}
public List <IInterNews> Search(DateTime dateFrom, DateTime dateTo, string Heading)
{
IDataReader objDataReader = null;
List <IInterNews> objNewsList = null;
IInterNews objNews = null;
var dbHelper = DBHelper.Instance;
try
{
dbHelper.AddInParameter("@DateFrom", dateFrom.ToString("yyyy-MM-dd"));
dbHelper.AddInParameter("@DateTo", dateTo.ToString("yyyy-MM-dd"));
dbHelper.AddInParameter("@Heading", "%" + Heading + "%", DbType.String);
objDataReader = dbHelper.ExecuteDataReader(ProcedureName.SearchInterNews, CommandType.StoredProcedure);
if (objDataReader != null)
{
objNewsList = new List <IInterNews>();
do
{
while (objDataReader.Read())
{
objNews = new InterNews();
if (!objDataReader.IsDBNull(0))
{
objNews.NewsID = objDataReader.GetString(0);
}
if (!objDataReader.IsDBNull(1))
{
objNews.EditorID = objDataReader.GetString(1);
}
if (!objDataReader.IsDBNull(2))
{
objNews.DisplayOrder = objDataReader.GetInt32(2);
}
if (!objDataReader.IsDBNull(3))
{
objNews.Heading = objDataReader.GetString(3);
}
if (!objDataReader.IsDBNull(4))
{
objNews.ShortDescription = objDataReader.GetString(4);
}
if (!objDataReader.IsDBNull(5))
{
objNews.NewsDescription = objDataReader.GetString(5);
}
if (!objDataReader.IsDBNull(6))
{
objNews.LanguageID = objDataReader.GetInt32(6);
}
if (!objDataReader.IsDBNull(7))
{
objNews.IsApproved = objDataReader.GetInt32(7);
}
if (!objDataReader.IsDBNull(8))
{
objNews.IsActive = objDataReader.GetInt32(8);
}
if (!objDataReader.IsDBNull(9))
{
objNews.IsTopNews = objDataReader.GetInt32(9);
}
if (!objDataReader.IsDBNull(10))
{
objNews.DttmCreated = objDataReader.GetDateTime(10);
}
if (!objDataReader.IsDBNull(11))
{
objNews.DttmModified = objDataReader.GetDateTime(11);
}
objNewsList.Add(objNews);
}
}while (objDataReader.NextResult());
}
if (!objDataReader.IsClosed)
{
objDataReader.Close();
}
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
dbHelper.ClearAllParameters();
dbHelper.CloseConnection();
dbHelper.Dispose();
}
return(objNewsList);
}
public List<IInterNews> Search(DateTime dateFrom, DateTime dateTo, string Heading)
{
IDataReader objDataReader = null;
List<IInterNews> objNewsList = null;
IInterNews objNews = null;
var dbHelper = DBHelper.Instance;
try
{
dbHelper.AddInParameter("@DateFrom", dateFrom.ToString("yyyy-MM-dd"));
dbHelper.AddInParameter("@DateTo", dateTo.ToString("yyyy-MM-dd"));
dbHelper.AddInParameter("@Heading", "%" + Heading + "%", DbType.String);
objDataReader = dbHelper.ExecuteDataReader(ProcedureName.SearchInterNews, CommandType.StoredProcedure);
if (objDataReader != null)
{
objNewsList = new List<IInterNews>();
do
{
while (objDataReader.Read())
{
objNews = new InterNews();
if (!objDataReader.IsDBNull(0))
objNews.NewsID = objDataReader.GetString(0);
if (!objDataReader.IsDBNull(1))
objNews.EditorID = objDataReader.GetString(1);
if (!objDataReader.IsDBNull(2))
objNews.DisplayOrder = objDataReader.GetInt32(2);
if (!objDataReader.IsDBNull(3))
objNews.Heading = objDataReader.GetString(3);
if (!objDataReader.IsDBNull(4))
objNews.ShortDescription = objDataReader.GetString(4);
if (!objDataReader.IsDBNull(5))
objNews.NewsDescription = objDataReader.GetString(5);
if (!objDataReader.IsDBNull(6))
objNews.LanguageID = objDataReader.GetInt32(6);
if (!objDataReader.IsDBNull(7))
objNews.IsApproved = objDataReader.GetInt32(7);
if (!objDataReader.IsDBNull(8))
objNews.IsActive = objDataReader.GetInt32(8);
if (!objDataReader.IsDBNull(9))
objNews.IsTopNews = objDataReader.GetInt32(9);
if (!objDataReader.IsDBNull(10))
objNews.DttmCreated = objDataReader.GetDateTime(10);
if (!objDataReader.IsDBNull(11))
objNews.DttmModified = objDataReader.GetDateTime(11);
objNewsList.Add(objNews);
}
}
while (objDataReader.NextResult());
}
if (!objDataReader.IsClosed)
objDataReader.Close();
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
dbHelper.ClearAllParameters();
dbHelper.CloseConnection();
dbHelper.Dispose();
}
return objNewsList;
}
internal IEnumerable <IInterNews> Select20TopNews()
{
IDataReader objDataReader = null;
List <IInterNews> objNewsList = null;
IInterNews objNews = null;
var dbHelper = DBHelper.Instance;
try
{
objDataReader = dbHelper.ExecuteDataReader(ProcedureName.Select20InterNews, CommandType.StoredProcedure);
if (objDataReader != null)
{
objNewsList = new List <IInterNews>();
do
{
while (objDataReader.Read())
{
objNews = new InterNews();
if (!objDataReader.IsDBNull(0))
{
objNews.NewsID = objDataReader.GetString(0);
}
if (!objDataReader.IsDBNull(1))
{
objNews.EditorID = objDataReader.GetString(1);
}
if (!objDataReader.IsDBNull(2))
{
objNews.DisplayOrder = objDataReader.GetInt32(2);
}
if (!objDataReader.IsDBNull(3))
{
objNews.Heading = objDataReader.GetString(3);
}
if (!objDataReader.IsDBNull(4))
{
objNews.ShortDescription = objDataReader.GetString(4);
}
if (!objDataReader.IsDBNull(5))
{
objNews.NewsDescription = objDataReader.GetString(5);
}
if (!objDataReader.IsDBNull(6))
{
objNews.LanguageID = objDataReader.GetInt32(6);
}
if (!objDataReader.IsDBNull(7))
{
objNews.IsApproved = objDataReader.GetInt32(7);
}
if (!objDataReader.IsDBNull(8))
{
objNews.IsActive = objDataReader.GetInt32(8);
}
if (!objDataReader.IsDBNull(9))
{
objNews.IsTopNews = objDataReader.GetInt32(9);
}
if (!objDataReader.IsDBNull(10))
{
objNews.DttmCreated = objDataReader.GetDateTime(10);
}
if (!objDataReader.IsDBNull(11))
{
objNews.DttmModified = objDataReader.GetDateTime(11);
}
if (!objDataReader.IsDBNull(12))
{
objNews.ImageUrl = objDataReader.GetString(12);
}
if (!objDataReader.IsDBNull(13))
{
objNews.ImageCaption = objDataReader.GetString(13);
}
objNewsList.Add(objNews);
}
}while (objDataReader.NextResult());
}
if (!objDataReader.IsClosed)
{
objDataReader.Close();
}
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
dbHelper.ClearAllParameters();
dbHelper.CloseConnection();
dbHelper.Dispose();
}
return(objNewsList.FindAll(v => v.DttmCreated.Date == DateTime.Now.Date || v.DttmCreated.Date.AddDays(-1) == DateTime.Now.Date.AddDays(-1)));;
}
public List <IInterNews> SelectAllForList(Int64?NextPageValue)
{
IDataReader objDataReader = null;
List <IInterNews> objNewsList = null;
IInterNews objNews = null;
DBHelper dbHelper = new DBHelper();
try
{
dbHelper.AddInParameter("@NextPageValue", NextPageValue, DbType.Int64);
objDataReader = dbHelper.ExecuteDataReader(ProcedureName.SelectAllInterForList, CommandType.StoredProcedure);
if (objDataReader != null)
{
objNewsList = new List <IInterNews>();
do
{
while (objDataReader.Read())
{
objNews = new InterNews();
if (!objDataReader.IsDBNull(0))
{
objNews.NewsID = objDataReader.GetString(0);
}
if (!objDataReader.IsDBNull(1))
{
objNews.EditorID = objDataReader.GetString(1);
}
if (!objDataReader.IsDBNull(2))
{
objNews.DisplayOrder = objDataReader.GetInt32(2);
}
if (!objDataReader.IsDBNull(3))
{
objNews.Heading = objDataReader.GetString(3);
}
if (!objDataReader.IsDBNull(4))
{
objNews.ShortDescription = objDataReader.GetString(4);
}
if (!objDataReader.IsDBNull(5))
{
objNews.NewsDescription = objDataReader.GetString(5);
}
if (!objDataReader.IsDBNull(6))
{
objNews.LanguageID = objDataReader.GetInt32(6);
}
if (!objDataReader.IsDBNull(7))
{
objNews.IsApproved = objDataReader.GetInt32(7);
}
if (!objDataReader.IsDBNull(8))
{
objNews.IsActive = objDataReader.GetInt32(8);
}
if (!objDataReader.IsDBNull(9))
{
objNews.IsTopNews = objDataReader.GetInt32(9);
}
if (!objDataReader.IsDBNull(10))
{
objNews.DttmCreated = objDataReader.GetDateTime(10);
}
if (!objDataReader.IsDBNull(11))
{
objNews.DttmModified = objDataReader.GetDateTime(11);
}
if (!objDataReader.IsDBNull(12))
{
objNews.ImageUrl = objDataReader.GetString(12);
}
if (!objDataReader.IsDBNull(13))
{
objNews.ImageCaption = objDataReader.GetString(13);
}
objNewsList.Add(objNews);
}
}while (objDataReader.NextResult());
}
if (!objDataReader.IsClosed)
{
objDataReader.Close();
}
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
dbHelper.ClearAllParameters();
dbHelper.CloseConnection();
dbHelper.Dispose();
}
return(objNewsList);
}
public IInterNews Select(string NewsID)
{
IInterNews objNews = null;
IDataReader objDataReader = null;
var dbHelper = DBHelper.Instance;
try
{
dbHelper.AddInParameter("@NewsID", NewsID, DbType.String);
objDataReader = dbHelper.ExecuteDataReader(ProcedureName.SelectInterNews, CommandType.StoredProcedure);
if (objDataReader != null)
{
while (objDataReader.Read())
{
objNews = new InterNews();
if (!objDataReader.IsDBNull(0))
{
objNews.NewsID = objDataReader.GetString(0);
}
if (!objDataReader.IsDBNull(1))
{
objNews.EditorID = objDataReader.GetString(1);
}
if (!objDataReader.IsDBNull(2))
{
objNews.DisplayOrder = objDataReader.GetInt32(2);
}
if (!objDataReader.IsDBNull(3))
{
objNews.Heading = objDataReader.GetString(3);
}
if (!objDataReader.IsDBNull(4))
{
objNews.ShortDescription = objDataReader.GetString(4);
}
if (!objDataReader.IsDBNull(5))
{
objNews.NewsDescription = objDataReader.GetString(5);
}
if (!objDataReader.IsDBNull(6))
{
objNews.LanguageID = objDataReader.GetInt32(6);
}
if (!objDataReader.IsDBNull(7))
{
objNews.IsApproved = objDataReader.GetInt32(7);
}
if (!objDataReader.IsDBNull(8))
{
objNews.IsActive = objDataReader.GetInt32(8);
}
if (!objDataReader.IsDBNull(9))
{
objNews.IsTopNews = objDataReader.GetInt32(9);
}
if (!objDataReader.IsDBNull(10))
{
objNews.DttmCreated = objDataReader.GetDateTime(10);
}
if (!objDataReader.IsDBNull(11))
{
objNews.DttmModified = objDataReader.GetDateTime(11);
}
if (!objDataReader.IsDBNull(12))
{
objNews.ImageUrl = objDataReader.GetString(12);
}
if (!objDataReader.IsDBNull(13))
{
objNews.ImageCaption = objDataReader.GetString(13);
}
}
}
if (!objDataReader.IsClosed)
{
objDataReader.Close();
}
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
dbHelper.ClearAllParameters();
dbHelper.CloseConnection();
dbHelper.Dispose();
}
return(objNews);
}
public async Task<ActionResult> UpdateNews(UpdateNews newForUpdate)
{
var dbHelpre = DBHelper.Instance;
dbHelpre.BeginTransaction();
return await Task.Run(() =>
{
try
{
bool IsNotValid = false;
ViewBag.Message = "Update new news.";
if (ModelState.IsValid)
{
var news = new InterNews
{
NewsID = newForUpdate.NewsID,
Heading = newForUpdate.Heading.Trim(),
ShortDescription = newForUpdate.ShortDesc.Trim(),
NewsDescription = string.IsNullOrEmpty(newForUpdate.Description) ? string.Empty : newForUpdate.Description.Trim(),
IsActive = newForUpdate.IsActiveNews ? 1 : 0,
IsApproved = newForUpdate.IsApprovedNews ? 1 : 0,
IsTopNews = newForUpdate.IsTopTenNews ? 1 : 0
};
var image = new ImageDetail
{
ImageType = 2,
ImageUrl = newForUpdate.ImageUrl,
Caption = newForUpdate.Caption,
IsActive = 1,
IsFirst = 1
};
var fileName = string.Empty;
if (newForUpdate.Image != null && newForUpdate.Image.ContentLength > 0)
{
fileName = new Random().Next(1000000000).ToString() + Path.GetFileName(newForUpdate.Image.FileName);
image.ImageUrl = ImagePath.InternationalNewsImage + "/" + fileName;
image.IsActive = 1;
image.IsFirst = 1;
}
var user = (IUsers)this.Session[Constants.UserSessionKey];
InterNewsBL.Instance.UpdateNews(ref dbHelpre, news, image, user);
if (!string.IsNullOrEmpty(fileName))
{
if (SaveImage(ImagePath.InternationalNewsImage, fileName, newForUpdate.Image))
{
if (DeleteImage(ImagePath.InternationalNewsImage, newForUpdate.ImageUrl))
{
ViewBag.Message = "Updated successfully.";
ModelState.Clear();
}
else
{
IsNotValid = true;
}
}
else
{
IsNotValid = true;
}
}
newForUpdate.ImageUrl = image.ImageUrl;
}
else
{
IsNotValid = true;
}
if (IsNotValid)
{
dbHelpre.RollbackTransaction();
ModelState.AddModelError("INSERT", "Oops ! There is some error.");
ViewBag.Message = "Oops ! There is some error.";
}
else
{
ViewBag.Message = "Updated successfully.";
ModelState.Clear();
}
dbHelpre.CommitTransaction();
}
catch (Exception ex)
{
dbHelpre.RollbackTransaction();
throw ex;
}
finally
{
dbHelpre.ClearAllParameters();
dbHelpre.CloseConnection();
dbHelpre.Dispose();
}
return View(newForUpdate);
});
}
public async Task<ActionResult> InsertNews(CreateNews newForInsert)
{
var dbHelpre = DBHelper.Instance;
var BLInstance = InterNewsBL.Instance;
dbHelpre.BeginTransaction();
return await Task.Run(() =>
{
try
{
if (ModelState.IsValid)
{
var news = new InterNews
{
Heading = newForInsert.Heading.Trim(),
ShortDescription = newForInsert.ShortDesc.Trim(),
NewsDescription = string.IsNullOrEmpty(newForInsert.Description) ? string.Empty : newForInsert.Description.Trim(),
IsTopNews = newForInsert.IsTopTenNews ? 1 : 0,
IsActive = 0,
IsApproved = 0
};
var image = new ImageDetail
{
ImageType = (int)ImageType.TopNewsImage,
ImageUrl = " ",
Caption = newForInsert.ImageCaption,
CaptionLink = newForInsert.CaptionLink,
IsActive = 0,
IsFirst = 0
};
var fileName = string.Empty;
if (newForInsert.Image != null && newForInsert.Image.ContentLength > 0)
{
fileName = new Random().Next(1000000000).ToString() + Path.GetFileName(newForInsert.Image.FileName);
image.ImageUrl = ImagePath.InternationalNewsImage + "/" + fileName;
image.IsActive = 1;
image.IsFirst = 1;
}
string dirPath = ImagePath.InternationalNewsImage;
var user = (IUsers)this.Session[Constants.UserSessionKey];
BLInstance.Insert(ref dbHelpre, news, image, user);
if (SaveImage(ImagePath.InternationalNewsImage, fileName, newForInsert.Image))
{
newForInsert = new CreateNews();
ViewBag.Message = "Successfully Inserter.";
ModelState.Clear();
}
}
else
{
ModelState.AddModelError("INSERT", "Oops ! There is some error.");
ViewBag.Message = "Oops ! There is some error.";
}
dbHelpre.CommitTransaction();
return View(newForInsert);
}
catch (Exception ex)
{
dbHelpre.RollbackTransaction();
throw ex;
}
finally
{
dbHelpre.Dispose();
BLInstance.Dispose();
}
});
}
