public void AddGuarantorFinancer(GuarantorFinancerUnit oUnit)
{
SqlCommand oCommand = new SqlCommand();
oCommand.Connection = this.Connection;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandText = "SP_TRANS_INSERT_GUARANTORFINANCER";
oCommand.Parameters.Add(new SqlParameter("@GuarantorFinancerCode", oUnit.GuarantorFinancerCode));
oCommand.Parameters.Add(new SqlParameter("@GuarantorFinancerName", oUnit.GuarantorFinancerName));
oCommand.Parameters.Add(new SqlParameter("@Address", oUnit.Address));
oCommand.Parameters.Add(new SqlParameter("@ContactNumber", oUnit.ContactNumber));
oCommand.Parameters.Add(new SqlParameter("@EmailAddress", oUnit.EmailAddress));
oCommand.Parameters.Add(new SqlParameter("@ContactPerson", oUnit.ContactPerson));
oCommand.ExecuteNonQuery();
}
public void AddGuarantor()
{
GuarantorFinancerManager oManager = new GuarantorFinancerManager();
GuarantorFinancerUnit oUnit = new GuarantorFinancerUnit();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
oUnit.GuarantorFinancerCode = txtCode.Text;
oUnit.GuarantorFinancerName = txtEmployerName.Text;
oUnit.Address = txtAddress.Text;
oUnit.ContactNumber = txtContactNo.Text;
oUnit.EmailAddress = txtEmailAddress.Text;
oUnit.ContactNumber = txtContactNo.Text;
oUnit.ContactPerson = txtContactPerson.Text;
oManager.AddGuarantorFinancer(oUnit);
oManager.Close();
}
bool IsExists(string sCode)
{
GuarantorFinancerManager oManager = new GuarantorFinancerManager();
GuarantorFinancerUnit oUnit = new GuarantorFinancerUnit();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
bool rValue = oManager.IsExists(txtCode.Text);
oManager.Close();
return rValue;
}
