public void Delete()
{
bool result = false;
string codeSequence = Aleatory.GetString(8);
int correlativo = Aleatory.GetShort();
BSequence bSequence = new BSequence();
ESequence eSequence = new ESequence(codeSequence, correlativo);
ESequence deletedSequence = null;
ESequence seletedSequence = null;
TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew);
bSequence.Insert(eSequence);
seletedSequence = bSequence.Select(eSequence);
if (seletedSequence != null)
{
bSequence.Delete(eSequence);
deletedSequence = bSequence.Select(eSequence);
if (deletedSequence == null)
{
result = true;
}
}
Assert.AreEqual(result, true);
}
public EProduct Insert(EProduct eProduct)
{
EProduct eResult = null;
BSequence bSequence = new BSequence();
ESequence eSequence = new ESequence(eProduct);
int correlative = 0;
correlative = bSequence.GetCorrelative(eSequence);
eProduct.CodeProduct = correlative.ToString("0000000000");
eProduct.Validar();
dProduct.Insert(eProduct);
if (dProduct.ExistsPrimaryKey())
{
Message = string.Format("El código de Producto '{0}' ya existe en el Sistema, no se puede crear el registro.", eProduct.CodeProduct);
throw new Exception(Message);
}
if (dProduct.ExistsReference())
{
Message = string.Format("Se intento grabar una llave foranea incorrecta '{0}', no se puede crear el registro.", eProduct.CodeProduct);
throw new Exception(Message);
}
correlative++;
eSequence.Correlative = correlative;
bSequence.SetCorrelativo(eSequence);
eResult = Select(eProduct);
eProduct.Audit.Code = eResult.CodeProduct.ToString();
eProduct.Audit.TypeEvent = "Insert";
bAudit.Insert(eProduct.Audit);
return(eResult);
}
public EClient Insert(EClient eClient)
{
EClient eResult = null;
BSequence bSequence = new BSequence();
ESequence eSequence = new ESequence(eClient);
int correlative = 0;
eClient.SearchName = ProcessSearchName(eClient);
correlative = bSequence.GetCorrelative(eSequence);
eClient.CodeClient = correlative;
eClient.Validar();
dClient.Insert(eClient);
if (dClient.ExistsPrimaryKey())
{
Message = string.Format("El código de Cliente '{0}' ya existe en el Sistema, no se puede crear el registro.", eClient.CodeClient);
throw new Exception(Message);
}
if (dClient.ExistsReference())
{
Message = string.Format("El código de Empresa '{0}' no existe en el Sistema, no se puede crear el registro.", eClient.CodeClient);
throw new Exception(Message);
}
correlative++;
eSequence.Correlative = correlative;
bSequence.SetCorrelativo(eSequence);
eResult = Select(eClient);
eClient.Audit.Code = eResult.CodeClient.ToString();
eClient.Audit.TypeEvent = "Insert";
bAudit.Insert(eClient.Audit);
return(eResult);
}
public void Select()
{
short routes = 0;
string codeSequence = Aleatory.GetString(8);
int correlativo = Aleatory.GetShort();
BSequence bSequence = new BSequence();
ESequence eSequence = new ESequence(codeSequence, correlativo);
ESequence selectedSequence = null;
TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew);
selectedSequence = bSequence.Select(eSequence);
if (selectedSequence == null)
{
routes++;
}
bSequence.Insert(eSequence);
selectedSequence = bSequence.Select(eSequence);
if (selectedSequence != null &&
selectedSequence.CodeSequence == eSequence.CodeSequence &&
selectedSequence.Correlative == eSequence.Correlative)
{
routes++;
}
ts.Dispose();
Assert.AreEqual(routes, 2);
}
public DataRow Select(ESequence sequence)
{
DaCommand command = new DaCommand("SequenceSelect");
command.AddInParameter("@CodeSequence", DbType.String, sequence.CodeSequence);
return(ExecuteDataRow(command));
}
public void Delete(ESequence sequence)
{
DaCommand command = new DaCommand("SequenceDelete");
command.AddInParameter("@CodeSequence", DbType.String, sequence.CodeSequence);
ExecuteNonQuery(command);
}
public void Update(ESequence sequence)
{
DaCommand command = new DaCommand("SequenceUpdate");
command.AddInParameter("@CodeSequence", DbType.String, sequence.CodeSequence);
command.AddInParameter("@Correlative", DbType.Int32, sequence.Correlative);
ExecuteNonQuery(command);
}
public int GetCorrelative(ESequence sequence)
{
ESequence eSequence = Select(sequence);
if (eSequence == null)
{
sequence.Correlative = 1;
Insert(sequence);
eSequence = Select(sequence);
}
return(eSequence.Correlative);
}
public ESequence Select(ESequence sequence)
{
DataRow rowSequence = dSequence.Select(sequence);
if (rowSequence != null)
{
ESequence eSequence = new ESequence(rowSequence, rowSequence.GetColumns());
return(eSequence);
}
else
{
return(null);
}
}
public void SetCorrelativo(ESequence sequence)
{
ESequence eSequence = Select(sequence);
if (eSequence == null)
{
eSequence = new ESequence(
CodeSequence: sequence.CodeSequence,
Correlative: sequence.Correlative);
eSequence.Correlative = 1;
Insert(eSequence);
}
else
{
eSequence.Correlative++;
Update(eSequence);
}
}
public void Insert()
{
bool result = false;
BAudit bAudit = new BAudit();
List <EAudit> listAudit = new List <EAudit>();
BClient bClient = new BClient();
EClient eClient = new EClient();
BSequence bSequence = new BSequence();
ESequence eSequence = null;
TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew);
eClient.CodeTypeDocumentIdentity = "0";
eClient.NumberIdentity = Aleatory.GetString(11);
eClient.FirstName = Aleatory.GetString(8);
eClient.SecondName = Aleatory.GetString(8);
eClient.FatherLastName = Aleatory.GetString(8);
eClient.MotherLastName = Aleatory.GetString(8);
eClient.Audit.UserRegister = Aleatory.GetString(8);
EClient insertedEClient = bClient.Insert(eClient);
eSequence = new ESequence(eClient);
eSequence = bSequence.Select(eSequence);
listAudit = bAudit.Select(eClient.Audit);
if (insertedEClient != null &&
listAudit.Exists(x => x.UserRegister == eClient.Audit.UserRegister &&
x.TypeEvent == "Insert" &&
x.Code == insertedEClient.CodeClient.ToString()) &&
eSequence.Correlative == insertedEClient.CodeClient + 1)
{
result = true;
}
ts.Dispose();
Assert.IsTrue(result);
}
public void Insert()
{
bool result = false;
string codeSequence = Aleatory.GetString(8);
int correlativo = Aleatory.GetShort();
BSequence bSequence = new BSequence();
ESequence eSequence = new ESequence(codeSequence, correlativo);
ESequence insertedSequence = null;
TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew);
bSequence.Insert(eSequence);
insertedSequence = bSequence.Select(eSequence);
if (insertedSequence != null &&
insertedSequence.CodeSequence == eSequence.CodeSequence &&
insertedSequence.Correlative == eSequence.Correlative)
{
result = true;
}
ts.Dispose();
Assert.AreEqual(result, true);
}
public void Delete(ESequence sequence)
{
dSequence.Delete(sequence);
}
public void Update(ESequence eSequence)
{
eSequence.Validar();
dSequence.Update(eSequence);
}
public void Insert(ESequence eSequence)
{
eSequence.Validar();
dSequence.Insert(eSequence);
}
