private void InitializeGridViewExpensesPerIndex(DataTable dt, int esexId)
{
var apartments = ApartmentsManager.GetForIndividual(Association.Id, esexId);
AssociationExpenses ee = AssociationExpensesManager.GetById(esexId);
foreach (var apartment in apartments)
{
ApartmentExpensesManager.ConfigureIndividual(ee, apartment);
string query = @"
Select
TE.Id as Id,
A.Number as Apartament,
TE.Value as 'Valoare'
from ApartmentExpenses TE
Inner join Apartments A
ON TE.Id_Tenant = A.Id
where Id_EstateExpense = " + esexId + " and Id_Tenant = " + apartment.Id +
" and A.Id_Estate = " + Association.Id;
SqlConnection cnn = new SqlConnection("data source=HOME\\SQLEXPRESS;initial catalog=Administratoro;integrated security=True;MultipleActiveResultSets=True;");
SqlCommand cmd = new SqlCommand(query, cnn);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
}
ViewState["dtIndividual"] = dt;
gvExpensesPerIndex.DataSource = dt;
gvExpensesPerIndex.DataBind();
}
