/// <summary>
/// Inserta el registro del movimiento de reasignacion de mobiliario dentro de la tabla historial
/// </summary>
/// <param name="servidorActual"></param>
/// <param name="servidorNuevo"></param>
private void InsertaHistorialMobiliario(HistorialMobiliario historial)
{
SqlConnection connection = Conexion.GetConexion();
SqlDataAdapter dataAdapter;
DataSet dataSet = new DataSet();
DataRow dr;
string sqlCadena = "SELECT * FROM HistorialMobiliario WHERE idMovimiento = 0";
try
{
dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand = new SqlCommand(sqlCadena, connection);
dataAdapter.Fill(dataSet, "Mobiliario");
dr = dataSet.Tables["Mobiliario"].NewRow();
dr["idMobiliario"] = historial.IdMobiliario;
dr["expAnterior"] = historial.ExpAnterior;
dr["expActual"] = historial.ExpActual;
dr["Observaciones"] = historial.Observaciones;
dr["usuarioModifica"] = AccesoUsuarioModel.Usuario;
dataSet.Tables["Mobiliario"].Rows.Add(dr);
dataAdapter.InsertCommand = connection.CreateCommand();
dataAdapter.InsertCommand.CommandText = "INSERT INTO HistorialMobiliario(idMobiliario,expAnterior,expActual,Observaciones,FechaReasignacion,usuarioModifica)" +
" VALUES(@idMobiliario,@expAnterior,@expActual,@Observaciones,SysDateTime(),@usuarioModifica)";
dataAdapter.InsertCommand.Parameters.Add("@idMobiliario", SqlDbType.Int, 0, "idMobiliario");
dataAdapter.InsertCommand.Parameters.Add("@expAnterior", SqlDbType.Int, 0, "expAnterior");
dataAdapter.InsertCommand.Parameters.Add("@expActual", SqlDbType.Int, 0, "expActual");
dataAdapter.InsertCommand.Parameters.Add("@Observaciones", SqlDbType.Text, 0, "Observaciones");
dataAdapter.InsertCommand.Parameters.Add("@usuarioModifica", SqlDbType.VarChar, 0, "usuarioModifica");
dataAdapter.Update(dataSet, "Mobiliario");
dataSet.Dispose();
dataAdapter.Dispose();
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,MobiliarioModel", "Inventario");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,MobiliarioModel", "Inventario");
}
finally
{
connection.Close();
}
}
/// <summary>
/// Actualiza el número de expediente del usuario que tiene el resguardo del mobiliario
/// </summary>
/// <param name="historial"></param>
public void UpdateMobiliario(HistorialMobiliario historial)
{
SqlConnection connection = Conexion.GetConexion();
SqlDataAdapter dataAdapter = new SqlDataAdapter();
DataSet dataSet = new DataSet();
DataRow dr;
string sqlCadena = "SELECT * FROM Mobiliario WHERE idMobiliario = " + mobiliario.IdMobiliario;
try
{
dataAdapter.SelectCommand = new SqlCommand(sqlCadena, connection);
dataAdapter.Fill(dataSet, "Mobiliario");
dr = dataSet.Tables["Mobiliario"].Rows[0];
dr.BeginEdit();
dr["Expediente"] = historial.ExpActual;
dr["Observaciones"] = historial.Observaciones;
dr.EndEdit();
//dataSet.Tables["Mobiliario"].Rows.Add(dr);
dataAdapter.UpdateCommand = connection.CreateCommand();
dataAdapter.UpdateCommand.CommandText = "UPDATE Mobiliario SET Expediente = @Expediente,Observaciones = @Observaciones,FechaModificacion = SysDateTime() " +
"WHERE idMobiliario = @idMobiliario";
dataAdapter.UpdateCommand.Parameters.Add("@Expediente", SqlDbType.Int, 0, "Expediente");
dataAdapter.UpdateCommand.Parameters.Add("@Observaciones", SqlDbType.Text, 0, "Observaciones");
dataAdapter.UpdateCommand.Parameters.Add("@idMobiliario", SqlDbType.Int, 0, "idMobiliario");
dataAdapter.Update(dataSet, "Mobiliario");
dataSet.Dispose();
dataAdapter.Dispose();
this.InsertaHistorialMobiliario(historial);
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,MobiliarioModel", "Inventario");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,MobiliarioModel", "Inventario");
}
finally
{
connection.Close();
}
}
/// <summary>
/// Devuelve el listado de movimientos que ha registrado un equipo
/// </summary>
/// <param name="mobiliario"></param>
/// <returns></returns>
public ObservableCollection <HistorialMobiliario> GetHistorial(Mobiliario mobiliario)
{
ObservableCollection <HistorialMobiliario> historiales = new ObservableCollection <HistorialMobiliario>();
SqlConnection connection = Conexion.GetConexion();
SqlDataReader dataReader;
try
{
connection.Open();
string selstr = "SELECT * FROM HistorialMobiliario WHERE IdMobiliario = @IdMobiliario ORDER BY fechaReasignacion ";
SqlCommand cmd = new SqlCommand(selstr, connection);
cmd.Parameters.AddWithValue("@IdMobiliario", mobiliario.Inventario);
dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
HistorialMobiliario historial = new HistorialMobiliario();
historial.IdMovimiento = Convert.ToInt32(dataReader["IdMovimiento"]);
historial.ExpAnterior = Convert.ToInt32(dataReader["ExpAnterior"]);
historial.ExpActual = Convert.ToInt32(dataReader["ExpActual"]);
historial.Observaciones = dataReader["Observaciones"].ToString();
historial.FechaReasignacion = DateTimeUtilities.GetDateFromReader(dataReader, "FechaReasignacion");
historiales.Add(historial);
}
}
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,MobiliarioModel", "Inventario");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,MobiliarioModel", "Inventario");
}
finally
{
connection.Close();
}
return(historiales);
}
private void RbtnAceptar_Click(object sender, RoutedEventArgs e)
{
HistorialMobiliario historial = new HistorialMobiliario();
historial.IdMobiliario = mobiliario.IdMobiliario;
historial.ExpAnterior = servidorActual.Expediente;
historial.ExpActual = servidorNuevo.Expediente;
historial.Observaciones = txtAObservaciones.Text;
MobiliarioModel model = new MobiliarioModel(mobiliario);
model.UpdateMobiliario(historial);
ServidoresSingleton.RemoveMobiliarioUsuario(servidorActual.Expediente, mobiliario);
ServidoresSingleton.AddMobiliarioUsuario(servidorNuevo.Expediente, mobiliario);
this.Close();
}
