public Task GetTask (int id)
{
using(var database = new SQLiteConnection(_helper.WritableDatabase.Path))
{
return database.Get<Task>(id);
}
}
public void zmienObrazek(int id, byte[] obrazek)
{
TabelaPrzepisy prze = conn.Get <TabelaPrzepisy> (id);
prze.Obrazek = obrazek;
conn.Update(prze);
przeladujPrzepisy();
}
// code to retrieve speicif record using ORM
public string GetTaskById( int id)
{
string dbPath = Path.Combine(Environment.GetFolderPath
(Environment.SpecialFolder.Personal), "ormdemo.db3");
var db = new SQLiteConnection(dbPath);
var item = db.Get<ToDoTasks>(id);
return item.Task;
}
//NEEDS WORK
//This function returns an event table based on id
public EventInfo GetEventById(int id)
{
string dbPath = Path.Combine (Environment.GetFolderPath (Environment.SpecialFolder.Personal), "AutomatechORM.db3");
var db = new SQLiteConnection (dbPath);
var table = db.Table<EventInfo> ();
var item = db.Get<EventInfo> (id);
return item;
}
public ResponseStatus UpdateProgress(int movieId, StatusType newStatus)
{
using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.DB_PATH))
{
var movie = conn.Get <ApiMovie>(movieId);
movie.Status = newStatus;
int nb = conn.Update(movie);
return(nb > 0 ? ResponseStatus.OK : ResponseStatus.NOT_OK);
}
}
public static Beacons GetBeacon(int id)
{
try
{
var db = new SQLiteConnection(dbPath);
return db.Get<Beacons>(id);
}
catch
{
return null;
}
}
public void makeavail()
{
Model.Userdata userd = new Model.Userdata();
var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "App.db");
var db = new SQLiteConnection( new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
var result = db.Get<Model.Userdata>(1);
test.Text = "Hello" + result.getName();
}
public static string Get ()
{
var output = "";
output += "\nGet query example: ";
string dbPath = Path.Combine (
Environment.GetFolderPath (Environment.SpecialFolder.Personal), "ormdemo.db3");
var db = new SQLiteConnection (dbPath);
var returned = db.Get<Stock>(2);
return output;
}
public bool LogIn(AccountDB account)
{
using (var dbConnection = new SQLiteConnection(_dbUnitAndroidPrinterApp))
{
try
{
dbConnection.Get<AccountDB>(x => x.Login == account.Login && x.Password == account.Password);
return true;
}
catch(Exception)
{
return false;
}
}
}
public override void LoadSettingAsync()
{
using (var conn = new SQLite.SQLiteConnection(DBSettingPath))
{
conn.CreateTable <AppSettings>();
if (conn.Table <AppSettings>().Count() == 0)
{
return;
}
var res = conn.Get <AppSettings>(1);
foreach (PropertyInfo property in typeof(AppSettings).GetProperties())
{
if (property.CanWrite)
{
property.SetValue(this, property.GetValue(res, null), null);
}
}
}
}
public void SaveNoteOldDate(int Id, string title, string note)
{
try
{
using (var conn = new SQLite.SQLiteConnection(System.IO.Path.Combine(folder, databaseName)))
{
Note myNote = conn.Get <Note>(p => p.Id.Equals(Id));
DateTime myTime = myNote.Time;
Note myNote1 = new Note {
Id = Id, Title = title, Description = note, Time = myTime
};
var query = conn.Update(myNote1);
}
}
catch (Exception ex)
{
Console.WriteLine("Error: " + ex.Message);
}
}
//REAL
static public string GetAccount()
{
//var testAccount = new AccountProfile { Email = "Emeri", Password = "******", PreferenceID = 2 };
using (var db = new SQLite.SQLiteConnection(accountDBPath))
{
var stock = db.Get <AccountProfile>(1);
return(Convert.ToString(stock.Email));
}
//string Ee = "empty";
//try
//{
//var query = conn.Table<Account>().Where(v => v.Email.StartsWith("E"));
//query.ToListAsync().ContinueWith(t3 =>
//{
// foreach (var testAccount in t3.Result) Ee = testAccount.Email; //Console.WriteLine("Stock: " + testAccount.Email);
//});
//return Ee;
//}
//catch (Exception e) { var k = e.Message; }
//return Ee;
}
//-----------sets the tag in the user.cs for further utilization in the application---------//
protected void settingTags()
{
using (var connection = new SQLiteConnection (dbPath)) {
var rowCount = connection.Table<User> ().Count ();
var presentUser = connection.Get<User> (1);
if (rowCount <= 2) {
//presentUser.Persons = persons;
connection.Update (presentUser);
//var Users = connection.Query<User>("UPDATE User SET Persons = ? WHERE ID = 1", persons);
Log.Info (Tag, "User Data Updated");
}
}
}
/// <summary>
/// Loads an AnimationInfo object from the database
/// </summary>
/// <returns>An AnimationInfo object</returns>
/// <param name="idStepNumber">A Pair containing the animation's MessageID and StepNumber. Set to null to return the currently editing animation.</param>
public AnimationInfo LoadAnimation(Pair<string, int> idStepNumber)
{
lock (this.dbLock)
{
using (SQLiteConnection sqlCon = new SQLiteConnection(this.AnimationDBPath))
{
sqlCon.Execute(WZConstants.DBClauseSyncOff);
AnimationInfo animationInfo = null;
if (null == idStepNumber)
{
animationInfo =
sqlCon.Query<AnimationInfo>("SELECT * FROM AnimationInfo WHERE IsEditing=?", true)
.FirstOrDefault();
} else
{
animationInfo =
sqlCon.Query<AnimationInfo>("SELECT * FROM AnimationInfo WHERE MessageGuid=? AND StepNumber=?",
idStepNumber.ItemA, idStepNumber.ItemB)
.FirstOrDefault();
}//end if else
if (null == animationInfo)
{
return null;
} else
{
List<FrameInfo> frameItems =
sqlCon.Query<FrameInfo>("SELECT * FROM FrameInfo WHERE AnimationDBID=?", animationInfo.DBID);
foreach (FrameInfo eachFrameInfo in frameItems)
{
List<LayerInfo> layerItems =
sqlCon.Query<LayerInfo>("SELECT * FROM LayerInfo WHERE FrameDBID=?", eachFrameInfo.DBID);
foreach (LayerInfo eachLayerItem in layerItems)
{
List<DrawingInfo> drItems =
sqlCon.Query<DrawingInfo>("SELECT * FROM DrawingInfo WHERE LayerDBID=?", eachLayerItem.DBID);
foreach (DrawingInfo eachDrInfo in drItems)
{
if (eachDrInfo.BrushItemDBID > 0)
{
eachDrInfo.Brush =
sqlCon.Get<BrushItem>(eachDrInfo.BrushItemDBID);
}//end if
if (eachDrInfo.DrawingType == DrawingLayerType.Drawing)
{
List<PathPointDB> pathPoints =
sqlCon.Query<PathPointDB>("SELECT * FROM PathPointDB WHERE DrawingInfoDBID=? " +
"ORDER BY SortOrder", eachDrInfo.DBID);
eachDrInfo.SetPathPointsFromDB(pathPoints);
}//end if
eachLayerItem.DrawingItems [eachDrInfo.DrawingID] = eachDrInfo;
}//end foreach
List<TransitionInfo> transitions =
sqlCon.Query<TransitionInfo>("SELECT * FROM TransitionInfo WHERE LayerDBID=?", eachLayerItem.DBID);
foreach (TransitionInfo eachTrInfo in transitions)
{
List<TransitionEffectSettings> efSettings =
sqlCon.Query<TransitionEffectSettings>("SELECT * FROM TransitionEffectSettings WHERE TransitionInfoDBID=?", eachTrInfo.DBID);
foreach (TransitionEffectSettings eachEfSetting in efSettings)
{
eachTrInfo.Settings [eachEfSetting.EffectType] = eachEfSetting;
}//end foreach
eachLayerItem.Transitions [eachTrInfo.ID] = eachTrInfo;
}//end foreach
eachFrameInfo.Layers [eachLayerItem.ID] = eachLayerItem;
}//end foreach
animationInfo.FrameItems [eachFrameInfo.ID] = eachFrameInfo;
List<AnimationAudioInfo> frameAudioItems =
sqlCon.Query<AnimationAudioInfo>("SELECT * FROM AnimationAudioInfo WHERE FrameDBID=?", eachFrameInfo.DBID);
foreach (AnimationAudioInfo eachAudioInfo in frameAudioItems)
{
animationInfo.AudioItems [eachAudioInfo.ID] = eachAudioInfo;
}//end foreach
}//end foreach
return animationInfo;
}//end if else
}//end using sqlCon
}//end lock
}
// Update a Beacon
public static int UpdateBeacon(int bID, string Name, string Longitude, string Latitude, double Distance)
{
try
{
var db = new SQLiteConnection(dbPath);
//Get Beacon to update
var Beacon = db.Get<Beacons>(bID);
//Assign new values to the Beacon
Beacon.bName = Name;
Beacon.bLatitude = Latitude;
Beacon.bLongitude = Longitude;
Beacon.bDistance = Distance;
//Update Beacon
var result = db.Update(Beacon);
return result;
}
catch (Exception exc)
{
return -1;
}
}
/************************************************|
* DEFINING METHODS |
* |
* |
*************************************************/
//--------------retrieving user data and storing in variables---------------//
private void RetrieveDatafromDB()
{
using (var connection = new SQLiteConnection(dbPath)) {
var User = connection.Get<User> (1);
existingJourney = User.ExistingJourney;
}
}
//USER CHECK LOGIN
public bool user_Check(string user_AndsoftUserTEXT,string user_PasswordTEXT)
{
string dbPath = System.IO.Path.Combine(Environment.GetFolderPath
(Environment.SpecialFolder.Personal), "ormDMS.db3");
var db = new SQLiteConnection(dbPath);
bool output = false;
var query = db.Table<TableUser>().Where (v => v.user_AndsoftUser.Equals(user_AndsoftUserTEXT)).Where (v => v.user_Password.Equals(user_PasswordTEXT));
foreach (var item in query) {
output = true;
var row = db.Get<TableUser> (item.Id);
row.user_IsLogin = true;
db.Update(row);
Console.WriteLine ("UPDATE GOOD" + row.user_IsLogin);
}
return output;
}
//NEEDS INTERGRATION
//This function removes an event based on id
public string RemoveEvent(int id)
{
string dbPath = Path.Combine (Environment.GetFolderPath (Environment.SpecialFolder.Personal), "AutomatechORM.db3");
var db = new SQLiteConnection (dbPath);
var item = db.Get<EventInfo> (id);
item.access = 0;
return "Record Deleted...";
}
public int GetidNext (int id)
{
string dbPath = System.IO.Path.Combine(Environment.GetFolderPath
(Environment.SpecialFolder.Personal), "ormDMS.db3");
var db = new SQLiteConnection(dbPath);
int idnext;
//get int ordremission
var item = db.Get<TablePositions>(id);
idnext = (item.Ordremission)+ 1;
var query = db.Table<TablePositions>().Where (v => v.Ordremission.Equals(idnext));
//getordremission -1
foreach (var row in query) {
idnext = row.Id;
}
if (idnext < 0) {
idnext = 0;
}
return idnext;
}
public string updateposimgpath (int i, string path)
{
string dbPath = System.IO.Path.Combine(Environment.GetFolderPath
(Environment.SpecialFolder.Personal), "ormDMS.db3");
var db = new SQLiteConnection(dbPath);
string output = "";
var row = db.Get<TablePositions>(i);
row.imgpath = path;
db.Update(row);
output = "UPDATE POSITIONS " + row.Id;
return output;
}
private void HandleClickGetInfo(object sender, EventArgs e)
{
HideKeyboard();
try
{
using (var dbConnection = new SQLiteConnection(mDBUnitAndroidPrinterApp))
{
m_deviceInfoDB = dbConnection.Get<PrinterEntryDB>(
x => x.DeviceSerialNum.ToLower() == mSerialKey.Text.ToLower());
}
}
catch (Exception)
{
m_deviceInfoDB = new PrinterEntryDB()
{
AddressStr = string.Empty,
ContractorStr = string.Empty,
ContractStr = string.Empty,
DescrStr = string.Empty,
DeviceId = -1,
DeviceSerialNum = string.Empty,
DeviceStr = string.Empty
};
}
ViewFillForm(m_deviceInfoDB);
}
public static void Main (string[] args)
{
Console.WriteLine ("Hello SQLite-net Data!");
/*
//Get the path to the folder where the database is stored.
// Notes: The Path class performs operations on strings that contain file path info
// Path.Combine appends the second path to the first path
// Environment.GetSpecialFolderPath gets the path to special pre-defined folders
// on Windows, the SpecialFolder enum defines: ProgramFiles, System, AppData, etc.
// on Android ...
string dbPath = Path.Combine (
Environment.GetFolderPath (Environment.SpecialFolder.Personal), "stocks.db3");
*/
/*
// Check for an existing db file and only create a new one if it doesn't exist
bool exists = File.Exists (dbPath);
if (!exists) {
// Need to create the database and seed it with some data.
SQLiteConnection.CreateFile (dbPath);
*/
// We're using a file in Assets instead of the one defined above
//string dbPath = Directory.GetCurrentDirectory ();
string dbPath = @"../../../DataAccess-Android/Assets/stocks.db3";
var db = new SQLiteConnection (dbPath);
// Create a Stocks table
//if (db.CreateTable (Mono.CSharp.TypeOf(Stock)) != 0)
db.DropTable<Stock>();
if (db.CreateTable<Stock>() == 0)
{
// A table already exixts, delete any data it contains
db.DeleteAll<Stock> ();
}
// Create a new stock and insert it into the database
var newStock = new Stock ();
newStock.Symbol = "APPL";
newStock.Name = "Apple";
newStock.ClosingPrice = 93.22m;
int numRows = db.Insert (newStock);
Console.WriteLine ("Number of rows inserted = {0}", numRows);
// Insert some more stocks
db.Insert(new Stock() {Symbol = "MSFT", Name = "Microsoft", ClosingPrice = 55.25m});
db.Insert (new Stock() {Symbol = "GOOG", Name = "Google", ClosingPrice = 15.25m});
db.Insert (new Stock() {Symbol = "SSNLF", Name = "Samsung", ClosingPrice = 25.25m});
db.Insert (new Stock() {Symbol = "AMZN", Name = "Amazon", ClosingPrice = 35.25m});
db.Insert (new Stock() {Symbol = "MMI", Name = "Motorola Mobility", ClosingPrice = 45.25m});
db.Insert (new Stock() {Symbol = "FB", Name = "Facebook", ClosingPrice = 65.25m});
// Read the stock from the database
// Use the Get method with a query expression
Stock singleItem = db.Get<Stock> (x => x.Name == "Google");
Console.WriteLine ("Stock Symbol for Google: {0}", singleItem.Symbol);
singleItem = db.Get<Stock> (x => x.ClosingPrice >= 30.0m);
Console.WriteLine ("First stock priced at or over 30: {0}, price: {1}",
singleItem.Symbol, singleItem.ClosingPrice);
// Use the Get method with a primary key
singleItem = db.Get<Stock> ("FB");
Console.WriteLine ("Stock Name for Symbol FB: {0}", singleItem.Symbol);
// Query using SQL
var stocksStartingWithA = db.Query<Stock> ("SELECT * FROM Stocks WHERE Symbol LIKE ?", "A%");
foreach(Stock stock in stocksStartingWithA)
Console.WriteLine ("Stock starting with A: {0}", stock.Symbol);
// Query using Linq
var stocksStartingWithM = from s in db.Table<Stock> () where s.Symbol.StartsWith ("M") select s;
foreach(Stock stock in stocksStartingWithM)
Console.WriteLine ("Stock starting with M: {0}", stock.Symbol);
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate (savedInstanceState);
SetContentView (Resource.Layout.JourneyPreview);
inflater = (LayoutInflater)this.GetSystemService (Context.LayoutInflaterService);
for (int i = 0; i < isUnfold.Length; i++) {
isUnfold [i] = false;
}
TstartingDate = (TextView)FindViewById (Resource.Id.StartingDate);
TendDate = (TextView)FindViewById (Resource.Id.EndDate);
newSearchButton = (Button)FindViewById (Resource.Id.NewSearchButton);
backToMenuBtn = (Button)FindViewById (Resource.Id.BackToMenu);
backToNewJourneyBtn = (Button)FindViewById (Resource.Id.BackToNewJourney);
finishPreviewBtn = (Button)FindViewById (Resource.Id.FinishPreviewButton);
scrollViewMain = (LinearLayout)FindViewById (Resource.Id.ScrollViewMain);
RetrieveDatafromDB ();
TstartingDate.Text = "Start: " + startingDate;
TendDate.Text = "Ende: " + endDate;
/************************************************|
* INVOKING METHODS |
* |
* |
*************************************************/
// drawing the necessary amount of destinations
// draw also sets the event listeners for every button
if (!hasStarted) {
draw ();
hasStarted = true;
}
newSearchButton.Click += delegate {
StartActivity(typeof(JourneyPreview));
Finish();
};
backToMenuBtn.Click += delegate {
StartActivity(typeof(GowlMain));
Finish();
};
backToNewJourneyBtn.Click += delegate {
StartActivity(typeof(NewJourneySpecificPreference));
Finish();
};
finishPreviewBtn.Click += delegate {
using (var connection = new SQLiteConnection(dbPath)) {
var currUser = connection.Get<User> (1);
currUser.ExistingJourney = true;
connection.Update(currUser);
}
StartActivity(typeof(GowlMain));
Finish();
};
}
//-----------sets the tag in the user.cs for further utilization in the application---------//
protected void settingTags()
{
using (var connection = new SQLiteConnection (dbPath)) {
var rowCount = connection.Table<User> ().Count ();
var presentUser = connection.Get<User> (1);
Log.Info (Tag, "rowCount: " + rowCount.ToString ());
if (rowCount > 2) {
Log.Info (Tag, "Database cleared");
for (int i = rowCount; i > 0-1; i--) {
var del = connection.Delete<User> (i);
//var deleted = connection.Query<User> ("DELETE FROM User WHERE ID = ?", i);
Log.Info (Tag, "for loop i: " + i.ToString ());
Log.Info (Tag, "Rows deleted: " + del.ToString ());
}
}
rowCount = connection.Table<User> ().Count ();
if (rowCount <= 2) {
presentUser.VacationTarget = vacationTarget;
connection.Update (presentUser);
//var Users = connection.Query<User>("UPDATE User SET Persons = ? WHERE ID = 1", persons);
Log.Info (Tag, "User Data Updated");
}
}
}
public string updatePosition (int idposition,string statut, string txtAnomalie, string txtRemarque, string codeAnomalie, string imgpath)
{
string dbPath = System.IO.Path.Combine(Environment.GetFolderPath
(Environment.SpecialFolder.Personal), "ormDMS.db3");
var db = new SQLiteConnection(dbPath);
string output = "";
var row = db.Get<TablePositions>(idposition);
row.StatutLivraison = statut;
db.Update(row);
output = "UPDATE POSITIONS " + row.Id;
return output;
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate (savedInstanceState);
RetrieveDatafromDB ();
//existingJourney = true;
if (existingJourney == false) {
SetContentView (Resource.Layout.Main);
newJourneyBtn = (Button)FindViewById (Resource.Id.NewJourneyButton);
userDataBtn = (Button)FindViewById (Resource.Id.UserDataButton);
backUserDataBtn = (Button)FindViewById (Resource.Id.backButtonUserData);
resetBtn = (Button)FindViewById (Resource.Id.NewMainPreferences);
flipper = (ViewFlipper)FindViewById (Resource.Id.viewFlipper1);
Menu ();
}
if (existingJourney == true) {
SetContentView (Resource.Layout.ExistingJourney);
Log.Info (Tag, "existing Journey false");
voiceResultText = (TextView)FindViewById (Resource.Id.VoiceResultText);
speechListener = (Button)FindViewById (Resource.Id.voiceButton);
speechListener.Click += RecordVoice;
newComJourneyBtn = (Button)FindViewById (Resource.Id.ExistingNewJourney);
existingMainMenu = (Button)FindViewById (Resource.Id.ExistingMainMenu);
existingMainMenu.Click += delegate {
using (var connection = new SQLiteConnection(dbPath)) {
var User = connection.Get<User> (1);
User.ExistingJourney = false;
connection.Update(User);
StartActivity (typeof(GowlMain));
Finish();
}
};
newComJourneyBtn.Click += delegate {
StartActivity(typeof(NewJourneySpecificPreference));
Finish();
};
}
}
async Task RunUpdateTest()
{
await Task.Factory.StartNew(() =>
{
using (var db = new SQLiteConnection(DatabasePath))
{
db.RunInTransaction(async () =>
{
// run the update operation
var person = db.Get<Person>(f => f.FullName.EndsWith("8"));
person.OtherField = "ABCD";
db.Update(person);
// check it was persisted
var updatedPerson = db.Get<Person>(f => f.FullName.EndsWith("8"));
var message = updatedPerson.OtherField == "ABCD"
? "Completed!"
: "Did not update person!";
await dispatcher.RunIdleAsync(a => { UpdateResult = message; });
});
}
});
}
public string updatePositionSuppliv (string numCommande)
{
string dbPath = System.IO.Path.Combine(Environment.GetFolderPath
(Environment.SpecialFolder.Personal), "ormDMS.db3");
var db = new SQLiteConnection(dbPath);
string output = "";
var query = db.Table<TablePositions>().Where (v => v.numCommande.Equals(numCommande));
foreach (var item in query) {
output = "YALO";
var row = db.Get<TablePositions> (item.Id);
row.imgpath = "SUPPLIV";
db.Update(row);
Console.WriteLine ("UPDATE SUPPLIV" + row.numCommande);
}
return output;
}
//NEEDS INTEGRATION
//This function updates an existing event with new info
public string updateEvent(int id,string name, string location, string date, string time)
{
string dbPath = Path.Combine (Environment.GetFolderPath (Environment.SpecialFolder.Personal), "AutomatechORM.db3");
var db = new SQLiteConnection(dbPath);
var item = db.Get<EventInfo>(id) ;
item.title = name;
item.location = location;
item.date = date;
item.time = time;
db.Update (item);
return "Record Updated...";
}
void ComWebService ()
{
//récupération des données dans la BDD
string dbPath = System.IO.Path.Combine (Environment.GetFolderPath
(Environment.SpecialFolder.Personal), "ormDMS.db3");
var db = new SQLiteConnection (dbPath);
var table = db.Query<TableStatutPositions> ("Select * FROM TableStatutPositions");
foreach (var item in table) {
try {
string _url = "http://dms.jeantettransport.com/api/livraisongroupage";
var webClient = new WebClient ();
webClient.Headers [HttpRequestHeader.ContentType] = "application/json";
//TODO
webClient.UploadString (_url, item.datajson);
//Sup pde la row dans statut pos
var row = db.Get<TableStatutPositions>(item.Id);
db.Delete(row);
} catch (Exception e) {
Console.WriteLine (e);
Insights.Report(e);
File.AppendAllText(log_file,"["+DateTime.Now.ToString("t")+"]"+"[ERROR] ComWebService : "+e+" à "+DateTime.Now.ToString("t")+"\n");
}
}
Console.WriteLine ("\nTask ComWebService done");
//File.AppendAllText(Data.log_file, "Task ComWebService done"+DateTime.Now.ToString("t")+"\n");
}
public string logout()
{
string dbPath = System.IO.Path.Combine(Environment.GetFolderPath
(Environment.SpecialFolder.Personal), "ormDMS.db3");
var db = new SQLiteConnection(dbPath);
string output = string.Empty;
var query = db.Table<TableUser>().Where (v => v.user_IsLogin.Equals(true));
foreach (var item in query) {
var row = db.Get<TableUser>(item.Id);
row.user_IsLogin = false;
db.Update(row);
output = "UPDATE USER LOGOUT " + row.user_AndsoftUser;
}
return output;
}
/************************************************|
* DEFINING METHODS |
* |
* |
*************************************************/
//--------------retrieving user data and storing in variables---------------//
private void RetrieveDatafromDB()
{
using (var connection = new SQLiteConnection(dbPath)) {
var User = connection.Get<User> (1);
persons = User.Persons;
standards = User.Standards;
isActive = User.IsActive;
interestCity = User.InterestCity;
interestCulture = User.InterestCulture;
interestNature = User.InterestNature;
interestSportActivities = User.InterestSportActivities;
interestEvents = User.InterestEvents;
vacationTarget = User.VacationTarget;
startingDate = User.StartingDate;
endDate = User.EndDate;
Log.Info (Tag, "Query - Result: " + persons.ToString ());
}
}
//suppresion d'un GRP
public string supp_grp(string numGroupage)
{
string dbPath = System.IO.Path.Combine(Environment.GetFolderPath
(Environment.SpecialFolder.Personal), "ormDMS.db3");
var db = new SQLiteConnection(dbPath);
string output = "";
var query = db.Table<TablePositions>().Where (v => v.groupage.Equals(numGroupage));
foreach (var item in query) {
output = item.groupage;
var row = db.Get<TablePositions>(item.Id);
db.Delete(row);
Console.WriteLine ("\nDELETE GOOD" + numGroupage);
}
return output;
}
private void HandleClickSaveInfo(object sender, EventArgs e)
{
HideKeyboard();
TypeWorkDB typeWork;
string specialistSid;
using (var dbConnection = new SQLiteConnection(mDBUnitAndroidPrinterApp))
{
string selectTypeWork = mSpinner.SelectedItem.ToString();
typeWork = dbConnection.Get<TypeWorkDB>(x => x.Name == selectTypeWork);
specialistSid = dbConnection.Get<AccountDB>(x => x.Login == mLogin).Sid;
}
DispatchDB dispatch = new DispatchDB()
{
DeviceSerialNum = mSerialKey.Text,
Address = mAddress.Text,
ClientName = mClientName.Text,
CounterColor = mColorCounter.Text,
CounterMono = mMonoCounter.Text,
DateCreate = DateTime.Now,
Descr = mComment.Text,
DeviceModel = mDeviceModel.Text,
CityName = string.Empty,
IdDevice = m_deviceInfoDB.DeviceId,
IdWorkType = typeWork.Id,
SpecialistSid = specialistSid
};
try
{
m_unitAPIShellSaver.PushData(dispatch);
}
catch (WebException webEx)
{
try
{
m_unitAPIShellSaver.SaveLocalData(dispatch);
}
catch (SQLiteException dbEx)
{
string resError = Resources.GetString(Resource.String.ErrorSaveInfo);
string errorDescr = string.Format(
resError + System.Environment.NewLine +
"Web error: {0}" + System.Environment.NewLine + "DB error: {1}",
webEx.Message, dbEx.Message);
Toast.MakeText(this, errorDescr, ToastLength.Long).Show();
}
}
GoCompleteSaveEntryActivity();
}
//SELECT PAR ID
public TablePositions GetPositionsData(int id)
{
string dbPath = System.IO.Path.Combine(Environment.GetFolderPath
(Environment.SpecialFolder.Personal), "ormDMS.db3");
var db = new SQLiteConnection(dbPath);
TablePositions data = new TablePositions ();
var item = db.Get<TablePositions>(id);
data.codeLivraison = item.codeLivraison;
data. numCommande = item.numCommande;
data. nomClient = item.nomClient;
data. refClient = item.refClient;
data. nomPayeur = item.nomPayeur;
data. adresseLivraison = item.adresseLivraison;
data. CpLivraison = item.CpLivraison;
data. villeLivraison = item.villeLivraison;
data. dateHeure = item.dateHeure;
data. dateExpe = item.dateExpe;
data. nbrColis = item.nbrColis;
data. nbrPallette = item.nbrPallette;
data. adresseExpediteur = item.adresseExpediteur;
data. CpExpediteur = item.CpExpediteur;
data. villeExpediteur = item.villeExpediteur;
data. nomExpediteur = item.nomExpediteur;
data. StatutLivraison = item.StatutLivraison;
data .instrucLivraison = item.instrucLivraison;
data. groupage = item.groupage;
data. ADRLiv = item.ADRLiv;
data .ADRGrp = item.ADRGrp;
data .planDeTransport = item.planDeTransport;
data. typeMission = item.typeMission;
data.typeSegment = item.typeSegment;
data.CR = item.CR;
data .nomClientLivraison = item.nomClientLivraison;
data .villeClientLivraison = item.villeClientLivraison;
data .Datemission = item.Datemission;
data. Ordremission = item.Ordremission;
data .Userandsoft = item.Userandsoft;
data .remarque = item.remarque;
data .codeAnomalie = item.codeAnomalie;
data .libeAnomalie = item.libeAnomalie;
data.imgpath = item.imgpath;
if (Convert.ToDouble((item.poids).Replace ('.', ',')) < 1) {
data.poids = ((Convert.ToDouble((item.poids).Replace ('.', ','))) * 1000) + " kg";
} else {
data.poids = item.poids + "tonnes";
}
return data;
}
