public void WatchCorporate(OClientTypes pClientTypes, bool includeOnlyActive)
{
groupBoxCorporates.Enabled = false;
if (pClientTypes == OClientTypes.Person || pClientTypes == OClientTypes.Group || OClientTypes.Village == pClientTypes)
{
radioButtonPerson.Checked = true;
checkBoxPersons.Checked = checkBoxPersons.Checked = pClientTypes == OClientTypes.Person;
checkBoxGroups.Checked = pClientTypes == OClientTypes.Group;
checkBoxVillages.Checked = pClientTypes == OClientTypes.Village;
checkBoxPersons.Enabled = true;
checkBoxGroups.Enabled = true;
checkBoxVillages.Enabled = true;
if (includeOnlyActive)
{
checkBoxActive.Enabled = false;
checkBoxActive.Checked = true;
checkBoxNotactive.Enabled = false;
checkBoxNotactive.Checked = true;
}
}
else
{
radioButtonCorporate.Checked = true;
}
}
//"person" or "group" for type
public int AddGenericTiersIntoDatabase(OClientTypes pClientType)
{
int districtId = AddDistrictIntoDatabase().Id;
OpenCbsCommand command = new OpenCbsCommand("INSERT INTO Tiers (creation_date,client_type_code,active,loan_cycle,bad_client,district_id,city) VALUES ('1/1/2007','G',1,1,0,@districtId,'Tress') SELECT SCOPE_IDENTITY()", SqlConnection);
command.AddParam("@districtId", districtId);
int tiersId = int.Parse(command.ExecuteScalar().ToString());
OpenCbsCommand insert = null;
if (pClientType == OClientTypes.Group)
{
insert = new OpenCbsCommand("INSERT INTO Groups (id,name) VALUES (" + tiersId + ",'SCG')", SqlConnection);
}
else if (pClientType == OClientTypes.Person)
{
insert = new OpenCbsCommand("INSERT INTO Persons (id,first_name,sex,identification_data,last_name,household_head) VALUES (" + tiersId + ",'Nicolas','M','123KH','BARON',1)", SqlConnection);
}
if (insert != null)
{
insert.ExecuteNonQuery();
}
return(tiersId);
}
protected SearchClientForm(OClientTypes pTiersEnum, bool inludeOnlyNotactive)
{
_clientType = pTiersEnum;
InitializeComponent();
Initialization(null, true);
WatchCorporate(pTiersEnum, inludeOnlyNotactive);
test = 2;
}
protected Client(List<Project> pProjects, OClientTypes pClientTypes)
{
foreach (Project project in pProjects)
project.Client = this;
_projects = pProjects;
Type = pClientTypes;
}
public static SearchClientForm GetInstance(OClientTypes pTiersEnum, bool includeNotactiveOnly, IApplicationController applicatinController)
{
if (_theUniqueInstance3 == null)
{
return(_theUniqueInstance3 = new SearchClientForm(pTiersEnum, includeNotactiveOnly, applicatinController));
}
return(_theUniqueInstance3);
}
public static SearchClientForm GetInstance(OClientTypes pTiersEnum, bool includeNotactiveOnly)
{
if (_theUniqueInstance3 == null)
{
return(_theUniqueInstance3 = new SearchClientForm(pTiersEnum, includeNotactiveOnly));
}
return(_theUniqueInstance3);
}
protected Client(List <Project> pProjects, OClientTypes pClientTypes)
{
foreach (Project project in pProjects)
{
project.Client = this;
}
_projects = pProjects;
Type = pClientTypes;
}
private void OpenClientForm(OClientTypes clientType)
{
var parent = Application.OpenForms[0];
var form = new ClientForm(clientType, parent, false)
{
MdiParent = parent
};
form.Show();
}
protected SearchClientForm(OClientTypes pTiersEnum, bool inludeOnlyNotactive, IApplicationController applicationController)
{
_clientType = pTiersEnum;
InitializeComponent();
Initialization(null, true);
WatchCorporate(pTiersEnum, inludeOnlyNotactive);
test = 2;
_applicationController = applicationController;
RunInitializers();
}
public ClientSearchResult(int pId, string pName, OClientTypes pType, bool pActive, int pLoanCycle, string pDistrict, string pCity,
bool pBadClient, string pPassportNumber,string pPersonGroupBelongTo)
{
Id = pId;
Type = pType;
PassportNumber = pPassportNumber;
BadClient = pBadClient;
City = pCity;
District = pDistrict;
LoanCycle = pLoanCycle;
Active = pActive;
Name = pName;
MemberOf = pPersonGroupBelongTo;
}
public ClientSearchResult(int pId, string pName, OClientTypes pType, bool pActive, int pLoanCycle, string pDistrict, string pCity,
bool pBadClient, string pPassportNumber, string pPersonGroupBelongTo)
{
Id = pId;
Type = pType;
PassportNumber = pPassportNumber;
BadClient = pBadClient;
City = pCity;
District = pDistrict;
LoanCycle = pLoanCycle;
Active = pActive;
Name = pName;
MemberOf = pPersonGroupBelongTo;
}
public List <LoanProduct> FindAllPackages(bool selectDeleted, OClientTypes pClientType)
{
List <LoanProduct> retval = _productManager.SelectAllPackages(selectDeleted, pClientType);
foreach (LoanProduct product in retval)
{
if (null == product.FundingLine)
{
continue;
}
product.FundingLine.Currency = new CurrencyServices(_user).GetCurrency(product.FundingLine.Currency.Id);
if (product.UseEntryFeesCycles)
{
product.EntryFeeCycles = _productManager.SelectEntryFeeCycles(product.Id, false);
product.EntryFees = _productManager.SelectEntryFeesWithCycles(product.Id, false);
}
else
{
product.EntryFees = _productManager.SelectEntryFeesWithoutCycles(product.Id, false);
}
}
return(retval);
}
private void InitializeComboboxActivity()
{
cmbEconomicActivity.Items.Clear();
cmbEconomicActivity.ValueMember = "Id";
cmbEconomicActivity.DisplayMember = "Name";
cmbEconomicActivity.Items.Add(
new { Id = 0, Name = MultiLanguageStrings.GetString(Ressource.AccountingRule, "All.Text") });
cmbEconomicActivity.SelectedIndex = 0;
OClientTypes clientType = (OClientTypes)Enum.Parse(typeof(OClientTypes), cmbClientType.SelectedValue.ToString());
if (clientType == OClientTypes.Person || clientType == OClientTypes.Corporate)
{
cmbEconomicActivity.Enabled = true;
foreach (EconomicActivity activity in ServicesProvider.GetInstance().GetEconomicActivityServices().FindAllEconomicActivities())
{
cmbEconomicActivity.Items.Add(activity);
}
}
else
{
cmbEconomicActivity.Enabled = false;
}
}
private void OpenClientForm(OClientTypes clientType)
{
var parent = Application.OpenForms[0];
var form = new ClientForm(clientType, parent, false) { MdiParent = parent };
form.Show();
}
public List<ClientSearchResult> SetClientSearchResult(string q, string pQuery, OClientTypes pClientType)
{
List<ClientSearchResult> list = new List<ClientSearchResult>();
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
{
c.AddParam("@name", string.Format("%{0}%", pQuery));
c.AddParam("@district", string.Format("%{0}%", pQuery));
c.AddParam("@city", string.Format("%{0}%", pQuery));
if (pClientType == OClientTypes.Person)
{
c.AddParam("@passportNumber", string.Format("%{0}%", pQuery));
}
using (OpenCbsReader r = c.ExecuteReader())
{
if (!r.Empty)
{
while (r.Read())
{
ClientSearchResult result = new ClientSearchResult();
result.Id = r.GetInt("id");
result.Type = r.GetChar("type") == 'I'
? OClientTypes.Person
: OClientTypes.Group;
result.Name = r.GetString("name");
result.Active = r.GetBool("active");
result.LoanCycle = pClientType == OClientTypes.Group
? 0
: r.GetInt("loan_cycle");
result.District = r.GetString("district");
result.City = r.GetString("city");
result.BadClient = r.GetBool("bad_client");
result.PassportNumber = r.GetString("passport_number");
result.MemberOf = r.GetString("group_name");
list.Add(result);
}
}
}
}
return list;
}
public List<ISavingProduct> FindAllSavingsProducts(bool showAlsoDeleted, OClientTypes clientType)
{
return _savingProductManager.SelectProducts(showAlsoDeleted, clientType);
}
public List<ClientSearchResult> SetCorporatesSearchResult(string q, string pQuery, OClientTypes pClientType)
{
List<ClientSearchResult> list = new List<ClientSearchResult>();
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
{
c.AddParam("@name", string.Format("%{0}%", pQuery));
c.AddParam("@district", string.Format("%{0}%", pQuery));
c.AddParam("@city", string.Format("%{0}%", pQuery));
c.AddParam("@siret", string.Format("%{0}%", pQuery));
using (OpenCbsReader r = c.ExecuteReader())
{
if (!r.Empty)
{
while (r.Read())
{
ClientSearchResult result = new ClientSearchResult();
result.Id = r.GetInt("id");
result.Name = r.GetString("name");
result.Active = r.GetBool("active");
result.District = r.GetString("district");
result.City = r.GetString("city");
result.Siret = r.GetString("siret");
result.Type = OClientTypes.Corporate;
list.Add(result);
}
}
}
}
return list;
}
public ClientForm(Person pPerson, Form pMdiParent)
: this()
{
_mdiParent = pMdiParent;
_person = pPerson;
_client = pPerson;
InitLoanOfficers(_client);
_listGuarantors = new List<Guarantor>();
_collaterals = new List<ContractCollateral>();
_loanShares = new List<LoanShare>();
InitializeComponent();
InitControls();
_oClientType = OClientTypes.Person;
InitializeUserControl(OClientTypes.Person, pMdiParent);
InitializeTitle(string.Format("{0} {1}", pPerson.FirstName, pPerson.LastName));
}
private static char _GetClientChar(OClientTypes clientType)
{
char type = 'I';
switch (clientType)
{
case OClientTypes.Person:
type = 'I';
break;
case OClientTypes.Group:
type = 'G';
break;
case OClientTypes.Corporate:
type = 'C';
break;
case OClientTypes.Village:
type = 'V';
break;
}
return type;
}
private void InitializeClient(IClient pClient, int pContractId)
{
if (pClient is Person)
{
_person = (Person)pClient;
_client = _person;
_oClientType = OClientTypes.Person;
InitializeUserControl(_oClientType, _mdiParent);
InitializeTitle(string.Format("{0} {1}", _person.FirstName, _person.LastName));
}
if (pClient is Group)
{
_group = (Group)pClient;
_client = _group;
_oClientType = OClientTypes.Group;
InitializeUserControl(_oClientType, _mdiParent);
InitializeTitle(_group.Name);
}
if (pClient is Corporate)
{
_corporate = (Corporate)pClient;
_client = _corporate;
_oClientType = OClientTypes.Corporate;
InitializeUserControl(_oClientType, _mdiParent);
InitializeTitle(_corporate.Name);
}
_project = pClient.SelectProject(pContractId);
_credit = _project.SelectCredit(pContractId);
_credit.LoanEntryFeesList = ServicesProvider.GetInstance().GetContractServices().GetInstalledLoanEntryFees(_credit);
_product = _credit.Product;
if (_product.CycleId != null && _credit.Disbursed == false)
{
ServicesProvider.GetInstance().GetProductServices().SetCyclesParamsForContract(_product, _credit, _client, false);
}
else
{
if (_credit.Product.Amount.HasValue == false)
{
_amountValueRange = new DecimalValueRange(_credit.Product.AmountMin.Value, _credit.Product.AmountMax.Value);
nudLoanAmount.Minimum = _credit.Product.AmountMin.Value;
nudLoanAmount.Maximum = _credit.Product.AmountMax.Value;
}
else
{
nudLoanAmount.Minimum = nudLoanAmount.Maximum = _credit.Product.Amount.Value;
}
if (_credit.Product.NbOfInstallments.HasValue == false)
{
nudLoanNbOfInstallments.Minimum = _credit.Product.NbOfInstallmentsMin.Value;
nudLoanNbOfInstallments.Maximum = _credit.Product.NbOfInstallmentsMax.Value;
}
else
{
nudLoanNbOfInstallments.Minimum = nudLoanNbOfInstallments.Maximum = _credit.Product.NbOfInstallments.Value;
}
}
if (ServicesProvider.GetInstance().GetGeneralSettings().UseProjects)
{
tabControlPerson.TabPages.Add(tabPageProject);
DisplaySelectedProject(_project);
}
else
{
AddProject(_project);
}
tabControlPerson.TabPages.Add(tabPageLoansDetails);
tabControlPerson.TabPages.Add(tabPageAdvancedSettings);
tabControlPerson.TabPages.Add(tabPageLoanGuarantees);
_credit.LoanInitialOfficer = _credit.LoanOfficer;
InitializeTabPageLoansDetails(_credit);
tabControlPerson.TabPages.Add(tabPageCreditCommitee);
if (_credit.Disbursed)
{
tabControlPerson.TabPages.Add(tabPageLoanRepayment);
//tabControlPerson.TabPages.Add(tabPageLAC);
tabControlPerson.SelectedTab = tabPageLoanRepayment;
InitializeTabPageLoanRepayment(_credit);
}
else if (_credit.ContractStatus == OContractStatus.Validated && !_credit.Disbursed)
{
tabControlPerson.SelectedTab = tabPageLoansDetails;
}
}
//"person" or "group" for type
public int AddGenericTiersIntoDatabase(OClientTypes pClientType)
{
int districtId = AddDistrictIntoDatabase().Id;
OpenCbsCommand command = new OpenCbsCommand("INSERT INTO Tiers (creation_date,client_type_code,active,loan_cycle,bad_client,district_id,city) VALUES ('1/1/2007','G',1,1,0,@districtId,'Tress') SELECT SCOPE_IDENTITY()", SqlConnection);
command.AddParam("@districtId", districtId);
int tiersId = int.Parse(command.ExecuteScalar().ToString());
OpenCbsCommand insert = null;
if (pClientType == OClientTypes.Group)
insert = new OpenCbsCommand("INSERT INTO Groups (id,name) VALUES (" + tiersId + ",'SCG')", SqlConnection);
else if (pClientType == OClientTypes.Person)
insert = new OpenCbsCommand("INSERT INTO Persons (id,first_name,sex,identification_data,last_name) VALUES (" + tiersId + ",'Nicolas','M','123KH','BARON',1)", SqlConnection);
if (insert != null) insert.ExecuteNonQuery();
return tiersId;
}
public void WatchCorporate(OClientTypes pClientTypes, bool includeOnlyActive)
{
groupBoxCorporates.Enabled = false;
if (pClientTypes == OClientTypes.Person || pClientTypes == OClientTypes.Group || OClientTypes.Village == pClientTypes)
{
radioButtonPerson.Checked = true;
checkBoxPersons.Checked = checkBoxPersons.Checked = pClientTypes == OClientTypes.Person;
checkBoxGroups.Checked = pClientTypes == OClientTypes.Group;
checkBoxVillages.Checked = pClientTypes == OClientTypes.Village;
checkBoxPersons.Enabled = true;
checkBoxGroups.Enabled = true;
checkBoxVillages.Enabled = true;
if (includeOnlyActive)
{
checkBoxActive.Enabled = false;
checkBoxActive.Checked = true;
checkBoxNotactive.Enabled = false;
checkBoxNotactive.Checked = true;
}
}
else
{
radioButtonCorporate.Checked = true;
}
}
public ClientForm(Group pGroup, Form pMdiParent)
: this()
{
_mdiParent = pMdiParent;
_group = pGroup;
_client = pGroup;
InitLoanOfficers(_client);
_listGuarantors = new List<Guarantor>();
_collaterals = new List<ContractCollateral>();
_loanShares = new List<LoanShare>();
InitializeComponent();
InitControls();
_oClientType = OClientTypes.Group;
InitializeUserControl(OClientTypes.Group, pMdiParent);
InitializeTitle(_group.Name);
}
public static SearchClientForm GetInstance(OClientTypes pTiersEnum, bool includeNotactiveOnly)
{
if (_theUniqueInstance3 == null)
return _theUniqueInstance3 = new SearchClientForm(pTiersEnum, includeNotactiveOnly);
return _theUniqueInstance3;
}
protected SearchClientForm(OClientTypes pTiersEnum, bool inludeOnlyNotactive)
{
_clientType = pTiersEnum;
InitializeComponent();
Initialization(null, true);
WatchCorporate(pTiersEnum, inludeOnlyNotactive);
test = 2;
}
public List<LoanProduct> SelectAllPackages(bool pShowAlsoDeleted, OClientTypes pClientType)
{
List<LoanProduct> packagesList = new List<LoanProduct>();
string q = @"SELECT DISTINCT
[dbo].[Packages].[id]
FROM [dbo].[Packages]
INNER JOIN [dbo].[PackagesClientTypes] ON [dbo].[Packages].[id]=[dbo].[PackagesClientTypes].[package_id]
INNER JOIN [dbo].[ClientTypes] ON [dbo].[ClientTypes].[id]=[dbo].[PackagesClientTypes].[client_type_id]
WHERE 1 = 1";
if (!pShowAlsoDeleted)
q += " AND [dbo].[Packages].[deleted] = 0";
switch (pClientType)
{
case OClientTypes.Person:
q += " AND [dbo].[ClientTypes].[type_name] ='Individual' ";
break;
case OClientTypes.Group:
q += " AND [dbo].[ClientTypes].[type_name]='Group' ";
break;
case OClientTypes.Corporate:
q += " AND [dbo].[ClientTypes].[type_name]='Corporate' ";
break;
case OClientTypes.Village:
q += " AND [dbo].[ClientTypes].[type_name]='Village' ";
break;
}
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
using (OpenCbsReader r = c.ExecuteReader())
{
if (r == null || r.Empty) return new List<LoanProduct>();
while (r.Read())
{
LoanProduct pack = new LoanProduct {Id = r.GetInt("id")};
packagesList.Add(pack);
}
}
for (int i = 0; i < packagesList.Count; i++)
{
LoanProduct product = Select(packagesList[i].Id);
packagesList[i] = product;
FireProductLoaded(product);
}
return packagesList;
}
public IClient FindTiers(int tiersId, OClientTypes type)
{
IClient client = null;
if (type == OClientTypes.Corporate)
client = _clientManagement.SelectBodyCorporateById(tiersId);
if (type == OClientTypes.Group)
client = _clientManagement.SelectGroupById(tiersId);
if (type == OClientTypes.Person)
client = _clientManagement.SelectPersonById(tiersId);
if (OClientTypes.Village == type)
client = _clientManagement.SelectVillageById(tiersId);
if (client != null)
client.ActiveLoans = _loanServices.GetActiveLoans(client.Id);
return client;
}
public void AddGuarantee(Guarantee pGuarantee, OClientTypes pClientType)
{
pGuarantee.ClientType = pClientType;
pGuarantee.Project = this;
_guarantees.Add(pGuarantee);
}
public ClientForm(OClientTypes pClientType, Form pMdiParent, bool pCloseFormAfterSave)
: this()
{
_listGuarantors = new List<Guarantor>();
_collaterals = new List<ContractCollateral>();
_loanShares = new List<LoanShare>();
_closeFormAfterSave = pCloseFormAfterSave;
_mdiParent = pMdiParent;
InitializeComponent();
InitControls();
_oClientType = pClientType;
if (pClientType == OClientTypes.Person) _person = new Person();
else if (pClientType == OClientTypes.Group) _group = new Group();
else _corporate = new Corporate();
InitializeUserControl(pClientType, pMdiParent);
InitializeTitle(null);
}
public List <ISavingProduct> FindAllSavingsProducts(bool showAlsoDeleted, OClientTypes clientType)
{
return(_savingProductManager.SelectProducts(showAlsoDeleted, clientType));
}
public ClientForm(Corporate pCorporate, Form pMdiParent)
: this()
{
_mdiParent = pMdiParent;
_corporate = pCorporate;
_client = pCorporate;
InitLoanOfficers(_client);
_listGuarantors = new List<Guarantor>();
_collaterals = new List<ContractCollateral>();
_loanShares = new List<LoanShare>();
InitializeComponent();
InitControls();
_oClientType = OClientTypes.Corporate;
InitializeUserControl(OClientTypes.Corporate, pMdiParent);
InitializeTitle(_corporate.Name);
}
private static string BuildWhereConditionsForSearchClients(string pQuery, OClientTypes pClientType)
{
string whereConditions = string.Empty;
if (pQuery != null)
{
if (pClientType == OClientTypes.Person)
whereConditions = @"AND (Persons.first_name LIKE @name
OR Persons.last_name LIKE @name
OR Persons.identification_data LIKE @passportNumber ";
if (pClientType == OClientTypes.Group)
whereConditions = @"AND (Groups.name LIKE @name ";
if (pClientType == OClientTypes.Corporate)
whereConditions = @"AND (Corporates.name LIKE @name
OR Corporates.siret LIKE @siret ";
whereConditions += @"OR Districts.name LIKE @district
OR Tiers.city LIKE @city) ";
}
return whereConditions;
}
public void DisplayClient(IClient pClient, Project project)
{
if (pClient is Person)
{
_person = (Person)pClient;
_oClientType = OClientTypes.Person;
InitializeUserControl(_oClientType, _mdiParent);
InitializeTitle(string.Format("{0} {1}", _person.FirstName, _person.LastName));
}
if (pClient is Group)
{
_group = (Group)pClient;
_oClientType = OClientTypes.Group;
InitializeUserControl(_oClientType, _mdiParent);
InitializeTitle(_group.Name);
}
if (pClient is Corporate)
{
_corporate = (Corporate)pClient;
_oClientType = OClientTypes.Corporate;
InitializeUserControl(_oClientType, _mdiParent);
InitializeTitle(_corporate.Name);
}
tabControlPerson.TabPages.Add(tabPageProject);
DisplaySelectedProject(_project);
}
public void AddCredit(Loan pCredit,OClientTypes pClientType)
{
pCredit.ClientType = pClientType;
pCredit.Project = this;
_credits.Add(pCredit);
}
private void InitializeUserControl(OClientTypes pClientType, Form pMdiParent)
{
btnLoanShares.Visible = OClientTypes.Group == pClientType;
tabControlPerson.TabPages.Remove(tabPageProject);
tabControlPerson.TabPages.Remove(tabPageCreditCommitee);
tabControlPerson.TabPages.Remove(tabPageLoansDetails);
tabControlPerson.TabPages.Remove(tabPageAdvancedSettings);
tabControlPerson.TabPages.Remove(tabPageLoanRepayment);
tabControlPerson.TabPages.Remove(tabPageLoanGuarantees);
tabControlPerson.TabPages.Remove(tabPageSavingDetails);
tabControlPerson.TabPages.Remove(tabPageContracts);
InitializeProjectAddress();
if (pClientType == OClientTypes.Person)
{
_personUserControl = new PersonUserControl(_person, pMdiParent)
{
Dock = DockStyle.Fill,
Enabled = true,
Name = "personUserControl",
Visible = true
};
_personUserControl.ButtonCancelClick += personUserControl_ButtonCancelClick;
_personUserControl.ButtonSaveClick += personUserControl_ButtonSaveClick;
_personUserControl.ButtonBadLoanClick += personUserControl_ButtonBadLoanClick;
_personUserControl.ButtonAddProjectClick += personUserControl_ButtonAddProjectClick;
_personUserControl.ViewProject += DisplayUserControl_ViewProject;
_personUserControl.AddSelectedSaving += PersonUserControl_SavingSelected;
_personUserControl.ViewSelectedSaving += PersonUserControl_ViewSelectedSaving;
tabPageDetails.Controls.Add(_personUserControl);
if (!ServicesProvider.GetInstance().GetGeneralSettings().UseProjects)
{
_personUserControl.RemoveSavings();
panelSavingsContracts.Controls.Add(_personUserControl.PanelSavings);
}
}
else if (pClientType == OClientTypes.Group)
{
_groupUserControl = new GroupUserControl(_group, pMdiParent)
{
Dock = DockStyle.Fill,
Enabled = true,
Name = "groupUserControl",
Visible = true
};
_groupUserControl.ButtonCancelClick += GroupUserControl_ButtonCancelClick;
_groupUserControl.ButtonSaveClick += GroupUserControl_ButtonSaveClick;
_groupUserControl.ButtonBadClientClick += GroupUserControl_ButtonBadClientClick;
_groupUserControl.ButtonAddProjectClick += GroupUserControl_ButtonAddProjectClick;
_groupUserControl.ViewSelectedSaving += GroupUserControl_ViewSelectedSaving;
_groupUserControl.AddSelectedSaving += GroupUserControl_AddSelectedSaving;
_groupUserControl.ViewProject += DisplayUserControl_ViewProject;
_groupUserControl.MembersChanged += MembersChanged;
tabPageDetails.Controls.Add(_groupUserControl);
if (!ServicesProvider.GetInstance().GetGeneralSettings().UseProjects)
{
_groupUserControl.RemoveSavings();
panelSavingsContracts.Controls.Add(_groupUserControl.PanelSavings);
AddProject(null);
}
}
else
{
_corporateUserControl = new CorporateUserControl(_corporate, pMdiParent)
{
Dock = DockStyle.Fill,
Enabled = true,
Name = "corporateUserControl",
Visible = true
};
_corporateUserControl.ViewProject += DisplayUserControl_ViewProject;
_corporateUserControl.ButtonCancel += CorporateUserControl_ButtonCancel;
_corporateUserControl.ButtonAddProjectClick += corporateUserControl_ButtonAddProjectClick;
_corporateUserControl.ButtonSaveClick += CorporateUserControl_ButtonSaveClick;
_corporateUserControl.ViewSelectedSaving += CorporateUserControl_ViewSelectedSaving;
_corporateUserControl.AddSelectedSaving += CorporateUserControl_AddSelectedSaving;
if (_closeFormAfterSave)
_corporateUserControl.CloseCorporate += CorporateUserControl_Closed;
tabPageDetails.Controls.Add(_corporateUserControl);
if (!ServicesProvider.GetInstance().GetGeneralSettings().UseProjects)
{
_corporateUserControl.RemoveSavings();
panelSavingsContracts.Controls.Add(_corporateUserControl.PanelSavings);
AddProject(null);
tabControlPerson.SelectedTab = tabPageCorporate;
}
}
}
/// <summary>
/// Select all packages in database
/// </summary>
/// <param name="showAlsoDeleted"></param>
/// <returns>a list contains all packages</returns>
/// <param name="clientType"></param>
public List<ISavingProduct> SelectProducts(bool showAlsoDeleted, OClientTypes clientType)
{
List<ISavingProduct> productsList = new List<ISavingProduct>();
string q = @"SELECT DISTINCT
[dbo].[SavingProducts].[id],
[dbo].[SavingProducts].[product_type]
FROM [dbo].[SavingProducts]
INNER JOIN [dbo].[SavingProductsClientTypes] ON
[dbo].[SavingProductsClientTypes].[saving_product_id]=[dbo].[SavingProducts].[id]
INNER JOIN [dbo].[ClientTypes] ON
[dbo].[ClientTypes].[id]=[dbo].[SavingProductsClientTypes].[client_type_id]
WHERE 1 = 1";
if (!showAlsoDeleted)
q += " AND deleted = 0";
switch (clientType)
{
case OClientTypes.Person:
q += " AND [dbo].[ClientTypes].[type_name] = 'Individual' ";
break;
case OClientTypes.Group:
q += " AND [dbo].[ClientTypes].[type_name] = 'Group' ";
break;
case OClientTypes.Corporate:
q += " AND [dbo].[ClientTypes].[type_name] = 'Corporate'";
break;
case OClientTypes.Village:
q += " AND [dbo].[ClientTypes].[type_name]='Village'";
break;
}
using (SqlConnection conn = GetConnection())
using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
{
using (OpenCbsReader r = c.ExecuteReader())
{
if(r == null || r.Empty) return new List<ISavingProduct>();
while (r.Read())
{
ISavingProduct pack;
switch (r.GetChar("product_type"))
{
case 'B' :
pack = new SavingsBookProduct();
break;
default:
pack = null; break;
}
pack.Id = r.GetInt("id");
productsList.Add(pack);
}
}
}
for (int i = 0; i < productsList.Count; i++)
{
if (productsList[i] is SavingsBookProduct)
productsList[i] = SelectSavingsBookProduct(productsList[i].Id);
}
return productsList;
}
public List<LoanProduct> FindAllPackages(bool selectDeleted,OClientTypes pClientType)
{
List<LoanProduct> retval = _productManager.SelectAllPackages(selectDeleted,pClientType);
foreach (LoanProduct product in retval)
{
if (null == product.FundingLine) continue;
product.FundingLine.Currency = new CurrencyServices(_user).GetCurrency(product.FundingLine.Currency.Id);
if (product.UseEntryFeesCycles)
{
product.EntryFeeCycles = _productManager.SelectEntryFeeCycles(product.Id, false);
product.EntryFees = _productManager.SelectEntryFeesWithCycles(product.Id, false);
}
else
{
product.EntryFees = _productManager.SelectEntryFeesWithoutCycles(product.Id, false);
}
}
return retval;
}
public void AddCredit(Loan pCredit, OClientTypes pClientType)
{
pCredit.ClientType = pClientType;
pCredit.Project = this;
_credits.Add(pCredit);
}
