protected void Page_Init(object sender, EventArgs e) { if (!Page.IsPostBack) { InitializeCounters(); } else { gvCounters.DataBind(); } var assoc = Association; txtAssociationName.Text = assoc.Name; txtAssociationAddress.Text = assoc.Address; txtAssociationFiscalCode.Text = assoc.FiscalCode; txtAssociationBanckAccount.Text = assoc.BanckAccont; txtPenaltyRate.Text = assoc.penaltyRate.HasValue ? (assoc.penaltyRate.Value * 100).ToString(new CultureInfo("ro-RO")) : string.Empty; drpAssociationEqualIndiviza.SelectedValue = (assoc.CotaIndivizaAparments.HasValue) ? "1" : "0"; if (assoc.CotaIndivizaAparments.HasValue) { txtAssociationCotaIndivizaApartments.Text = assoc.CotaIndivizaAparments.Value.ToString(CultureInfo.InvariantCulture); btnAssociationEqualIndiviza.Visible = true; txtAssociationCotaIndivizaApartments.Visible = true; } //todo refactor, use SP var apartments = ApartmentsManager.Get(assoc.Id); tbFondReparatii.Text = apartments.Sum(a => a.FondReparatii).ToString(); tbFondRulment.Text = apartments.Sum(a => a.FondRulment).ToString(); InitializeStairs(); }
private void InitializeUsersTable() { var apartments = ApartmentsManager.Get(Association.Id); foreach (Administratoro.DAL.Apartments ap in apartments) { TableRow row = new TableRow(); HyperLink linkEditUser = new HyperLink { NavigateUrl = "~/Apartments/Add.aspx?apartmentid=" + ap.Id, CssClass = "toClickOn", Text = "Editează" }; TableCell userEditCell = new TableCell(); userEditCell.Controls.Add(linkEditUser); row.Cells.Add(userEditCell); TableCell tentantNr = new TableCell { Text = ap.Number.ToString() }; row.Cells.Add(tentantNr); TableCell tentantName = new TableCell { Text = ap.Name }; row.Cells.Add(tentantName); TableCell userPhone = new TableCell { Text = ap.Telephone }; row.Cells.Add(userPhone); TableCell userEmail = new TableCell { Text = ap.Email }; row.Cells.Add(userEmail); TableCell userDependents = new TableCell { Text = ap.Dependents.ToString() }; row.Cells.Add(userDependents); TableCell userSurface = new TableCell { Text = ap.CotaIndiviza.ToString() }; row.Cells.Add(userSurface); datatableResponsive.Rows.Add(row); } }
private void InitializeApartments() { var ap = ApartmentsManager.Get(Association.Id); drpApartments.Items.Add(new ListItem { Text = string.Empty, Value = "-1" }); foreach (var apartment in ap) { drpApartments.Items.Add(new ListItem { Value = apartment.Id.ToString(), Text = apartment.Number + ": " + apartment.Name }); } }
private void InitializeYearMonth() { drpApartaments.Items.Clear(); drpApartaments.Items.Add(new ListItem { Value = string.Empty, Text = string.Empty }); var apartments = ApartmentsManager.Get(Association.Id); foreach (var apartment in apartments) { drpApartaments.Items.Add(new ListItem { Value = apartment.Id.ToString(), Text = "Ap. " + apartment.Number + " : " + apartment.Name }); } }
protected void btnDownload_Click(object sender, EventArgs e) { BaseFont bfTimes = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1250, false); Font times = new Font(bfTimes, 12, Font.ITALIC, BaseColor.BLACK); //server folder path which is stored your PDF documents string path = Server.MapPath(""); string filename = path + "\\Doc1.pdf"; var apartments = ApartmentsManager.Get(Association.Id); Font boldFont = new Font(null, 12, Font.BOLD); //Create new PDF document Document document = new Document(PageSize.A4, 80f, 80f, 20f, 20f); using (Document doc = new Document()) { MemoryStream msPDFData = new MemoryStream(); doc.Open(); doc.Add(new Paragraph("I'm a pdf!")); byte[] pdfData = msPDFData.ToArray(); } var association = Association; try { PdfWriter.GetInstance(document, new FileStream(filename, FileMode.Create)); document.Open(); foreach (var apartment in apartments) { decimal? sumToPay = 0; PdfPTable tblHeader = new PdfPTable(2) { WidthPercentage = 100 }; tblHeader.AddCell(GetCell("ASOCIATIA DE PROPRIETARI " + association.Name + ", CF " + association.FiscalCode, PdfPCell.ALIGN_LEFT)); tblHeader.AddCell(GetCell("CONTUL BANCAR " + association.BanckAccont, PdfPCell.ALIGN_RIGHT)); document.Add(tblHeader); document.Add(new Phrase("\n")); PdfPTable tbAp = new PdfPTable(4); tbAp.WidthPercentage = 100; tbAp.AddCell(GetCell("Ap.: " + apartment.Number, PdfPCell.ALIGN_CENTER)); tbAp.AddCell(GetCell("Nume: " + apartment.Name, PdfPCell.ALIGN_CENTER)); tbAp.AddCell(GetCell("Cota: " + (apartment.CotaIndiviza.HasValue ? apartment.CotaIndiviza.Value.ToString(CultureInfo.InvariantCulture) : string.Empty), PdfPCell.ALIGN_CENTER)); tbAp.AddCell(GetCell("Nr. Pers: " + apartment.Dependents, PdfPCell.ALIGN_CENTER)); document.Add(tbAp); document.Add(new Phrase("\n")); var associationExpensesGrouped = AssociationExpensesManager.GetByMonthAndYearNotDisabled(association.Id, GetYear(), GetMonth()) .GroupBy(ee => ee.Id_ExpenseType).OrderBy(er => er.Key); foreach (var assocExpenses in associationExpensesGrouped) { // add header document.Add(new Paragraph("Cheltuielile de tipulîățșț " + assocExpenses.FirstOrDefault().ExpenseTypes.Name, times)); if (assocExpenses.FirstOrDefault().Id_ExpenseType == (int)ExpenseType.PerIndex) { foreach (var assocExpense in assocExpenses) { var apExpenses = assocExpense.ApartmentExpenses.Where(w => w.Id_Tenant == apartment.Id).ToList(); if (apExpenses.Any()) { sumToPay = sumToPay + AddIndexTable(document, apExpenses, apartment, assocExpense.Id); } } } else if (assocExpenses.FirstOrDefault().Id_ExpenseType == (int)ExpenseType.PerCotaIndiviza) { sumToPay = sumToPay + AddCotaTable(document, assocExpenses.ToList(), apartment.Id); } else if (assocExpenses.FirstOrDefault().Id_ExpenseType == (int)ExpenseType.PerNrTenants) { sumToPay = sumToPay + AddTenantsTable(document, assocExpenses.ToList(), apartment.Id); } // add rows // add subtotal } document.Add(new Paragraph("TOTAL DE PLATA: " + sumToPay, boldFont)); document.NewPage(); } } catch (Exception) { } finally { document.Close(); ShowPdf(filename); } }