public void DeactiveNewsByPhone(string phoneNo)
{
var model = new PrivateNewsModel();
var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString);
if (_conn.State == ConnectionState.Closed)
{
_conn.Open();
}
try
{
//Create command store procedure
var command = new SqlCommand("DeactivePrivateNewsByPhone");
command.Connection = _conn;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@PhoneNumber", phoneNo).Direction = ParameterDirection.Input;
command.Prepare();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
_conn.Close();
}
}
public ActionResult Index(
int page = 1,
int row = 20)
{
var areaDb = new AreaDb();
var listArea = areaDb.GetAll();
ViewBag.listArea = listArea;
var listAreaChild = areaDb.GetListAreaById(1);
ViewBag.listAreaChild = listAreaChild;
var listStatus = new List <ListItem> {
new ListItem {
Text = "Lựa chọn loại tin",
Value = "0"
},
new ListItem {
Text = "Tin chính chủ",
Value = "1"
},
new ListItem {
Text = "Tin chưa được lọc",
Value = "2"
},
new ListItem {
Text = "Tin spam",
Value = "3"
},
};
ViewBag.listStatus = listStatus;
var privateNewsModel = new PrivateNewsModel();
if (Session["ListOfPrivateNews"] != null)
{
privateNewsModel = (PrivateNewsModel)Session["ListOfPrivateNews"];
}
var privateNewsDb = new PrivateNewsDb();
int intCount;
privateNewsModel.listPrivateNews = privateNewsDb.SearchNews(out intCount,
privateNewsModel.StartDate,
privateNewsModel.EndDate,
privateNewsModel.Title,
privateNewsModel.Address,
privateNewsModel.Price, page, row,
privateNewsModel.Status);
ViewBag.NumberOfPages = intCount / row + (intCount % row > 0 ? 1 : 0);
ViewBag.CurrentPage = page;
return(View(privateNewsModel));
}
/// <summary>
/// Lay ra tin bai chi tiet
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public PrivateNewsModel GetDetail(int Id)
{
var model = new PrivateNewsModel();
var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString);
if (_conn.State == ConnectionState.Closed)
{
_conn.Open();
}
//Create command store procedure
var command = new SqlCommand("GetPrivateNewsById");
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.NewsContent = reader.GetString(2);
model.Address = reader.GetString(3);
model.Dientich = reader.GetString(4);
model.Price = reader.GetString(5);
model.PhoneNumer = reader.GetString(6);
model.Datetime = reader.GetDateTime(7);
model.Status = reader.GetInt32(8);
break;
}
reader.Close();
}
}
finally
{
command.Connection.Close();
command.Connection.Dispose();
}
return(model);
}
/// <summary>
/// Tim kiem tin tuc
/// </summary>
/// <param name="Count"></param>
/// <param name="StartDate"></param>
/// <param name="EndDate"></param>
/// <param name="TitleSearch"></param>
/// <param name="Address"></param>
/// <param name="Price"></param>
/// <param name="PageNumber"></param>
/// <param name="RowsPage"></param>
/// <returns></returns>
public List <PrivateNewsModel> SearchNews(
out int Count,
DateTime StartDate,
DateTime EndDate,
String TitleSearch = "",
String Address = "",
String Price = "",
int PageNumber = 0,
int RowsPage = 0,
int Status = 0)
{
var listSearch = new List <PrivateNewsModel>();
var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString);
if (_conn.State == ConnectionState.Closed)
{
_conn.Open();
}
//Create command store procedure
var command = new SqlCommand("Search_tblPrivateNews");
command.Connection = _conn;
command.CommandType = CommandType.StoredProcedure;
var CountTitleParam = new SqlParameter("@CountTitle", SqlDbType.Int);
CountTitleParam.Direction = ParameterDirection.Output;
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 AddressParam = new SqlParameter("@Address", Address);
AddressParam.Direction = ParameterDirection.Input;
var StatusParam = new SqlParameter("@Status", Status);
StatusParam.Direction = ParameterDirection.Input;
if (StartDate != DateTime.MinValue)
{
var StartDateParam = new SqlParameter("@DateStart", StartDate);
StartDateParam.Direction = ParameterDirection.Input;
command.Parameters.Add(StartDateParam);
}
if (EndDate != DateTime.MinValue)
{
var EndDateParam = new SqlParameter("@DateEnd", EndDate);
EndDateParam.Direction = ParameterDirection.Input;
command.Parameters.Add(EndDateParam);
}
command.Parameters.Add(TitleSearchParam);
command.Parameters.Add(PriceParam);
command.Parameters.Add(PageNumberParam);
command.Parameters.Add(RowspPageParam);
command.Parameters.Add(CountTitleParam);
command.Parameters.Add(AddressParam);
command.Parameters.Add(StatusParam);
try
{
Count = 0;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var model = new PrivateNewsModel();
model.Number = (int)reader.GetInt64(0);
model.Id = reader.GetInt32(1);
model.Title = reader.GetString(2);
model.Price = reader.GetString(3);
model.PhoneNumer = reader.GetString(4);
model.Status = reader.GetInt32(5);
listSearch.Add(model);
}
reader.Close();
}
}
catch (Exception ex) {
}
finally
{
command.Connection.Close();
command.Connection.Dispose();
}
Count = CountTitleParam.Value as int? ?? default(int);
return(listSearch);
}
public List <PrivateNewsModel> GetListNewsWithNoDistrictVal(
out int Count,
int PageNumber = 0,
int RowsPage = 20)
{
var listSearch = new List <PrivateNewsModel>();
var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString);
if (_conn.State == ConnectionState.Closed)
{
_conn.Open();
}
//Create command store procedure
var command = new SqlCommand("GetNewsWithNoDistrictVal");
command.Connection = _conn;
command.CommandType = CommandType.StoredProcedure;
var CountTitleParam = new SqlParameter("@CountTitle", SqlDbType.Int);
CountTitleParam.Direction = ParameterDirection.Output;
var PageNumberParam = new SqlParameter("@PageNumber", PageNumber);
PageNumberParam.Direction = ParameterDirection.Input;
var RowspPageParam = new SqlParameter("@RowspPage", RowsPage);
command.Parameters.Add(PageNumberParam);
command.Parameters.Add(RowspPageParam);
command.Parameters.Add(CountTitleParam);
try
{
Count = 0;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var model = new PrivateNewsModel();
model.Number = (int)reader.GetInt64(0);
model.Id = reader.GetInt32(1);
model.Title = reader.GetString(2);
model.Price = reader.GetString(3);
model.PhoneNumer = reader.GetString(4);
model.Status = reader.GetInt32(5);
model.Datetime = reader.GetDateTime(6);
model.NewsContent = reader.GetString(7);
model.TinhThanhId = reader.GetInt32(8);
model.QuanHuyenId = reader.GetInt32(9);
listSearch.Add(model);
}
reader.Close();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
command.Connection.Close();
command.Connection.Dispose();
}
Count = CountTitleParam.Value as int? ?? default(int);
return(listSearch);
}
public RedirectToRouteResult Index(PrivateNewsModel model)
{
Session["ListOfPrivateNews"] = model;
return(RedirectToAction("Index"));
}
