public CorporateUserControl(FundingLine pFundingLine)
{
_fundingLine = pFundingLine;
InitializeComponent();
InitializeUserControlsAddress();
_corporate = new Corporate();
}
public void AddFundinLineWithNameThatAlreadyExists()
{
var fundingLineServices = (FundingLineServices)container["FundingLineServices"];
var fund = new FundingLine
{
Purpose = "Microsoft financement",
Name = "XXX",
Deleted = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now
};
fundingLineServices.Create(fund);
var fundingLineToAdd = new FundingLine
{
Purpose = "Microsoft financement",
Name = "XXX",
Deleted = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now
};
fundingLineServices.Create(fund);
}
public int AddFundingLine(FundingLine pFund, SqlTransaction sqlTransac)
{
string q =
@"INSERT INTO [FundingLines]([name],[begin_date],[end_date],[amount],[purpose], [deleted], [currency_id])
VALUES(@name,@beginDate,@endDate,@amount,@purpose,@deleted, @currency_id ) SELECT SCOPE_IDENTITY()";
using (OpenCbsCommand c = new OpenCbsCommand(q, sqlTransac.Connection, sqlTransac))
{
c.AddParam("@name", pFund.Name);
c.AddParam("@beginDate", pFund.StartDate);
c.AddParam("@endDate", pFund.EndDate);
c.AddParam("@amount", pFund.Amount);
c.AddParam("@purpose", pFund.Purpose);
c.AddParam("@deleted", pFund.Deleted);
c.AddParam("@currency_id", pFund.Currency.Id);
pFund.Id = int.Parse(c.ExecuteScalar().ToString());
foreach (FundingLineEvent eventFL in pFund.Events)
{
if (eventFL.Id == 0)
{
_eventFundingLineManager.AddFundingLineEvent(eventFL, sqlTransac); //new event
}
else
{
_eventFundingLineManager.UpdateFundingLineEvent(eventFL, sqlTransac); // delete event
}
}
}
SetLazyLoader(pFund);
return(pFund.Id);
}
public int AddFundingLine(FundingLine pFund, SqlTransaction sqlTransac)
{
string q =
@"INSERT INTO [FundingLines]([name],[begin_date],[end_date],[amount],[purpose], [deleted], [currency_id])
VALUES(@name,@beginDate,@endDate,@amount,@purpose,@deleted, @currency_id ) SELECT SCOPE_IDENTITY()";
using (OpenCbsCommand c = new OpenCbsCommand(q, sqlTransac.Connection, sqlTransac))
{
c.AddParam("@name", pFund.Name);
c.AddParam("@beginDate", pFund.StartDate);
c.AddParam("@endDate", pFund.EndDate);
c.AddParam("@amount", pFund.Amount);
c.AddParam("@purpose", pFund.Purpose);
c.AddParam("@deleted", pFund.Deleted);
c.AddParam("@currency_id", pFund.Currency.Id);
pFund.Id = int.Parse(c.ExecuteScalar().ToString());
foreach (FundingLineEvent eventFL in pFund.Events)
{
if (eventFL.Id == 0)
_eventFundingLineManager.AddFundingLineEvent(eventFL, sqlTransac); //new event
else
_eventFundingLineManager.UpdateFundingLineEvent(eventFL, sqlTransac); // delete event
}
}
SetLazyLoader(pFund);
return pFund.Id;
}
public CorporateUserControl(Corporate corporate, Form pMdiParent, IApplicationController applicationController)
{
_applicationController = applicationController;
_mdifrom = pMdiParent;
_corporate = corporate;
_fundingLine = null;
InitializeComponent();
InitializeUserControlsAddress();
InitializeCorporate();
PicturesServices ps = ServicesProvider.GetInstance().GetPicturesServices();
if (ps.IsEnabled())
{
pictureBox1.Image = ps.GetPicture("CORPORATE", corporate.Id, true, 0);
pictureBox1.SizeMode = PictureBoxSizeMode.Zoom;
pictureBox2.Image = ps.GetPicture("CORPORATE", corporate.Id, true, 1);
pictureBox2.SizeMode = PictureBoxSizeMode.Zoom;
}
else
{
pictureBox1.Visible = false;
pictureBox2.Visible = false;
linkLabelChangePhoto.Visible = false;
linkLabelChangePhoto2.Visible = false;
}
}
public CorporateUserControl(Corporate corporate, Form pMdiParent, IExtensionActivator extensionActivator)
: base(extensionActivator)
{
_mdifrom = pMdiParent;
_corporate = corporate;
_fundingLine = null;
InitializeComponent();
InitializeUserControlsAddress();
InitializeCorporate();
PicturesServices ps = ServicesProvider.GetInstance().GetPicturesServices();
if (ps.IsEnabled())
{
pictureBox1.Image = ps.GetPicture("CORPORATE", corporate.Id, true, 0);
pictureBox1.SizeMode = PictureBoxSizeMode.Zoom;
pictureBox2.Image = ps.GetPicture("CORPORATE", corporate.Id, true, 1);
pictureBox2.SizeMode = PictureBoxSizeMode.Zoom;
}
else
{
pictureBox1.Visible = false;
pictureBox2.Visible = false;
linkLabelChangePhoto.Visible = false;
linkLabelChangePhoto2.Visible = false;
}
InitializeCustomizableFields(_corporate.Id);
}
private OCurrency GetAmountImpl(FundingLine fl, OFundingLineEventTypes type, bool equals)
{
string q = @"SELECT ISNULL(SUM(
CASE
WHEN 1 = direction THEN CAST(amount AS DECIMAL(20,4))
ELSE -1*CAST(amount AS DECIMAL(20,4))
END), 0) amount
FROM dbo.FundingLineEvents
WITH (READUNCOMMITTED)
WHERE fundingline_id = @id
AND deleted = 0
AND CAST(FLOOR(CAST(creation_date AS FLOAT)) AS DATETIME) <= @date
AND type ";
q += equals ? "= @type" : "<> @type";
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
{
c.AddParam("@id", fl.Id);
c.AddParam("@date", TimeProvider.Now.Date);
c.AddParam("@type", (int)type);
object retval = c.ExecuteScalar();
return(null == retval ? 0m : Convert.ToDecimal(retval));
}
}
private void SetLazyLoader(FundingLine fl)
{
if (null == fl)
{
return;
}
fl.SetLazyLoader(this);
}
public FrmFundingLineEvent(FundingLine pFundingLine, FundingLineEvent pFundingLineEvent)
{
InitializeComponent();
_FundingLine = pFundingLine;
_fundingLineEvent = pFundingLineEvent;
InitializeComboBoxDirections();
dateTimePickerEvent.Value = TimeProvider.Now;
}
public FundingLine SelectFundingLineByNameAndPurpose(FundingLine lookupFundingLine, SqlTransaction sqlTransac,
bool includeAll)
{
FundingLine newFL = new FundingLine();
string q =
@"SELECT FundingLines.[id],
[deleted],
[currency_id],
Currencies.[name] as currency_name,
Currencies.[code] as currency_code,
Currencies.[is_pivot] as currency_pivot,
Currencies.[is_swapped] as currency_is_swapped
FROM [FundingLines]
LEFT JOIN Currencies ON FundingLines.currency_id = Currencies.id
WHERE [purpose] = @purpose AND
FundingLines.[name] = @name";
if (!includeAll)
{
q += "and [deleted]=@deleted";
}
using (OpenCbsCommand c = new OpenCbsCommand(q, sqlTransac.Connection, sqlTransac))
{
c.AddParam("@purpose", lookupFundingLine.Purpose);
c.AddParam("@name", lookupFundingLine.Name);
if (!includeAll)
{
c.AddParam("@deleted", lookupFundingLine.Deleted);
}
using (OpenCbsReader r = c.ExecuteReader())
{
if (r != null)
{
if (!r.Empty)
{
r.Read();
newFL.Id = r.GetInt("id");
newFL.Deleted = r.GetBool("deleted");
newFL.Currency = new Currency
{
Id = r.GetInt("currency_id"),
Name = r.GetString("currency_name"),
Code = r.GetString("currency_code"),
IsPivot = r.GetBool("currency_is_pivot"),
IsSwapped = r.GetBool("currency_is_swapped")
};
}
}
}
}
SetLazyLoader(newFL);
return(newFL);
}
public FrmFundingLineEvent(FundingLine pFundingLine)
{
InitializeComponent();
_FundingLine = pFundingLine;
_exchangeRate=null;
_fundingLineEvent = new FundingLineEvent();
InitializeComboBoxDirections();
dateTimePickerEvent.Value = TimeProvider.Now;
}
public FundingLine SelectFundingLineByName(string name)
{
FundingLine fundingLine = null;
string q =
@"SELECT FundingLines.[id],
FundingLines.[name],
FundingLines.[deleted],
FundingLines.[amount],
FundingLines.[begin_date],
FundingLines.[end_date],
FundingLines.[purpose],
FundingLines.[currency_id],
Currencies.[name] as currency_name,
Currencies.[code] as currency_code,
Currencies.[is_pivot] as currency_is_pivot,
Currencies.[is_swapped] as currency_is_swapped
FROM [FundingLines]
LEFT JOIN Currencies ON FundingLines.currency_id = Currencies.id
WHERE FundingLines.[name]=@name AND [deleted]=0";
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
{
c.AddParam("@name", name);
using (OpenCbsReader r = c.ExecuteReader())
{
if (r != null)
{
if (!r.Empty)
{
r.Read();
fundingLine = new FundingLine();
fundingLine.Id = r.GetInt("id");
fundingLine.Name = r.GetString("name");
fundingLine.Deleted = r.GetBool("deleted");
fundingLine.StartDate = r.GetDateTime("begin_date");
fundingLine.Purpose = r.GetString("purpose");
fundingLine.EndDate = r.GetDateTime("end_date");
fundingLine.Amount = r.GetMoney("amount");
fundingLine.Currency = new Currency
{
Id = r.GetInt("currency_id"),
Name = r.GetString("currency_name"),
Code = r.GetString("currency_code"),
IsPivot = r.GetBool("currency_is_pivot"),
IsSwapped = r.GetBool("currency_is_swapped")
};
}
}
}
}
SetLazyLoader(fundingLine);
return(fundingLine);
}
public CashPrevisionForm(FundingLine pfundingLine, bool pIncludeDeleted)
{
InitializeComponent();
date = TimeProvider.Today;
_cashForFundingLine = pfundingLine;
forecastDays = 5;
includeDeleted = pIncludeDeleted;
checkBoxIncludeLateLoans.Checked = pIncludeDeleted;
DrawZedGraphForCashPrevision();
}
public FrmFundingLineEvent(FundingLine pFundingLine)
{
InitializeComponent();
_FundingLine = pFundingLine;
_exchangeRate=null;
_fundingLineEvent = new FundingLineEvent();
InitializeComboBoxDirections();
dateTimePickerEvent.Value = TimeProvider.Now;
dateTimePickerEvent.Format = DateTimePickerFormat.Custom;
dateTimePickerEvent.CustomFormat = ApplicationSettings.GetInstance("").SHORT_DATE_FORMAT;
}
public FundingLine Create(FundingLine fund)
{
using (SqlConnection conn = _fundingLineManager.GetConnection())
using (SqlTransaction sqlTransac = conn.BeginTransaction())
try
{
if (string.IsNullOrEmpty(fund.Purpose))
{
throw new OpenCbsFundingLineException(OpenCbsFundingLineExceptionEnum.CodeIsEmpty);
}
if (fund.StartDate > fund.EndDate)
{
throw new OpenCbsFundingLineException(OpenCbsFundingLineExceptionEnum.BeginDateGreaterEndDate);
}
if (string.IsNullOrEmpty(fund.Name))
{
throw new OpenCbsFundingLineException(OpenCbsFundingLineExceptionEnum.NameIsEmpty);
}
if (fund.Currency == null)
{
throw new OpenCbsFundingLineException(OpenCbsFundingLineExceptionEnum.CurrencyIsEmpty);
}
if (fund.Currency.Id == 0)
{
throw new OpenCbsFundingLineException(OpenCbsFundingLineExceptionEnum.CurrencyIsEmpty);
}
FundingLine tempfund = _fundingLineManager.SelectFundingLineByNameAndPurpose(fund, sqlTransac, true);
if (tempfund.Id > 0)
{
if (tempfund.Deleted)
{
fund.Deleted = false;
UpdateFundingLine(fund, sqlTransac);
return(fund);
}
else
{
throw new OpenCbsFundingLineException(OpenCbsFundingLineExceptionEnum.FundingLineNameExists);
}
}
fund.Id = _fundingLineManager.AddFundingLine(fund, sqlTransac);
sqlTransac.Commit();
return(fund);
}
catch (Exception ex)
{
sqlTransac.Rollback();
throw ex;
}
}
public void DeleteFundingLine(FundingLine fund)
{
string q = "UPDATE [FundingLines] SET [deleted] = @deleted WHERE [id] = @id";
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
{
c.AddParam("@id", fund.Id);
c.AddParam("@deleted", true);
c.ExecuteScalar();
}
}
public List <FundingLine> SelectFundingLines()
{
List <FundingLine> list = new List <FundingLine>();
string q =
@"SELECT FundingLines.[id],
FundingLines.[name],
[begin_date],
[end_date],
[amount],
[purpose],
[deleted],
[currency_id],
Currencies.[name] as currency_name,
Currencies.[code] as currency_code,
Currencies.[is_pivot] as currency_is_pivot,
Currencies.[is_swapped] as currency_is_swapped
FROM [FundingLines]
LEFT JOIN Currencies ON FundingLines.currency_id = Currencies.id
WHERE [deleted] = 0";
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
using (OpenCbsReader r = c.ExecuteReader())
{
while (r.Read())
{
FundingLine fundingLine = new FundingLine();
fundingLine.Id = r.GetInt("id");
fundingLine.Name = r.GetString("name");
fundingLine.StartDate = r.GetDateTime("begin_date");
fundingLine.EndDate = r.GetDateTime("end_date");
fundingLine.Amount = r.GetMoney("amount");
fundingLine.Amount = r.GetMoney("amount");
fundingLine.Purpose = r.GetString("purpose");
fundingLine.Deleted = r.GetBool("deleted");
fundingLine.Currency = new Currency
{
Id = r.GetInt("currency_id"),
Name = r.GetString("currency_name"),
Code = r.GetString("currency_code"),
IsPivot = r.GetBool("currency_is_pivot"),
IsSwapped = r.GetBool("currency_is_swapped")
};
SetLazyLoader(fundingLine);
list.Add(fundingLine);
}
}
return(list);
}
/* this method returns
* estimated amount of funding line for several loans (ex. village members)
* to check whether financial commitment will be enough
*/
public decimal CheckIfAmountIsEnough(FundingLine fL, decimal amount)
{
decimal prevAmount = fundingLinesWithAmounts[fL.Id] == null ? 0 : (decimal)fundingLinesWithAmounts[fL.Id];
if (fundingLinesWithAmounts.ContainsKey(fL.Id))
{
fundingLinesWithAmounts[fL.Id] = prevAmount + amount;
}
else
{
fundingLinesWithAmounts.Add(fL.Id, amount);
}
return(fL.AnticipatedRemainingAmount.Value - (decimal)fundingLinesWithAmounts[fL.Id]);
}
public void UpdateFundingLine(FundingLine fund)
{
using (SqlConnection conn = _fundingLineManager.GetConnection())
using (SqlTransaction sqlTransac = conn.BeginTransaction())
try
{
UpdateFundingLine(fund, sqlTransac);
sqlTransac.Commit();
}
catch (Exception ex)
{
sqlTransac.Rollback();
throw ex;
}
}
public void AddFundinLine()
{
var fundingLineManager = (FundingLineManager)container["FundingLineManager"];
var fund = new FundingLine
{
Id = 0,
Purpose = "Microsoft financement",
Name = "Clyon",
Deleted = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now,
Currency = new Currency{Id = 1}
};
fundingLineManager.AddFundingLine(fund);
Assert.IsTrue(fund.Id > 0);
}
public double[] CalculateChartForFundingLine(FundingLine pFundingLine, DateTime pStartDate, int pDayNum, bool pAssumeLateLoansRepaidToday)
{
bool creditInterestsInFundingLine = ApplicationSettings.GetInstance(_user.Md5).InterestsCreditedInFL;
List<KeyValuePair<DateTime, decimal>> result = _contractManagement.CalculateCashToRepayByDayByFundingLine(pFundingLine.Id,
pAssumeLateLoansRepaidToday,
creditInterestsInFundingLine);
double[] y = pFundingLine.CalculateCashProvisionChart(pStartDate, pDayNum, pAssumeLateLoansRepaidToday);
if (y == null) return y;
for (int i = 0; i < pDayNum; i++)
{
decimal amount = result.Where(x => x.Key <= pStartDate.AddDays(i)).Sum(x => x.Value);
y[i] += Convert.ToDouble(amount);
}
return y;
}
public void UpdateFundingLine(FundingLine fund)
{
using (SqlConnection conn = GetConnection())
using (SqlTransaction t = conn.BeginTransaction())
{
try
{
UpdateFundingLine(fund, t);
t.Commit();
}
catch (Exception)
{
t.Rollback();
throw;
}
}
}
public void UpdateFundingLine(FundingLine fund, SqlTransaction sqlTransac)
{
if (fund.Purpose == string.Empty)
{
throw new OpenCbsFundingLineException(OpenCbsFundingLineExceptionEnum.NameIsEmpty);
}
if (fund.StartDate > fund.EndDate)
{
throw new OpenCbsFundingLineException(OpenCbsFundingLineExceptionEnum.BeginDateGreaterEndDate);
}
if (fund.Name == string.Empty)
{
throw new OpenCbsFundingLineException(OpenCbsFundingLineExceptionEnum.CodeIsEmpty);
}
_fundingLineManager.UpdateFundingLine(fund, sqlTransac);
}
public int AddFundingLine(FundingLine pFund)
{
using (SqlConnection conn = GetConnection())
using (SqlTransaction t = conn.BeginTransaction())
{
try
{
int id = AddFundingLine(pFund, t);
t.Commit();
return(id);
}
catch (Exception)
{
t.Rollback();
throw;
}
}
}
public int AddFundingLine(FundingLine pFund)
{
using (SqlConnection conn = GetConnection())
using (SqlTransaction t = conn.BeginTransaction())
{
try
{
int id = AddFundingLine(pFund, t);
t.Commit();
return id;
}
catch (Exception)
{
t.Rollback();
throw;
}
}
}
public List <FundingLineEvent> GetEvents(FundingLine fl)
{
List <FundingLineEvent> list = new List <FundingLineEvent>();
const string q = @"SELECT id,
code,
amount,
direction,
deleted,
creation_date,
type
FROM dbo.FundingLineEvents
WITH (READUNCOMMITTED)
WHERE fundingline_id = @id
ORDER BY creation_date DESC, id DESC";
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
{
c.AddParam("@id", fl.Id);
using (OpenCbsReader r = c.ExecuteReader())
{
if (null == r || r.Empty)
{
return(list);
}
while (r.Read())
{
FundingLineEvent e = new FundingLineEvent();
e.Id = r.GetInt("id");
e.Code = r.GetString("code");
e.Amount = r.GetMoney("amount");
e.Movement = (OBookingDirections)r.GetSmallInt("direction");
e.IsDeleted = r.GetBool("deleted");
e.CreationDate = r.GetDateTime("creation_date");
e.Type = (OFundingLineEventTypes)r.GetSmallInt("type");
e.FundingLine = fl;
list.Add(e);
}
}
}
return(list);
}
public void DeleteFundinLine()
{
FundingLineManager fundingLineManager = (FundingLineManager)container["FundingLineManager"];
FundingLine fund = new FundingLine
{
Purpose = "Microsoft financement",
Name = "XXX",
Deleted = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now,
Currency = new Currency{Id = 1}
};
fundingLineManager.AddFundingLine(fund);
FundingLine fundingLineInitial = fundingLineManager.SelectFundingLineById(fund.Id, false);
Assert.AreEqual("XXX", fundingLineInitial.Name);
fundingLineManager.DeleteFundingLine(fundingLineInitial);
FundingLine fundingLineFinal = fundingLineManager.SelectFundingLineById(fundingLineInitial.Id, false);
Assert.IsNull(fundingLineFinal);
}
public void UpdateFundingLine(FundingLine fund, SqlTransaction pSqlTransac)
{
string q =
@"UPDATE [FundingLines]
SET [name] = @name,
[begin_date] = @beginDate,
[end_date]=@endDate,
[amount] = @amount,
[purpose] = @purpose,
[deleted]=@deleted,
[currency_id] = @currency_id
WHERE [id] = @id";
using (OpenCbsCommand c = new OpenCbsCommand(q, pSqlTransac.Connection, pSqlTransac))
{
c.AddParam("@id", fund.Id);
c.AddParam("@name", fund.Name);
c.AddParam("@beginDate", fund.StartDate);
c.AddParam("@purpose", fund.Purpose);
c.AddParam("@endDate", fund.EndDate);
c.AddParam("@amount", fund.Amount);
c.AddParam("@deleted", fund.Deleted);
c.AddParam("@currency_id", fund.Currency.Id);
c.ExecuteNonQuery();
foreach (FundingLineEvent eventFL in fund.Events)
{
if (eventFL.Id == 0)
{
_eventFundingLineManager.AddFundingLineEvent(eventFL, pSqlTransac); //new event
}
else
{
_eventFundingLineManager.UpdateFundingLineEvent(eventFL, pSqlTransac); // delete event
}
}
}
}
public void AddCredit_SelectByCode_ContractChartOfAccounts()
{
FundingLine fund = new FundingLine
{
Purpose = "Microsoft financement",
Name = "AFD130",
Deleted = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now,
Currency = new Currency { Id = 1 }
};
fundingLineManager.AddFundingLine(fund, null);
credit.FundingLine = fund;
credit.Code = "TEST";
credit.ChartOfAccounts.Accounts[1].Balance = 3000;
credit.ChartOfAccounts.Accounts[4].Balance = 1254;
credit.ChartOfAccounts.Accounts[6].Balance = 4587;
credit.ChartOfAccounts.Accounts[16].Balance = 32.54m;
credit.Id = creditManagement.AddCredit(credit, _project.Id, null);
Loan contractRetrieved = creditManagement.SelectContractByContractCode(credit.Code);
Assert.AreEqual(3000m, contractRetrieved.ChartOfAccounts.Accounts[1].Balance.Value);
Assert.AreEqual(1254m, contractRetrieved.ChartOfAccounts.Accounts[4].Balance.Value);
Assert.AreEqual(4587m, contractRetrieved.ChartOfAccounts.Accounts[6].Balance.Value);
Assert.AreEqual(32.54m, contractRetrieved.ChartOfAccounts.Accounts[16].Balance.Value);
}
public void TestSearchContractInDatabaseWithStartDateSetAndLoanOfficerFilterNotActive()
{
ApplicationSettings dataParam = ApplicationSettings.GetInstance("");
dataParam.DeleteAllParameters();
dataParam.AddParameter(OGeneralSettings.LOANOFFICERPORTFOLIOFILTER, false);
dataParam.AddParameter(OGeneralSettings.ACCOUNTINGPROCESS, OAccountingProcesses.Cash);
dataParam.AddParameter(OGeneralSettings.USECENTS, true);
FundingLine fund = new FundingLine();
fund.Purpose = "Microsoft financement";
fund.Name = "AFD130";
fund.Deleted = false;
fund.StartDate = DateTime.Now;
fund.EndDate = DateTime.Now;
fund.Currency = new Currency { Id = 1 };
fundingLineManager.AddFundingLine(fund, null);
credit.FundingLine = fund;
creditManagement.AddCredit(credit, _project.Id, null);
Assert.AreEqual(1, creditManagement.SearchCreditInDatabase(1, null).Count);
}
public OCurrency GetAmount(FundingLine fl)
{
return(GetAmountImpl(fl, OFundingLineEventTypes.Entry, true));
}
private void _DisplayAmounts(FundingLine fl)
{
bool useCents = null == fl.Currency ? true : fl.Currency.UseCents;
tbInitialAmt.Text = fl.Amount.GetFormatedValue(useCents);
tbRealAmt.Text = fl.RealRemainingAmount.GetFormatedValue(useCents);
tbAnticipatedAmt.Text = fl.AnticipatedRemainingAmount.GetFormatedValue(useCents);
}
private void InitializeTabPageFundingLineDetails(FundingLine fl)
{
btnSave.Text = GetString(0 == fl.Id ? "save" : "update");
textBoxFundingLineCode.Text = fl.Name;
textBoxFundingLineName.Text = fl.Purpose;
dateTimePickerFundingLineBeginDate.Value = fl.StartDate == DateTime.MinValue
? TimeProvider.Today
: fl.StartDate;
dateTimePickerFundingLineEndDate.Value = fl.EndDate == DateTime.MinValue
? TimeProvider.Today
: fl.EndDate;
_InitializeComboBoxCurrencies();
if (fl.Currency != null)
{
comboBoxCurrencies.Text = fl.Currency.Name;
comboBoxCurrencies.Enabled = false;
}
else
comboBoxCurrencies.Enabled = true;
RefreshView();
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (listViewFundingLine.SelectedItems != null)
{
_fundingLine = (FundingLine) listViewFundingLine.SelectedItems[0].Tag;
ServicesProvider.GetInstance().GetFundingLinesServices().DeleteFundingLine(_fundingLine);
InitializeFundingLines();
}
}
private void comboBoxLoanFundingLine_SelectedIndexChanged(object sender, EventArgs e)
{
if (!(comboBoxLoanFundingLine.SelectedItem is FundingLine))
{
comboBoxLoanFundingLine.Tag = null;
return;
}
_fundingLine = (FundingLine)comboBoxLoanFundingLine.SelectedItem;
if (!_fundingLine.Deleted)
{
comboBoxLoanFundingLine.ForeColor = Color.Black;
comboBoxLoanFundingLine.Font = new Font(Font, FontStyle.Regular);
buttonLoanRepaymentRepay.Enabled = true;
if (_credit != null && !_credit.WrittenOff)
btnWriteOff.Enabled = true;
}
comboBoxLoanFundingLine.Tag = _fundingLine;
}
public void TestAddLoanInDatabaseWithCreditCommitteeCode()
{
FundingLine fund = new FundingLine
{
Purpose = "Microsoft financement",
Name = "AFD130",
Deleted = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now,
Currency = new Currency { Id = 1 }
};
fundingLineManager.AddFundingLine(fund, null);
credit.FundingLine = fund;
credit.CreditCommitteeCode = "Code";
credit.Id = creditManagement.AddCredit(credit, _project.Id, null);
Loan contractRetrieved = creditManagement.SelectCreditById(credit.Id);
Assert.AreEqual("Code", contractRetrieved.CreditCommitteeCode);
}
public List <FundingLineEvent> SelectFundingLineEvents(FundingLine fl)
{
return(_eventFundingLineManager.SelectFundingLineEvents(fl));
}
public OCurrency GetAnticipatedAmount(FundingLine fl)
{
return(GetAmountImpl(fl, OFundingLineEventTypes.Disbursment, false));
}
public void DeleteFundingLine(FundingLine fund)
{
_fundingLineManager.DeleteFundingLine(fund);
}
public FundingLine SelectFundingLineById(int id, bool pAddOptionalEventInformations)
{
FundingLine fund = _fundingLineManager.SelectFundingLineById(id, pAddOptionalEventInformations);
return(fund);
}
public FundingLine SelectFundingLineById(int id, SqlTransaction sqlTransac)
{
FundingLine fund = _fundingLineManager.SelectFundingLineById(id, sqlTransac);
return(fund);
}
public OCurrency GetRealAmount(FundingLine fl)
{
return(GetAmountImpl(fl, OFundingLineEventTypes.Commitment, false));
}
public void TestSearchContractInDatabaseWithUserIdSetAndUserLastNameAndFirstNameNull()
{
ApplicationSettings dataParam = ApplicationSettings.GetInstance("");
dataParam.DeleteAllParameters();
dataParam.AddParameter(OGeneralSettings.LOANOFFICERPORTFOLIOFILTER, false);
dataParam.AddParameter(OGeneralSettings.ACCOUNTINGPROCESS, OAccountingProcesses.Cash);
dataParam.AddParameter(OGeneralSettings.USECENTS, true);
UserManager userManager = new UserManager(DataUtil.TESTDB);
User loanOfficer = new User();
loanOfficer.UserName = "******";
loanOfficer.Password = "******";
loanOfficer.Role = User.Roles.LOF;
loanOfficer.Mail = "Not Set";
loanOfficer.Id = userManager.AddUser(loanOfficer);
credit.LoanOfficer = loanOfficer;
FundingLine fund = new FundingLine();
fund.Purpose = "Microsoft financement";
fund.Name = "AFD130";
fund.Deleted = false;
fund.StartDate = DateTime.Now;
fund.EndDate = DateTime.Now;
fund.Currency = new Currency { Id = 1 };
fundingLineManager.AddFundingLine(fund, null);
credit.FundingLine = fund;
creditManagement.AddCredit(credit, _project.Id, null);
List<CreditSearchResult> ds = creditManagement.SearchCreditInDatabase(1, "G");
Assert.AreEqual(1, ds.Count);
Assert.AreEqual("lo", ds[0].LoanOfficerName);
}
public void TestSelectAllAlertsDisbursmentAlertWhenStartDateGreaterThanTodayAndDisbursedTrueAndLoanOfficerFilterNotActive()
{
ApplicationSettings dataParam = ApplicationSettings.GetInstance("");
dataParam.DeleteAllParameters();
dataParam.AddParameter(OGeneralSettings.LOANOFFICERPORTFOLIOFILTER, false);
dataParam.AddParameter(OGeneralSettings.ACCOUNTINGPROCESS, OAccountingProcesses.Cash);
dataParam.AddParameter(OGeneralSettings.USECENTS, true);
credit.StartDate = DateTime.Today.AddDays(1);
credit.Disbursed = true;
FundingLine fund = new FundingLine();
fund.Purpose = "Microsoft financement";
fund.Name = "AFD130";
fund.Deleted = false;
fund.StartDate = DateTime.Now;
fund.EndDate = DateTime.Now;
fund.Currency = new Currency { Id = 1 };
fundingLineManager.AddFundingLine(fund, null);
credit.FundingLine = fund;
creditManagement.AddCredit(credit, _project.Id, null);
AlertStock alertStock = creditManagement.SelectAllAlerts("");
Assert.AreEqual(0, alertStock.GetNumberOfAlerts);
}
public void TestDeleteContract()
{
FundingLine fund = new FundingLine
{
Purpose = "Microsoft financement",
Name = "AFD130",
Deleted = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now,
Currency = new Currency { Id = 1 }
};
fundingLineManager.AddFundingLine(fund, null);
credit.FundingLine = fund;
guarantor.Tiers = tiers;
guarantor.Amount = 1000m;
credit.AddGuarantor(guarantor);
credit.Events.Add(new LoanDisbursmentEvent { Date = new DateTime(2006, 1, 1), Amount = 100, Commission = 100, ClientType = credit.ClientType });
credit.Id = creditManagement.AddCredit(credit, _project.Id, null);
Loan contractRetrievedBeforeDelete = creditManagement.SelectCreditById(credit.Id);
Assert.AreEqual(credit.Id, contractRetrievedBeforeDelete.Id);
creditManagement.DeleteContract(credit, null);
Loan contractRetrievedAfterDelete = creditManagement.SelectCreditById(credit.Id);
Assert.IsNull(contractRetrievedAfterDelete);
}
private void buttonAdd_Click(object sender, EventArgs e)
{
tabControlFundingLines.TabPages.Remove(tabPageFundingLineDetails);
tabControlFundingLines.TabPages.Add(tabPageFundingLineDetails);
tabControlFundingLines.SelectedTab = tabPageFundingLineDetails;
_fundingLine = new FundingLine();
InitializeTabPageFundingLineDetails(_fundingLine);
}
public void TestReassignContract()
{
User user = new User();
user.FirstName = "Andrey";
user.LastName = "Galkin";
user.Password = "******";
user.UserName = "******";
user.Mail = "*****@*****.**";
userManager.AddUser(user);
Assert.AreEqual(2, credit.InstallmentList.Count);
FundingLine fund = new FundingLine
{
Purpose = "Microsoft financement",
Name = "AFD130",
Deleted = false,
StartDate = DateTime.Now,
EndDate = DateTime.Now,
Currency = new Currency { Id = 1 }
};
fundingLineManager.AddFundingLine(fund, null);
credit.FundingLine = fund;
credit.LoanOfficer = user;
credit.Id = creditManagement.AddCredit(credit, _project.Id, null);
var newUser = new User { Id = addDataForTesting.AddUserWithMaximumAttributs() };
creditManagement.UpdateCreditByOfficer(credit.Id, newUser.Id, user.Id, null);
List<int> contract_id = creditManagement.SelectContractIdByNewOldLoanOfficer(newUser.Id, user.Id, null);
Assert.AreEqual(credit.Id, contract_id[0]);
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
_fundingLine.Name = textBoxFundingLineCode.Text;
_fundingLine.Purpose = textBoxFundingLineName.Text;
_fundingLine.StartDate = dateTimePickerFundingLineBeginDate.Value;
_fundingLine.EndDate = dateTimePickerFundingLineEndDate.Value;
_fundingLine.Currency = comboBoxCurrencies.SelectedItem as Currency;
if (_fundingLine.Id != 0)
ServicesProvider.GetInstance().GetFundingLinesServices().UpdateFundingLine(_fundingLine);
else
_fundingLine = ServicesProvider.GetInstance().GetFundingLinesServices().Create(_fundingLine);
InitializeFundingLines();
InitializeTabPageFundingLineDetails(_fundingLine);
btnSave.Text = GetString("update");
}
catch (Exception ex)
{
new frmShowError(CustomExceptionHandler.ShowExceptionText(ex)).ShowDialog();
}
}
public void TestSeachContractByCode()
{
FundingLine fund = new FundingLine();
fund.Purpose = "Microsoft financement";
fund.Name = "AFD130";
fund.Deleted = false;
fund.StartDate = DateTime.Now;
fund.EndDate = DateTime.Now;
fund.Currency = new Currency { Id = 1 };
fundingLineManager.AddFundingLine(fund, null);
credit.FundingLine = fund;
credit.Code = "TEST22";
credit.Id = creditManagement.AddCredit(credit, _project.Id, null);
int id = credit.Id;
Assert.AreEqual(id, creditManagement.SelectContractByContractCode(credit.Code).Id);
}
private void listViewFundingLine_DoubleClick(object sender, EventArgs e)
{
tabControlFundingLines.TabPages.Remove(tabPageFundingLineDetails);
tabControlFundingLines.TabPages.Add(tabPageFundingLineDetails);
tabControlFundingLines.SelectedTab = tabPageFundingLineDetails;
_fundingLine = (FundingLine) listViewFundingLine.SelectedItems[0].Tag;
InitializeTabPageFundingLineDetails(_fundingLine);
}
public void TestSearchContractInDatabaseWithClientNameSetWhenClientIsPerson()
{
ApplicationSettings dataParam = ApplicationSettings.GetInstance("");
dataParam.DeleteAllParameters();
dataParam.AddParameter(OGeneralSettings.LOANOFFICERPORTFOLIOFILTER, false);
dataParam.AddParameter(OGeneralSettings.ACCOUNTINGPROCESS, OAccountingProcesses.Cash);
dataParam.AddParameter(OGeneralSettings.USECENTS, true);
addDataForTesting.DeleteInstallments();
addDataForTesting.DeleteCreditContract();
addDataForTesting.DeletedProject();
addDataForTesting.DeleteInstallmentTypes();
addDataForTesting.DeleteTiers();
addDataForTesting.DeleteAllUser();
biWeekly = addDataForTesting.AddBiWeeklyInstallmentType();
package.Id = addDataForTesting.AddGenericPackage();
user.Id = addDataForTesting.AddUserWithIntermediaryAttributs();
addDataForTesting.AddGenericFundingLine();
credit.InstallmentType = biWeekly;
credit.Product = package;
credit.LoanOfficer = user;
Person person = new Person();
person.Id = addDataForTesting.AddGenericTiersIntoDatabase(OClientTypes.Person);
_project.Id = projectManager.Add(_project, person.Id, null);
FundingLine fund = new FundingLine();
fund.Purpose = "Microsoft financement";
fund.Name = "AFD130";
fund.Deleted = false;
fund.StartDate = DateTime.Now;
fund.EndDate = DateTime.Now;
fund.Currency = new Currency { Id = 1 };
fundingLineManager.AddFundingLine(fund, null);
credit.FundingLine = fund;
creditManagement.AddCredit(credit, _project.Id, null);
List<CreditSearchResult> ds = creditManagement.SearchCreditInDatabase(1, "Nico");
Assert.AreEqual(1, ds.Count);
Assert.AreEqual("Nicolas BARON", ds[0].ClientName);
}
public void FireFundingLineEvent(Event e, FundingLine fundingLine, SqlTransaction sqlTransac)
{
e.IsFired = true;
FundingLineEvent fL = e as FundingLineEvent;
//_movementSetManagement.AddTransaction(mS, sqlTransac);
}
public void TestSearchContractInDatabaseWithStartDateSetAndLoanOfficerFilterActiveButCurrentUserIsAdmin()
{
ApplicationSettings dataParam = ApplicationSettings.GetInstance("");
dataParam.DeleteAllParameters();
dataParam.AddParameter(OGeneralSettings.LOANOFFICERPORTFOLIOFILTER, false);
dataParam.AddParameter(OGeneralSettings.ACCOUNTINGPROCESS, OAccountingProcesses.Cash);
dataParam.AddParameter(OGeneralSettings.USECENTS, true);
User _user = new User();
_user.Id = this.addDataForTesting.AddUserWithMaximumAttributs();
_user.Role = User.Roles.ADMIN;
FundingLine fund = new FundingLine();
fund.Purpose = "Microsoft financement";
fund.Name = "AFD130";
fund.Deleted = false;
fund.StartDate = DateTime.Now;
fund.EndDate = DateTime.Now;
fund.Currency = new Currency { Id = 1 };
fundingLineManager.AddFundingLine(fund, null);
credit.FundingLine = fund;
creditManagement.AddCredit(credit, _project.Id, null);
credit.LoanOfficer = _user;
creditManagement.AddCredit(credit, _project.Id, null);
Assert.AreEqual(2, creditManagement.SearchCreditInDatabase(1, null).Count);
dataParam.DeleteAllParameters();
dataParam.AddParameter(OGeneralSettings.LOANOFFICERPORTFOLIOFILTER, true);
dataParam.AddParameter(OGeneralSettings.ACCOUNTINGPROCESS, OAccountingProcesses.Cash);
dataParam.AddParameter(OGeneralSettings.USECENTS, true);
User.CurrentUser = new User();
User.CurrentUser.Id = _user.Id;
User.CurrentUser.Role = User.Roles.ADMIN;
CreditContractManagement manager = new CreditContractManagement(DataUtil.TESTDB, User.CurrentUser);
Assert.AreEqual(2, manager.SearchCreditInDatabase(1, null).Count);
}
