public AddGuarantorForm(Form pMdiParent, Currency tcode)
{
_mdiParent = pMdiParent;
_guarantor = new Guarantor();
_guarantor.Amount = 0;
code = tcode;
Initialization();
}
public AddGuarantorForm(Form pMdiParent, Currency tcode, IApplicationController applicationController)
{
_mdiParent = pMdiParent;
_guarantor = new Guarantor();
_guarantor.Amount = 0;
code = tcode;
Initialization();
}
public AddGuarantorForm(Form pMdiParent, Currency tcode, IExtensionActivator extensionActivator)
{
_extensionActivator = extensionActivator;
_mdiParent = pMdiParent;
_guarantor = new Guarantor();
_guarantor.Amount = 0;
code = tcode;
Initialization();
}
public AddGuarantorForm(Guarantor guarantor, Form pMdiParent, bool isView, Currency tcode)
{
_mdiParent = pMdiParent;
_guarantor = guarantor;
code = tcode;
Initialization();
InitializeGuarantor();
if (isView)
{
groupBoxName.Enabled = false;
groupBoxAmount.Enabled = false;
buttonSave.Enabled = false;
}
}
private void _AddGuarantor(Guarantor pGuarantor, int pLoanId, SqlTransaction pSqlTransac)
{
const string q = @"INSERT INTO [LinkGuarantorCredit]([tiers_id], [contract_id], [guarantee_amount], [guarantee_desc])
VALUES(@tiersId, @contractId, @guaranteeAmount, @guaranteeDesc)";
using (OpenCbsCommand c = new OpenCbsCommand(q, pSqlTransac.Connection, pSqlTransac))
{
c.AddParam("@tiersId", pGuarantor.Tiers.Id);
c.AddParam("@contractId", pLoanId);
c.AddParam("@guaranteeAmount", pGuarantor.Amount);
c.AddParam("@guaranteeDesc", pGuarantor.Description);
c.ExecuteNonQuery();
}
}
private List<Guarantor> GetGuarantors(int pLoanId)
{
const string q = @"SELECT [tiers_id],
[guarantee_amount],
[guarantee_desc],
[client_type_code],
Groups.name,
Persons.first_name,
Persons.last_name,
district_id
FROM [LinkGuarantorCredit]
INNER JOIN Tiers ON LinkGuarantorCredit.tiers_id = Tiers.id
LEFT OUTER JOIN Groups ON Groups.id = Tiers.id
LEFT OUTER JOIN Persons ON Persons.id = Tiers.id
WHERE LinkGuarantorCredit.contract_id = @id";
using (SqlConnection conn = GetConnection())
using(OpenCbsCommand c = new OpenCbsCommand(q, conn))
{
c.AddParam("@id", pLoanId);
using (OpenCbsReader r = c.ExecuteReader())
{
if(r == null || r.Empty) return new List<Guarantor>();
List<Guarantor> list = new List<Guarantor>();
while (r.Read())
{
Guarantor guarantor = new Guarantor
{
Amount = r.GetMoney("guarantee_amount"),
Description = r.GetString("guarantee_desc")
};
if (r.GetChar("client_type_code") == 'I')
{
guarantor.Tiers = new Person
{
FirstName = r.GetString("first_name"),
LastName = r.GetString("last_name"),
District = new District
{
Id = r.GetInt("district_id"),
Name = null
}
};
}
else
guarantor.Tiers = new Group {Name = r.GetString("name")};
guarantor.Tiers.Id = r.GetInt("tiers_id");
list.Add(guarantor);
}
return list;
}
}
}
private void buttonCancel_Click(object sender, EventArgs e)
{
_guarantor = null;
Close();
}
public void AddGuarantor(Guarantor pGuarantor)
{
_guarantors.Add(pGuarantor);
}
public bool GuarantorIsNull(Guarantor guarantor)
{
bool result = false;
if (guarantor == null)
result = true;
else if (guarantor.Tiers == null || guarantor.Amount == 0)
result = true;
return result;
}
