/*Working with user*/ static public void InsertUser(User income) { if (SQConnection != null) { SQConnection.Insert(income); } }
/*Working with products*/ static public void InsertAlcohol(Alcohol income) { if (SQConnectionAlcohol != null) { SQConnectionAlcohol.Insert(income); } }
/*Working with products*/ static public void InsertProduct(Product income) { if (SQConnectionProduct != null) { SQConnectionProduct.Insert(income); } }
public void AddToTable() { using (var db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { var s = db.Insert(this); } }
public NewGame() { this.InitializeComponent(); path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite"); conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path); conn.CreateTable<Game>(); var add = conn.Insert(game); Debug.WriteLine(path); }
public static void Insert(Object _Obj) { using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH)) { conn.RunInTransaction(() => { conn.Insert(_Obj); }); } }
private async void AddData(object sender, RoutedEventArgs e) { Checkout nnn = new Checkout(); try { //string CDay = DateStamp.Date.Value.Day.ToString(); //string CMonth = DateStamp.Date.Value.Month.ToString(); //string CYear = DateStamp.Date.Value.Year.ToString(); //string FinalDate = "" + CMonth + "/" + CDay + "/" + CYear; if (Desc.Text == "") { MessageDialog dialog = new MessageDialog("Not entered Debt name"); await dialog.ShowAsync(); } else { double Money = Convert.ToDouble(MoneyIn.Text); double Dmoney = 0 - Money; conn.Insert(new Appointments() { ApptName = Desc.Text, DebtAmount = Dmoney }); } Results(); } catch (Exception ex) { if (ex is FormatException) { MessageDialog dialog = new MessageDialog("You forgot to enter the Value or entered an invalid data", "Oops..!"); await dialog.ShowAsync(); } else if (ex is SQLiteException) { MessageDialog dialog = new MessageDialog("A Similar Debt Name already exists, try different name", "Oops..!"); await dialog.ShowAsync(); } } }
public NewGame() { this.InitializeComponent(); path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite"); conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path); conn.CreateTable <Game>(); var add = conn.Insert(game); Debug.WriteLine(path); }
//Adds a new record to the Sales table. public void AddRecordToTable() { if (Items != null && Date != null) { using (var db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { var s = db.Insert(this); } } }
public static string AddRecord(int age) { Console.WriteLine("Creating database, if it doesn't already exist"); SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid(); string dbPath = Path.Combine( Environment.GetFolderPath(Environment.SpecialFolder.Personal), "ormdemo.db3"); var db = new SQLite.Net.SQLiteConnection(plat, dbPath); //db.CreateTable<Stock>(); //if (db.Table<Stock>().Count() == 0) { // only insert the data if it doesn't already exist var newStock = new Stock(); newStock.Symbol = "AAPL" + age.ToString(); db.Insert(newStock); newStock = new Stock(); newStock.Symbol = "GOOG" + age.ToString(); db.Insert(newStock); newStock = new Stock(); newStock.Symbol = "MSFT" + age.ToString(); db.Insert(newStock); } Console.WriteLine("Reading data"); var table = db.Table <Stock>(); string data = string.Empty; foreach (var s in table) { Console.WriteLine(s.Id + " " + s.Symbol); data += s.Id + " " + s.Symbol + " :: "; } return(data); }
public static async Task InsertAsync(Object _Obj) { await Task.Run(() => { using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH)) { conn.RunInTransaction(() => { conn.Insert(_Obj); }); } }); }
private static void CreateDatabase() { try { string folderPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); System.IO.Directory.CreateDirectory(folderPath); string databaseFilePath = System.IO.Path.Combine(folderPath, "FinancialProfile.db"); using (var db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS(), databaseFilePath)) { db.CreateTable <FinancialProfileDomain>(); if (db.Table <FinancialProfileDomain>().Count() == 0) { var FinancialProfile = new FinancialProfileDomain() { Question = "When is your birthday?", DataType = "DateTime" }; db.Insert(FinancialProfile); var question = db.Get <FinancialProfileDomain>(1); FinancialProfile = new FinancialProfileDomain() { Question = "What is your net worth?", DataType = "Int" }; db.Insert(FinancialProfile); FinancialProfile = new FinancialProfileDomain() { Question = "How much do you make each month after taxes including 1099, w2, 401k, and ira contributions?", DataType = "Int" }; db.Insert(FinancialProfile); FinancialProfile = new FinancialProfileDomain() { Question = "How much do you spend each month on your house?", DataType = "Int" }; db.Insert(FinancialProfile); FinancialProfile = new FinancialProfileDomain() { Question = "How much do you spend each month on your car?", DataType = "Int" }; db.Insert(FinancialProfile); FinancialProfile = new FinancialProfileDomain() { Question = "How much do you spend each month on everything else?", DataType = "Int" }; db.Insert(FinancialProfile); } } } catch (SQLiteException ex) { var t = ex; } }
private void Add_Page(object sender, RoutedEventArgs e) { try { var page = connect.Insert(new Page() { date = DateResult.Text, image = ImageResult.Source.ToString(), title = TitleResult.Text, description = ContentResult1.Text, }); }catch (Exception ex) { } }
//Inserts a new customer if the customer is not already in the table, if it is, it updates it. public void AddToTable() { using (var db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { //Look for customer in table Customer returnedCustomer = (from s in db.Table <Customer>() where s.Id.Equals(Id) select s).FirstOrDefault(); if (returnedCustomer != null) { //Add new items to items in items column. this.Items = returnedCustomer.Items + "\r(" + DateTime.Now.ToLocalTime().ToString("d") + ")\r" + this.Items; db.Update(this); } else { db.Insert(this); } } }
public void AddMobile(string macAddress, string name, DateTime lastConnectionDate, string lastState) { Debug.WriteLine("Add Mobile to DB : " + macAddress + " " + name + " " + lastConnectionDate.ToString() + " " + lastState); try { var s = new Mobile { MACAddress = macAddress, Name = name, LastConnectionDate = lastConnectionDate, LastState = lastState }; using (SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), this.DB_PATH)) { conn.RunInTransaction(() => { conn.Insert(s); }); } //conn.DeleteAll<Message> (); } catch { Debug.WriteLine("ERROR : Unable to add Message"); } }
//Adds a new sale to the Sales table and to SalesByDay table. Updates customer if necessary. public void AddToTable() { Items = ItemsString; Date = DateTime.Now; Total = TotalValue; //Insert new sale to Sale Table using (var db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { var s = db.Insert(this); } //Add each item in the cart to the sale of the day table and delete from the inventory. foreach (UniqueItem ui in CartList) { ui.DeleteFromInventory(); } //If there is a customer set, add as debt instead. if (Customer != null) { foreach (UniqueItem ui in CartList) { ui.AddToSalesByDayAsDebt(); } //Set all customer properties. Customer.Date = DateTime.Now; Customer.Debt = Customer.Debt + TotalValue; Customer.Total = Customer.PayedDebt - Customer.Debt; Customer.Items = ItemsString; Customer.AddToTable(); } else { foreach (UniqueItem ui in CartList) { ui.AddToSalesByDay(); } } }
public static SalesByDay Today() { using (var db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { String today = DateTime.Now.ToLocalTime().ToString("s").Substring(2, 8); new SalesByDay(); var query = (from s in db.Table <SalesByDay>() where s.Day == today select s).FirstOrDefault(); if (query == null) { SalesByDay newDay = new SalesByDay() { Day = today, ItemsString = String.Empty, Total = 0, TotalOwed = 0 }; db.Insert(newDay); return(SalesByDay.Today()); } else { return(query); } } }
public void Insert(Contato contato) { _connection.Insert(contato); }
public void Add(ItemCardapio itemCardapio) { sqlConnection.Insert(itemCardapio); }
public void AddBookToDB(Book book) { con.Insert(book); }
public void Insert <T>(T model) { connection.Insert(model); }
public void Insert(Cliente cliente) { _conexao.Insert(cliente); }
SQLite.Net.SQLiteConnection conn; //data connection /// <summary> /// Creates the database. /// </summary> public int createDatabase() { //create database local file name "HD_db.sqlite.sqlite" path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "HD_db.sqlite"); if (!File.Exists(path)) { //create database conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path); //Thêm bảng conn.CreateTable<Model_CHI_TIET_VAY_CHOVAY>(); conn.CreateTable<Model_GHI_CHEP>(); conn.CreateTable<Model_GUI_TIET_KIEM>(); conn.CreateTable<Model_HANG_MUC_CHI>(); conn.CreateTable<Model_HANG_MUC_CHI_CHA>(); conn.CreateTable<Model_HANG_MUC_THU>(); conn.CreateTable<Model_HANG_MUC_THU_CHA>(); conn.CreateTable<Model_LOAI_TAI_KHOAN>(); conn.CreateTable<Model_LOAI_TIEN>(); conn.CreateTable<Model_TAI_KHOAN>(); conn.CreateTable<Model_THIET_LAP>(); conn.CreateTable<Model_USERS>(); conn.CreateTable<Model_VAY_NGAN_HANG>(); //Thêm record try { EncryptPassword pass = new EncryptPassword(); conn.Insert(new Model_USERS() { Email = "*****@*****.**", FirstName = "Heo Đất", LastName = "Admin", Password = pass.encrypt("admin"), Type = "Admin", Status = true }); Debug.WriteLine("[QLTC] đã thêm admin"); } catch (Exception ex) { Debug.WriteLine("[QLTC] " + ex.Message); } try { var listHangMucChiCha = new List<Model_HANG_MUC_CHI_CHA>() { new Model_HANG_MUC_CHI_CHA() {TenHangMucChiCha= "Trang phục"}, new Model_HANG_MUC_CHI_CHA() {TenHangMucChiCha="Ăn uống" } }; foreach (var item in listHangMucChiCha) { conn.Insert(item); } var listHangMucChi = new List<Model_HANG_MUC_CHI>() { new Model_HANG_MUC_CHI() {IdHangMucChi=0, IdHangMucChiCha=1,TenHangMucChi="Quần áo",ChinhSuaHangMucChi=false,GhiChuHangMucChi="Mua sắm quần áo" }, new Model_HANG_MUC_CHI() {IdHangMucChi=1, IdHangMucChiCha=1,TenHangMucChi="Giầy dép",ChinhSuaHangMucChi=false,GhiChuHangMucChi="Mua sắm giầy dép" }, new Model_HANG_MUC_CHI() {IdHangMucChi=2, IdHangMucChiCha=1,TenHangMucChi="Khác",ChinhSuaHangMucChi=false,GhiChuHangMucChi="Mua sắm" }, new Model_HANG_MUC_CHI() {IdHangMucChi=3, IdHangMucChiCha=2,TenHangMucChi="Đi chợ/Siêu thị",ChinhSuaHangMucChi=false,GhiChuHangMucChi="Đi chợ, siêu thị" }, new Model_HANG_MUC_CHI() {IdHangMucChi=4, IdHangMucChiCha=2,TenHangMucChi="Ăn tiệm",ChinhSuaHangMucChi=false,GhiChuHangMucChi="Ăn tiệm" } }; foreach (var item in listHangMucChi) { conn.Insert(item); } } catch (Exception ex) { Debug.WriteLine("[QLTC] " + ex.Message); } } else // if file exist { conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path); } return 1; }