public void Borrar(DO.Persona persona)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
DAL.Mantenimiento.Instancia.Borrar(persona);
scope.Complete();
}
}
catch (Exception ee)
{
throw;
}
}
public void Insertar(DO.Persona persona)
{
DbProviderFactory factory = DbProviderFactories.GetFactory(Settings.Default.proveedor);
DbConnection conn = null;
DbCommand comm = null;
try
{
conn = factory.CreateConnection();
conn.ConnectionString = Settings.Default.connection;
comm = factory.CreateCommand();
DbParameter param1 = factory.CreateParameter();
DbParameter param2 = factory.CreateParameter();
DbParameter param3 = factory.CreateParameter();
DbParameter param4 = factory.CreateParameter();
DbParameter param5 = factory.CreateParameter();
// DbParameter param6 = factory.CreateParameter();
//Carga de Parametros
/*param1.ParameterName = "@iCedula";
*
* param1.DbType = System.Data.DbType.Int32;
*
* param1.Value = persona.ICedula;*/
param1.ParameterName = "@vNombre";
param1.DbType = System.Data.DbType.String;
param1.Value = persona.VNombre;
param2.ParameterName = "@bMuerto";
param2.DbType = System.Data.DbType.Boolean;
param2.Value = persona.BMuerto;
param3.ParameterName = "@dtNacimiento";
param3.DbType = System.Data.DbType.Date;
param3.Value = persona.DTNacimiento;
param4.ParameterName = "@iEdad";
param4.DbType = System.Data.DbType.Int32;
param4.Value = persona.IEdad;
param5.ParameterName = "@vEmail";
param5.DbType = System.Data.DbType.String;
param5.Value = persona.VEmail;
//Abrir Coneccion
comm.Connection = conn;
conn.Open();
//Ejecutar Store Procedure
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.CommandText = "sp_insertar_identity";
comm.Parameters.Add(param1);
comm.Parameters.Add(param2);
comm.Parameters.Add(param3);
comm.Parameters.Add(param4);
comm.Parameters.Add(param5);
//comm.Parameters.Add(param6);
comm.ExecuteNonQuery();
}
catch (Exception ee)
{
throw;
}
finally
{
comm.Dispose();
conn.Dispose();
}
}
public void Borrar(DO.Persona persona)
{
DbProviderFactory factory = DbProviderFactories.GetFactory(Settings.Default.proveedor);
DbConnection conn = null;
DbCommand comm = null;
try
{
conn = factory.CreateConnection();
conn.ConnectionString = Settings.Default.connection;
comm = factory.CreateCommand();
DbParameter param1 = factory.CreateParameter();
//Carga de Parametros
param1.ParameterName = "@iCedula";
param1.DbType = System.Data.DbType.Int32;
param1.Value = persona.ICedula;
//Abrir Coneccion
comm.Connection = conn;
conn.Open();
//Ejecutar Store Procedure
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.CommandText = "sp_Eliminar";
comm.Parameters.Add(param1);
comm.ExecuteNonQuery();
}
catch (Exception ee)
{
throw;
}
finally
{
comm.Dispose();
conn.Dispose();
}
}