75
{
dataGridViewl.Rows. Add();
dataGridView1.Rows[i].Cells[0].Value = "Истекающий договор
аренды помещения" + aRow["Ciph"].ToString();
dataGridView1.Rows[i].Cells[1].Value = aRow["DtEnd"].ToString();
i++;
}
string cs =
ConfigurationManager.ConnectionStrings["Arenda.Properties.Settings.ArendaConnect
ionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(cs))
using (SqlCommand cmd = new SqlCommand("IOplata", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
var adapter = new SqlDataAdapter(cmd);
var dataContainer = new DataSet();
adapter.Fill(dataContainer);
int i = 0;
foreach (DataRow aRow in adapter.Rows)
{
dataGridView1.Rows. Add();
dataGridView1.Rows[i].Cells[0].Value = "Истекающая оплата
договора аренды помещения" + aRow["Ciph"].ToString();
dataGridView1.Rows[i].Cells[1].Value = aRow["DtEnd"].ToString();
i++;
}
76
}
private void HOBb^n,oroBopToolStripMenuItem_Click(object sender,
EventArgs e)
{
Contract F = new Contract();
F.Show();
}
private void договораToolStripMenuItem_Click(object sender, EventArgs
e)
{
Lease F = new Lease();
F.Show();
}
private void apeHgaTOpbiToolStripMenuItem_Click(object sender,
EventArgs e)
{
Tenant F = new Tenant();
F.Show();
}
private void зданияToolStripMenuItem_Click(object sender, EventArgs e)
{
Building F = new Building();
F.Show();
}
private void помещенияToolStripMenuItem_Click(object sender,
EventArgs e)
{
Room F = new Room();
F.Show();
77
private void ^HbiToolStripMenuItem1_Click(object sender, EventArgs e)
{
Price F = new Price();
F.Show();
}
private void CK^g^ToolStripMenuItem_Click(object sender, EventArgs e)
{
Sale F = new Sale();
F.Show();
}
private void сотрудникиToolStripMenuItem_Click(object sender,
EventArgs e)
{
Worker F = new Worker();
F.Show();
}
private void пользователиToolStripMenuItem_Click(object sender,
EventArgs e)
{
UserData F = new UserData();
F.Show();
}
private void настройкиПодключенияToolStripMenuItem_Click(object
sender, EventArgs e)
{
}
Settengs F = new Settengs();
78
F.Show();
}
private void onaaTaToolStripMenuItem_Click(object sender, EventArgs e)
{
Payment F = new Payment();
F.Show();
}
private void comboBox1_SelectionChangeCommitted(object sender,
EventArgs e)
{
this.roomTableAdapter.FillByIDBuilding(this.arendaDataSet.Room,
Convert.ToInt32(comboBox1.ValueMember));
}
private void истекающиеДоговораToolStripMenuItem_Click(object
sender, EventArgs e)
{
Report1 F = new Report1();
F.Show();
}
}
}