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(); }
protected void Page_Load(object sender, EventArgs e) { InitializeStairCases(); var idExes = Request.QueryString["id_exes"]; int idExpenseEstate; if (int.TryParse(idExes, out idExpenseEstate)) { AssociationExpenses ee = AssociationExpensesManager.GetById(idExpenseEstate); if (ee != null) { btnRedirect.PostBackUrl = "Invoices.aspx?year=" + ee.Year + "&month=" + ee.Month; btnRedirect.Visible = true; lblExpenseMeessage.Text = "Modifică <b>" + ee.Expenses.Name + "</b> pe luna <b>" + CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(ee.Month) + "</b> (cheltuială " + ee.ExpenseTypes.Name + ")"; if (ee.ExpenseTypes.Id == (int)ExpenseType.PerIndex) { DataTable dt = new DataTable(); if (!Page.IsPostBack) { //todo1 - work around counters and staircase //txtExpensesPerIndexValue.Text = ee.AssociationExpensesUnitPrices.FirstOrDefault().PricePerExpenseUnit.ToString(); } if (ViewState["dtPerIndex"] == null) { InitializeGridViewExpensesPerIndex(dt, ee.Id); } else { dt = (DataTable)ViewState["dtPerIndex"]; ViewState["dtPerIndex"] = dt; gvExpensesPerIndex.DataSource = dt; } } else { throw new ArgumentException("Expense type not per index"); } } else { throw new ArgumentException("AddEditExpenseRequest parameter does not exist"); } } else { throw new ArgumentException("AddEditExpenseRequest parameter not correct"); } }
public void ClickablePanel1_Click(object sender, EventArgs e) { Button btn = (Button)sender; int associationExpenseId; if (int.TryParse(btn.CommandArgument, out associationExpenseId)) { var associationExpense = AssociationExpensesManager.GetById(associationExpenseId); if (associationExpense == null) { return; } Response.Redirect("~/Invoices/Add.aspx?year=" + year() + "&month=" + month() + "&expense=" + associationExpense.Id_Expense); } }
private void InitializeGridViewExpensesPerIndex(DataTable dt, int esexId) { AssociationExpenses ee = AssociationExpensesManager.GetById(esexId); int stairCase; List <Administratoro.DAL.Apartments> apartments; if (Association.HasStaircase && !string.IsNullOrEmpty(drpStairCases.SelectedValue) && int.TryParse(drpStairCases.SelectedValue, out stairCase)) { apartments = ApartmentsManager.GetAllThatAreRegisteredWithSpecificCounters(Association.Id, esexId, stairCase); } else { apartments = ApartmentsManager.GetAllThatAreRegisteredWithSpecificCounters(Association.Id, esexId); } ApartmentExpensesManager.ConfigurePerIndex(ee, apartments); foreach (var apartment in apartments) { string query = @" Select AE.Id as Id, A.Number as Apartament, cast(AE.IndexOld as float) as 'Index vechi', cast(AE.IndexNew as float) as 'Index nou', (AE.IndexNew - AE.IndexOld ) as 'Consum', AE.Value as 'Valoare' from ApartmentExpenses AE Inner join Apartments A ON AE.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["dtPerIndex"] = dt; gvExpensesPerIndex.DataSource = dt; gvExpensesPerIndex.DataBind(); }