}//End del constructor.
public PagHome obtenerDatosIndex() {
SqlConnection connection = new SqlConnection(this.connString);
String sqlSelect = "PA_ObtenerDatosIndex";
SqlDataAdapter sqlDataAdapterClient = new SqlDataAdapter();
sqlDataAdapterClient.SelectCommand = new SqlCommand(sqlSelect, connection);
DataSet dataSetPersonas = new DataSet();
sqlDataAdapterClient.Fill(dataSetPersonas, "TSH_Pagina");
sqlDataAdapterClient.SelectCommand.Connection.Close();
DataRowCollection dataRow = dataSetPersonas.Tables["TSH_Pagina"].Rows;
int idPag = 0;
string descripcion = "";
string urlImagen = "";
foreach (DataRow currentRow in dataRow) {
idPag = int.Parse(currentRow["TN_Identificador_TSH_Pagina"].ToString());
descripcion = currentRow["TC_Descripcion_TSH_Tipo_Habitacion"].ToString();
urlImagen = currentRow["TI_Imagen_TSH_Pag_Home"].ToString();
}//End foreach (DataRow currentRow in dataRow)
PagHome home = new PagHome(idPag,descripcion,urlImagen);
return home;
}//End obtenerDatosIndex
// GET: AdminHome
public ActionResult AdminHome(){
PaginaHomeModel modelo = new PaginaHomeModel(this.connectionString);
PagHome home = modelo.obtenerDatosIndex();
ViewData["id"] = home.IdPagina;
ViewData["descripcion"] = home.DescripcionPagina;
ViewData["imagen"] = home.UrlImagen;
return View();
}//End AdminHome()
public ActionResult Index()
{
PaginaHomeModel modelo = new PaginaHomeModel(this.connectionString);
PagHome home = modelo.obtenerDatosIndex();
ViewData["id"] = home.IdPagina;
ViewData["descripcion"] = home.DescripcionPagina;
ViewData["imagen"] = home.UrlImagen;
ViewBag.Message = "nada";
return(View());
}
public ActionResult guardarCambios(int id, string descripcion, string imagen){
PaginaHomeModel modelo = new PaginaHomeModel(this.connectionString);
PagHome home = new PagHome(id, descripcion, "C:/Users/Dylan/Source/Repos/ISBrumarkCode/SistemaHotel/img/homeIMG.jpg");
bool res = modelo.actualizaDatosIndex(home);
if (res){
ViewBag.Message = "Exitoso";
return RedirectToAction("Index", "Home");
}else{
ViewBag.Message = "Error";
return RedirectToAction("Index", "Home");
}//End if-else (res)
}//End AdminHome()
}//End obtenerDatosIndex
public bool actualizaDatosIndex(PagHome pagHome) {
SqlConnection connection = new SqlConnection(this.connString);
String sqlStoredProcedure = "PA_ActualizaPagHome";
SqlCommand cmdInsertar = new SqlCommand(sqlStoredProcedure, connection);
cmdInsertar.CommandType = System.Data.CommandType.StoredProcedure;
cmdInsertar.Parameters.Add(new SqlParameter("@idPag", pagHome.IdPagina));
cmdInsertar.Parameters.Add(new SqlParameter("@descripcion", pagHome.DescripcionPagina));
cmdInsertar.Parameters.Add(new SqlParameter("@imagen", pagHome.UrlImagen));
cmdInsertar.Connection.Open();
bool res = Convert.ToBoolean(cmdInsertar.ExecuteNonQuery());
cmdInsertar.Connection.Close();
return res;
}//End actualizaDatosIndex
