public List <ObservacionXHardware> GetListaObservacionesXHardwareByIdAndTipo(int idHardware, string tipo)
{
List <ObservacionXHardware> listaObservaciones = new List <ObservacionXHardware>();
using (DbCommand command = Database.GetStoredProcCommand("[dbo].[SP_GET_OBSERVACIONES_HARDWARE_BY_ID_AND_TIPO]"))
{
Database.AddInParameter(command, "@ID_HARDWARE", DbType.Int32, idHardware);
Database.AddInParameter(command, "@TIPO", DbType.String, tipo);
using (IDataReader reader = Database.ExecuteReader(command))
{
while (reader.Read())
{
ObservacionXHardware observacion = new ObservacionXHardware();
observacion.IdObservacionXHardware = DataUtil.DbValueToDefault <int>(reader["idObservacionXHardware"]);
observacion.IdHardware = DataUtil.DbValueToDefault <int>(reader["idHardware"]);
observacion.Tipo = DataUtil.DbValueToDefault <string>(reader["tipo"]);
observacion.Observacion = DataUtil.DbValueToDefault <string>(reader["observacion"]);
observacion.Fecha = DataUtil.DbValueToDefault <DateTime>(reader["fecha"]);
if (tipo.Equals("Software"))
{
observacion.NombreSoftware = DataUtil.DbValueToDefault <string>(reader["nombreSoftware"]);
observacion.VersionSoftware = DataUtil.DbValueToDefault <string>(reader["versionSoftware"]);
observacion.TipoSoftware = DataUtil.DbValueToDefault <string>(reader["tipoSoftware"]);
}
listaObservaciones.Add(observacion);
}
}
}
return(listaObservaciones);
}
public void UpdateObservacionTipoHardware(ObservacionXHardware observacionXHardware)
{
using (DbCommand command = Database.GetStoredProcCommand("[dbo].[SP_UPDATE_OBSERVACION_TIPO_HARDWARE]"))
{
Database.AddInParameter(command, "@ID_OBSERVACION_X_HARDWARE", DbType.Int32, observacionXHardware.IdObservacionXHardware);
Database.AddInParameter(command, "@OBSERVACION", DbType.String, observacionXHardware.Observacion);
Database.ExecuteNonQuery(command);
}
}
public void CreateObservacionTipoEquipoGeneral(ObservacionXHardware observacionXHardware)
{
using (DbCommand command = Database.GetStoredProcCommand("[dbo].[SP_CREATE_OBSERVACION_TIPO_HARDWARE]"))
{
Database.AddInParameter(command, "@ID_HARDWARE", DbType.Int32, observacionXHardware.IdHardware);
Database.AddInParameter(command, "@TIPO", DbType.String, "EquipoGeneral");
Database.AddInParameter(command, "@OBSERVACION", DbType.String, observacionXHardware.Observacion);
Database.ExecuteNonQuery(command);
}
}
public ActionResult ObservacionesGeneralView(ObservacionXHardware observacion)
{
if (SecurityHelper.GetAdministradorID() > 0 && SecurityHelper.GetAdministradorRol() == "Administrador General")
{
observacionXHardwareDataAccess.CreateObservacionTipoEquipoGeneral(observacion);
return(RedirectToAction("Index", "EquipoGeneral", new { Area = "" }));
}
else
{
return(RedirectToAction("Index", "Login", new { Area = "" }));
}
}
public void CreateObservacionTipoSoftware(ObservacionXHardware observacionXHardware)
{
using (DbCommand command = Database.GetStoredProcCommand("[dbo].[SP_CREATE_OBSERVACION_TIPO_SOFTWARE]"))
{
Database.AddInParameter(command, "@ID_HARDWARE", DbType.Int32, observacionXHardware.IdHardware);
Database.AddInParameter(command, "@TIPO", DbType.String, "Software");
Database.AddInParameter(command, "@OBSERVACION", DbType.String, observacionXHardware.Observacion);
Database.AddInParameter(command, "@NOMBRE_SOFTWARE", DbType.String, observacionXHardware.NombreSoftware);
Database.AddInParameter(command, "@VERSION_SOFTWARE", DbType.String, observacionXHardware.VersionSoftware);
Database.AddInParameter(command, "@TIPO_SOFTWARE", DbType.String, observacionXHardware.TipoSoftware);
Database.ExecuteNonQuery(command);
}
}
public ActionResult EditarObservacion(ObservacionXHardware observacion)
{
if (SecurityHelper.GetAdministradorID() > 0 && (SecurityHelper.GetAdministradorRol() == "Administrador General" || SecurityHelper.GetAdministradorRol() == "Técnico"))
{
if (observacion.Tipo.Equals("Hardware"))
{
observacionXHardwareDataAccess.UpdateObservacionTipoHardware(observacion);
}
else if (observacion.Tipo.Equals("Software"))
{
observacionXHardwareDataAccess.UpdateObservacionTipoSoftware(observacion);
}
return(RedirectToAction("Index", "EquipoComputo", new { Area = "" }));
}
else
{
return(RedirectToAction("Index", "Login", new { Area = "" }));
}
}
