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; }