public static void UpdateFonds(int apartamentId, DebtType debtType, decimal amount) { var result = GetContext().Apartments.FirstOrDefault(b => b.Id == apartamentId); if (result != null) { if (debtType == DebtType.RulmentFond) { if (result.FondRulment == null) { result.FondRulment = 0m; } result.FondRulment = result.FondRulment + amount; } else if (debtType == DebtType.Repairfond) { if (result.FondReparatii == null) { result.FondReparatii = 0m; } result.FondReparatii = result.FondReparatii + amount; } GetContext().Entry(result).CurrentValues.SetValues(result); GetContext().SaveChanges(); } }
public OperationResult Create(DebtType debtType, long referenceUserId, decimal amount, string description) { try { using (YomContainer container = GetYomContainer()) { Item item = container.Items.Add(new Item { Type = (short)debtType, UserId = UserService.UserGetCurrent().Id, OweItem = new OweItem { Amount = amount, ReferenceUser = referenceUserId, Description = description, } }); container.SaveChanges(); } return OperationResult.Success; } catch (Exception e) { return OperationResult.Error(e.Message); } }
public async Task CreateDebtAsync(Debt debt, DebtType debtType) { var classInstallments = new InstallmentsContext(); if (debtType == DebtType.Card) { debt.Date = CardRules.CardDateRule(debt.Card.ClosureDate, debt.Card.DueDate, debt).Date; } // TODO ver forma de fazer isso melhor if (debt.DebtInstallmentType == DebtInstallmentType.Simple) { classInstallments.SetStrategy(new CreateSimpleInstallments()); } else if (debt.DebtInstallmentType == DebtInstallmentType.Fixed) { classInstallments.SetStrategy(new CreateFixedInstallments()); } else if (debt.DebtInstallmentType == DebtInstallmentType.Installment) { classInstallments.SetStrategy(new CreateInstallments()); } var installments = classInstallments.CreateInstallments(debt); debt.Installments = installments; debt.Id = Guid.NewGuid(); debt.CreatedAt = DateTime.Now; debt.DebtType = debtType; await _debtRepository.AddAsync(debt); }
private void comboBoxType_SelectedIndexChanged(object sender, EventArgs e) { if (comboBoxType.SelectedIndex != (int)debtType) { debtType = (DebtType)comboBoxType.SelectedIndex; OnDebtPropertiesChanged(); } }
/// <summary> /// Получить список строк задолженностей. /// </summary> /// <param name="type">Тип задолженности</param> /// <param name="month">Месяц</param> /// <param name="year">Год</param> /// <returns>Список строк задолженностей</returns> public static IList <DebtRow> GetDebtRows(DebtType type, int month, int year) { CheckInitialization(); return(session.CreateCriteria(typeof(DebtRow)). Add(Expression.Eq("DebtType", type)). Add(Expression.Eq("Month", month)). Add(Expression.Eq("Year", year)). List <DebtRow>()); }
public static byte[] GenerateFondsReport(int apartmentId, DebtType debtType) { var stringFormatH1 = "<h1>{0}</h1>"; var stringFormatH2 = "<h2>{0}</h2>"; var nrCrt = 0; decimal rulajIncome = 0; decimal rulajOutcome = 0; var sb = new StringBuilder(); var apartament = ApartmentsManager.GetById(apartmentId); if (apartament == null) { return(ConverterHelper.ConvertHtMLtoBytes(sb.ToString())); } var debts = ApartmentDebtsManager.GetAllPaidOfType(apartmentId, debtType); if (debtType == DebtType.RulmentFond && apartament.FondRulment.HasValue) { sb.Append(string.Format(stringFormatH1, "Fisa fond de rulment ")); sb.Append(string.Format(stringFormatH2, "Suma disponibila in fondul de rulment: " + apartament.FondRulment)); } else if (debtType == DebtType.Repairfond && apartament.FondReparatii.HasValue) { sb.Append(string.Format(stringFormatH1, "Fisa fond de reparații ")); sb.Append(string.Format(stringFormatH2, "Suma disponibila in fondul de reparatii: " + apartament.FondReparatii)); } sb.Append("<br><br>"); sb.Append("<table border='1'>"); sb.Append("<tr>"); sb.Append("<td>Nr Crt</td><td>Data</td><td>Explicații</td><td>Încasat</td><td>Restituit</td><td>Sold contabil</td><td>Sold restant</td>"); sb.Append("</tr>"); foreach (var debt in debts) { nrCrt++; var income = (debt.Value.HasValue) ? debt.Value.Value.ToString() : string.Empty; var createdDate = (debt.created.HasValue) ? debt.created.Value.ToShortDateString() : string.Empty; sb.Append("<tr>"); sb.Append("<td>" + nrCrt + "</td>"); sb.Append("<td>" + createdDate + "</td>"); sb.Append("<td>" + debt.Year + " " + debt.Month + "</td>"); sb.Append("<td>" + income + "</td>"); sb.Append("<td>" + "- </td>"); sb.Append("<td>" + "</td>"); sb.Append("<td>" + "</td>"); sb.Append("</tr>"); } sb.Append("</table>"); sb.Append("<br><br>"); return(ConverterHelper.ConvertHtMLtoBytes(sb.ToString())); }
/// <summary> /// Получить список строк задолженностей. /// </summary> /// <param name="type">Тип задолженности</param> /// <param name="month">Месяц</param> /// <param name="year">Год</param> /// <param name="budget">Бюджет</param> /// <returns>Список строк задолженностей</returns> public static IList <DebtRow> GetDebtRows(DebtType type, int month, int year, string budgetName) { CheckInitialization(); return(session.CreateQuery("from DebtRow r where DebtType = ? and Month = ? and Year = ? and r.Subject.BudgetName = ?"). SetInt32(0, (Int32)type). SetInt32(1, month). SetInt32(2, year). SetString(3, budgetName). List <DebtRow>()); }
public Report1ParamForm(DebtType type, int month, int year) { InitializeComponent(); DebtProperties.DebtType = type; DebtProperties.Month = month; DebtProperties.Year = year; comboBoxBudgetName.Items.Add("<Все бюджеты>"); comboBoxBudgetName.Items.AddRange(DebtDAO.GetBudgets()); comboBoxBudgetName.SelectedIndex = 0; }
private HouseholdDebtTracker.DAL.Models.DebtType MapToDALDebtType(DebtType type) { switch (type) { case DebtType.Loan: return(HouseholdDebtTracker.DAL.Models.DebtType.Loan); default: return(HouseholdDebtTracker.DAL.Models.DebtType.Repayment); } }
/// <summary> /// Создает экземпляр контрола для редактирования свойств строк задолженности. /// </summary> public DebtPropertiesControl() : base() { InitializeComponent(); debtType = DebtType.Кредиторская; month = DateTime.Today.Month; year = DateTime.Today.Year; comboBoxType.SelectedIndex = 0; comboBoxMonth.SelectedIndex = 0; numericUpDownYear.Value = year; }
public void SetDebtProperties(DebtType type, int month, int year) { debtType = type; comboBoxType.SelectedIndex = (int)debtType; this.month = month; comboBoxMonth.SelectedIndex = month - 1; this.year = year; numericUpDownYear.Value = year; OnDebtPropertiesChanged(); }
public DebtCopyForm(DebtType fromDebtType, int fromMonth, int fromYear) { InitializeComponent(); DebtPropertiesFrom.DebtType = fromDebtType; DebtPropertiesFrom.Month = fromMonth; DebtPropertiesFrom.Year = fromYear; DebtPropertiesTo.DebtType = fromDebtType; var date = new DateTime(fromYear, fromMonth, 1).AddMonths(1); DebtPropertiesTo.Month = date.Month; DebtPropertiesTo.Year = date.Year; }
public void ShowReport(DebtType type, int month, int year) { var reportParam = new Report1ParamForm(type, month, year); if (reportParam.ShowDialog() != DialogResult.OK) { return; } type = reportParam.DebtProperties.DebtType; month = reportParam.DebtProperties.Month; year = reportParam.DebtProperties.Year; string reportCaption = string.Format("Отчет по {0} задолженности за {1} месяц {2} года", (type == DebtType.Кредиторская ? "кредиторской" : "дебиторской"), DebtUtil.GetMonthName(month).ToLower(), year); string reportName = (reportParam.GroupBySubjects ? reportName = "CI.Debt.Reports.Report1.rdlc" : "CI.Debt.Reports.Report2.rdlc"); var reportForm = new ReportForm(); reportForm.Text = reportCaption; reportForm.reportViewer.LocalReport.ReportEmbeddedResource = reportName; reportForm.reportViewer.LocalReport.DisplayName = reportCaption; reportForm.reportViewer.LocalReport.SetParameters(new[] { new ReportParameter("pCaption", reportCaption) }); reportForm.Show(); IList <DebtRow> rows = null; if (reportParam.GroupBySubjects && 0 < reportParam.comboBoxBudgetName.SelectedIndex) { rows = DebtDAO.GetDebtRows(type, month, year, (string)reportParam.comboBoxBudgetName.SelectedItem); } else { rows = DebtDAO.GetDebtRows(type, month, year); } var reportRows = new List <Report1Row>(); foreach (var row in rows) { reportRows.Add(new Report1Row(row)); } reportForm.reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Report1Row", reportRows)); reportForm.reportViewer.RefreshReport(); reportForm.reportViewer.SetDisplayMode(DisplayMode.PrintLayout); reportForm.reportViewer.ZoomMode = ZoomMode.Percent; reportForm.reportViewer.ZoomPercent = 100; }
public AmortizationEntry( string debtName, DebtType debtType, DateTime date, double startBalance, double interest, double minPrincipal, double addPrincipal, double endBalance) { DebtName = debtName; DebtType = debtType; Date = date; StartBalance = startBalance; MinimumInterest = interest; MinimumPrincipal = minPrincipal; AdditionalPrincipal = addPrincipal; TotalPayment = interest + minPrincipal + addPrincipal; EndBalance = endBalance; }
/// <summary> /// Копировать строки из одной задолженности в другую. /// </summary> /// <param name="fromDebtType">Тип задолженности откуда копировать.</param> /// <param name="fromMonth">Месяц задолженности откуда копировать.</param> /// <param name="fromYear">Год задолженности откуда копировать.</param> /// <param name="toDebtType">Тип задолженности куда копировать.</param> /// <param name="toMonth">Месяц задолженности куда копировать.</param> /// <param name="toYear">Год задолженности куда копировать.</param> public static void CopyDebtRows( DebtType fromDebtType, int fromMonth, int fromYear, DebtType toDebtType, int toMonth, int toYear) { CheckInitialization(); var fromRows = GetDebtRows(fromDebtType, fromMonth, fromYear); using (var tx = session.BeginTransaction()) { foreach (var fromRow in fromRows) { var row = (DebtRow)fromRow.Clone(); row.DebtType = toDebtType; row.Month = toMonth; row.Year = toYear; session.Save(row); } tx.Commit(); } }
internal static IEnumerable <ApartmentsDebt> GetAllUnpaiedOfType(Apartments apartment, int year, int month, DebtType debtType) { return(GetContext(true).ApartmentsDebt.Where(ad => ad.Id_debtType == (int)debtType && ad.Id_Apartament == apartment.Id && ad.Year <= year && ad.Month <= month && !ad.IsPayed)); }
internal static IEnumerable <ApartmentsDebt> GetAllPaidOfType(int apartmentId, DebtType debtType) { return(GetContext(true).ApartmentsDebt.Where(ad => ad.Id_debtType == (int)debtType && ad.Id_Apartament == apartmentId && ad.IsPayed)); }
public static ApartmentsDebt Get(int apartmentId, int year, int month, DebtType debtType) { return(GetContext(true).ApartmentsDebt.FirstOrDefault(a => a.Id_Apartament == apartmentId && a.Year == year && a.Month == month && a.Id_debtType == (int)debtType)); }