private void StoreData(IObjectContainer container)
{
container.Store(new Person("Roman","Stoffel")
{
Address = new Address()
{
City = "Zurich",
Street = "FunStreet"
}
});
container.Store(new Person("Joe","Cool")
{
Address = new Address()
{
City = "FunTown",
Street = "Fun Plaza"
}
});
container.Store(new Person("Joanna", "Awesome")
{
Address = new Address()
{
City = "More Fun Town",
Street = "Plaza"
}
});
}
public static void StoreSecondCar(IObjectContainer db)
{
Pilot pilot2 = new Pilot("Rubens Barrichello", 99);
db.Store(pilot2);
Car car2 = new Car("BMW");
car2.Pilot = pilot2;
db.Store(car2);
}
protected override void PopulateContainer(IObjectContainer container)
{
MyTestClass test1 = new MyTestClass();
container.Store(test1);
MyTestClass test2 = new MyTestClass();
container.Store(test2);
}
private static void CommitChanges(IObjectContainer container)
{
// #example: Rollback changes
container.Store(new Pilot("John"));
container.Store(new Pilot("Joanna"));
container.Rollback();
// #end example
}
// #end example:
private void StoreInitialObjects(IObjectContainer container)
{
lock (dataLock)
{
container.Store(new Person("Joe"));
container.Store(new Person("Jan"));
container.Store(new Person("Joanna"));
container.Store(new Person("Phil"));
}
}
public void StoreState(IObjectContainer container) {
if (null != state)
{
if (OnlyNeedUpdate(container))
{
container.Store(state.CurrentHighestIds);
} else
{
container.Store(state);
}
}
}
private static void StoreData(IObjectContainer container)
{
Pilot john = new Pilot("John", 42);
Pilot joanna = new Pilot("Joanna", 45);
Pilot jenny = new Pilot("Jenny", 21);
Pilot rick = new Pilot("Rick", 33);
container.Store(new Car(john, "Ferrari"));
container.Store(new Car(joanna, "Mercedes"));
container.Store(new Car(jenny, "Volvo"));
container.Store(new Car(rick, "Fiat"));
}
private void Store(IObjectContainer objectContainer)
{
Item item = new Item();
item._name = "First";
item._enumAsInteger = EnumAsInteger.First;
objectContainer.Store(item);
item = new Item();
item._name = "Second";
item._enumAsInteger = EnumAsInteger.Second;
objectContainer.Store(item);
}
private void Store(IObjectContainer objectContainer)
{
Item item = new Item();
item._name = "First";
item._dateTime = new DateTime(2009,1,14);
objectContainer.Store(item);
item = new Item();
item._name = "Second";
item._dateTime = new DateTime(2009, 1, 15);
objectContainer.Store(item);
}
public static void StoreCars(IObjectContainer db)
{
Pilot pilot1 = new Pilot("Michael Schumacher", 100);
Car car1 = new Car("Ferrari");
car1.Pilot = pilot1;
car1.Snapshot();
db.Store(car1);
Pilot pilot2 = new Pilot("Rubens Barrichello", 99);
Car car2 = new Car("BMW");
car2.Pilot = pilot2;
car2.Snapshot();
car2.Snapshot();
db.Store(car2);
}
// #end example:
private void StoreInitialObjects(IObjectContainer container)
{
dataLock.EnterWriteLock();
try
{
container.Store(new Person("Joe"));
container.Store(new Person("Jan"));
container.Store(new Person("Joanna"));
container.Store(new Person("Phil"));
}
finally
{
dataLock.ExitWriteLock();
}
}
public static void StoreFirstCar(IObjectContainer db)
{
Car car1 = new Car("Ferrari");
Pilot pilot1 = new Pilot("Michael Schumacher", 100);
car1.Pilot = pilot1;
db.Store(car1);
}
private static void StoreData(IObjectContainer container, Random rnd)
{
for (int i = 0; i < rnd.Next(4096); i++)
{
container.Store(new DataObject(rnd));
}
}
public static void SetSecondCar(IObjectContainer db)
{
Pilot pilot = new Pilot("Michael Schumacher", 100);
Car car = new Car("Ferrari");
car.Pilot = pilot;
db.Store(car);
}
public Boolean cadastrarCliente(Cliente objCliente)
{
objCliente.Codigo = obtemNovoId();
try
{
if (!temDuplicidade(objCliente, "Cadastrar"))
{
db = ServidorSingleton.obterServidor().OpenClient();
db.Store(objCliente);
db.Commit();
return true;
}
else {
return false;
}
}
catch(Exception e)
{
throw new Exception("Erro cadastrando o cliente :" + e.Message);
}
finally {
db.Close();
db.Dispose();
}
}
public static void SetFirstCar(IObjectContainer db)
{
Pilot pilot = new Pilot("Rubens Barrichello", 99);
Car car = new Car("BMW");
car.Pilot = pilot;
db.Store(car);
}
public Boolean cadastrarStatus(clsStatus objStatus)
{
try
{
if (!temDuplicidade(objStatus, "Cadastrar"))
{
objStatus.Codigo = obtemNovoId(); //Executa a solicitação de um novo id
db = ServidorSingleton.obterServidor().OpenClient();
db.Store(objStatus);
db.Commit();
return true;
}
else {
return false;
}
}
catch (Exception ex)
{
db.Rollback();
throw new Exception("Erro cadastrando o status :" + ex.ToString());
}
finally {
db.Close();
db.Dispose();
}
}
// #end example
private static void StoreExampleObjects(IObjectContainer container)
{
for (int i = 0; i < 100; i++)
{
container.Store(new Item(i));
}
}
public Boolean alterarStatus(clsStatus objAtualizar)
{
try
{
if (!temDuplicidade(objAtualizar, "Alterar"))
{
clsStatus objStatusBuscar = new clsStatus();
objStatusBuscar.Codigo = objAtualizar.Codigo;
db = ServidorSingleton.obterServidor().OpenClient();
IObjectSet leitor = db.QueryByExample(objStatusBuscar);
clsStatus objStatus = (clsStatus)leitor.Next();
objStatus.Descricao = objAtualizar.Descricao;
db.Store(objStatus);
db.Commit();
db.Close();
db.Dispose();
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception("Erro atualizando o status :" + ex.ToString());
}
}
private static void StoreObjects(IObjectContainer container)
{
Random rnd = new Random();
for (int i = 0; i < 10000; i++)
{
container.Store(IndexedClass.Create(rnd));
}
}
private static void StoreALotOfObjects(IObjectContainer container)
{
Random rnd = new Random();
for (int i = 0; i < 10000; i++)
{
container.Store(new DataObject(rnd.Next()));
}
}
public static void CarSnapshotRollback(IObjectContainer db)
{
IObjectSet result = db.QueryByExample(new Car("BMW"));
Car car = (Car)result.Next();
car.Snapshot();
db.Store(car);
db.Rollback();
Console.WriteLine(car);
}
private static void StoreObjects(IObjectContainer container)
{
Random rnd = new Random();
for (int i = 0; i < 500000; i++)
{
container.Store(new DataObject(rnd));
}
container.Commit();
}
public Boolean alterarFuncionario(Funcionario objFuncionarioAlterar)
{
try
{
if (!temDuplicidade(objFuncionarioAlterar, "Alterar"))
{
db = ServidorSingleton.obterServidor().OpenClient();
Funcionario objFuncionarioProt = FactoryClasses.criarFuncionario();
objFuncionarioProt.Codigo = objFuncionarioAlterar.Codigo;
IObjectSet leitor = db.QueryByExample(objFuncionarioProt);
if (leitor.HasNext())
{
Funcionario objFuncionario = (Funcionario)leitor.Next();
//Atribui o cargo
IObjectSet leitorCargo = db.QueryByExample(objFuncionarioAlterar.Cargo);
if (leitorCargo.HasNext())
{
Cargo objCargo = (Cargo)leitorCargo.Next();
objFuncionario.Cargo = objCargo;
}
leitorCargo = null;
objFuncionario.DataAdmissao = objFuncionarioAlterar.DataAdmissao;
objFuncionario.DataDemissao = objFuncionarioAlterar.DataDemissao;
objFuncionario.Email = objFuncionarioAlterar.Email;
objFuncionario.Login = objFuncionarioAlterar.Login;
objFuncionario.Nome = objFuncionarioAlterar.Nome;
objFuncionario.Senha = objFuncionarioAlterar.Senha;
objFuncionario.Telefone = objFuncionarioAlterar.Telefone;
db.Store(objFuncionario);
db.Commit();
leitor = null;
return true;
}
else
{
leitor = null;
return false;
}
}
else
{
return false;
}
}
catch (Exception ex)
{
db.Rollback();
throw new Exception("Erro atualizando o funcionario :" + ex.ToString());
}
finally
{
db.Close();
db.Dispose();
}
}
protected override void Exercise(IObjectContainer db)
{
Assert.AreEqual(1, db.Query(typeof(ConcurrentRenameTestCase.QueryItem)).Count);
ConcurrentRenameTestCase.QueryItem newItem = new ConcurrentRenameTestCase.QueryItem
();
db.Store(newItem);
db.Commit();
db.Delete(newItem);
db.Commit();
}
public static void StoreCarAndSnapshots(IObjectContainer db)
{
Pilot pilot = new Pilot("Kimi Raikkonen", 110);
Car car = new Car("Ferrari");
car.Pilot = pilot;
for (int i = 0; i < 5; i++)
{
car.snapshot();
}
db.Store(car);
}
private void FragmentDatabase(IObjectContainer container)
{
var items = CreateItems();
for (var i = 0; i < items.Length; ++i)
{
container.Store(items[i]);
}
for (var i = 0; i < items.Length; i += 2)
{
container.Delete(items[i]);
}
}
public void AddProxyInfoToDb(ProxyAuthentication proxyAuthObj)
{
if (Db4oClient.RecentConnFile == null)
{
Db4oClient.RecentConnFile = Config.OMNConfigDatabasePath();
}
_proxyAuthObj = proxyAuthObj;
_container = Db4oClient.RecentConn;
ProxyAuthenticator proxyobj = ReturnProxyAuthenticationInfo();
if (proxyobj == null)
{
_container.Store(this);
}
else
{
proxyobj._proxyAuthObj = proxyAuthObj;
_container.Store(proxyobj);
}
_container.Commit();
_container.Ext().Refresh(proxyobj, 1);
}
private void Update(IEmbeddedConfiguration config)
{
IObjectContainer oc = Open(config);
IObjectSet objectSet = AllItems(oc);
while (objectSet.HasNext())
{
Item item = (Item)objectSet.Next();
item.Change();
oc.Store(item);
}
oc.Close();
}
public static void saveConfig(appConfig config)
{
IObjectContainer db = Db4oFactory.OpenFile(appConfig.configFilePath);
try
{
IList <appConfig> list = db.Query <appConfig>(typeof(appConfig));
if (list.Count <= 0)
{
db.Store(config);
}
else
{
appConfig.copy(config, list[0]);
db.Store(list[0]);
}
}
finally
{
db.Close();
}
}
private void Store(FieldsToTypeHandlerMigrationTestCase.Item item)
{
IObjectContainer db = OpenContainer();
try
{
db.Store(item);
}
finally
{
db.Close();
}
}
public static void Insert(Model.Compra compra)
{
IObjectContainer db = Db4oFactory.OpenFile(path + "\\Database.yap");
try
{
db.Store(compra);
}
finally
{
db.Close();
}
}
public static void UpdatePilotSeparateSessionsImprovedPart1()
{
IEmbeddedConfiguration config = Db4oEmbedded.NewConfiguration();
config.Common.ObjectClass(typeof(Car)).CascadeOnUpdate(true);
using (IObjectContainer db = Db4oEmbedded.OpenFile(config, YapFileName))
{
IObjectSet result = db.QueryByExample(new Car("Ferrari"));
Car found = (Car)result.Next();
found.Pilot.AddPoints(1);
db.Store(found);
}
}
private static void UseThePool(ConnectionPool connectionPool)
{
IObjectContainer session = connectionPool.Acquire();
try
{
session.Store(new Person("Joe"));
}
finally
{
connectionPool.CloseAndRelease(session);
}
}
public void AddProxyInfoToDb(ProxyAuthentication proxyAuthObj)
{
if (Db4oClient.RecentConnFile == null)
{
Db4oClient.RecentConnFile = Config.OMNConfigDatabasePath();
}
_proxyAuthObj = proxyAuthObj;
_container = Db4oClient.RecentConn;
ProxyAuthenticator proxyobj = ReturnProxyAuthenticationInfo();
if (proxyobj == null)
{
_container.Store(this);
}
else
{
proxyobj._proxyAuthObj = proxyAuthObj;
_container.Store(proxyobj);
}
_container.Commit();
_container.Ext().Refresh(proxyobj, 1);
}
public static void IndividualUUID()
{
// #example: Enable db4o uuids for certain classes
IEmbeddedConfiguration configuration = Db4oEmbedded.NewConfiguration();
configuration.File.GenerateUUIDs = ConfigScope.Individually;
configuration.Common.ObjectClass(typeof(SpecialClass)).GenerateUUIDs(true);
// #end example
IObjectContainer container = Db4oEmbedded.OpenFile(configuration, "database.db4o");
SpecialClass withUUID = new SpecialClass();
container.Store(withUUID);
NormalClass withoutUUID = new NormalClass();
container.Store(withoutUUID);
AssertNotNull(container.Ext().GetObjectInfo(withUUID).GetUUID());
AssertNull(container.Ext().GetObjectInfo(withoutUUID).GetUUID());
container.Close();
}
private static void MigrationOnTheFly()
{
DeleteDatabases();
IObjectContainer desktopDatabaseWithoutUUID = Db4oEmbedded.OpenFile(DesktopDatabaseName);
desktopDatabaseWithoutUUID.Store(new Car(new Pilot("Max"), "Max's Car"));
desktopDatabaseWithoutUUID.Store(new Car(new Pilot("Joe"), "Joe's Car"));
desktopDatabaseWithoutUUID.Commit();
desktopDatabaseWithoutUUID.Close();
IObjectContainer desktopDatabase = OpenDatabase(DesktopDatabaseName);
IObjectContainer mobileDatabase = OpenDatabase(MobileDatabaseName);
IReplicationProvider desktopRelicationPartner
= new Db4oEmbeddedReplicationProvider(desktopDatabase);
IReplicationProvider mobileRelicationPartner
= new Db4oEmbeddedReplicationProvider(mobileDatabase);
// #example: Migrate on the fly
IReplicationSession replicationSession = Replication.Begin(desktopRelicationPartner, mobileRelicationPartner);
IList <Car> initialReplication = desktopDatabase.Query <Car>();
foreach (Car changedObjectOnDesktop in initialReplication)
{
IObjectInfo infoAboutObject = desktopDatabase.Ext().GetObjectInfo(changedObjectOnDesktop);
if (null == infoAboutObject.GetUUID())
{
desktopDatabase.Ext().Store(changedObjectOnDesktop, 2);
}
replicationSession.Replicate(changedObjectOnDesktop);
}
replicationSession.Commit();
// #end example
PrintCars(mobileDatabase);
CloseDBs(desktopDatabase, mobileDatabase);
}
private void CreateDatabaseInOlderVersion()
{
_logger.LogMessage("Creating database ({0}) at version {1}.)", DATABASE_PATH, Db4oVersion.Name);
NullableHolder <bool> obj = new NullableHolder <bool>(new bool?[] { true, false, null, false, true });
using (IObjectContainer container = Db4oFactory.OpenFile(DATABASE_PATH))
{
container.Store(obj);
}
_logger.LogMessage("Object {0} added to database.", obj.ToString());
}
private static void RefreshAfterRollback(IObjectContainer container)
{
// #example: Refresh objects after rollback
Pilot pilot = container.Query<Pilot>()[0];
pilot.Name = "New Name";
container.Store(pilot);
container.Rollback();
// use refresh to return the in memory objects back
// to the state in the database.
container.Ext().Refresh(pilot, int.MaxValue);
// #end example
}
//store
private void UpdateItem()
{
IObjectContainer client = OpenClient();
IQuery query = client.Query();
query.Constrain(typeof(CsSchemaMigrationSourceCode.Item));
CsSchemaMigrationSourceCode.Item item = (CsSchemaMigrationSourceCode.Item)query.Execute
().Next();
//update
//assert
client.Store(item);
client.Close();
}
//Function to store Detail Transaction
private void storeDetailTransaction(string ht, string shoeid, int qty)
{
DB = Db4oFactory.OpenFile("Detail Transaction.yap");
DetailTransaction dt = new DetailTransaction()
{
ShoeID = shoeid,
HeaderTransactionID = ht,
Quantity = qty
};
DB.Store(dt);
DB.Close();
}
private void CreateDatabase(string fileName)
{
IObjectContainer db = Db4oEmbedded.OpenFile(Config(), fileName);
Collection4 removed = new Collection4();
for (int idx = 0; idx < NumItemsPerClass; idx++)
{
RepeatDeleteReaddTestCase.ItemA itemA = new RepeatDeleteReaddTestCase.ItemA(idx);
RepeatDeleteReaddTestCase.ItemB itemB = new RepeatDeleteReaddTestCase.ItemB(FillStr
('x', idx));
db.Store(itemA);
db.Store(itemB);
if ((idx % DeleteRatio) == 0)
{
removed.Add(itemA);
removed.Add(itemB);
}
}
db.Commit();
DeleteAndReadd(db, removed);
db.Close();
}
//Function to store Header Transaction
private void storeHeaderTransaction()
{
DB = Db4oFactory.OpenFile("Header Transaction.yap");
HeaderTransaction ht = new HeaderTransaction()
{
HeaderTransactionID = genereateHeaderID(),
UserId = currentUser.ID.ToString()
};
currHT = ht;
DB.Store(ht);
DB.Close();
}
protected void Discard_Document_Click(object sender, EventArgs e)
{
string docname;
float versionOfDoc;
string reasonToDiscard;
System.Web.HttpContext context = System.Web.HttpContext.Current;
string docname_versionOfDoc = (String)context.Session["docNameVersionNo"];
List <String> compare = new List <string>();
compare = docname_versionOfDoc.Split(':').ToList();
docname = compare[0];
versionOfDoc = float.Parse(compare[1]);
string username = (string)Session["UserName"];
reasonToDiscard = Textuser.Text;
if (reasonToDiscard.Equals(""))
{
reasonToDiscard = "Reason to discard is not specified";
}
else
{
}
try
{
Config path = new Config();
DB = Db4oFactory.OpenFile(path.addressOfDocument);
IObjectSet result = DB.QueryByExample(new Document_model(docname, versionOfDoc));
Document_model docmodel = (Document_model)result.Next();
DB.Delete(docmodel);
DB.Close();
Discarded_Document_model document_fragment_model = new Discarded_Document_model()
{
ReasonToDiscard = reasonToDiscard,
DocumentTitle = docname,
DocumentVersion = versionOfDoc,
NameOfReviever = username
};
DB = Db4oFactory.OpenFile(path.addressOfDiscardedDocument);
DB.Store(document_fragment_model);
DB.Close();
Page.RegisterStartupScript("Alert&Redirect", "<script>alert('Document Discarded Sucessfully'); location.href='./Document_page.aspx';</script>");
}
catch
{
}
}
private static void AddPerson()
{
List <Phone> kontakty = new List <Phone>();
Console.WriteLine("Podaj imie:");
var imie = Console.ReadLine();
Console.WriteLine("Podaj nazwisko:");
var nazwisko = Console.ReadLine();
Console.WriteLine("Czy chcesz dodać adres? [t/n]");
var choice = Console.ReadLine();
Address adres = null;
if (choice.ToLower() == "t")
{
Console.WriteLine("Podaj ulicę:");
var ulica = Console.ReadLine();
Console.WriteLine("Podaj kod pocztowy:");
var kod = Console.ReadLine();
Console.WriteLine("Podaj miasto:");
var miasto = Console.ReadLine();
adres = new Address {
Street = ulica, PostalCode = kod, City = miasto
};
}
Console.WriteLine("czy chcesz dodać telefon? [t/n]");
choice = Console.ReadLine();
while (choice.ToLower() == "t")
{
Console.WriteLine("Podaj numer:");
var numer = Console.ReadLine();
Console.WriteLine("Podaj operatora:");
var operatr = Console.ReadLine();
Console.WriteLine("Podaj rodzaj:");
var rodzaj = Console.ReadLine();
kontakty.Add(new Phone {
Number = numer, Provider = operatr, Type = rodzaj
});
Console.WriteLine("czy chcesz dodać kolejny telefon? [t/n]");
choice = Console.ReadLine();
}
Person osoba = new Person {
Name = imie, Lastname = nazwisko, Adress = adres, Contacts = kontakty
};
using (IObjectContainer db = Db4oEmbedded.OpenFile("baza.txt"))
{
db.Store(osoba);
}
}
public override System.Threading.Tasks.Task OnConnected()
{
string databasePath = System.Web.Hosting.HostingEnvironment.MapPath(@"~\ObjectDatabase\support.db4o");
string userID = Context.User.Identity.GetUserId();
bool isSupport = Context.User.IsInRole("Support");
using (IObjectContainer container = Db4oEmbedded.OpenFile(databasePath))
{
IEnumerable <ChatUser> users = from ChatUser user in container where user.UserID == userID select user;
if (users.Count() == 0)
{
container.Store(new ChatUser {
UserID = userID, IsSupport = isSupport, HubUserID = Context.ConnectionId
});
}
else
{
ChatUser temp = users.First();
temp.HubUserID = Context.ConnectionId;
container.Store(temp);
}
if (isSupport)
{
var conversations = from Conversation c in container where c.SupportUserID == null select c;
if (conversations.Count() > 0)
{
Conversation c = conversations.First();
c.SupportUserID = userID;
c.HubSupportUserID = Context.ConnectionId;
c.StartDate = DateTime.Now;
container.Store(c);
Clients.Client(c.HubUserID).Notify("User '" + HttpContext.Current.User.Identity.GetUserName() + "' will assist you.");
Clients.Client(Context.ConnectionId).Notify("You will be helping the user '" + c.UserName + "'");
}
}
}
return(base.OnConnected());
}
private void button1_Click(object sender, EventArgs e)
{
IObjectContainer db = Db4oEmbedded.OpenFile("EmployeeManager3.yap");
if (double.Parse(textBox4.Text) < 300)
{
MessageBox.Show("Lỗi nhập liệu", "Lỗi");
}
else
{
var employee = new Employee(textBox1.Text, textBox2.Text, (Company)this.comboBox1.SelectedItem, double.Parse(textBox4.Text));
db.Store(employee);
var pilot1 = new Company
{
CompanyName = comboBox1.Text,
};
IObjectSet result = db.QueryByExample(pilot1);
int a = result.Count;
Company p2 = (Company)result[0];
Company p = (Company)result[1];
var pilot2 = new Employee
{
FullName = textBox1.Text,
};
IObjectSet result1 = db.QueryByExample(pilot2);
Employee p1 = (Employee)result1[0];
p1.HomeBase = p2;
db.Store(p1);
db.Delete(p);
db.Close();
getdata();
}
}
private void button1_Click(object sender, EventArgs e)
{
IObjectContainer db = Db4oEmbedded.OpenFile("ADBTeamTPTPT_EmployeeManage.yap");
CongTy add = new CongTy(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text);
db.Store(add);
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
db.Close();
}
private static void StoreExampleObjects()
{
using (IObjectContainer container = Db4oEmbedded.OpenFile(DatabaseFileName))
{
var beetle = new Car("VW Beetle");
var ferrari = new Car("Ferrari");
var driver = new Driver("John", ferrari);
driver.AddOwnedCar(beetle);
driver.AddOwnedCar(ferrari);
container.Store(driver);
}
}
// #end example
// #example: Grab the lock protecting the data
private void UpdateSomePeople(IObjectContainer container)
{
lock (dataLock)
{
var people = from Person p in container
where p.Name.Equals("Joe")
select p;
foreach (Person joe in people)
{
joe.Name = "New Joe";
container.Store(joe);
}
}
}
public void NowGhostCommits()
{
IObjectContainer container1 = toTest.Acquire();
container1.Store(new AStoredObject());
toTest.Release(container1);
IObjectContainer container2 = toTest.Acquire();
container2.Commit();
int countStoredObjects = server.OpenClient().Query <AStoredObject>().Count;
Assert.AreEqual(1, countStoredObjects);
}
public static void UpdateCar()
{
IEmbeddedConfiguration config = Db4oEmbedded.NewConfiguration();
config.Common.ObjectClass(typeof(Car)).CascadeOnUpdate(true);
using (IObjectContainer db = Db4oEmbedded.OpenFile(config, YapFileName))
{
var result = db.QueryByExample(new Car("BMW", null));
Car car = result.Next();
car.Snapshot();
db.Store(car);
RetrieveAllSensorReadout(db);
}
}
private void Store(string databaseFileName, object obj)
{
IObjectContainer db = Db4oEmbedded.OpenFile(Db4oEmbedded.NewConfiguration(), databaseFileName
);
try
{
db.Store(obj);
}
finally
{
db.Close();
}
}
// #end example
// #example: Grab the lock protecting the data
private void UpdateSomePeople(IObjectContainer container)
{
lock (dataLock)
{
var people = from Person p in container
where p.Name.Equals("Joe")
select p;
foreach (Person joe in people)
{
joe.Name = "New Joe";
container.Store(joe);
}
}
}
public virtual void TestOpenWithStaticConfiguration()
{
Db4oFactory.Configure().ReadOnly(true);
Assert.Expect(typeof(DatabaseReadOnlyException), new _ICodeBlock_53(this));
Db4oFactory.Configure().ReadOnly(false);
IObjectContainer db = Db4oFactory.OpenFile(TempFile());
db.Store(new GlobalVsNonStaticConfigurationTestCase.Data(1));
db.Close();
db = Db4oFactory.OpenFile(TempFile());
Assert.AreEqual(1, db.Query(typeof(GlobalVsNonStaticConfigurationTestCase.Data)).
Count);
db.Close();
}
private void Prepare()
{
Sharpen.IO.File file = new Sharpen.IO.File(TempFile());
if (file.Exists())
{
file.Delete();
}
IObjectContainer testDB = OpenDB();
DefragEncryptedFileTestCase.Item item = new DefragEncryptedFileTestCase.Item("richard"
, 100);
testDB.Store(item);
testDB.Close();
}
private void EditInfoSaveClick(object sender, EventArgs e)
{
IEnumerable <Person> localUser = from Person p in _db
where
p.UserName == _user.UserName
select p;
localUser.First().Name = nameBox.Text;
localUser.First().Surname = surnameBox.Text;
localUser.First().BirthDay = birthDayBox.Text;
localUser.First().Phone = phoneBox.Text;
localUser.First().City = cityComboBox.Text;
localUser.First().Addres = addressBox.Text;
var firstOrDefault = editInfo.Controls.OfType <RadioButton>().FirstOrDefault(r => r.Checked);
if (firstOrDefault != null)
{
localUser.First().Gender = firstOrDefault.Text;
}
_db.Store(localUser.First());
UpdateUser(localUser.First());
MessageBox.Show("Saved Succesfully");
}
void AddToolStripMenuItemClick(object sender, EventArgs e)
{
AddDialog dlg = new AddDialog();
if (dlg.ShowDialog() == DialogResult.OK)
{
IObjectContainer db = DBConnection.Instance.DB;
IObjectSet result = db.QueryByExample(new ItemType(dlg.TypeBox.Text));
ItemType item = (ItemType)result.Next();
DateTime data = dlg.BuyDatePicker.Value;
db.Store(new Item(item, dlg.TitleBox.Text, data, data, false, (float)dlg.Price.Value, dlg.PlaceBox.Text));
this.refreshItems();
}
}
private void Populate(IObjectContainer container)
{
for (int i = 0; i < 10; i++)
{
container.Store(new CrashSimulatingTestSuite.Item("delme"));
}
CrashSimulatingTestSuite.CrashData one = new CrashSimulatingTestSuite.CrashData(null
, "one");
CrashSimulatingTestSuite.CrashData two = new CrashSimulatingTestSuite.CrashData(one
, "two");
CrashSimulatingTestSuite.CrashData three = new CrashSimulatingTestSuite.CrashData
(one, "three");
container.Store(one);
container.Store(two);
container.Store(three);
container.Commit();
IObjectSet objectSet = container.Query(typeof(CrashSimulatingTestSuite.Item));
while (objectSet.HasNext())
{
container.Delete(objectSet.Next());
}
}
private void btInserir_Click(object sender, EventArgs e)
{
try
{
if (String.IsNullOrEmpty(tbCodigo.Text) || String.IsNullOrEmpty(tbNome.Text) ||
String.IsNullOrEmpty(tbProfissao.Text))
{
MessageBox.Show("Preencha todos os campos corretamente.");
return;
}
Usuarios user = new Usuarios();
int id = Convert.ToInt32(tbCodigo.Text);
string nome = tbNome.Text;
string profissao = tbProfissao.Text;
user.id = id;
user.nome = nome;
user.profissao = profissao;
if (VerificaID(user.id))
{
MessageBox.Show("Conta com ID ja existe..", "Erro");
return;
}
int id_ajustado = ajustaID(user);
user.id = id_ajustado;
tbCodigo.Text = id_ajustado.ToString();
// SE ESTIVER TUDO TRANQUILO...
banco.Store(user);
table.Rows.Add(id_ajustado, nome, profissao);
dataGridView.DataSource = table;
//banco.Close();
}
catch (FormatException ex)
{
MessageBox.Show("Digite apenas números..", "Erro");
return;
}catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erro");
return;
}
}
