private void SetLodgerTab() { ISLodger lodger = DBLodgers.GetLodgerById(user.Id); _SetLodgerInfo(lodger); List <ISCard> cards = DBCards.GetCardsById(user.Id); if (cardsGrid.Rows.Count > 0) { cardsGrid.Rows.Clear(); } if (cards.Count > 0) { for (int i = 0; i < cards.Count; i++) { ISCard c = cards[i]; int id = c.Id; string cardNumber = c.CardNumber; string expirationDate = c.ExpirationDate; cardsGrid.Rows.Add(new string[] { (i + 1).ToString(), id.ToString(), cardNumber, expirationDate }); } } }
public static ISLodger GetLodgerById(int userId) { ISLodger lodger = null; using (MySqlConnection conn = DBUtils.GetConnection()) { try { conn.Open(); using (var command = new MySqlCommand($"SELECT * FROM lodgers WHERE userId = {userId}", conn)) using (var reader = command.ExecuteReader()) { if (reader.Read()) { int id = Convert.ToInt32(reader[0]); int uId = Convert.ToInt32(reader[1]); int currentMoneyAmmount = Convert.ToInt32(reader[2]); string agreementAcceptedDate = reader[3].ToString().Split(' ')[0]; int paymentAmmount = Convert.ToInt32(reader[4]); lodger = new ISLodger(id, uId, currentMoneyAmmount, agreementAcceptedDate, paymentAmmount); return(lodger); } } } catch (Exception err) { MessageBox.Show("Error: " + err.Message, "Ошибка!"); } } return(null); }
private void _SetLodgerInfo(ISLodger lodger) { lodgerIdField.Text = lodger.Id.ToString(); agreementAcceptedDateField.Text = lodger.AgreementAcceptedDate; currentMoneyAmmountField.Text = lodger.CurrentMoneyAmmount.ToString(); paymentAmmountField.Text = lodger.PaymentAmmount.ToString(); notEnougthMoneyField.Visible = lodger.CurrentMoneyAmmount < lodger.PaymentAmmount ? true : false; }