/// <summary>
/// Find Personal, returneaza Personal cu id-ul specificat daca exista in Db
/// Null altfel
/// </summary>
/// <param name="id">Id-ul personalului de cautat</param>
/// <returns></returns>
public Personal Find(int id)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
using (var command = con.CreateCommand())
{
command.CommandText = "SELECT * " +
"FROM Personal P " +
"WHERE P.Id = @id";
var paramId = command.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = id;
command.Parameters.Add(paramId);
using (var dataReader = command.ExecuteReader())
{
if (dataReader.Read())
{
var idPersonal = dataReader.GetInt32(0);
var userName = dataReader.GetString(1);
var password = dataReader.GetString(2);
var nume = dataReader.GetString(3);
var prenume = dataReader.GetString(4);
var personal = new Personal(idPersonal, userName, password, nume, prenume);
return(personal);
}
}
}
con.Close();
return(null);
}
protected TagPerformanceTestBase()
{
connection = new SQLiteConnectionFactory().Create("Data Source=:memory:;Version=3;");
connection.Open();
repository = new SQLiteTagRepository(logger, typeFactory, connection);
repository.Initialize();
}
/// <summary>
/// Find Destinatie from Db by Id
/// </summary>
/// <param name="id">Id-ul destiantiei de gasit</param>
/// <returns>Destinatia gasita sau null daca nu exista in Db</returns>
public Destinatie Find(int id)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select * from Destinatii where Id=@id";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = id;
comm.Parameters.Add(paramId);
using (var dataR = comm.ExecuteReader())
{
while (dataR.Read())
{
var idDestinatie = dataR.GetInt32(0);
var nume = dataR.GetString(1);
var d = new Destinatie(idDestinatie, nume);
return(d);
}
}
}
con.Close();
return(null);
}
/// <summary>
/// Find all Personal din DB
/// </summary>
/// <returns>O lista de Personal</returns>
public IEnumerable <Personal> FindAll()
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
var listaPersonal = new List <Personal>();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select * from Personal";
using (var dataR = comm.ExecuteReader())
{
while (dataR.Read())
{
var id = dataR.GetInt32(0);
var user = dataR.GetString(1);
var pass = dataR.GetString(2);
var nume = dataR.GetString(3);
var prenume = dataR.GetString(4);
var p = new Personal(id, user, pass, nume, prenume);
listaPersonal.Add(p);
}
}
}
con.Close();
return(listaPersonal);
}
public static Client FindClinetDupaDetalii(string nume, string prenume)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
using (var command = con.CreateCommand())
{
command.CommandText = "SELECT * " +
"FROM Clienti C " +
"WHERE C.Nume=@Nume and C.Prenume=@Prenume";
var paramNume = command.CreateParameter();
paramNume.ParameterName = "@Nume";
paramNume.Value = nume;
command.Parameters.Add(paramNume);
var paramPrenume = command.CreateParameter();
paramPrenume.ParameterName = "@Prenume";
paramPrenume.Value = prenume;
command.Parameters.Add(paramPrenume);
using (var dataR = command.ExecuteReader())
{
if (dataR.Read())
{
var idClient = dataR.GetInt32(0);
var numeC = dataR.GetString(1);
var prenumeC = dataR.GetString(2);
var c = new Client(idClient, numeC, prenumeC);
return(c);
}
}
}
con.Close();
return(null);
}
/// <summary>
/// Find all Rezervari din Db
/// </summary>
/// <returns>Lista cu toate Rezervarile</returns>
public IEnumerable <Rezervare> FindAll()
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
var listaRezervari = new List <Rezervare>();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select * from Rezervari";
using (var dataR = comm.ExecuteReader())
{
while (dataR.Read())
{
var id = dataR.GetInt32(0);
var idCl = dataR.GetInt32(1);
var idCu = dataR.GetInt32(2);
var nr = dataR.GetInt32(3);
var r = new Rezervare(id, idCl, idCu, nr);
listaRezervari.Add(r);
}
}
}
con.Close();
return(listaRezervari);
}
/// <summary>
/// Update Client cu noul nou
/// Arunca ValidationException daca nu e valid
/// </summary>
/// <param name="entity">Noul client</param>
public void Update(Client entity)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
ValidatorClient.Validate(entity);
using (var comm = con.CreateCommand())
{
comm.CommandText = "update Clienti " +
"set Nume=@nume, Prenume=@prenume " +
"where Id=@id";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = entity.Id;
comm.Parameters.Add(paramId);
var paramNume = comm.CreateParameter();
paramNume.ParameterName = "@nume";
paramNume.Value = entity.Nume;
comm.Parameters.Add(paramNume);
var paramPreNume = comm.CreateParameter();
paramPreNume.ParameterName = "@prenume";
paramPreNume.Value = entity.Prenume;
comm.Parameters.Add(paramPreNume);
var dataR = comm.ExecuteNonQuery();
if (dataR == 0)
{
throw new RepositoryException("Clientul nu a fost modificat!");
}
}
con.Close();
}
/// <summary>
/// Cauta clinet in Db
/// </summary>
/// <param name="id">Id-ul clientului de cautat</param>
/// <returns>Clientul gasit sau null daca nu exista</returns>
public Client Find(int id)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
using (var command = con.CreateCommand())
{
command.CommandText = "SELECT * " +
"FROM Clienti C " +
"WHERE C.Id = @id";
var paramId = command.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = id;
command.Parameters.Add(paramId);
using (var dataR = command.ExecuteReader())
{
if (dataR.Read())
{
var idClient = dataR.GetInt32(0);
var nume = dataR.GetString(1);
var prenume = dataR.GetString(2);
var c = new Client(idClient, nume, prenume);
return(c);
}
}
}
con.Close();
return(null);
}
/// <summary>
/// Adaugare Clinet in Db
/// Arunca ValidationException daca clientul nu e valid
/// </summary>
/// <param name="entity">Clientul de adaugagt</param>
public void Add(Client entity)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
ValidatorClient.Validate(entity);
using (var comm = con.CreateCommand())
{
comm.CommandText = "insert into Clienti values (@id,@nume,@prenume)";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = entity.Id;
comm.Parameters.Add(paramId);
var paramNume = comm.CreateParameter();
paramNume.ParameterName = "@nume";
paramNume.Value = entity.Nume;
comm.Parameters.Add(paramNume);
var paramPreNume = comm.CreateParameter();
paramPreNume.ParameterName = "@prenume";
paramPreNume.Value = entity.Prenume;
comm.Parameters.Add(paramPreNume);
var result = comm.ExecuteNonQuery();
if (result == 0)
{
throw new RepositoryException("Clientul nu a fost adaugat!");
}
}
con.Close();
}
public Rezervare Find(int id)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select * from Rezervari";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = id;
comm.Parameters.Add(paramId);
using (var dataR = comm.ExecuteReader())
{
while (dataR.Read())
{
var idRezervare = dataR.GetInt32(0);
var idCl = dataR.GetInt32(1);
var idCu = dataR.GetInt32(2);
var nr = dataR.GetInt32(3);
var r = new Rezervare(idRezervare, idCl, idCu, nr);
return(r);
}
}
}
con.Close();
return(null);
}
/// <summary>
/// Find all Curse from Db
/// </summary>
/// <returns>Lista cu toate cursele din Db</returns>
public IEnumerable <Cursa> FindAll()
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
var listaCurse = new List <Cursa>();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select * from Curse";
using (var dataR = comm.ExecuteReader())
{
while (dataR.Read())
{
var id = dataR.GetInt32(0);
var destinatie = dataR.GetInt32(1);
var data = dataR.GetDateTime(2);
var nrLocuri = dataR.GetInt32(3);
var plecare = dataR.GetString(4);
var c = new Cursa(id, destinatie, data, nrLocuri, plecare);
listaCurse.Add(c);
}
}
}
con.Close();
return(listaCurse);
}
/// <summary>
/// Find Cursa din Db
/// </summary>
/// <param name="id">Id-ul cursei de gasit</param>
/// <returns>Cursa gasita sau null</returns>
public Cursa Find(int id)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select * from Curse where id=@id";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = id;
comm.Parameters.Add(paramId);
using (var dataR = comm.ExecuteReader())
{
while (dataR.Read())
{
var idCursa = dataR.GetInt32(0);
var destinatie = dataR.GetInt32(1);
var data = dataR.GetDateTime(2);
var nrLocuri = dataR.GetInt32(3);
var plecare = dataR.GetString(4);
var c = new Cursa(idCursa, destinatie, data, nrLocuri, plecare);
return(c);
}
}
}
con.Close();
return(null);
}
public SqliteAttributeStorage(
SQLiteConnectionFactory connectionFactory,
IStorageConfiguration configuration,
[Import(typeof(FileAttributeReaderFactory))] IAttributeReaderFactory fileAttributesReaderFactory)
{
_fileAttributeReaderFactory = fileAttributesReaderFactory;
_connectionFactory = connectionFactory;
_requests = new Dictionary <string, Request>(StringComparer.CurrentCultureIgnoreCase);
_configuration = configuration;
}
protected MediaTestBase()
{
logger = new DebugLogger();
mediaFactory = new MediaFactory(logger);
connection = new SQLiteConnectionFactory().Create("Data Source=:memory:;Version=3;");
connection.Open();
repository = new SQLiteMediaRepository(logger, mediaFactory, connection);
repository.Initialize();
}
//private static IRepository<int, Personal> _repository = new MockPersonalRepo();
public static Personal CautaPersonalDupaDetalii(string user, string parola)
{
Personal rez = null;
_repository.FindAll().ToList().ForEach(p =>
{
if ((p.UserName.CompareTo(user) == 0) && (p.Password.CompareTo(parola) == 0))
{
rez = p;
}
});
return(rez);
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
using (var command = con.CreateCommand())
{
command.CommandText = "SELECT * " +
"FROM Personal P " +
"WHERE P.Username = @user and P.Password=@pass";
var paramUser = command.CreateParameter();
paramUser.ParameterName = "@user";
paramUser.Value = user;
command.Parameters.Add(paramUser);
var paramPass = command.CreateParameter();
paramPass.ParameterName = "@pass";
paramPass.Value = parola;
command.Parameters.Add(paramPass);
using (var dataReader = command.ExecuteReader())
{
if (dataReader.Read())
{
var idPersonal = dataReader.GetInt32(0);
var userName = dataReader.GetString(1);
var password = dataReader.GetString(2);
var nume = dataReader.GetString(3);
var prenume = dataReader.GetString(4);
var personal = new Personal(idPersonal, userName, password, nume, prenume);
return(personal);
}
}
}
con.Close();
return(null);
}
public NoteService(IDialogService dialogService)
{
this.dialogService = dialogService;
this.factory = new SQLiteConnectionFactory();
// Initialize the notes storage location
// -------------------------------------
// If using the default storage location, check if the location needs to be created.
if (ApplicationPaths.IsUsingDefaultStorageLocation)
{
if (!Directory.Exists(ApplicationPaths.CurrentNoteStorageLocation))
{
Directory.CreateDirectory(ApplicationPaths.CurrentNoteStorageLocation);
}
}
}
public void Setup()
{
var factory = new SQLiteConnectionFactory(new FileSystem(), "test.db");
var attributeReader = new Mock <IAttributeReader>();
attributeReader.Setup(mock => mock.Read()).Returns <Attribute>(null);
var attributeReaderFactory = new Mock <IAttributeReaderFactory>();
attributeReaderFactory
.Setup(mock => mock.CreateFromSegments(It.IsAny <FileInfo>(), It.IsAny <IEnumerable <JpegSegment> >()))
.Returns(attributeReader.Object);
_configuration = new ConfigurationMock();
_storage = new SqliteAttributeStorage(factory, _configuration, attributeReaderFactory.Object);
}
/// <summary>
/// Add Personal, adauga personalul in DB
/// Arunca RepositoryException daca nu se poate
/// </summary>
/// <param name="entity"></param>
public void Add(Personal entity)
{
ValidatorPersonal.Validate(entity);
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "INSERT into Personal " +
"values (@id, @userName, @password, @nume, @prenume)";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = entity.Id;
comm.Parameters.Add(paramId);
var paramUser = comm.CreateParameter();
paramUser.ParameterName = "@userName";
paramUser.Value = entity.UserName;
comm.Parameters.Add(paramUser);
var paramPass = comm.CreateParameter();
paramPass.ParameterName = "@password";
paramPass.Value = entity.Password;
comm.Parameters.Add(paramPass);
var paramNume = comm.CreateParameter();
paramNume.ParameterName = "@nume";
paramNume.Value = entity.Nume;
comm.Parameters.Add(paramNume);
var paramPrenume = comm.CreateParameter();
paramPrenume.ParameterName = "@prenume";
paramPrenume.Value = entity.Prenume;
comm.Parameters.Add(paramPrenume);
var result = comm.ExecuteNonQuery();
if (result == 0)
{
throw new RepositoryException("Personalul nu putut fi adaugat!!");
}
}
con.Close();
}
/// <summary>
/// Update Cursa
/// Arunca RepositoryException in caz de esec
/// </summary>
/// <param name="entity">Cursa de updatat</param>
public void Update(Cursa entity)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "update Curse " +
"set Destinatie=@Destinatie, DataPlecare=@dataPlecare, NrLocuri=@nrLocuri, Plecare=@plecare " +
"where Id=@id";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = entity.Id;
comm.Parameters.Add(paramId);
var paramDestinatie = comm.CreateParameter();
paramDestinatie.ParameterName = "@destinatie";
paramDestinatie.Value = entity.IdDestinatie;
comm.Parameters.Add(paramDestinatie);
var paramData = comm.CreateParameter();
paramData.ParameterName = "@dataPlecare";
paramData.Value = entity.DataPlecare;
comm.Parameters.Add(paramData);
var paramLocuri = comm.CreateParameter();
paramLocuri.ParameterName = "@nrLocuri";
paramLocuri.Value = entity.NrLocuriDisponibile;
comm.Parameters.Add(paramLocuri);
var paramPlecare = comm.CreateParameter();
paramPlecare.ParameterName = "@plecare";
paramPlecare.Value = entity.LocPlecare;
comm.Parameters.Add(paramPlecare);
var dataR = comm.ExecuteNonQuery();
if (dataR == 0)
{
throw new RepositoryException("Cursa nu a fost modificata!");
}
}
con.Close();
}
/// <summary>
/// Update Personal
/// Arunca RepositoryException in caz de esec
/// </summary>
/// <param name="entity">Entitatea noua, cu id-ul entitatii de updatat</param>
public void Update(Personal entity)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
ValidatorPersonal.Validate(entity);
using (var comm = con.CreateCommand())
{
comm.CommandText = "update Personal " +
"set UserName=@userName, Password=@password, Nume=@nume, Prenume=@prenume " +
"where Id=@id";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = entity.Id;
comm.Parameters.Add(paramId);
var paramUser = comm.CreateParameter();
paramUser.ParameterName = "@userName";
paramUser.Value = entity.UserName;
comm.Parameters.Add(paramUser);
var paramPass = comm.CreateParameter();
paramPass.ParameterName = "@password";
paramPass.Value = entity.Password;
comm.Parameters.Add(paramPass);
var paramNume = comm.CreateParameter();
paramNume.ParameterName = "@nume";
paramNume.Value = entity.Nume;
comm.Parameters.Add(paramNume);
var paramPrenume = comm.CreateParameter();
paramPrenume.ParameterName = "@prenume";
paramPrenume.Value = entity.Prenume;
comm.Parameters.Add(paramPrenume);
var dataR = comm.ExecuteNonQuery();
if (dataR == 0)
{
throw new RepositoryException("Personal nu a fost modificat!");
}
}
con.Close();
}
/// <summary>
/// Adauga Cursa in Db
/// Arunca RepositoryException in caz de esec
/// </summary>
/// <param name="entity">Cursa e adaugat</param>
public void Add(Cursa entity)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
ValidatorCursa.Validate(entity);
using (var comm = con.CreateCommand())
{
comm.CommandText = "insert into Curse values (@id, @destinatie, @dataPlecare, @nrLocuri, @plecare)";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = entity.Id;
comm.Parameters.Add(paramId);
var paramDestinatie = comm.CreateParameter();
paramDestinatie.ParameterName = "@destinatie";
paramDestinatie.Value = entity.IdDestinatie;
comm.Parameters.Add(paramDestinatie);
var paramData = comm.CreateParameter();
paramData.ParameterName = "@dataPlecare";
paramData.Value = entity.DataPlecare;
comm.Parameters.Add(paramData);
var paramLocuri = comm.CreateParameter();
paramLocuri.ParameterName = "@nrLocuri";
paramLocuri.Value = entity.NrLocuriDisponibile;
comm.Parameters.Add(paramLocuri);
var paramPlecare = comm.CreateParameter();
paramPlecare.ParameterName = "@plecare";
paramPlecare.Value = entity.LocPlecare;
comm.Parameters.Add(paramPlecare);
var result = comm.ExecuteNonQuery();
if (result == 0)
{
throw new RepositoryException("Cursa nu a fost adaugata!");
}
}
con.Close();
}
public static DBSQLiteConnection CreateOrGet()
{
var ins = SQLiteConnectionFactory.Restore();
if (ins == null)
{
lock (_OBJECT_LOCK)
{
ins = SQLiteConnectionFactory.Restore();
if (ins == null)
{
ins = new DBSQLiteConnection();
SQLiteConnectionFactory.Cache(ins);
}
}
}
return(ins);
}
/// <summary>
/// Delete Rezervare from Db
/// Arunca RepositoryExecption in caz de esec
/// </summary>
/// <param name="id">Id-ul rezervarii de sters</param>
public void Delete(int id)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "delete from Rezervari where id=@id";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = id;
comm.Parameters.Add(paramId);
var dataR = comm.ExecuteNonQuery();
if (dataR == 0)
{
throw new RepositoryException("Rezervarea nu a fost stearsa!");
}
}
con.Close();
}
protected LinkTestBase()
{
connection = new SQLiteConnectionFactory().Create("Data Source=:memory:;Version=3;");
connection.Open();
repository = new SQLiteLinkRepository(logger, connection);
repository.Initialize();
link1 = new Link(source1, target1, type5, name1);
link2 = new Link(source1, target2, type2, name2);
link3 = new Link(source3, target3, type3, name3);
link4 = new Link(source4, target4, type4, name4);
link5 = new Link(source5, target2, type5, name5);
link6 = new Link(source1, target6, type6, name6);
link7 = new Link(source7, target7, type7, name7);
link8 = new Link(source5, target2, type5, name8);
link9 = new Link(source5, target2, type9, name9);
link10 = new Link(source5, target10, type10, name10);
link11 = new Link(source11, target11, type11, name11);
link12 = new Link(source12, target2, type5, name12);
link13 = new Link(source13, target13, type13, name13);
link14 = new Link(source14, target14, type14, name14);
link15 = new Link(source15, target15, type15, name15);
links.Add(link1);
links.Add(link2);
links.Add(link3);
links.Add(link4);
links.Add(link5);
links.Add(link6);
links.Add(link7);
links.Add(link8);
links.Add(link9);
links.Add(link10);
links.Add(link11);
links.Add(link12);
links.Add(link13);
links.Add(link14);
links.Add(link15);
}
/// <summary>
/// Find all Destinatii din Db
/// </summary>
/// <returns>Lista cu toate destinatiile</returns>
public IEnumerable <Destinatie> FindAll()
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
var listaDestinatii = new List <Destinatie>();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select * from Destinatii";
using (var dataR = comm.ExecuteReader())
{
while (dataR.Read())
{
var id = dataR.GetInt32(0);
var nume = dataR.GetString(1);
var d = new Destinatie(id, nume);
listaDestinatii.Add(d);
}
}
}
con.Close();
return(listaDestinatii);
}
