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