//private void GenerateMonthlyInvoicesFromLoan(Contract entity)
//{
// InvoicesManager manager = new InvoicesManager(this);
// Invoice invoice = new Invoice();
// Invoice original_invoice = new Invoice();
// if (entity.InvoiceId.HasValue)
// original_invoice = manager.GetInvoice(entity.CompanyId, Convert.ToInt32(entity.InvoiceId));
// invoice.CopyPropertiesFrom(original_invoice);
// invoice.CompanyId = entity.CompanyId;
// invoice.CustomerId = entity.CustomerId;
// invoice.Description = !String.IsNullOrEmpty(entity.ContractNumber) ? entity.ContractNumber : entity.ContractId.ToString();
// invoice.InvoiceValue = decimal.Zero;
// if (or/ger.InsertRetrievingId(invoice);
// else
// manager.Update(original_invoice, invoice);
// entity.InvoiceId = invoice.InvoiceId;
// invoice.InvoiceValue += GenerateMonthlyInvoiceParcelFromLoan(entity);
// DbContext.SubmitChanges();
//}
/// <summary>
/// this method generates MonthlyInvoice's parcels
/// </summary>
/// <param name="entity">Current Contract</param>
/// <param name="qtdParcels">Number of parcels</param>
/// <returns>returns the sum of invoice's parcels</returns>
private Decimal GenerateMonthlyInvoiceParcelFromLoan(Contract entity)
{
DateTime dueDate = Convert.ToDateTime(entity.FirstParcelDueDate);
Decimal parcelAmount = decimal.Zero;
Parcel parcel;
var invoicesManager = new FinancialManager(this);
for (int i = 1; i <= entity.FinancierCondition.ParcelCount; i++)
{
if ((entity.Periodicity.Value == 30
? entity.BeginDate.AddMonths(1)
: entity.BeginDate.AddDays(entity.Periodicity.Value)) > DateTime.Now.Date)
{
parcel = CreateMonthlyInvoiceParcelFromLoan(entity,
(i / entity.FinancierCondition.ParcelCount).ToString(),
dueDate);
parcelAmount += parcel.Amount;
invoicesManager.Insert(parcel, entity.FinancierCondition);
}
//If days contains 30, Add a Month
if (entity.Periodicity.Value == 30)
{
dueDate = dueDate.AddMonths(1);
}
else
{
dueDate = dueDate.AddDays(entity.Periodicity.Value);
}
}
DbContext.SubmitChanges();
return(parcelAmount);
}
/// <summary>
/// Generate All Invoices to a contract
/// </summary>
/// <param name="contract"></param>
/// <returns></returns>
//private void GenerateLoanFromContract(Contract contract, int qtdParcels)
//{
// AccountManager accountManager = new AccountManager(this);
// //contract.FinancierOperation = accountManager.GetFinancierOperation(contract.CompanyId, Convert.ToInt32(contract.FinancierOperationId));
// contract.FinancierCondition = accountManager.GetFinancierConditionByParcelCount(contract.CompanyId, Convert.ToInt32(contract.FinancierOperationId), qtdParcels) ?? new FinancierCondition();
// if (contract.FinancierOperation.Brokerage.HasValue && contract.FinancierOperation.Brokerage.Value)
// {
// GenerateBrokerCommission(contract);
// GenerateRepresententBrokerComission(contract);
// }
// else
// {
// GenerateMonthlyInvoicesFromLoan(contract);
// GenerateBillToCustomerFromLoan(contract);
// }
//}
#region Calculate Commission
//private void GenerateBrokerCommission(Contract contract)
//{
// InvoicesManager manager = new InvoicesManager(this);
// Invoice invoice = new Invoice();
// invoice.CompanyId = contract.CompanyId;
// invoice.CustomerId = contract.CustomerId;
// invoice.EntryDate = contract.FirstParcelDueDate.Value.AddDays(contract.FinancierOperation.ReceiveDay).NextUtilDay();
// //invoice.Creditor = !String.IsNullOrEmpty(contract.ContractNumber) ? contract.ContractNumber : contract.ContractId.ToString();
// invoice.Description = "Comissão Contrato N. " + contract.ContractNumber;
// //invoice.InvoiceValue = Decimal.Zero;
// if (contract.InvoiceId.HasValue)
// {
// Invoice original_invoice = manager.GetInvoice(contract.CompanyId, contract.InvoiceId.Value);
// new ParcelsManager(this).DeleteAllNextInvoiceParcels(invoice, DateTime.Now);
// manager.Update(original_invoice, invoice);
// }
// else
// {
// //manager.Insert(invoice, null);
// manager.InsertRetrievingId(invoice);
// contract.InvoiceId = invoice.InvoiceId;
// }
// GenerateBrokerCommissionParcel(contract, invoice);
// DbContext.SubmitChanges();
//}
//private Parcel GenerateBrokerCommissionParcel(Contract contract, Invoice invoice)
//{
// if (contract.FinancierOperation == null)
// return null;
// Parcel parcel = new Parcel();
// parcel.FinancierOperationId = contract.FinancierOperationId;
// parcel.CompanyId = contract.CompanyId;
// parcel.Description = "1/1";
// parcel.DueDate = contract.FirstParcelDueDate.Value.AddDays(contract.FinancierOperation.ReceiveDay).NextUtilDay(); ;
// parcel.Amount = CalculateNetWorth(contract) * contract.FinancierCondition.PercentCompany / 100m;
// if (contract.Insurance.HasValue) //seguro
// parcel.Amount += contract.Insurance.Value * Convert.ToDecimal(contract.FinancierOperation.InsurancePercent) / 100m;
// if (contract.MoneyReserves.HasValue) //pecúlio
// parcel.Amount += contract.MoneyReserves.Value * Convert.ToDecimal(contract.FinancierOperation.PeculiumPercent) / 100m;
// if (contract.MonthlyFee.HasValue)// mensalidade
// parcel.Amount += (contract.MonthlyFee.Value * contract.FinancierCondition.ParcelCount) * Convert.ToDecimal(contract.FinancierOperation.MonthlyFeePercent) / 100m;
// //invoice.InvoiceValue += parcel.Amount;
// parcel.InvoiceId = invoice.InvoiceId;
// new InvoicesManager(this).Insert(parcel, contract.FinancierCondition);
// return parcel;
//}
//private void GenerateRepresententBrokerComission(Contract contract)
//{
// if (contract.RepresentantId.HasValue)
// {
// BillManager billManager = new BillManager(this);
// Bill bill = new Bill();
// bill.CompanyId = contract.CompanyId;
// bill.DocumentType = (Int32)DocumentType.others;
// bill.EntryDate = contract.FirstParcelDueDate.Value.AddDays(contract.FinancierOperation.ReceiveDay).NextUtilDay();
// //if (contract.RepresentantId.HasValue)
// //{
// // // bill.Creditor = (contract.Representant.Profile != null ? contract.Representant.Profile.AbreviatedName : contract.Representant.LegalEntityProfile.CompanyName);
// // bill.Description = "Comissão »" + bill.Creditor;
// //}
// billManager.Insert(bill, null);
// GenerateRepresententBrokerComissionParcel(contract, bill);
// DbContext.SubmitChanges();
// }
//}
//private Parcel GenerateRepresententBrokerComissionParcel(Contract contract, Bill bill)
//{
// if (contract.FinancierOperation == null)
// return null;
// Parcel parcel = new Parcel();
// parcel.FinancierOperationId = contract.FinancierOperationId;
// parcel.CompanyId = contract.CompanyId;
// parcel.Description = "1/1";
// parcel.DueDate = contract.FirstParcelDueDate.Value.AddDays(contract.FinancierOperation.ReceiveDay).NextUtilDay(); ;
// parcel.Amount = CalculateNetWorth(contract) * contract.FinancierCondition.PercentRepresentant / 100m;
// if (contract.Insurance.HasValue) //seguro
// parcel.Amount += contract.Insurance.Value * Convert.ToDecimal(contract.FinancierOperation.InsurancePercentPerRepresentant) / 100m;
// if (contract.MoneyReserves.HasValue) //pecúlio
// parcel.Amount += contract.MoneyReserves.Value * Convert.ToDecimal(contract.FinancierOperation.PeculiumPercentPerRepresentant) / 100m;
// if (contract.MonthlyFee.HasValue)// mensalidade
// parcel.Amount += (contract.MonthlyFee.Value * contract.FinancierCondition.ParcelCount) * Convert.ToDecimal(contract.FinancierOperation.MonthlyFeePercentPerRepresentant) / 100m;
// //bill.BillValue += parcel.Amount;
// parcel.BillId = bill.BillId;
// new BillManager(this).Insert(parcel, contract.FinancierCondition);
// return parcel;
//}
#endregion
private void GenerateBillToCustomerFromLoan(Contract contract)
{
var billManager = new FinancialManager(this);
var parcelsManager = new ParcelsManager(this);
var customerManager = new CustomerManager(this);
var bill = new Bill();
bill.CompanyId = contract.CompanyId;
bill.DocumentType = (Int32)DocumentType.others;
Customer customer = customerManager.GetCustomer(contract.CustomerId, contract.CompanyId);
//bill.Creditor = customer.Profile != null ? customer.Profile.Name : customer.LegalEntityProfile.CompanyName;
//bill.Description = "Empréstimo p/ " + bill.Creditor;
//bill.BillValue = contract.ContractValue.Value - CalculateOtherDebits(contract);
billManager.Insert(bill, null);
//
var parcel = new Parcel();
parcel.FinancierOperationId = contract.FinancierOperationId;
parcel.CompanyId = contract.CompanyId;
parcel.BillId = bill.BillId;
parcel.Description = "1/1";
parcel.DueDate = contract.BeginDate.NextUtilDay();
//parcel.Amount = bill.BillValue.Value;
parcelsManager.Insert(parcel, null);
}
private Invoice SaveInvoice()
{
financialManager = new FinancialManager(this);
Invoice original_invoice = new Invoice();
Invoice invoice = new Invoice();
if (Page.ViewState["InvoiceId"] != null)
{
original_invoice = financialManager.GetInvoice(Company.CompanyId, Convert.ToInt32(Page.ViewState["InvoiceId"]));
invoice.CopyPropertiesFrom(original_invoice);
}
invoice.Description = txtSource.Text;
invoice.CompanyId = Company.CompanyId;
invoice.CostCenterId = Convert.ToInt32(cboCostCenter.SelectedValue);
if (Page.ViewState["CustomerId"] != null)
{
invoice.CustomerId = Convert.ToInt32(Page.ViewState["CustomerId"]);
}
//accountPlan
if (!String.IsNullOrEmpty(cboAccountPlan.SelectedValue))
{
invoice.AccountingPlanId = Convert.ToInt32(cboAccountPlan.SelectedValue);
}
if (Page.ViewState["InvoiceId"] != null)
{
invoice.ModifiedByUser = User.Identity.UserName;
financialManager.Update(original_invoice, invoice, ucParcels.DataSource);
}
else
{
invoice.CreatedByUser = User.Identity.UserName;
financialManager.Insert(invoice, ucParcels.DataSource);
}
if (Page.ViewState["InvoiceId"] != null)
{
return(original_invoice);
}
else
{
return(invoice);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (ucCurrFieldBalance.Text == "0,00")
{
litErrorMessage.Visible = true;
litErrorMessage.Text = "<font color='red'> Saldo a ser ajustado não pode ser zero! </font>";
return;
}
var invoice = new Invoice();
var parcel = new Parcel();
var financialManager = new FinancialManager(this);
invoice.CompanyId = Company.CompanyId;
invoice.EntryDate = DateTime.Now;
parcel.EffectedDate = SqlDateTime.MinValue.Value;
parcel.DueDate = SqlDateTime.MinValue.Value;
parcel.OperationDate = SqlDateTime.MinValue.Value;
invoice.Description = "(Conta a receber através de acerto de saldo)";
parcel.Amount = ucCurrFieldBalance.CurrencyValue.Value;
parcel.EffectedAmount = parcel.Amount;
var parcels = new List <Parcel>();
parcels.Add(parcel);
financialManager.Insert(invoice, parcels);
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('Operação realizada com sucesso!')", true);
ucCurrFieldBalance.CurrencyValue = null;
litErrorMessage.Visible = false;
CalculateBalance();
}
private void SaveBill(object sender)
{
var bill = new Bill();
bill.CopyPropertiesFrom(OriginalBill);
bill.CompanyId = Company.CompanyId;
// Numero da Nota fiscal do fornecedor
bill.DocumentNumber = txtDocumentNumber.Text;
bill.Description = txtDescription.Text;
bill.CostCenterId = Convert.ToInt32(cboCostCenter.SelectedValue);
bill.EntryDate = DateTime.Now;
//supplier
if (Page.ViewState["SupplierId"] != null)
{
bill.SupplierId = Convert.ToInt32(Page.ViewState["SupplierId"]);
}
else
{
bill.SupplierId = null;
}
//accountPlan
if (!String.IsNullOrEmpty(cboAccountPlan.SelectedValue))
{
bill.AccountingPlanId = Convert.ToInt32(cboAccountPlan.SelectedValue);
}
//documentType
if (rbtGuia.Checked)
{
bill.DocumentType = (Int32)DocumentType.Guia;
}
else if (rbtReceipt.Checked)
{
bill.DocumentType = (Int32)DocumentType.receipt;
}
else if (rbtOthers.Checked)
{
bill.DocumentType = (Int32)DocumentType.others;
}
var billManager = new FinancialManager(this);
//bill.Parcels = ucParcels.DataSource;
if (Page.ViewState["BillId"] != null)
{
bill.ModifiedByUser = User.Identity.UserName;
billManager.Update(OriginalBill, bill, ucParcels.DataSource);
}
else
{
bill.CreatedByUser = User.Identity.UserName;
billManager.Insert(bill, ucParcels.DataSource);
Context.Items["PostBack"] = Context.Items["BillId"] = bill.BillId;
}
ucParcels.Clear();
if ((sender as Button).ID == "btnNew")
{
Response.Redirect("Bill.aspx");
}
else
{
Response.Redirect("Bills.aspx");
}
}
/// <summary>
/// this method save the receipt and its items
/// </summary>
/// <param name="original_entity">this parameter is used in update operation</param>
/// <param name="entity">this parameter always is used</param>
/// <param name="lstReceiptItem">this parameter contai the list of ReceiptItems</param>
public void SaveReceipt(Receipt original_entity, Receipt entity, List <ReceiptItem> lstReceiptItem,
List <Int32> lstServiceOrder, List <Int32> lstSale)
{
//Managers
var accountManager = new AccountManager(this);
var parcelsManager = new ParcelsManager(this);
var financialManager = new FinancialManager(this);
var invoice = new Invoice();
var bill = new Bill();
entity.ModifiedDate = DateTime.Now;
if (original_entity.ReceiptId == 0)
{
//insert the Receipt
//if (ExistReceiptNumber(entity.CompanyId, Convert.ToInt32(entity.ReceiptNumber)))
// throw new InvalidOperationException();
DbContext.Receipts.InsertOnSubmit(entity);
}
else
{
//update
original_entity.CopyPropertiesFrom(entity);
//delete all receiptItens
DeleteReceiptItemsByReceipt(entity.ReceiptId, entity.CompanyId);
}
DbContext.SubmitChanges();
foreach (ReceiptItem item in lstReceiptItem)
{
item.ReceiptId = entity.ReceiptId;
item.CompanyId = entity.CompanyId;
InsertReceiptItem(item);
}
////insert the ReceiptItems
//for (int i = 0; i < lstReceiptItem.Count; i++)
//{
// lstReceiptItem[i].ReceiptId = entity.ReceiptId;
// InsertReceiptItem(lstReceiptItem[i]);
//}
if (entity.SupplierId.HasValue)
{
bill.CompanyId = entity.CompanyId;
bill.EntryDate = DateTime.Now;
bill.SupplierId = entity.SupplierId;
bill.DocumentNumber = Convert.ToString(entity.ReceiptNumber);
//if (entity.ReceiptValue.HasValue)
// bill.BillValue = entity.ReceiptValue.Value;
financialManager.Insert(bill, null);
}
else
{
SetReceiptIdInSale(entity.CompanyId, lstSale, entity.ReceiptId);
SetReceiptIdInServiceOrder(entity.CompanyId, lstServiceOrder, entity.ReceiptId);
}
DbContext.SubmitChanges();
if (bill.BillId != 0)
{
//insert the parcel
var parcel = new Parcel();
parcel.PaymentMethodId = PaymentMethod.Cash;
parcel.CompanyId = entity.CompanyId;
parcel.DueDate = DateTime.Now;
//parcel.Amount = bill.BillValue.Value;
parcel.BillId = bill.BillId;
parcelsManager.Insert(parcel,
accountManager.GetFinancierConditionByParcelCount(entity.CompanyId,
PaymentMethod.Cash, 1));
}
DbContext.SubmitChanges();
}