/// <summary>
/// Delete itemn
/// </summary>
/// <param name="Id"></param>
public void Delete(int Id)
{
var model = new NewsModels();
var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString);
if (_conn.State == ConnectionState.Closed)
{
_conn.Open();
}
//Create command store procedure
var command = new SqlCommand("DeleteNewsById");
command.Connection = _conn;
command.CommandType = CommandType.StoredProcedure;
try
{
var IdParam = new SqlParameter("@Id", Id);
IdParam.Direction = ParameterDirection.Input;
command.Parameters.Add(IdParam);
command.ExecuteScalar();
}
finally
{
command.Connection.Close();
command.Connection.Dispose();
}
}
public async Task <ActionResult> NewsAsyncAsync()
{
DateTime dt1 = DateTime.Now;
var rss = new string[]
{
"http://articles.csdn.net/api/rss.php?tid=1008",
"http://aspnet.codeplex.com/project/feeds/rss",
"http://solidot.org.feedsportal.com/c/33236/f/556826/index.rss",
"http://www.codeguru.com/icom_includes/feeds/codeguru/rss-csharp.xml",
"http://feed.google.org.cn/"
};
List <List <NewsItem> > list = new List <List <NewsItem> >();
foreach (var item in rss)
{
List <NewsItem> news = await(NewsModels.GetNews(item));
list.Add(news);
}
var model = list.SelectMany(x => x)
.ToList()
.OrderByDescending(x => x.PostDate)
.Take(100);
DateTime dt2 = DateTime.Now;
ViewBag.TimeCost = new TimeSpan(dt2.Ticks - dt1.Ticks).ToString();
return(View("News", model));
}
public ActionResult Edit(int id)
{
var newsItem = NewsService.Find(id);
if (newsItem == null)
{
SetFlashMessage("Tin tức cần sửa không tồn tại trên hệ thống.");
return(RedirectToAction("Index"));
}
var newsEdit = new NewsModels
{
Id = newsItem.ID,
Title = newsItem.Title,
CategoryId = newsItem.TypeID ?? 0,
ImageUrl = newsItem.Image,
Summary = newsItem.Summary,
Detail = newsItem.Detail,
Keyword = newsItem.Keyword,
Description = newsItem.Description,
Order = newsItem.Order ?? 0,
IsHot = newsItem.Hot ?? false,
IsFast = newsItem.Fast ?? false,
IsFeatured = newsItem.Featured ?? false,
Status = newsItem.Status ?? false,
Site = newsItem.Site
};
ViewBag.ListCategory = BuildListCategory();
ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>();
return(View("Edit", newsEdit));
}
public ActionResult Create(NewsModels model)
{
try
{
if (ModelState.IsValid)
{
var user = User.Identity.Name;
NewsModels news = new NewsModels();
news.Title = model.Title;
news.Text = model.Text;
news.Publisher = User.Identity.Name;
db.News.Add(news);
db.SaveChanges();
}
// If we got this far, something failed, redisplay form
return(RedirectToAction("Index", "News"));
}
catch
{
return(View());
}
}
public ActionResult DetailPost(int Id = 1, int menuId = 1)
{
var newsDb = new NewsDb();
var newsModel = new NewsModels();
newsModel = newsDb.GetDetailNews(Id);
return(View(newsModel));
}
// GET: MyAdminNews/Create
public ActionResult Create()
{
var n = new NewsModels();
n.admin_id_Member = 1;
n.topic_idTopic = 1;
return(View(n));
}
public ActionResult Details(Guid id)
{
NewsService service = new NewsService();
var info = service.GetbyNews(id);
var model = new NewsModels().ToModel(info);
return(View(model));
}
//
// GET: /News/
public PartialViewResult Index()
{
NewsService service = new NewsService();
NewsModels model = new NewsModels();
ViewBag.Newslist = service.GetNewslist();
return(PartialView());
}
public ActionResult NewsList(NewsModels model)
{
ServiceResult <List <NewsListOM> > result = new ServiceResult <List <NewsListOM> >
{
Data = _component.GetNewsList(model.NewsSetionId, model.PageSize.Value, model.PageIndex.Value)
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Update new item and return success of fail
/// </summary>
/// <returns></returns>
public void Update(NewsModels model)
{
var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString);
if (_conn.State == ConnectionState.Closed)
{
_conn.Open();
}
//Create command store procedure
var command = new SqlCommand("Update_tblNews");
command.Connection = _conn;
command.CommandType = CommandType.StoredProcedure;
try
{
var TitleParam = new SqlParameter("@Title", model.Title);
TitleParam.Direction = ParameterDirection.Input;
var TinhThanhIdParam = new SqlParameter("@TinhThanhId", model.TinhThanhId);
TinhThanhIdParam.Direction = ParameterDirection.Input;
var QuanHuyenIdParam = new SqlParameter("@QuanHuyenId", model.QuanHuyenId);
QuanHuyenIdParam.Direction = ParameterDirection.Input;
var AddressParam = new SqlParameter("@Address", model.Address);
AddressParam.Direction = ParameterDirection.Input;
var MenuIdParam = new SqlParameter("@MenuId", model.MenuId);
MenuIdParam.Direction = ParameterDirection.Input;
var DientichParam = new SqlParameter("@Dientich", model.Dientich);
DientichParam.Direction = ParameterDirection.Input;
var PriceParam = new SqlParameter("@Price", model.Price);
PriceParam.Direction = ParameterDirection.Input;
var PhoneNumberParam = new SqlParameter("@PhoneNumber", model.PhoneNumber);
PhoneNumberParam.Direction = ParameterDirection.Input;
var NewsContentParam = new SqlParameter("@NewsContent", model.NewsContent);
NewsContentParam.Direction = ParameterDirection.Input;
var UserIdParam = new SqlParameter("@UserId", model.UserId);
UserIdParam.Direction = ParameterDirection.Input;
var IdParam = new SqlParameter("@Id", model.Id);
IdParam.Direction = ParameterDirection.Input;
command.Parameters.Add(TitleParam);
command.Parameters.Add(TinhThanhIdParam);
command.Parameters.Add(QuanHuyenIdParam);
command.Parameters.Add(AddressParam);
command.Parameters.Add(MenuIdParam);
command.Parameters.Add(DientichParam);
command.Parameters.Add(PriceParam);
command.Parameters.Add(PhoneNumberParam);
command.Parameters.Add(NewsContentParam);
command.Parameters.Add(UserIdParam);
command.Parameters.Add(IdParam);
command.ExecuteScalar();
}
finally
{
command.Connection.Close();
command.Connection.Dispose();
}
}
public ActionResult OnCreate(NewsModels news)
{
if (ModelState.IsValid)
{
news.ImageUrl = news.Image != null?
news.Image.Upload() :
news.ImageUrl;
var newsItem = new News
{
Title = news.Title,
TypeID = news.CategoryId,
Image = news.ImageUrl,
Summary = news.Summary,
Detail = news.Detail,
Keyword = news.Keyword,
Description = news.Description,
Order = news.Order,
Hot = news.IsFast,
Fast = news.IsFast,
Featured = news.IsFeatured,
Status = news.Status,
Date = news.CreatedAt,
Site = news.Site
};
var result = NewsService.Insert(newsItem);
if (result == Result.Exists)
{
ModelState.AddModelError("", string.Format("Tin tức '{0}' đã tồn tại trên hệ thống.", news.Title));
ViewBag.ListCategory = BuildListCategory();
ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>();
return(View("Create", news));
}
SetFlashMessage(string.Format("Thêm tin tức '{0}' thành công.", news.Title));
if (news.SaveList)
{
return(RedirectToAction("Index"));
}
ModelState.Clear();
ViewBag.ListCategory = BuildListCategory();
ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>();
return(View("Create", news.ResetValue()));
}
ViewBag.ListCategory = NewsGroupService.GetAll().Select
(
cate => new MutilCategoryItem
{
Name = cate.Name,
Id = cate.ID,
ParentId = cate.Parent
}
).ToList();
return(View("Create", news));
}
// GET: MyAdminNews/Details/5
public ActionResult Details(int id)
{
var detailsNews = ns.getNewsById(id);
NewsModels item = new NewsModels();
item.idNews = detailsNews.idNews;
item.title = detailsNews.title;
item.description = detailsNews.description;
item.topic = detailsNews.topic;
return(View(item));
}
/// <summary>
/// Get News by Id
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public NewsModels GetDetailNews(int Id)
{
var model = new NewsModels();
var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString);
if (_conn.State == ConnectionState.Closed)
{
_conn.Open();
}
//Create command store procedure
var command = new SqlCommand("GetDetailNews");
command.Connection = _conn;
command.CommandType = CommandType.StoredProcedure;
try
{
var IdParam = new SqlParameter("@Id", Id);
IdParam.Direction = ParameterDirection.Input;
command.Parameters.Add(IdParam);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
model.Id = reader.GetInt32(0);
model.Title = reader.GetString(1);
model.TinhThanhId = reader.GetInt32(2);
model.QuanHuyenId = reader.GetInt32(3);
model.Address = reader.GetString(4);
model.MenuId = reader.GetInt32(5);
model.MenuIdHidden = reader.GetInt32(5);
model.Dientich = reader.GetString(6);
model.Price = reader.GetString(7);
model.PhoneNumber = reader.GetString(8);
model.NewsContent = reader.GetString(9);
model.UserId = reader.GetInt32(10);
model.MenuName = reader.GetString(11);
model.Datetime = reader.GetDateTime(12);
break;
}
reader.Close();
}
}
finally
{
command.Connection.Close();
command.Connection.Dispose();
}
return(model);
}
// GET: MyAdminNews/Edit/5
public ActionResult Edit(int id)
{
var detailsNews = ns.getNewsById(id);
NewsModels item = new NewsModels();
item.idNews = detailsNews.idNews;
item.title = detailsNews.title;
item.description = detailsNews.description;
item.picture = detailsNews.picture;
item.admin_id_Member = detailsNews.admin_id_Member;
item.topic_idTopic = detailsNews.topic_idTopic;
return(View(item));
}
public ActionResult EditPost(NewsModels model, string CaptchaText)
{
var areaDb = new AreaDb();
var listArea = areaDb.GetAll();
ViewBag.listArea = listArea;
var listAreaChild = areaDb.GetListAreaById(1);
ViewBag.listAreaChild = listAreaChild;
if (model.MenuId == 0)
{
ModelState.AddModelError("MenuId", "Vui lòng chọn chuyên mục.");
}
if (model.QuanHuyenId == 0)
{
ModelState.AddModelError("QuanHuyenId", "Vui lòng chọn quận huyện.");
}
if (model.TinhThanhId == 0)
{
ModelState.AddModelError("TinhThanhId", "Vui lòng chọn tỉnh thành.");
}
if (this.Session["CaptchaImageText"].ToString() != CaptchaText)
{
ModelState.AddModelError("CaptchaText", "Mã xác nhận không đúng");
}
if (!ModelState.IsValid)
{
return(View(model));
}
var newsDb = new NewsDb();
var userId = new UserDb().GetUserInfo(User.Identity.Name).Id;
if (model.UserId == userId)
{
newsDb.Update(model);
Session["AddNewsSuccessMessage"] = "Sửa bài viết thành công!";
return(RedirectToAction("EditPost", "News", new { @Id = model.Id }));
}
else
{
return(RedirectToAction("MyPost", "News"));
}
}
public ActionResult OnEdit(NewsModels news)
{
if (ModelState.IsValid)
{
news.ImageUrl = news.Image != null?
news.Image.Upload() :
news.ImageUrl.ToImageOriginalPath();
var newsItem = new News
{
ID = news.Id,
Title = news.Title,
TypeID = news.CategoryId,
Image = news.ImageUrl,
Summary = news.Summary,
Detail = news.Detail,
Keyword = news.Keyword,
Description = news.Description,
Order = news.Order,
Hot = news.IsFast,
Fast = news.IsFast,
Featured = news.IsFeatured,
Status = news.Status,
Date = news.CreatedAt,
Site = news.Site
};
var result = NewsService.Update(newsItem);
if (result == Result.NotExists)
{
ModelState.AddModelError("", "Tin tức không tồn tại trên hệ thống.");
ViewBag.ListCategory = BuildListCategory();
ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>();
return(View("Edit", news));
}
SetFlashMessage(string.Format("Sửa tin tức '{0}' thành công.", news.Title));
if (news.SaveList)
{
return(RedirectToAction("Index"));
}
ViewBag.ListCategory = BuildListCategory();
ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>();
return(View("Edit", news));
}
ViewBag.ListCategory = BuildListCategory();
ViewBag.ListSite = DataHelper.ListEnumType <NewsSiteEnum>();
return(View("Edit"));
}
///查看更多 切换显示Ajax
public JsonResult SeeAjaxIndex(string NewsType, int pagings = 0)
{
NewsModels model = new NewsModels();
NewsService service = new NewsService();
model.Condition.PageSize = 3;
model.Condition.NewsType = new Guid(NewsType);
Paging paging = new Paging(model.Condition);
var ser = service.SearchNews(model.Condition, ref paging);
NewsModelsListModel models = new NewsModelsListModel(ser);
models.Paging = paging;
models.Total = paging.Total.ToString();
models.Index = paging.PageIndex.ToString();
models.Size = paging.PageSize.ToString();
return(Json(models, JsonRequestBehavior.AllowGet));
}
public JsonResult FenyeSeeMoreNew(string type = "", int pagings = 0)
{
NewsModels model = new NewsModels();
NewsService service = new NewsService();
model.Condition.PageSize = 3;
model.Condition.NewsType = new Guid(type);
Paging paging = new Paging(model.Condition);
paging.PageIndex = pagings;
var news = service.SearchNews(model.Condition, ref paging);
NewsModelsListModel models = new NewsModelsListModel(news);
models.Paging = paging;
models.Total = paging.Total.ToString();
models.Index = paging.PageIndex.ToString();
models.Size = paging.PageSize.ToString();
return(Json(models, JsonRequestBehavior.AllowGet));
}
// GET: MyAdminNews/Delete/5
/* public ActionResult Delete(int id)
* {
* var detailsNews = ns.getNewsById(id);
* NewsModels item = new NewsModels();
*
* item.idNews = detailsNews.idNews;
* item.title = detailsNews.title;
* item.description = detailsNews.description;
* item.picture = detailsNews.picture;
* item.admin_id_Member = detailsNews.admin_id_Member;
* item.topic_idTopic = detailsNews.topic_idTopic;
*
* return View(item);
* }
*/
// POST: MyAdminNews/Delete/5
/* [HttpPost]
* public ActionResult Delete(NewsModels nm)
* {
* // news x = null;
* Console.WriteLine("hani l fou9");
*
* if (ModelState.IsValid)
* {
*
* var n = ns.getNewsById(nm.idNews);
*
* //news item = new news();
*
*
* //n.idNews = nm.idNews;
* /*n.idNews = nm.idNews;
* n.title = nm.title;
* n.description = nm.description;
* n.picture = nm.picture;
* n.admin_id_Member = nm.admin_id_Member;
* n.topic_idTopic = nm.topic_idTopic;
*
*
*
* // ns.deleteNewsById(n.idNews);
*
* ns.Delete(n);
* ns.Commit();
* }
*
* return RedirectToAction("Index");
* }
*/
//////////////////////
// GET: AdminSeaAward/Delete/5
public ActionResult Delete(int id)
{
news n = ns.getNewsById(id);
NewsModels model = new NewsModels
{
idNews = n.idNews,
title = n.title,
description = n.description,
picture = n.picture,
video = n.video,
like = n.like,
comment = n.comment,
admin_id_Member = 1,
topic_idTopic = 1
};
return(View(model));
}
public ActionResult Edit(NewsModels nm)
{
if (ModelState.IsValid)
{
var n = ns.getNewsById(nm.idNews);
n.idNews = nm.idNews;
n.title = nm.title;
n.description = nm.description;
n.picture = nm.picture;
n.admin_id_Member = nm.admin_id_Member;
n.topic_idTopic = nm.topic_idTopic;
ns.Update(n);
ns.Commit();
}
return(RedirectToAction("Index"));
}
// CommentNewsByMember
// POST
// GET: MemberNews/Details/5
public ActionResult Details(int id)
{
var detailsNews = ns.getNewsById(id);
NewsModels item = new NewsModels();
item.idNews = detailsNews.idNews;
item.title = detailsNews.title;
item.description = detailsNews.description;
item.picture = detailsNews.picture;
item.comment = detailsNews.comment;
item.like = detailsNews.like;
item.topic = detailsNews.topic;
// CommentNewsByMember(item);
return(View(item));
}
public ActionResult SeeMore(int pagings = 0)
{
NewsModels model = new NewsModels();
NewsService service = new NewsService();
model.Condition.PageSize = 3;
model.Condition.NewsType = service.GetActivityTypeList("新闻类型").Where(n => n.Name == "要点新闻").FirstOrDefault().Id;
Paging paging = new Paging(model.Condition);
paging.PageIndex = pagings;
var news = service.SearchNews(model.Condition, ref paging);
NewsModelsListModel models = new NewsModelsListModel(news);
models.Paging = paging;
models.Total = paging.Total.ToString();
models.Index = paging.PageIndex.ToString();
models.Size = paging.PageSize.ToString();
models.DataDictionary = service.GetActivityTypeList("新闻类型");
return(View(models));
}
public ActionResult NewsSync()
{
DateTime dt1 = DateTime.Now;
var rss = new string[]
{
"http://articles.csdn.net/api/rss.php?tid=1008",
"http://aspnet.codeplex.com/project/feeds/rss",
"http://solidot.org.feedsportal.com/c/33236/f/556826/index.rss",
"http://www.codeguru.com/icom_includes/feeds/codeguru/rss-csharp.xml",
"http://feed.google.org.cn/"
};
var model = rss.SelectMany(x => NewsModels.GetNews(x).Result)
.ToList()
.OrderByDescending(x => x.PostDate)
.Take(100);
DateTime dt2 = DateTime.Now;
ViewBag.TimeCost = new TimeSpan(dt2.Ticks - dt1.Ticks).ToString();
return(View("News", model));
}
public ActionResult Create(NewsModels nm)
{
if (ModelState.IsValid)
{
//UploadImage();
news n = new news
{
title = nm.title,
description = nm.description,
picture = nm.picture,
admin_id_Member = nm.admin_id_Member,
topic_idTopic = nm.topic_idTopic
};
UploadImage();
ns.Add(n);
ns.Commit();
}
return(RedirectToAction("Index"));
}
public IActionResult listnew()
{
NewsModels nm = new NewsModels();
News nw = new News();
var query = "SELECT * FROM tb_nilecon";
SqlConnection con = new SqlConnection(Startup.ConnectionString);
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
nw = new News();
if (reader["id"] != DBNull.Value)
{
nw.id = int.Parse(reader["id"].ToString());
}
if (reader["title"] != DBNull.Value)
{
nw.titel = reader["title"].ToString();
}
if (reader["sup_content"] != DBNull.Value)
{
nw.sup_content = reader["sup_content"].ToString();
}
if (reader["main_content"] != DBNull.Value)
{
nw.main_content = reader["main_content"].ToString();
}
if (reader["image"] != DBNull.Value)
{
nw.image = reader["image"].ToString();
}
nm.LNews.Add(nw);
}
return(PartialView("Listnews", nm));
}
public ActionResult Delete(int id, NewsModels news)
{
try
{
if (User.IsInRole("Admin") || news.Publisher == User.Identity.Name)
{
db.Entry(news).State = EntityState.Deleted;
db.SaveChanges();
}
else
{
ViewBag.Error = "You cannot delete this News item, either because you are not the publisher or you are not Admin.";
}
return(RedirectToAction("Index", "News"));
}
catch
{
ViewBag.Error = "An error occurred while trying to delete the News item.";
return(RedirectToAction("Index", "News"));
}
}
public ActionResult Edit(int id, NewsModels model)
{
try
{
if (ModelState.IsValid)
{
if (User.IsInRole("Admin") || model.Publisher == User.Identity.Name)
{
var user = User.Identity.Name;
NewsModels news = new NewsModels
{
Id = model.Id,
Title = model.Title,
Text = model.Text,
Publisher = User.Identity.Name
};
db.Entry(news).State = EntityState.Modified;
db.SaveChanges();
}
else
{
ViewBag.Error = "You cannot edit the News item because, either you are not the publisher or you are not Admin.";
return(RedirectToAction("Index", "News"));
}
}
return(RedirectToAction("Details", "News", new { id = model.Id }));
}
catch
{
ViewBag.Error = "An error occurred while trying to edit the News item.";
return(RedirectToAction("Index", "News"));
}
}
public ActionResult IndexNegative(NewsModels news)
{
return(PartialView("_NegativeVote", news));
}
public ActionResult Delete(int id, NewsModels model)
{
ns.DeleteNewsById(id);
return(RedirectToAction("Index"));
}
/// <summary>
/// Tim kiem tin tuc
/// </summary>
/// <param name="Count">Tong so ban ghi</param>
/// <param name="TinhThanhId">Tinh Thanh</param>
/// <param name="QuanHuyenId">Quan Huyen</param>
/// <param name="TitleSearch">Tu khoa tim kiem</param>
/// <param name="Price">Gia tien</param>
/// <param name="PageNumber">Trang thu bao nhieu</param>
/// <param name="RowsPage">So luong dong tren 1 trang</param>
/// <param name="UserId">Menu</param>
/// <returns></returns>
public List <NewsModels> SearchMyPost(
out int Count,
int TinhThanhId = 0,
int QuanHuyenId = 0,
String TitleSearch = "",
String Price = "",
int PageNumber = 0,
int RowsPage = 0,
int UserId = 0)
{
var listSearch = new List <NewsModels>();
var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString);
if (_conn.State == ConnectionState.Closed)
{
_conn.Open();
}
//Create command store procedure
var command = new SqlCommand("Search_MyPost");
command.Connection = _conn;
command.CommandType = CommandType.StoredProcedure;
var CountTitleParam = new SqlParameter("@CountTitle", SqlDbType.Int);
CountTitleParam.Direction = ParameterDirection.Output;
var TinhThanhIdParam = new SqlParameter("@TinhThanhId", TinhThanhId);
TinhThanhIdParam.Direction = ParameterDirection.Input;
var QuanHuyenIdParam = new SqlParameter("@QuanHuyenId", QuanHuyenId);
QuanHuyenIdParam.Direction = ParameterDirection.Input;
var TitleSearchParam = new SqlParameter("@TitleSearch", TitleSearch);
TitleSearchParam.Direction = ParameterDirection.Input;
var PriceParam = new SqlParameter("@Price", Price);
PriceParam.Direction = ParameterDirection.Input;
var PageNumberParam = new SqlParameter("@PageNumber", PageNumber);
PageNumberParam.Direction = ParameterDirection.Input;
var RowspPageParam = new SqlParameter("@RowspPage", RowsPage);
RowspPageParam.Direction = ParameterDirection.Input;
var MenuIdParam = new SqlParameter("@UserId", UserId);
MenuIdParam.Direction = ParameterDirection.Input;
command.Parameters.Add(TinhThanhIdParam);
command.Parameters.Add(QuanHuyenIdParam);
command.Parameters.Add(TitleSearchParam);
command.Parameters.Add(PriceParam);
command.Parameters.Add(PageNumberParam);
command.Parameters.Add(RowspPageParam);
command.Parameters.Add(MenuIdParam);
command.Parameters.Add(CountTitleParam);
try
{
Count = 0;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var model = new NewsModels();
model.Number = (int)reader.GetInt64(0);
model.Id = reader.GetInt32(1);
model.Title = reader.GetString(2);
model.NewsContent = reader.GetString(3);
model.Price = reader.GetString(4);
model.MenuName = reader.GetString(5);
model.Datetime = reader.GetDateTime(6);
listSearch.Add(model);
}
reader.Close();
}
}
finally
{
command.Connection.Close();
command.Connection.Dispose();
}
Count = CountTitleParam.Value as int? ?? default(int);
return(listSearch);
}
