private void RetrivingHistoryInformation(ViewClientCard clientCard, int ClientId) { string queryString = "SELECT InventNum, FilmName, DistrDate, ReturnDate, CountOfDay, FilmPrice, Penny, TotalAmount FROM ClientHistory WHERE ClientId='" + ClientId + "';"; cmd.CommandText = queryString; cmd.Connection = connection; try { connection.Open(); SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Scrollable); if (rs.HasRows) { while (rs.Read()) { string[] rowI = new string[] { (rs["InventNum"]).ToString(), (rs["FilmName"]).ToString(), (rs["DistrDate"]).ToString(), (rs["ReturnDate"]).ToString(), (rs["CountOfDay"]).ToString(), (rs["FilmPrice"]).ToString(), (rs["Penny"]).ToString(), (rs["TotalAmount"]).ToString() }; clientCard.ClientDataGridView.Rows.Add(rowI); for (int i = 0; i < clientCard.ClientDataGridView.RowCount; i++) { DataGridViewRow dataGridViewRow = clientCard.ClientDataGridView.Rows[i]; if (dataGridViewRow.IsNewRow) { continue; } if (dataGridViewRow.Cells["Дата возврата"].Value.ToString() != "-") { dataGridViewRow.DefaultCellStyle.BackColor = Color.BlueViolet; } } } } rs.Close(); connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void SearchDataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { ViewClientCard clientCard = new ViewClientCard(this); rowClientId = Convert.ToInt16(this.SearchDataGridView.CurrentRow.Cells["Id"].Value); RetrivingInfoFromBusyFilmCopy(clientCard, rowClientId); RetrivingHistoryInformation(clientCard, rowClientId); clientCard.ClientTextBox.Text = this.SearchDataGridView.CurrentRow.Cells["Фамилия"].Value.ToString() + " " + this.SearchDataGridView.CurrentRow.Cells["Имя"].Value.ToString() + " " + this.SearchDataGridView.CurrentRow.Cells["Отчество"].Value.ToString(); clientCard.GenderTextBox.Text = this.SearchDataGridView.CurrentRow.Cells["Пол"].Value.ToString(); clientCard.AgeTextBox.Text = this.SearchDataGridView.CurrentRow.Cells["Возраст"].Value.ToString(); clientCard.RegistrDateTextBox.Text = this.SearchDataGridView.CurrentRow.Cells["Дата регистрации"].Value.ToString(); clientCard.Show(); }
private void RetrivingInfoFromBusyFilmCopy(ViewClientCard clientCard, int clientId) { string queryString = "SELECT Film.Жанр, Film.Id, Film.Название, Film.[Тип носителя], BusyFilmCopy.CopyId, BusyFilmCopy.DistrDate FROM Film, BusyFilmCopy WHERE BusyFilmCopy.ClientId='" + clientId + "' AND BusyFilmCopy.FilmId=Film.Id;"; cmd.CommandText = queryString; cmd.Connection = connection; try { connection.Open(); SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Scrollable); string filmInvNum = ""; short flag = 0; if (rs.HasRows) { while (rs.Read()) { int FilmId = Convert.ToInt32(rs["Id"]); int CopyId = Convert.ToInt32(rs["CopyId"]); if (FilmId >= 1 && FilmId < 10) { if (CopyId >= 1 && CopyId < 10) { filmInvNum = (rs["Жанр"]).ToString().Substring(0, 2).ToUpper() + "00" + FilmId + "0" + CopyId; } if (CopyId >= 10 && CopyId < 100) { filmInvNum = (rs["Жанр"]).ToString().Substring(0, 2).ToUpper() + "00" + FilmId + "" + CopyId; } } else if (FilmId >= 10 && FilmId < 100) { if (CopyId >= 1 && CopyId < 10) { filmInvNum = (rs["Жанр"]).ToString().Substring(0, 2).ToUpper() + "0" + FilmId + "0" + CopyId; } if (CopyId >= 10 && CopyId < 100) { filmInvNum = (rs["Жанр"]).ToString().Substring(0, 2).ToUpper() + "0" + FilmId + "" + CopyId; } } else if (FilmId >= 100 && FilmId < 1000) { if (CopyId >= 1 && CopyId < 10) { filmInvNum = (rs["Жанр"]).ToString().Substring(0, 2).ToUpper() + "" + FilmId + "0" + CopyId; } if (CopyId >= 10 && CopyId < 100) { filmInvNum = (rs["Жанр"]).ToString().Substring(0, 2).ToUpper() + "" + FilmId + "" + CopyId; } } string filmPrice = new Film((rs["Тип носителя"]).ToString()).RentalPrice.ToString(); DateTime distributionDate = Convert.ToDateTime(rs["DistrDate"]); //DateTime returnedDate = DateTime.Now; //Convert.ToDateTime(rs["ReturnDate"]); int daysCount = Rental.GetExpireDays(distributionDate, DateTime.Now); if (daysCount != 0) { flag++; clientCard.ClientDataGridView.Rows.Add(new string[] { filmInvNum, (rs["Название"]).ToString(), distributionDate.ToShortDateString(), "-", daysCount.ToString(), filmPrice, Rental.CountOfPenny(distributionDate, DateTime.Now).ToString(), Rental.GetTotalRentalAmount(filmPrice, distributionDate, DateTime.Now).ToString() }); } else { clientCard.ClientDataGridView.Rows.Add(new string[] { filmInvNum, (rs["Название"]).ToString(), distributionDate.ToShortDateString(), "-", daysCount.ToString(), filmPrice, "-", Rental.GetTotalRentalAmount(filmPrice, distributionDate, DateTime.Now).ToString() }); } if (flag != 0) { clientCard.DebtTextBox.Text = "Да"; } else { clientCard.DebtTextBox.Text = "Нет"; } } } rs.Close(); connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }