/// <summary>
/// Método para actulizar a un empleado
/// </summary>
/// <param name="client"></param>
public static void Actualizar(Client client)
{
OperationsLogs.WriteLogsDebug("EmpleadoDal", "Actualizar", string.Format("{0} Info: {1}", DateTime.Now.ToString(), "Empezando a ejecutar el metodo acceso a datos para eliminar un Persona"));
SqlCommand command = null;
// Proporcionar la cadena de consulta
string queryString = @"UPDATE Cliente
WHERE idPersona=@idPersona";
try
{
command = OperationsSql.CreateBasicCommand(queryString);
command.Parameters.AddWithValue("@idPersona", client.IdPerson);
//Actualizo a la persona
PersonDal.Actualizar(client as Person);
OperationsSql.ExecuteBasicCommand(command);
}
catch (SqlException ex)
{
OperationsLogs.WriteLogsRelease("EmpleadoDal", "Actualizar", string.Format("{0} Error: {1}", DateTime.Now.ToString(), ex.Message));
throw ex;
}
catch (Exception ex)
{
OperationsLogs.WriteLogsRelease("EmpleadoDal", "Actualizar", string.Format("{0} Error: {1}", DateTime.Now.ToString(), ex.Message));
throw ex;
}
OperationsLogs.WriteLogsDebug("EmpleadoDal", "Actualizar", string.Format("{0} Info: {1}", DateTime.Now.ToString(), "Termino de ejecutar el metodo acceso a datos para Eliminar un Cliente"));
}
/// <summary>
/// Inserta una Cliente a la base de datos
/// </summary>
/// <param name="Cliente"></param>
public static void Insertar(Client client)
{
OperationsLogs.WriteLogsDebug("ClienteDal", "Insertar", string.Format("{0} Info: {1}",
DateTime.Now.ToString(), "Empezando a ejecutar el metodo acceso a datos para crear un Cliente"));
SqlCommand command = null;
//Consulta para insertar Clientes
string queryString = @"INSERT INTO Cliente(idPersona)
VALUES(@idCliente)";
//Declaro e inicio la conexion
SqlConnection conexion = OperationsSql.ObtenerConexion();
//Declaro la transaccion
SqlTransaction transaccion = null;
try
{
//Abro la conexion a la base de datos
conexion.Open();
//Inicio la transaccion
transaccion = conexion.BeginTransaction();
//Inserto a la persona
PersonDal.InsertarConTransaccion(client as Person, transaccion, conexion);
//Inserto al Cliente
command = OperationsSql.CreateBasicCommandWithTransaction(queryString, transaccion, conexion);
command.Parameters.AddWithValue("@idCliente", client.IdPerson);
OperationsSql.ExecuteBasicCommandWithTransaction(command);
transaccion.Commit();
}
catch (SqlException ex)
{
OperationsLogs.WriteLogsRelease("ClienteDal", "Insertar", string.Format("{0} Error: {1} ",
DateTime.Now.ToString(), ex.Message));
throw ex;
}
catch (Exception ex)
{
OperationsLogs.WriteLogsRelease("ClienteDal", "Insertar", string.Format("{0} Error: {1}",
DateTime.Now.ToString(), ex.Message));
throw ex;
}
finally
{
conexion.Close();
}
OperationsLogs.WriteLogsDebug("ClienteDal", "Insertar", string.Format("{0} Info: {1}",
DateTime.Now.ToString(),
"Termino de ejecutar el metodo acceso a datos para insertar Cliente"));
}
/// <summary>
/// Método para eliminar a un Cliente
/// </summary>
/// <param name="Cliente"></param>
public static void Eliminar(Guid idCliente)
{
OperationsLogs.WriteLogsDebug("ClienteDal", "Eliminar", string.Format("{0} Info: {1}", DateTime.Now.ToString(), "Empezando a ejecutar el metodo acceso a datos para eliminar un Persona"));
SqlCommand command = null;
// Proporcionar la cadena de consulta
string queryString = @"UPDATE Cliente SET idPersona = @id
WHERE idPersona=@id";
//Declaro e inicio la conexion
SqlConnection conexion = OperationsSql.ObtenerConexion();
//Declaro la transaccion
SqlTransaction transaccion = null;
try
{
//Abro la conexion a la base de datos
conexion.Open();
//Inicio la transaccion
transaccion = conexion.BeginTransaction();
command = OperationsSql.CreateBasicCommandWithTransaction(queryString, transaccion, conexion);
command.Parameters.AddWithValue("@id", idCliente);
//Elimino a la persona
PersonDal.EliminarConTransaccion(idCliente, transaccion, conexion);
OperationsSql.ExecuteBasicCommandWithTransaction(command);
transaccion.Commit();
}
catch (SqlException ex)
{
OperationsLogs.WriteLogsRelease("ClienteDal", "Eliminar", string.Format("{0} Error: {1}", DateTime.Now.ToString(), ex.Message));
throw ex;
}
catch (Exception ex)
{
OperationsLogs.WriteLogsRelease("ClienteDal", "Eliminar", string.Format("{0} Error: {1}", DateTime.Now.ToString(), ex.Message));
throw ex;
}
OperationsLogs.WriteLogsDebug("ClienteDal", "Eliminar", string.Format("{0} Info: {1}", DateTime.Now.ToString(), "Termino de ejecutar el metodo acceso a datos para Eliminar un Cliente"));
}
/// <summary>
/// Metodo para obtener un Cliente
/// </summary>
/// <param name="id">Identificado del Cliente </param>
/// <returns>Cliente</returns>
public static Client Obtener(Guid id)
{
Client cliente = null;
SqlCommand cmd = null;
SqlDataReader dr = null;
string query = @"SELECT c.idPersona, c.idUbicacion
FROM Cliente c
INNER JOIN Persona p ON p.idPersona = c.idPersona
WHERE c.idPersona = @id and p.eliminado = 1";
try
{
cmd = OperationsSql.CreateBasicCommand(query);
cmd.Parameters.AddWithValue("@id", id);
dr = OperationsSql.ExecuteDataReaderCommand(cmd);
cliente = PersonDal.ObtenerCliente(id);
while (dr.Read())
{
cliente.IdPerson = dr.GetGuid(0);
cliente.Location = LocationDal.Obtener(dr.GetGuid(1));
}
}
catch (SqlException ex)
{
OperationsLogs.WriteLogsRelease("ClienteDal", "Obtenet", string.Format("{0} {1} Error: {1}", DateTime.Now.ToString(), DateTime.Now.ToString(), ex.Message));
throw ex;
}
catch (Exception ex)
{
OperationsLogs.WriteLogsRelease("ClienteDal", "Obtenet", string.Format("{0} {1} Error: {1}", DateTime.Now.ToString(), DateTime.Now.ToString(), ex.Message));
throw ex;
}
finally
{
cmd.Connection.Close();
}
return(cliente);
}
