public void Update(ContBancar contBancar, string denumire, string IBAN)
{
MySqlCommand command = entity.CreateConnection();
command.CommandText = "update contbancar set denumire='" + denumire + "',iban='" + IBAN + "';";
Reader = command.ExecuteReader();
entity.CloseConnection();
}
public static ContBancar ContBancar_Adaugare(ContBancar cont, string cui)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("Parteneri")))
{
var p = new DynamicParameters();
p.Add("@iban", cont.IBAN);
p.Add("@banca", cont.Banca);
p.Add("@moneda", cont.Moneda_Cont);
p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.ConturiBancare_Adaugare", p, commandType: CommandType.StoredProcedure);
cont.Id = p.Get <int>("@id");
var pa = new DynamicParameters();
pa.Add("@id_cont", cont.Id);
pa.Add("@cui_firma", cui);
pa.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.FirmaContBancar_Adaugare", pa, commandType: CommandType.StoredProcedure);
return(cont);
}
}
public void TestSessionFactory()
{
//AuditEventListener lis = (AuditEventListener)applicationContext.GetObject("enversEventListener");
Address adr = new Address {
number = "16", street = "Diligentei"
};
addressRepository.Add(adr);
ContBancar cnt = new ContBancar {
NumeBanca = "BCR", IBAN = "RO212BCRO423455634", Adresa = adr
};
contRepository.Add(cnt);
Person persoana = new Person {
firstName = "Mihai", lastName = "Popa", cont = cnt
};
personRepository.Add(persoana);
persoana.lastName = "Popatatu";
personRepository.Update(persoana);
IList personRevisionIds;
//personRevisionIds = personRepository.GetAllRevisionIds(persoana);
//foreach (object personRevId in personRevisionIds)
//{
// Person auditedPerson = personRepository.GetRevision(typeof(Person), persoana.id, (long)(int)personRevId);
// Assert.IsTrue(auditedPerson.cont is SessionImpl);
// System.Console.Write(personRevId + ":" + auditedPerson.firstName + " " + auditedPerson.lastName + " -> " + auditedPerson.address.street);
//}
Address address = new Address {
number = "22", street = "Valea Calugareasca"
};
addressRepository.Add(address);
Assert.IsTrue(address.id != 0);
long id1 = address.id;
address.number = "29";
addressRepository.Update(address);
Person pers = new Person {
firstName = "Ion", lastName = "Gheorghe", address = address
};
personRepository.Add(pers);
Assert.IsTrue(pers.id != 0);
pers.firstName = "Ionel";
personRepository.Update(pers);
personRevisionIds = personRepository.GetAllRevisionIds(pers);
foreach (object personRevId in personRevisionIds)
{
Person auditedPerson = personRepository.GetRevision(typeof(Person), pers.id, (long)(int)personRevId);
if (auditedPerson.address is INHibernateProxy)
{
Type tt = ((INHibernateProxy)auditedPerson.address).HibernateLazyInitializer.PersistentClass;
object gigi = ((INHibernateProxy)auditedPerson.address).HibernateLazyInitializer.GetImplementation();
}
Type t = NHibernateUtil.GetClass(auditedPerson.address);
System.Console.Write(personRevId + ":" + auditedPerson.firstName + " " + auditedPerson.lastName + " -> " + auditedPerson.address.street);
}
address.number = "23";
addressRepository.Update(address);
address.number = "24";
addressRepository.Update(address);
address = new Address {
number = "45", street = "Strada Strada"
};
addressRepository.Add(address);
ContBancar cont = new ContBancar {
NumeBanca = "BRD", IBAN = "RO212423455634", Adresa = address
};
contRepository.Add(cont);
pers.cont = cont;
personRepository.Update(pers);
address = new Address {
number = "55bis", street = "Alta strada"
};
addressRepository.Add(address);
ContBancar cont2 = new ContBancar {
NumeBanca = "BCR", IBAN = "RO33BCRO212423455634", Adresa = address
};
contRepository.Add(cont2);
pers.cont = cont2;
personRepository.Update(pers);
cont.IBAN += "P2";
contRepository.Update(cont);
Person pers2 = new Person {
firstName = "Mihai", lastName = "Trompetzescu", address = address, cont = cont
};
personRepository.Add(pers2);
address = addressRepository.GetById(id1);
Assert.IsTrue(address.number == "24" && address.street == "Valea Calugareasca");
address = new Address {
number = "123", street = "P-asta o stergem"
};
addressRepository.Add(address);
addressRepository.Remove(address);
}
