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;
}
