private async void SubmitButton_Click(object sender, RoutedEventArgs e) { DateTime d = DateTime.Now; string day = d.Day < 10 ? "0" + d.Day.ToString() : d.Day.ToString(); string month = d.Month < 10 ? "0" + d.Month.ToString() : d.Month.ToString(); string year = d.Year.ToString(); string date = day + "-" + month + "-" + year; string hour = d.Hour < 10 ? "0" + d.Hour.ToString() : d.Hour.ToString(); string minute = d.Minute < 10 ? "0" + d.Minute.ToString() : d.Minute.ToString(); string second = d.Second < 10 ? "0" + d.Minute.ToString() : d.Minute.ToString(); string time = hour + ":" + minute + ":" + second; string orderNo = "Order - " + (rowCount + 1000).ToString(); if (orderDict.Count > 0) { // insert in order table conn.CreateTable <Order>(); conn.Insert(new Order() { Id = rowCount, UserId = Login.userId, OrderDate = date, OrderTime = time, TotalAmount = total, Acknowledged = 0, Deliveried = 0, ProcessTime = "", Canceled = 0, OrderNo = orderNo }); // insert in order item table foreach (var order in orderDict) { string[] itemId_Price = order.Key.Split(' '); int itemId = Convert.ToInt32(itemId_Price[0]); double price = Convert.ToDouble(itemId_Price[1]); int quantity = Convert.ToInt32(order.Value); conn.CreateTable <OrderItem>(); conn.Insert(new OrderItem() { OrderId = rowCount, UserId = Login.userId, Date = date, Time = time, ItemId = itemId, Price = price, Quantity = quantity, Total = price * quantity }); } await new MessageDialog("Order is submitted successfully.\nTotal Amount: " + total).ShowAsync(); SubmittedOrder.showOrderDict = orderDict; SubmittedOrder.title = orderNo; this.Frame.Navigate(typeof(SubmittedOrder)); } }
///Add new account methods public void AddPWAcc() { NewPassword.Add(new Passwords { Account = accountTextbox.Text, Username = usernameTextbox.Text, Password = passwordTextbox.Text, SQ1 = sq1_Textbox.Text, SQA1 = sqa1_Textbox.Text, SQ2 = sq2_Textbox.Text, SQA2 = sqa2_Textbox.Text, Code = codeTextbox.Text, Accnumber = accNoTextbox.Text, }); //Add curr text in texboxes to new row in SQL db conn.Insert(new Passwords() { Account = accountTextbox.Text, Username = usernameTextbox.Text, Password = passwordTextbox.Text, SQ1 = sq1_Textbox.Text, SQA1 = sqa1_Textbox.Text, SQ2 = sq2_Textbox.Text, SQA2 = sqa2_Textbox.Text, Code = codeTextbox.Text, Accnumber = accNoTextbox.Text }); }
public int Add(string journalDate, string typeString, string partyString, string referenceString, string note, Dictionary <int, double> accountInfo, double totalDebit, double totalCredit) { int add = -1; if (accountInfo.Count < 2) { return(-2); } if (totalDebit != totalCredit) { return(-3); } try { int type = int.Parse(typeString), party_id = int.Parse(partyString), ref_journal_id = int.Parse(referenceString); string number = GetJournalNumber(type); string json = JsonConvert.SerializeObject(accountInfo, Formatting.Indented).ToString() .Replace("\r", "").Replace("\n", "").Replace(" ", ""); Journal journal = new Journal() { number = number, journal_date = DateTime.Parse(journalDate), amount = totalDebit, type = type, party_id = party_id, ref_journal_id = ref_journal_id, description = note, account_info = json.Trim(), deleted = 0 }; conn.Insert(journal); add = journal.id; if (add > 0) { foreach (KeyValuePair <int, double> pair in accountInfo) { conn.Insert(new Ledger() { journal_id = journal.id, account_id = pair.Key, amount = pair.Value, party_id = party_id, entry_date = DateTime.Parse(journalDate), description = note, other_accounts = json }); } } } catch (Exception e) { Debug.WriteLine(e.ToString()); add = -1; } return(add); }
private void button_Click(object sender, RoutedEventArgs e) { var s = conn.Insert(new Userdata() { Username = us, Site = textBox.Text, SiteUsername = textBox1.Text, Password = passwordBox.Password }); }
public int save() { var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite"); using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { var infoTable = conn.GetTableInfo("Eat"); if (!infoTable.Any()) { //conn.DropTable<Eat>(); conn.CreateTable <Eat>(); } var info = conn.GetMapping(typeof(Eat)); if (this._eat.EatID == 0) { var i = conn.Insert(this._eat); conn.Commit(); return(i); } else { var i = conn.Update(this._eat); return(i); } } }
private void enter_Click(object sender, RoutedEventArgs e) { String t = ""; if (sexfemale != null) { t = sexfemale.Content.ToString(); } var s = conn.Insert(new GuestTable() { Name = username.Text, Age = userage.Text, sex = t, country = usercountry.PlaceholderText.ToString(), }); if (((username.Text != "") && (userage.Text != "")) && (((ComboBoxItem)usercountry.SelectedItem).Content.ToString() != "")) { Frame.Navigate(typeof(PostPage)); } else { MyMessageBox("Enter Required Details"); } }
public int save() { var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite"); using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { var infoTable = conn.GetTableInfo("User"); if (!infoTable.Any()) { // conn.DropTable<User>(); conn.CreateTable<User>(); } var info = conn.GetMapping(typeof(User)); if (this._user.UserID == 0) { //var i = conn.InsertOrReplace(this._user); var i = conn.Insert(this._user); conn.Commit(); // this._user.UserID = i; return i; } else { var i = conn.Update(this._user); return i; } } }
//ADD //create SQLite DB connection //create variable "addProduct" that holds SQLite insert statement //set each instance variable in the Item class with values from each TextBox //Call Show_tapped func to asynchronously update page //close db conn //clear textboxes after adding private async void Add_Tapped(object sender, TappedRoutedEventArgs e) { dbConnection(); try { if (!IsDecimal(quantityTextBox) || !IsDecimal(priceTextBox)) { MessageDialog decimalMsg = new MessageDialog("Quantity + Price must be a number."); await decimalMsg.ShowAsync(); } else { var addProduct = conn.Insert(new Product() { productName = productTextBox.Text, productQTY = Convert.ToInt32(quantityTextBox.Text), productPrice = Convert.ToDouble(priceTextBox.Text) }); } } catch (Exception) { MessageDialog message = new MessageDialog("Nothing to Add."); await message.ShowAsync(); } //ShowAllError_Tapped(sender, e); for showing all data when using Add_Tapped closeDBconnection(); //clearTextBoxes(); Show_Tapped(sender, e); SetBalance(); } // End Add_Tapped
public static bool setValueByKey(string key_, string value_) { bool res = false; var conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), FullPathSQLite); try { var row = conn.Query <Settings>("select * from Settings where Key=?", key_).FirstOrDefault(); if (row != null) { row.Value = value_; conn.RunInTransaction(() => { conn.Update(row); }); res = true; } else { Settings row_ = new Settings { Key = key_, Value = value_, DefaultValue = value_ }; conn.Insert(row_); res = true; } } catch (Exception ex) { res = false; } return(res); }
private async void themmuctieuButton_Click(object sender, RoutedEventArgs e) { if (await checkNumberTextBox() == true) { // xóa mục tiêu hiện tại var mtht = connection.Table<MucTieu>().Where(r => r.TenDangNhap == nguoidung.TenDangNhap && (r.TrangThai == "Đã bắt đầu" || r.TrangThai == "Chưa bắt đầu")).FirstOrDefault(); if (mtht != null) { mtht.TrangThai = "Hủy"; connection.Update(mtht); } // thêm mục tiêu mới vào db muctieu.SoCanMuonGiam = socanmuongiam; muctieu.SoNgay = thoigian; muctieu.TrangThai = "Chưa bắt đầu"; // 1kg = 7700; muctieu.LuongKaloCanTieuHaoMoiNgay = Math.Round(socanmuongiam * 7700.0 / thoigian,2); connection.Insert(muctieu); MessageDialog msDialog = new MessageDialog("Tạo mục tiêu thành công"); await msDialog.ShowAsync(); Frame.Navigate(typeof(TrangChu), nguoidung); } }
private void Add_Click(object sender, RoutedEventArgs e) { var query = conn.Table <Logindata>(); var dummy = 0; textBlock3.Text = ""; foreach (var message in query) { if (textBox.Text == message.Username) { dummy = 1; textBlock3.Text = "Username already taken"; break; } } if (dummy == 0) { textBlock3.Text = "Registered, click on Login"; var s = conn.Insert(new Logindata() { Username = textBox.Text, Password = textBox1.Password }); } }
protected override void OnNavigatedTo(NavigationEventArgs e) { ScenarioEnableButton.IsEnabled = true; ScenarioDisableButton.IsEnabled = false; ScenarioPauseButton.IsEnabled = false; nguoidung = TrangChu.nguoidung; muctieu = TrangChu.muctieu; if (muctieu != null) { thongkengay = TrangChu.getThongKeNgayHienTai(muctieu); chaybo = connection.Table <ThongKeBaiTap>().Where(r => r.IdThongKeNgay == thongkengay.IdThongKeNgay && r.IdBaiTap == 1).FirstOrDefault(); if (chaybo == null) { chaybo = new ThongKeBaiTap() { IdBaiTap = 1, IdThongKeNgay = thongkengay.IdThongKeNgay, QuangDuong = 0, SoBuoc = 0, LuongKaloTieuHao = 0, ThoiGianTap = 0 }; connection.Insert(chaybo); } } // mục tiêu == null || thống kê ngày == null -> tập nhưng không đưa vào database else { chaybo = new ThongKeBaiTap(); } }
//hien thi dialog ve nhan xet luon kalo da an private async void XongBtn_Click(object sender, RoutedEventArgs e) { if (kaloSum == 0) { var ms = new MessageDialog("Bạn nên chọn lượng Kcal nhập vào \nđể thống kê chính xác nhất"); await ms.ShowAsync(); return; } var msKalo = new MessageDialog("Tổng lượng Kcal bạn đã ăn là: " + kaloSum); await msKalo.ShowAsync(); if (muctieu != null && thongkengay != null) { connection.Execute("DELETE FROM ThucDon WHERE IdThongKeNgay =?", thongkengay.IdThongKeNgay); //add cac thuc an da chon vao database foreach (var item in monanChonList) { connection.Insert(item); } thongkengay.LuongKaloDuaVao = connection.ExecuteScalar <double>("SELECT SUM(LuongKalo) FROM THUCDON WHERE IdThongKeNgay =?", thongkengay.IdThongKeNgay); connection.Update(thongkengay); } Frame.Navigate(typeof(TrangChu), nguoidung); }
CreateGameViewModel.CreateGameResult IStorage.Upload(Core.Model.Game game, FileInfo dbFile, FileInfo savedGame) { CreateGameAtGoogle cgg = new CreateGameAtGoogle(); GoogleDrive.GoogleStorageResult googleResult = cgg.Execute(m_User, game, dbFile, savedGame); m_DB.CreateTable <MasterTableGoogle>(); MasterTableGoogle googleMasterTable = new MasterTableGoogle(); googleMasterTable.GameID = game.ID; googleMasterTable.DBFileID = googleResult.DatabaseFileID; googleMasterTable.GameFileID = googleResult.GameFileID; m_DB.Insert(googleMasterTable); var result = new CreateGameViewModel.CreateGameResult(); result.GameID = game.ID; result.GameType = game.GameType; result.StorageType = this.Type; result.IDList.Add(googleResult.DatabaseFileID); result.IDList.Add(googleResult.GameFileID); return(result); }
public int Add(string name, string code, string typeString, string subtypeString, string parentString, string openingBalance, string openingDate, string note) { int add = -1; try { int type = int.Parse(typeString), subtype = int.Parse(subtypeString), parent_id = int.Parse(parentString); Account account = new Account() { name = name, code = code, type = type, subtype = subtype, parent_id = parent_id, depth = 0, entry_date = DateTime.Parse(openingDate), note = note, opening_balance = Double.Parse(openingBalance), deleted = 0 }; conn.Insert(account); add = account.id; if (Double.Parse(openingBalance) > 0.0) { int flag = CreateJournal(account.id, openingDate, openingBalance, note); } } catch (Exception e) { Debug.WriteLine(e.ToString()); add = -1; } return(add); }
public int Add(string name, string prefix, string start_number, string debit_account_id_str, string credit_account_id_str) { int add = -1; try { int debit_account_id = int.Parse(debit_account_id_str), credit_account_id = int.Parse(credit_account_id_str); JournalType type = new JournalType() { name = name, prefix = prefix, start_number = start_number, debit_account_id = debit_account_id, credit_account_id = credit_account_id, deleted = 0 }; conn.Insert(type); add = type.id; } catch (Exception e) { Debug.WriteLine(e.ToString()); add = -1; } return(add); }
private void AddData_Click(object sender, RoutedEventArgs e) { var customer = conn.Insert(new Customer() { Name = textBox.Text, PhoneNumber = textBox1.Text }); }
private void Add_Click(object sender, RoutedEventArgs e) { var s = conn.Insert(new Customer() { Name = textBox.Text, Age = textBox1.Text }); }
private void Add_Click(object sender, RoutedEventArgs e) { var s = conn.Insert(new Contact() { email = textBox.Text, phone = textBox1.Text }); }
private void Add_OnClick(object sender, RoutedEventArgs e) { var s = conn.Insert(new ToDoList() { Title = Title.Text, StartDate = DateTimeOffset.Now, //Description = Description.Text }); }
public void AddRegister(Registre registre) { using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { conn.Insert(new Registre { RegistreDate = registre.RegistreDate }); } }
private void btl1_Click(object sender, RoutedEventArgs e) { var a = conn.Insert(new logdata() { Name = TT1.Text, Email = TT3.Text, Password = TT0.Password, Number = TT7.Text }); Frame.Navigate(typeof(MainPage)); }
private void btnExit_Click(object sender, RoutedEventArgs e) { if (txtBoxNickName.Text.Length < 3 || txtBoxNickName.Text.Length > 8) { ShowDialog(); } else { var insert = conn.Insert(new Game() { Name = txtBoxNickName.Text.ToString(), Move = moves, Result = result }); this.Frame.Navigate(typeof(MainPage)); } }
private void AddTaskButton_Click(object sender, RoutedEventArgs e) { if (TaskNameTextBox.Text.Equals("")) { PopupNotice popupNotice = new PopupNotice("计划名称不能为空~"); popupNotice.ShowAPopup(); } else { List <ToDoTasks> tempList = conn.Query <ToDoTasks>("select * from ToDoTasks where Name = ?", TaskNameTextBox.Text); if (tempList.Count != 0) { if (tempList[0].IsDelete.Equals("1")) { conn.Execute("update ToDoTasks set Name = ?, Date = ?, Star = ?, Remark = ?, Done = ?, UpdateTime = ?, IsDelete = ? where TaskId = ?", TaskNameTextBox.Text, "", "0", "", "0", DateTime.Now.ToString(), "0", tempList[0].TaskId); ToDoTaskViewModel1.ToDoDatas.Add(new ToDoTasks() { TaskId = tempList[0].TaskId, Name = TaskNameTextBox.Text, Date = "", Remark = "", UpdateTime = DateTime.Now.ToString(), StarVisibility = Visibility.Collapsed, DateVisibility = Visibility.Collapsed, RemarkVisibility = Visibility.Collapsed }); } else { PopupNotice popupNotice0 = new PopupNotice("请勿重复添加计划"); popupNotice0.ShowAPopup(); } } else { string uuid = Guid.NewGuid().ToString(); conn.Insert(new ToDoTasks() { TaskId = uuid, Name = TaskNameTextBox.Text, Date = "", Star = "0", Remark = "", Done = "0", UpdateTime = DateTime.Now.ToString(), IsDelete = "0" }); ToDoTaskViewModel1.ToDoDatas.Add(new ToDoTasks() { TaskId = uuid, Name = TaskNameTextBox.Text, Date = "", Remark = "", UpdateTime = DateTime.Now.ToString(), StarVisibility = Visibility.Collapsed, DateVisibility = Visibility.Collapsed, RemarkVisibility = Visibility.Collapsed }); } PopupNotice popupNotice = new PopupNotice("添加成功"); popupNotice.ShowAPopup(); TaskNameTextBox.Text = ""; } }
private async void dangkyButton_Click(object sender, RoutedEventArgs e) { try { if (tendangnhapTextBox.Text.Trim() == "" || matkhauPasswordBox.Password.Trim() == "") { // neu khong nhap tendangnhap, matkhau thi se hien len thong bao var msDialog = new MessageDialog("TÊN ĐĂNG NHẬP và MẬT KHẨU không được để trống"); await msDialog.ShowAsync(); return; } // kiem tra ngay sinh (ngay sinh khong duoc la ngay o tuong lai) if (ngaysinhDatePicker.Date > DateTime.Today) { var msDialog = new MessageDialog("NGÀY SINH không chính xác"); await msDialog.ShowAsync(); return; } // kiem tra tendangnhap da co nguoidung su dung chua var nguoidungCollection = connection.Table <NguoiDung>(); foreach (var nd in nguoidungCollection) { if (nd.TenDangNhap == tendangnhapTextBox.Text) { var msDialog = new MessageDialog("TÊN ĐĂNG NHẬP đã tồn tại.\nVui lòng chọn tên đăng nhập khác."); await msDialog.ShowAsync(); return; } } //dua nguoidung vao database //lay ngaysinh, dua ve dang dd-MM-yyyy string ngaysinh = ngaysinhDatePicker.Date.ToString("dd/MM/yyyy"); //lay gioitinh RadioButton selectedRadio = gioitinhPanel.Children.OfType <RadioButton>().FirstOrDefault(r => r.IsChecked == true); // tao moi nguoidung NguoiDung nguoidung = new NguoiDung(tendangnhapTextBox.Text, matkhauPasswordBox.Password, ngaysinh, selectedRadio.Content.ToString()); //insert nguoidung connection.Insert(nguoidung); //hien thi thong bao thanh cong var msDialog1 = new MessageDialog("Đăng ký thành công!"); await msDialog1.ShowAsync(); //tro ve trang MainPage de dang nhap Frame.Navigate(typeof(MainPage)); } catch (Exception) { throw; } }
// Insert the new contact in the Contacts table. public void InsertRegular(RegularItem _RegularItem) { using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH)) { conn.RunInTransaction(() => { conn.Insert(_RegularItem); }); } }
public async void Button_Click(object sender, RoutedEventArgs e) { var page = conn.Insert(new BookMark() { date = DateResult.Text, title = TitleResult.Text, image = ImageResult.Source.ToString(), description = ContentResult.Text, }); }
// Insert the new contact in the Contacts table. public void Insert(Contacts objContact) { using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH)) { conn.RunInTransaction(() => { conn.Insert(objContact); }); } }
private void submit_Click(object sender, RoutedEventArgs e) { double totheight = 0, totneck = 0, totwaist = 0, tothip = 0, totbust = 0, totweight = 0; double h1, n1, w1, hi1, b1; h1 = double.Parse(feetinput.Text); n1 = double.Parse(neckfeetinput.Text); w1 = double.Parse(waistfeetinput.Text); hi1 = double.Parse(hipfeetinput.Text); b1 = double.Parse(bustfeetinput.Text); totweight = double.Parse(poundinput.Text); if (unit == 0) { totheight = h1 * 0.3048; totneck = n1 * 0.3048; totwaist = w1 * 0.3048; tothip = hi1 * 0.3048; totbust = b1 * 0.3048; totweight = totweight * 0.453592; } if (unit == 1) { totheight = h1; totneck = n1; totwaist = w1; tothip = hi1; totbust = b1; } var s = conn.Insert(new userdata2() { Name1 = nam, Password1 = pass, Age1 = ageinput.Text, Gender1 = gend, Height1 = totheight, Weight1 = totweight, Activity1 = act, Neck1 = totneck, Waist1 = totwaist, Hip1 = tothip, Bust1 = totbust, }); Window.Current.Content = new SignupPage(); }
public void AddButtonExecute() { WorkerTable currentWorker = new WorkerTable(); currentWorker.Lastname = "Worker"; currentWorker.Firstname = "New"; Database.Insert(currentWorker); var current = Database.Query <WorkerTable>("SELECT * FROM WorkerTable Where id = (SELECT MAX(Id) FROM WorkerTable);"); WorkerListing.Add(new Worker(currentWorker.Firstname, currentWorker.Lastname, current[0].Id)); }
private void Add_Click(object sender, RoutedEventArgs e) { var s = connection.Insert(new HNT_listView2.Models.Contact { Name = name_textBox.Text, Phone = phone_textBox.Text, Photo = photo_textBox.Text }); Debug.WriteLine("Added"); }
public async void SavePack_Click(object sender, RoutedEventArgs e) { try { bool isAlreadyInDatabase = false; AppBarButton button = new AppBarButton { }; button = sender as AppBarButton; int packnumber = 1; packnumber = Convert.ToInt32(button.Label.Substring(13, 1)); using (SQLite.Net.SQLiteConnection db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.path)) { int sizeQuery = db.Table<SavedCards>().Where(packs => packs.PackNumber == packnumber && packs.NounWord == currentModel.Noun && packs.Image == currentModel.Image && packs.VerbWord == currentModel.Verb && packs.AdjectiveWord == currentModel.Adjective).Count(); if (sizeQuery > 0) { isAlreadyInDatabase = true; } if (isAlreadyInDatabase == false) { int size = db.Table<SavedCards>().Where(me => me.PackNumber == packnumber).Count(); if (size < 12) { try { SavedCards savedcard = new SavedCards() { VerbWord = currentModel.Verb, AdjectiveWord = currentModel.Adjective, NounWord = currentModel.Noun, Image = currentModel.Image, CardNumber = size, PackNumber = packnumber }; db.Insert(savedcard); } catch (Exception error) { Debug.WriteLine(error.Message); } } else { var dialog = new MessageDialog("Pack " + packnumber + " has maximum number of cards!"); await dialog.ShowAsync(); } } else { var dialog = new MessageDialog("This card is already in the database"); await dialog.ShowAsync(); } } } catch (Exception error) { Debug.WriteLine(error.Message); } }
/// <summary> /// Used to save a card, when user is browsing generated cards. /// </summary> /// <param name="overWrite">If we are overwriting existing genererated card then overWrite should be true, else false</param> /// <param name="index">Generated card index which we are overwriting</param> public void SaveGeneratedCard(bool overWrite, int index) { using (SQLite.Net.SQLiteConnection db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.path)) { if (overWrite == false) { GeneratedCards generatedCards = new GeneratedCards() { VerbWord = currentModel.Verb, AdjectiveWord = currentModel.Adjective, NounWord = currentModel.Noun, Image = currentModel.Image }; try { db.Insert(generatedCards); } catch (Exception e) { Debug.WriteLine(e.Message); } } else { try { GeneratedCards generatedCard = db.Table<GeneratedCards>().Skip(index).First(); generatedCard.Image = currentModel.Image; generatedCard.VerbWord = currentModel.Verb; generatedCard.AdjectiveWord = currentModel.Adjective; generatedCard.NounWord = currentModel.Noun; db.Update(generatedCard); } catch (Exception e) { Debug.WriteLine(e.Message); } } } }