/*protected void RunPersonInfoChanged(IPersonInfo pInfo) { if (OnPersonInfoChanged != null) PropertyChanged(this, new PersonInfoEventArgs(new PersonInfoView())); }*/ public void Row_DoubleClick(object sender, MouseButtonEventArgs e) { PropertyInfo[] propInfos; DataGridRow row = sender as DataGridRow; PersonInfoModel outputPersonInfo = (row.Item as PersonInfoModel); List<PersonPaymentsModel> outputPP; using (DataBaseConnector dbService = new DataBaseConnector()) { List<IPersonPayments> inputPP = dbService.GetPersonPaymentRecords(t => t.PersonUUID == outputPersonInfo.UUID); if (inputPP.Count > 0) { outputPP = new List<PersonPaymentsModel>(); foreach (var item in inputPP) { PersonPaymentsModel newpp = new PersonPaymentsModel(); propInfos = typeof(IPersonPayments).GetProperties(); foreach (var curPropt in propInfos) { curPropt.SetValue(newpp, curPropt.GetValue(item)); } outputPP.Add(newpp); } outputPersonInfo.Payments = new ObservableCollection<PersonPaymentsModel>(outputPP); } } PersonInfoView hbDetailed = new PersonInfoView(outputPersonInfo); hbDetailed.ParentListView = this; //hbDetailed.Owner = this; hbDetailed.Show(); }
public void GetAllRooms() { using (DataBaseConnector dbService = new DataBaseConnector()) { if (RoomList != null) { RoomList = dbService.GetAllRecords<IRoom>(); } } }
/// <summary> /// Initializes a new instance of the <see cref="CompletionController"/> class. /// </summary> protected CompletionController() { _signInController = SignInController.GetInstance(); _topArtistsCache = new Dictionary <string, List <string> >(); _topPlacesCache = new Dictionary <string, List <string> >(); _topSongsCache = new Dictionary <string, List <string> >(); _topGeneresCache = new Dictionary <string, List <string> >(); _yearsList = new List <string> { "1900 - 1940", "1940 - 1960", "1960 - 1980", "1980 - 2000", "2000 - 2018" }; conn = DataBaseConnector.GetInstance(); }
private void FullFillDBWithRooms() { IRoom room = new RoomDBModel();; using (DataBaseConnector dbService = new DataBaseConnector()) { for (int i = 0; i < 3; i++) { for (int j = 0; j < 12; j++) { room.UUID = Guid.NewGuid().ToString(); room.RoomNumber = (i + 1) + "-" + (j + 1); dbService.HandleRoomsTable(room, null, RecordActions.Inserted); } } dbService.SaveChanges(); } }
public static Song GetSongFromSongName(string songName, DataBaseConnector conn) { MySqlCommand command = new MySqlCommand(); command.Connection = conn.Connection; command.CommandText = "select id_song from songs where lower(song_name) = \"" + songName.ToLower() + "\""; List <string> result = conn.ExecuteOneColumnCommand(command); if (result.Count <= 0) { return(null); } Song song = new Song(songName, result[0]); return(song); }
public static Genre GetGenreFromGenreName(string genreName, DataBaseConnector conn) { MySqlCommand command = new MySqlCommand(); command.Connection = conn.Connection; command.CommandText = "select id_genre from genres where lower(genere_name) = \"" + genreName.ToLower() + "\""; List <string> result = conn.ExecuteOneColumnCommand(command); if (result.Count <= 0) { return(null); } Genre genreObject = new Genre(genreName, int.Parse(result[0])); return(genreObject); }
public static Place GetPlaceFromPlaceId(int placeId, DataBaseConnector conn) { MySqlCommand command = new MySqlCommand(); command.Connection = conn.Connection; command.CommandText = "select area_name from area where id_area = " + placeId; List <string> result = conn.ExecuteOneColumnCommand(command); if (result.Count <= 0) { return(null); } Place place = new Place(placeId, result[0]); return(place); }
// Use this for initialization IEnumerator Start() { yield return(StartCoroutine(DataBaseConnector.SelectPlayerInfo())); yield return(StartCoroutine(DataBaseConnector.SelectItems(this))); yield return(StartCoroutine(DataBaseConnector.SelectPurchasedItems(this))); yield return(StartCoroutine(DataBaseConnector.SelectLoadouts(this))); showingItemList = allItemList; UpdatePlayerInfo(); RefreshShop(); RefreshLoadouts(0); btn_loadoutRename.onClick.AddListener(OpenLoadoutRename); btn_loadoutSave.onClick.AddListener(OnLoadoutSynchronize); }
public IEnumerator TryToBuyItem(ShopItem s) { if (Money >= s.item.Price && Level >= s.item.Level) { //SQL transaction Debug.Log("start"); yield return(StartCoroutine(DataBaseConnector.BuyItem(s.item))); s.item.IsBought = true; panelInfo.SetButtonAction(s); Money -= s.item.Price; // } else { Debug.Log("not enough money or level"); } }
public void getRents() { /* * SELECT * * FROM Products * where UserId<>'245875698' AND type='Nadlan' AND RentDateFrom > #3/1/1996# AND RentDateTo < #3/1/2019# AND Condition='New' AND Bundle=true AND Purpose='loan' */ string query = "Select * From Products INNER JOIN Rents ON Products.ProductID = Rents.ProductID where Renter = '" + Router.root.loginView1.getUserEmail() + "'"; OleDbDataReader result = DataBaseConnector.sql(query); productsToDisplay = new List <ProductListingModel>(); if (!result.Read()) { MessageBox.Show("no Results found please try again."); return; } do { //string value=(string)result.GetValue(0).ToString(); email = result.GetString(0); productId = result.GetValue(1).ToString(); purpose = result.GetValue(2).ToString(); from = result.GetValue(3).ToString(); to = result.GetString(4); price = result.GetValue(5).ToString(); addons = result.GetString(6); deposite = result.GetValue(7).ToString(); condition = result.GetString(8); description = result.GetString(9); category = result.GetString(10); composition = result.GetValue(12).ToString(); ProductListingModel product = new ProductListingModel(productId, description, composition, condition, category, purpose, from, to, price, addons); productsToDisplay.Add(product); }while (result.Read()); // Router.root.showRents1.populateListingView(productsToDisplay, this.category); Router.navigate("DASHBOARD", "SHOWRENTS"); }
private void AddButton_OnClick(object sender, RoutedEventArgs e) { if (AllIsGood()) { DataBaseConnector.NonQueryCommand( $"INSERT Clients(name, surname, phone, email, genderID) " + $"VALUES ((N'{Name.Text}'), (N'{Surname.Text}'), (N'{Phone.Text}'), (N'{Email.Text}'), (N'{Gender.SelectedIndex}'))"); MessageBox.Show("Client added successfully", "Success", MessageBoxButton.OK); Name.Text = ""; Surname.Text = ""; Phone.Text = ""; Email.Text = ""; Gender.SelectedIndex = 0; } else { MessageBox.Show("Check spelling", "ERROR", MessageBoxButton.OK); } }
private void FullFillDBWithFurniture() { IRoomFurniture roomfurn; List<IRoom> rooms = new List<IRoom>(); using (DataBaseConnector dbService = new DataBaseConnector()) { rooms = dbService.GetAllRecords<IRoom>(); foreach ( var room in rooms) { roomfurn = new RoomFurnitureDBModel(); roomfurn.UUID = Guid.NewGuid().ToString(); roomfurn.RoomUUID = room.UUID; roomfurn.FurnitureUnit = "Кровать"; roomfurn.Quantity = 2; dbService.HandleRoomFurnituresTable(roomfurn,null,RecordActions.Inserted); roomfurn.UUID = Guid.NewGuid().ToString(); roomfurn.FurnitureUnit = "Стул"; roomfurn.Quantity = 2; dbService.HandleRoomFurnituresTable(roomfurn, null, RecordActions.Inserted); roomfurn.UUID = Guid.NewGuid().ToString(); roomfurn.FurnitureUnit = "Стол"; roomfurn.Quantity = 1; dbService.HandleRoomFurnituresTable(roomfurn, null, RecordActions.Inserted); roomfurn.UUID = Guid.NewGuid().ToString(); roomfurn.FurnitureUnit = "Шкаф"; roomfurn.Quantity = 2; dbService.HandleRoomFurnituresTable(roomfurn, null, RecordActions.Inserted); roomfurn.UUID = Guid.NewGuid().ToString(); roomfurn.FurnitureUnit = "Полочка"; roomfurn.Quantity = 3; dbService.HandleRoomFurnituresTable(roomfurn, null, RecordActions.Inserted); } dbService.SaveChanges(); } }
private void ClientForm_OnLoaded(object sender, RoutedEventArgs e) { Clients = new List <Client>(); // ORM-3 заполнение коллекции try { SqlDataReader reader = DataBaseConnector.GetReader( "SELECT C.id, C.name, surname, email, phone, COALESCE(genderId,'-'), COALESCE(G.description, '-') FROM Clients C LEFT JOIN Genders G ON C.GenderID = G.Id"); while (reader.Read()) { Clients.Add( new Client() { Id = reader.GetInt32(0), Name = reader.GetString(1), Surname = reader.GetString(2), Email = reader.GetString(3), Phone = reader.GetString(4), GenderId = (reader.GetValue(5) == DBNull.Value) ? 0 : reader.GetInt32(5), GenderDescription = reader.GetString(6) } ); } reader.Close(); // С незакрытым reader блокируется connection } catch (Exception ex) { MessageBox.Show(ex.Message); Close(); } DataTable dataTable = DataBaseConnector.GetDataTable("SELECT id, name FROM Genders"); Genders = new List <string>(); foreach (DataRow row in dataTable.Rows) { Genders.Add(row.ItemArray[1].ToString()); } ShowClient(); }
public IEnumerator MailCheck() { validation.MailChecked = false; string mail = text_regMail.text; if (String.IsNullOrEmpty(mail)) { ShowWarning( text_regMail.gameObject.transform, "Enter email field!"); //ShowMessage("Enter email field!"); yield break; } if (!regexMail.IsMatch(mail)) { ShowWarning( text_regMail.gameObject.transform, "Entered mail is not valid"); //ShowMessage("Entered mail is not valid"); yield break; } yield return(StartCoroutine(DataBaseConnector.MailExist(mail, validation))); if (validation.MailExist) { ShowWarning( text_regMail.gameObject.transform, "This mail is already exist"); //ShowMessage("This mail is already exist"); } else { HideWarning(text_regMail.gameObject.transform); validation.MailChecked = true; } }
public static Artist GetArtistFromArtistId(string artistId, DataBaseConnector conn) { MySqlCommand command = new MySqlCommand(); command.Connection = conn.Connection; command.CommandText = "select * from artists where id_artist = \"" + artistId + "\" limit 1"; List <Dictionary <string, string> > result = conn.ExecuteCommand(command); if (result.Count == 0) { return(null); } Artist artist = new Artist(); artist.Name = result[0]["artist_name"]; artist.Id = result[0]["id_artist"]; artist.Day = result[0]["begin_date_day"]; artist.Month = result[0]["begin_date_month"]; artist.Year = result[0]["begin_date_year"]; return(artist); }
public void SettleButton_Click(object sender, RoutedEventArgs e) { if (sender.GetType() != typeof(DataGrid)) { MessageBox.Show("Невозможно определить список"); return; } var dg = sender as DataGrid; if (dg == null) { MessageBox.Show("Невозможно определить список"); return; } else { var toSettleList = dg.Items.OfType<SettledListModel>(); int count = 0; using (DataBaseConnector dbService = new DataBaseConnector()) { ObservableCollection<SettledListModel> settledAllListForChecks = new ObservableCollection<SettledListModel>(); if (ms!=null) { ms.Position = 0; settledAllListForChecks = (ObservableCollection<SettledListModel>)oldSettleAllListKeeper.Deserialize(ms); } bool savef = false; foreach (var row in toSettleList) { if (String.IsNullOrEmpty(row.RoomNumber)) { MessageBox.Show("Укажите комнату"); MakeDataGridRowFocused(dg, count); return; } string newRoomUUID = ""; try { newRoomUUID = RoomList.Where(t => t.RoomNumber == row.RoomNumber).First().UUID; } catch(NullReferenceException nullEx) { MessageBox.Show("Такого номера команты нет в базе данных"); return; } if (String.IsNullOrEmpty(row.RoomUUID)==false && row.RoomUUID != newRoomUUID) row.ViewModelStatus = RecordActions.Updated; else if (String.IsNullOrEmpty(row.RoomUUID)) row.ViewModelStatus = RecordActions.Inserted; //checks if (row.ViewModelStatus == RecordActions.Inserted || row.ViewModelStatus == RecordActions.Updated) { SettledListModel tempSettle = settledAllListForChecks.Where(t => t.UUID == row.UUID).FirstOrDefault(); if (tempSettle != null) tempSettle = row; else settledAllListForChecks.Add(row); if (settledAllListForChecks.Where(t => t.RoomNumber == row.RoomNumber).Count() > 4) { MessageBox.Show("В комнате " + row.RoomNumber + " теперь больше четырех человек"); MakeDataGridRowFocused(dg, count); return; } string roomSex = settledAllListForChecks.Where(t => t.RoomNumber == row.RoomNumber && t.PersonUUID != row.PersonUUID).Select(t => t.Sex).Distinct().ElementAtOrDefault(0); if (String.IsNullOrEmpty(roomSex)==false && roomSex!=row.Sex) { MessageBox.Show("В одной команте не могут быть жители разного пола"); MakeDataGridRowFocused(dg, count); return; } if (settledAllListForChecks.Where(t => t.PersonUUID == row.PersonUUID).Count() > 1) { MessageBox.Show("Человек селится больше, чем в одну комнату"); MakeDataGridRowFocused(dg, count); return; } row.SettledDate = DateTime.Now; if (String.IsNullOrEmpty(row.UUID)) row.UUID = Guid.NewGuid().ToString(); row.RoomUUID = newRoomUUID; dbService.HandleSettledListTable(row, t => (t.UUID == row.UUID), row.ViewModelStatus); List<IPersonInfo> persons = dbService.GetPersonRecords(t=>t.UUID==row.PersonUUID); if (persons!=null) { IPersonInfo person = persons[0]; person.RoomUUID = row.RoomUUID; dbService.HandlePersonInfoTable(person,t=>t.UUID==person.UUID,RecordActions.Updated); } else { MessageBox.Show("Невозможно найти человека"); return; } savef = true; } count++; } if (savef) { //MessageBox.Show("Saved"); int result = dbService.SaveChanges(); if (result > 0) { ms.Position = 0; settledAllList = settledAllListForChecks; oldSettleAllListKeeper.Serialize(ms, settledAllList); if (OnSettledListViewModelChanged != null) OnSettledListViewModelChanged(this, new EventArgs()); } else MessageBox.Show("Люди не заселены"); } } } }
private void DeleteButton_Click(object sender, RoutedEventArgs e) { PersonInfoModel pInfo = (PersonInfoModel)this.DataContext; using (DataBaseConnector dbService = new DataBaseConnector()) { dbService.HandlePersonInfoTable(pInfo, t => (t.UUID == pInfo.UUID), RecordActions.Deleted); if (pInfo.Payments != null && pInfo.Payments.Count > 0) { foreach (var payment in pInfo.Payments) { dbService.HandlePersonPaymentsTable(payment, t => (t.UUID == payment.UUID), RecordActions.Deleted); } if (removedPayments.Count > 0) { foreach (var payment in removedPayments) { dbService.HandlePersonPaymentsTable(payment, t => (t.UUID == payment.UUID), RecordActions.Deleted); } removedPayments = new List<PersonPaymentsModel>(); } } int result = dbService.SaveChanges(); if (result > 0) { if (ParentListView!=null) ParentListView.UpdatePersonList(pInfo, RecordActions.Deleted); this.Close(); } } }
public UserDetailsRepository(DataBaseConnector dataBaseConnector) { _dataBaseConnector = dataBaseConnector; }
public IEnumerable <Crop> GetAllWeeds() { return(DataBaseConnector.GetAllWeeds()); }
public IEnumerable <TrialType> GetTrialTypes() { return(DataBaseConnector.GetTrialTypes()); }
/// <summary> /// Constructeur /// </summary> public AuthenticationController() { //Construction du connecteur à la base de données model = new DataBaseConnector("db_pictionnary", "172.16.30.244", "pictionnary", ".Etml-"); model.Connect(); }
public DAOChofer() { this.connector = DataBaseConnector.getInstance(); }
public void UnSettleButton_Click(object sender, RoutedEventArgs e) { if (sender.GetType() != typeof(DataGrid)) { MessageBox.Show("Невозможно определить список"); return; } var dg = sender as DataGrid; if (dg == null) { MessageBox.Show("Невозможно определить список"); return; } else { var toUnSettleList = dg.Items.OfType<SettledListModel>(); int count = 0; using (DataBaseConnector dbService = new DataBaseConnector()) { ObservableCollection<SettledListModel> settledAllListForChecks = new ObservableCollection<SettledListModel>(); if (ms != null) { ms.Position = 0; settledAllListForChecks = (ObservableCollection<SettledListModel>)oldSettleAllListKeeper.Deserialize(ms); } bool savef = false; foreach (var row in toUnSettleList) { if (String.IsNullOrEmpty(row.RoomUUID) == false) row.ViewModelStatus = RecordActions.Deleted; //checks if (row.ViewModelStatus == RecordActions.Deleted) { SettledListModel tempSettle = settledAllListForChecks.Where(t => t.UUID == row.UUID).FirstOrDefault(); if (tempSettle != null) tempSettle = row; else { MessageBox.Show("Нельзя выселить. Неопредленная запись"); MakeDataGridRowFocused(dg, count); return; } if (String.IsNullOrEmpty(row.UUID)) { MessageBox.Show("Нельзя выселить. Неопредленная запись"); MakeDataGridRowFocused(dg, count); return; } row.RoomNumber = ""; row.SettledDate = DateTime.MinValue; row.RoomUUID = ""; dbService.HandleSettledListTable(row, t => (t.UUID == row.UUID), RecordActions.Deleted); settledAllListForChecks.Remove(row); savef = true; } count++; } if (savef) { //MessageBox.Show("Saved"); int result = dbService.SaveChanges(); if (result > 0) { ms.Position = 0; settledAllList = settledAllListForChecks; oldSettleAllListKeeper.Serialize(ms, settledAllList); if (OnSettledListViewModelChanged != null) OnSettledListViewModelChanged(this, new EventArgs()); } else MessageBox.Show("Люди не выселены"); } } } }
//public void RefreshButton_Click(object sender, RoutedEventArgs e) public void RefreshButton_Click() { using (DataBaseConnector dbService = new DataBaseConnector()) { List<ISettledList> tempSettledList = new List<ISettledList>(); List<IRoom> tempRoomList = new List<IRoom>(); foreach (var dbPer in Habitants) { bool foundf = false; tempSettledList = dbService.GetSettledListRecords(t => t.PersonUUID == dbPer.UUID).ToList(); if (tempSettledList.Count > 0) { string roomUUID = tempSettledList[0].RoomUUID; tempRoomList = dbService.GetRoomRecords(t => t.UUID == roomUUID).ToList(); if (tempRoomList.Count > 0) { dbPer.RoomNumber = tempRoomList[0].RoomNumber; dbPer.SettledDate = tempSettledList[0].SettledDate; foundf = true; } } if (foundf==false) { dbPer.RoomNumber = ""; dbPer.SettledDate = DateTime.MinValue; } } } }
public void InsertRowIntoManager(List<IPersonInfo> pInfoList) { SettledListModel settle; PropertyInfo[] propInfos; if (pInfoList != null) { using (DataBaseConnector dbService = new DataBaseConnector()) { propInfos = typeof(ISettledList).GetProperties(); foreach (var pInfo in pInfoList) { if (settledAllList==null) { settledAllList = new ObservableCollection<SettledListModel>(); List<ISettledList> tempSettleList = dbService.GetAllRecords<ISettledList>(); foreach (var setUnit in tempSettleList) { settle = new SettledListModel(); foreach (var curPropt in propInfos) { curPropt.SetValue(settle, curPropt.GetValue(setUnit)); } /*IPersonInfo pi = dbService.GetPersonRecords(t=>t.UUID==settle.PersonUUID).First(); if (pi!=null) { settle.FirstName = pi.FirstName; settle.LastName = pi.LastName; settle.Sex = pi.Sex; }*/ IRoom room = dbService.GetRoomRecords(t => t.UUID == settle.RoomUUID).First(); if (room!=null) { settle.RoomNumber = room.RoomNumber; } settledAllList.Add(settle); } if (oldSettleAllListKeeper == null) oldSettleAllListKeeper = new BinaryFormatter(); if (ms == null) ms = new MemoryStream(); else ms.Position = 0; oldSettleAllListKeeper.Serialize(ms, settledAllList); } List<SettledListModel> curSettleList = settledAllList.Where(t => t.PersonUUID == pInfo.UUID).ToList<SettledListModel>(); if (curSettleList.Count > 1) { MessageBox.Show("Невозможно добавить строку в менеджер поселения"); } else { if (curSettleList.Count == 1) { settle = curSettleList[0]; settle.FirstName = pInfo.FirstName; settle.LastName = pInfo.LastName; settle.Sex = pInfo.Sex; } else { settle = new SettledListModel(); settle.UUID = Guid.NewGuid().ToString(); settle.PersonUUID = pInfo.UUID; settle.FirstName = pInfo.FirstName; settle.LastName = pInfo.LastName; settle.Sex = pInfo.Sex; } ManagerList.Add(settle); } } } } }
private void LoginWin_onKeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Enter) { //FullFillDBWithRooms(); //FullFillDBWithFurniture(); try { using (DataBaseConnector dbService = new DataBaseConnector(5)) { PersonInfoModel viewPerson; IRoom dbRoom; List<IRoom> tempRoomList = new List<IRoom>(); PersonInfoListView hb = new PersonInfoListView(); ObservableCollection<PersonInfoModel> viewPersons = new ObservableCollection<PersonInfoModel>(); List<IPersonInfo> dbPersons = dbService.GetAllRecords<IPersonInfo>(); List<IRoom> dbRoomList = dbService.GetAllRecords<IRoom>(); PropertyInfo[] propInfos = typeof(IPersonInfo).GetProperties(); foreach (var dbPer in dbPersons) { viewPerson = new PersonInfoModel(); foreach (var curPropt in propInfos) { curPropt.SetValue(viewPerson, curPropt.GetValue(dbPer)); } tempRoomList = dbRoomList.Where(t => t.UUID == viewPerson.RoomUUID).ToList(); if (tempRoomList.Count>0) { dbRoom = tempRoomList[0]; viewPerson.RoomNumber = dbRoom.RoomNumber; } viewPersons.Add(viewPerson); } PersonInfoListViewModel hbViewModel = new PersonInfoListViewModel(viewPersons); hb.NewButton.Click += hbViewModel.NewButton_Click; hb.ManagerButton.Click += hbViewModel.ManagerButton_Click; hb.SchemeButton.Click += hbViewModel.SchemeButton_Click; hb.Redirect_HabitantsGridRow_DoubleClick += hbViewModel.Row_DoubleClick; hb.Redirect_HabitantsGridRow_MouseLeftButtonDown += hbViewModel.Row_MouseLeftButtonDown; hb.DataContext = hbViewModel; hb.Show(); } } catch (SqlException ex) { MessageBox.Show(ex.Message); } finally { this.Close(); } } }
public DAOFacturacion() { this.db = DataBaseConnector.getInstance(); }
private void SaveButton_Click(object sender, RoutedEventArgs e) { PersonInfoModel pInfo = (PersonInfoModel)this.DataContext; if (String.IsNullOrEmpty(pInfo.FirstName)) { MessageBox.Show("Укажите имя"); return; } if (String.IsNullOrEmpty(pInfo.LastName)) { MessageBox.Show("Укажите фамилию"); return; } if (String.IsNullOrEmpty(pInfo.Sex)) { MessageBox.Show("Укажите пол"); return; } using (DataBaseConnector dbService = new DataBaseConnector()) { bool savef = false; if (pInfo != null && pInfo.ViewModelStatus == RecordActions.Inserted) { pInfo.UUID = Guid.NewGuid().ToString(); dbService.HandlePersonInfoTable(pInfo, null, RecordActions.Inserted); savef = true; } else if (pInfo != null && pInfo.ViewModelStatus == RecordActions.Updated) { dbService.HandlePersonInfoTable(pInfo, t => (t.UUID == pInfo.UUID), RecordActions.Updated); savef = true; } if (pInfo.Payments != null && pInfo.Payments.Count > 0) { foreach (var payment in pInfo.Payments) { if (String.IsNullOrEmpty(payment.PersonUUID) == true) { payment.PersonUUID = pInfo.UUID; payment.UUID = Guid.NewGuid().ToString(); payment.ViewModelStatus = RecordActions.Inserted; } if (payment.ViewModelStatus == RecordActions.Inserted) dbService.HandlePersonPaymentsTable(payment, null, RecordActions.Inserted); else if (payment.ViewModelStatus == RecordActions.Updated) dbService.HandlePersonPaymentsTable(payment, t => (t.UUID == payment.UUID), RecordActions.Updated); } if (removedPayments.Count>0) { foreach (var payment in removedPayments) { if (String.IsNullOrEmpty(payment.UUID) == false) { dbService.HandlePersonPaymentsTable(payment, t => (t.UUID == payment.UUID), RecordActions.Deleted); } } removedPayments = new List<PersonPaymentsModel>(); } savef = true; } if (savef==true) { int result = dbService.SaveChanges(); if (result > 0) { if (ParentListView != null) ParentListView.UpdatePersonList(pInfo, pInfo.ViewModelStatus); InitialOperations(); ms.Position = 0; oldContextKeeper.Serialize(ms, pInfo); } } } }
public DAOListado() { this.db = DataBaseConnector.getInstance(); }
public SalaryDetailsRepository(DataBaseConnector dataBaseConnector) { _dataBaseConnector = dataBaseConnector; }
public static User GetUserFromEmailAndPassword(string email, string password, DataBaseConnector conn) { MySqlCommand getUser = UserQueryBank.GetSimpleUserQuery(conn.Connection); getUser.Parameters["@email"].Value = email; getUser.Parameters["@password"].Value = password; List <Dictionary <string, string> > result = conn.ExecuteCommand(getUser); if (result.Count == 0) { return(null); } User user = new User(); Dictionary <string, string> userAsDictionary = result[0]; user.Id = int.Parse(userAsDictionary["id_user"]); user.FirstName = userAsDictionary["first_name"]; user.LastName = userAsDictionary["last_name"]; user.Email = userAsDictionary["email"]; user.PlaceId = int.Parse(userAsDictionary["id_area"]); user.GenreId = int.Parse(userAsDictionary["id_favorite_genre"]); user.Year = int.Parse(userAsDictionary["birthday_year"]); user.Day = int.Parse(userAsDictionary["birthday_day"]); user.Month = int.Parse(userAsDictionary["birthday_month"]); MySqlCommand getSongs = UserQueryBank.GetUserSongsQuery(conn.Connection); getSongs.Parameters["@userId"].Value = user.Id; List <string> songs = conn.ExecuteOneColumnCommand(getSongs); user.Songs = songs; MySqlCommand getArtists = UserQueryBank.GetUserArtistsQuery(conn.Connection); getArtists.Parameters["@userId"].Value = user.Id; List <string> artists = conn.ExecuteOneColumnCommand(getArtists); foreach (string artist in artists) { user.AddArtist(int.Parse(artist)); } return(user); }
/// <summary> /// Конструктор /// </summary> /// <param name="connector">Коннектор базы данных</param> /// <param name="output">Класс вывода</param> public DataBase(DataBaseConnector connector, DataBaseOutput output) { this.connector = connector; this.output = output; }
public DAORoles() { this.connector = DataBaseConnector.getInstance(); }
public DataTable getAllCars() { DataBaseConnector db = DataBaseConnector.getInstance(); return db.select_query("SELECT AUTOS.Patente,MODELOS.Description,TURNOS.Descripcion,PERSONAS.Apellido,PERSONAS.Nombre FROM FSOCIETY.Autos AUTOS LEFT JOIN FSOCIETY.Modelos MODELOS ON AUTOS.IdModelo = MODELOS.Id LEFT JOIN FSOCIETY.Turnos TURNOS ON AUTOS.IdTurno = TURNOS.Id LEFT JOIN FSOCIETY.Personas PERSONAS ON AUTOS.IdChofer = PERSONAS.Id"); }
public DAORendicionViaje() { this.connector = DataBaseConnector.getInstance(); }
public IEnumerable <TopResult> GetTopResults() { return(DataBaseConnector.GetTopResults()); }
public QuestionDataService(DataBaseConnector dbc) { _dbc = dbc; _db = _dbc.getDBInstance(); }
public PlayerDataService(DataBaseConnector dbc) { _dbc = dbc; _db = _dbc.getDBInstance(); }
public LevelSuccessTimeService(DataBaseConnector dbc) { _dbc = dbc; _db = _dbc.getDBInstance(); }
public void doSearch() { /* * SELECT * * FROM Products * where UserId<>'245875698' AND type='Nadlan' AND RentDateFrom > #3/1/1996# AND RentDateTo < #3/1/2019# AND Condition='New' AND Bundle=true AND Purpose='loan' */ string query = "Select * From Products INNER JOIN " + this.category + " ON Products.ProductID=" + this.category + ".ProductID Where Products.category='" + this.category + "' "; query += "AND Products.RentDateFrom <= #" + this.from + "# "; query += "AND Products.RentDateTo >= #" + this.to + "# "; /*if (this.userID.Length > 0) * { * query += "AND UserId<>'" + this.userID + "' "; * }*/ if (this.purpose != null) { query += "AND Products.Purpose='" + this.purpose + "' "; } if (this.condition != null) { query += "AND Products.Condition='" + this.condition + "' "; } /* * if (this.composition != null) * { * Boolean isBundel = this.composition.Equals("Bundle"); * query += "AND Products.Bundle=" + isBundel + " "; * } */ OleDbDataReader result = DataBaseConnector.sql(query); // temp for example if (!result.HasRows) { MessageBox.Show("No Results Found! \n Please Try again"); return; } productsToDisplay = new List <ProductListingModel>(); result.Read(); do { //string value=(string)result.GetValue(0).ToString(); email = result.GetString(0); productId = result.GetValue(1).ToString(); purpose = result.GetValue(2).ToString(); from = result.GetValue(3).ToString(); to = result.GetString(4); price = result.GetValue(5).ToString(); addons = result.GetString(6); deposite = result.GetValue(7).ToString(); condition = result.GetString(8); description = result.GetString(9); category = result.GetString(10); composition = result.GetValue(12).ToString(); // breed = result.GetValue(13).ToString(); // age = result.GetValue(14).ToString(); // sex = result.GetString(15); ProductListingModel product = new ProductListingModel(productId, description, composition, condition, category, purpose, from, to, price, addons); Dictionary <string, string> props = new Dictionary <string, string>(); populateProps(result, props); product.props = props; productsToDisplay.Add(product); }while (result.Read()); /* * else if (this.category.Equals("Nadlan")) * { * productsToDisplay = new List<ProductListingModel>(); * result.Read(); * do * { * //string value=(string)result.GetValue(0).ToString(); * email = result.GetString(0); * productId = result.GetValue(1).ToString(); * purpose = result.GetValue(2).ToString(); * from = result.GetValue(3).ToString(); * to = result.GetString(4); * price = result.GetValue(5).ToString(); * addons = result.GetString(6); * deposite = result.GetValue(7).ToString(); * condition = result.GetString(8); * description = result.GetString(9); * category = result.GetString(10); * composition = result.GetValue(12).ToString(); * breed = result.GetValue(13).ToString(); * age = result.GetValue(14).ToString(); * sex = result.GetString(15); * ProductListingModel pets = new Pets(productId, description, composition, condition, category, purpose, from, to, sex, age, breed); * productsToDisplay.Add(pets); * } * while (result.Read()); * } * else if (this.category.Equals("Vehicle")) * { * productsToDisplay = new List<ProductListingModel>(); * result.Read(); * do * { * //string value=(string)result.GetValue(0).ToString(); * email = result.GetString(0); * productId = result.GetValue(1).ToString(); * purpose = result.GetValue(2).ToString(); * from = result.GetValue(3).ToString(); * to = result.GetString(4); * price = result.GetValue(5).ToString(); * addons = result.GetString(6); * deposite = result.GetValue(7).ToString(); * condition = result.GetString(8); * description = result.GetString(9); * category = result.GetString(10); * composition = result.GetValue(12).ToString(); * breed = result.GetValue(13).ToString(); * age = result.GetValue(14).ToString(); * sex = result.GetString(15); * ProductListingModel pets = new Pets(productId, description, composition, condition, category, purpose, from, to, sex, age, breed); * productsToDisplay.Add(pets); * } * while (result.Read()); * } * else if (this.category.Equals("SecondHand")) * { * productsToDisplay = new List<ProductListingModel>(); * result.Read(); * do * { * //string value=(string)result.GetValue(0).ToString(); * email = result.GetString(0); * productId = result.GetValue(1).ToString(); * purpose = result.GetValue(2).ToString(); * from = result.GetValue(3).ToString(); * to = result.GetString(4); * price = result.GetValue(5).ToString(); * addons = result.GetString(6); * deposite = result.GetValue(7).ToString(); * condition = result.GetString(8); * description = result.GetString(9); * category = result.GetString(10); * composition = result.GetValue(12).ToString(); * breed = result.GetValue(13).ToString(); * age = result.GetValue(14).ToString(); * sex = result.GetString(15); * ProductListingModel pets = new Pets(productId, description, composition, condition, category, purpose, from, to, sex, age, breed); * productsToDisplay.Add(pets); * } * while (result.Read()); * } */ // 1) go back to the point where you had the filtered product list // 2) once you get the OleDbDataReader result for products table you need to map it into objects // 3) meanwhile we'll use a mockup: /* // our goal is to create a list of products models * ProductListingModel productMock1 = new ProductListingModel("PET1", this.composition, this.condition, this.category, this.purpose, this.from, this.to); * ProductListingModel productMock2 = new ProductListingModel("PET2", this.composition, this.condition, this.category, this.purpose, this.from, this.to); * ProductListingModel productMock3 = new ProductListingModel("PET3", this.composition, this.condition, this.category, this.purpose, this.from, this.to); * ProductListingModel productMock4 = new ProductListingModel("PET4", this.composition, this.condition, this.category, this.purpose, this.from, this.to); */ // do it with a for loop :) /* * productsToDisplay.Add((ProductListingModel)pets); * productsToDisplay.Add(productMock2); * productsToDisplay.Add(productMock3); * productsToDisplay.Add(productMock4); */ Router.root.listingView.cleanPanel(); Router.root.listingView.populateListingView(productsToDisplay, this.category); Router.navigate("SEARCH", "RENT_LISTING"); /*DataTable table= result.GetSchemaTable(); * while (result.Read()) * { * string companyCode = reader.GetValue(0).ToString(); * string agentId = reader.GetString(1); * string firstName = reader.GetString(2); * string lastName = reader.GetString(3); * string nameSuffix = reader.GetString(4); * string corporateName = reader.GetString(5); * string entityType = reader.GetString(6); * string obfSSN = reader.GetString(7); * string obfFEIN = reader.GetString(8); * string dummyIndicator = reader.GetString(9); * // Insert code to process data. * }*/ }
public DaoViajes() { this.db = DataBaseConnector.getInstance(); }