//static SqlConnection sql;
public ActionResult Index()
{
ListNewsModel listNewsModel = new ListNewsModel();
if (DataBase.GetSqlConnection().State == System.Data.ConnectionState.Open)
{
string query = string.Format("select * from News");
SqlCommand command = new SqlCommand(query, DataBase.Sql);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
NewsModel newsModel = new NewsModel();
newsModel.Author = reader["UserName"].ToString();
newsModel.ID = (int)reader["NewsID"];
newsModel.Title = reader["Title"].ToString();
newsModel.Raiting = (int)reader["Raiting"];
newsModel.Text = reader["Contect"].ToString();
newsModel.CreateDate = (DateTime)reader["CreateDate"];
listNewsModel.listNews.Add(newsModel);
}
reader.Close();
}
else
{
ViewBag.Message = "Непредвиденные проблемы с ДБ.";
}
return(View(listNewsModel));
}
/// <summary>
/// This is the default Action.
/// </summary>
public ActionResult Index()
{
var model = new ListNewsModel();
if (string.IsNullOrEmpty(this.Message))
{
model.Message = "Hello, World!";
}
else
{
model.Message = this.Message;
}
return(View("Default", model));
}
public static ListNewsRequestModel MapListNewsModel(ListNewsModel model)
{
return(new ListNewsRequestModel
{
});
}
