/// <summary>
/// Create a new t_dmms_master object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
/// <param name="nEW_NRIC">Initial value of the NEW_NRIC property.</param>
/// <param name="pROPERTY_ADD1">Initial value of the PROPERTY_ADD1 property.</param>
/// <param name="cERT_START_DATE">Initial value of the CERT_START_DATE property.</param>
public static t_dmms_master Createt_dmms_master(global::System.Int32 id, global::System.String nEW_NRIC, global::System.String pROPERTY_ADD1, global::System.String cERT_START_DATE)
{
t_dmms_master t_dmms_master = new t_dmms_master();
t_dmms_master.id = id;
t_dmms_master.NEW_NRIC = nEW_NRIC;
t_dmms_master.PROPERTY_ADD1 = pROPERTY_ADD1;
t_dmms_master.CERT_START_DATE = cERT_START_DATE;
return t_dmms_master;
}
/// <summary>
/// Deprecated Method for adding a new object to the t_dmms_master EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTot_dmms_master(t_dmms_master t_dmms_master)
{
base.AddObject("t_dmms_master", t_dmms_master);
}
private void merging()
{
foreach (t_Bank_data bank in bankList)
{
List<t_Insurance_data> tempInsList = new List<t_Insurance_data>();
tempInsList = getInsurance(bank.policy_no);
if(tempInsList.Count > 0)
{
foreach(t_Insurance_data tempIns in tempInsList)
{
t_dmms_master mrgObj = new t_dmms_master();
mrgObj.BANK_REF_NO = bank.bank_ref_number;
mrgObj.NEW_NRIC = bank.nric;
mrgObj.POLICY_NO = bank.policy_no;
mrgObj.CUSTOMER_NAME = bank.participant_name;
//mrgObj.CUSTOMER_ADD2 = bank.customer_address_1;
mrgObj.CUSTOMER_ADD2 = bank.customer_address_2;
mrgObj.CUSTOMER_ADD3 = bank.customer_address_3;
mrgObj.CUSTOMER_ADD4 = bank.customer_address_4;
mrgObj.CUSTOMER_ADD5 = bank.customer_address_5;
mrgObj.CUSTOMER_CITY = tempIns.city;
mrgObj.CUSTOMER_POSTCODE = tempIns.post_code;
mrgObj.PROPERTY_TYPE = bank.property_type;
mrgObj.PROPERTY_ADD1 = bank.property_address_1;
mrgObj.PROPERTY_ADD2 = bank.property_address_2;
mrgObj.PROPERTY_ADD3 = bank.property_address_3;
mrgObj.PROPERTY_ADD4 = bank.property_address_4;
mrgObj.PROPERTY_CITY = tempIns.property_city;
mrgObj.PROPERTY_POSCODE = tempIns.property_post_code;
mrgObj.INSURANCE_TYPE = tempIns.insurance_type;
mrgObj.CERT_START_DATE = Convert.ToString(bank.policy_effective_date);
mrgObj.CERT_END_DATE = Convert.ToString(bank.policy_expired_date);
mrgObj.SUM_INSURED_AMOUNT = tempIns.sum_insured_amt;
mrgObj.BANK_STAFF = tempIns.bank_staff;
mrgObj.ACC_NO = tempIns.account_no;
mrgObj.TRITON_ACC_NO = tempIns.triton_account_no;
mrgObj.BRANCH_CODE = tempIns.branch_code;
mrgObj.FACILTY_TYPE = tempIns.facility_type;
mrgObj.APPROVED_LIMIT = tempIns.approved_limit;
mrgObj.APPROVED_DATE = Convert.ToString(tempIns.approved_date);
mrgObj.BAL_OUTSTANDING = tempIns.balance_outstanding;
mrgObj.COST_OUTSTANDING = tempIns.cost_outstanding;
mrgObj.PRINCIPAL_OUTSTANDING = tempIns.principal_outstanding;
mrgObj.UEI_OUTSTANDING = tempIns.uei_outstanding;
mrgObj.MONTH_ARREARS = tempIns.month_arrears;
mrgObj.CREDIT_STATUS = tempIns.credit_status;
mrgObj.CREDIT_STAT_CHG_DATE = Convert.ToString(tempIns.credit_stat_change_date);
mrgObj.NPF_STATUS = tempIns.npf_status;
mrgObj.REPORTING_BALANCE = tempIns.reporting_balance;
mrgObj.INCOME_ARREARS = tempIns.income_arrears;
mrgObj.CURR_BAL_OUTSTANDING = tempIns.curr_balance_outstanding;
mrgObj.COLLATERAL_REFNO = tempIns.collateral_ref_number;
mrgObj.CLAIM_TYPE = tempIns.claim_type;
mrgObj.TITLE_NO = tempIns.title_no;
mrgObj.LAND_OFFICE = tempIns.land_office;
mrgObj.LOT_NO = tempIns.lot_number;
mrgObj.PROPERTY_DISTRICT = tempIns.property_district;
mrgObj.MUKIM = tempIns.mukim;
mrgObj.SECURITY_VALUE = tempIns.security_value;
mrgObj.PROPERTY_DESC = tempIns.property_desc;
mrgObj.PROPERTY_OWNER1 = tempIns.property_owner_1;
mrgObj.PROPERTY_OWNER2 = tempIns.property_owner_2;
mrgObj.INSURANCE_COMPANY = tempIns.insurance_company;
mrgObj.COVERAGE_TYPE = tempIns.coverage_type;
mrgObj.PARTICIPANT_NAME = tempIns.participant_name;
mrgObj.RISK_ADD1 = tempIns.risk_address_1;
mrgObj.RISK_ADD2 = tempIns.risk_address_2;
mrgObj.RISK_ADD3 = tempIns.risk_address_3;
mrgObj.RISK_POSTCODE = tempIns.risk_post_code;
mrgObj.RISK_STATE_CODE = tempIns.risk_state_code;
mrgObj.PREMIUM_AMOUNT = tempIns.premium_amt;
mrgObj.INSURANCE_LAST_MODIFIED_DATE = Convert.ToString(tempIns.insurance_last_modified_date);
mrgList.Add(mrgObj);
}
}
else
{
t_dmms_master mrgObj = new t_dmms_master();
mrgObj.BANK_REF_NO = bank.bank_ref_number;
mrgObj.NEW_NRIC = bank.nric;
mrgObj.POLICY_NO = bank.policy_no;
mrgObj.CUSTOMER_NAME = bank.participant_name;
// mrgObj.CUSTOMER_ADD2 = bank.customer_address_1;
mrgObj.CUSTOMER_ADD2 = bank.customer_address_2;
mrgObj.CUSTOMER_ADD3 = bank.customer_address_3;
mrgObj.CUSTOMER_ADD4 = bank.customer_address_4;
mrgObj.CUSTOMER_ADD5 = bank.customer_address_5;
mrgObj.CUSTOMER_POSTCODE = bank.customer_post_code;
mrgObj.PROPERTY_TYPE = bank.property_type;
mrgObj.PROPERTY_ADD1 = bank.property_address_1;
mrgObj.PROPERTY_ADD2 = bank.property_address_2;
mrgObj.PROPERTY_ADD3 = bank.property_address_3;
mrgObj.PROPERTY_ADD4 = bank.property_address_4;
mrgObj.PROPERTY_POSCODE = bank.property_post_code;
mrgObj.CERT_START_DATE = Convert.ToString(bank.policy_effective_date);
mrgObj.CERT_END_DATE = Convert.ToString(bank.policy_expired_date);
mrgObj.SUM_INSURED_AMOUNT = Convert.ToString(bank.sum_covered);
mrgList.Add(mrgObj);
}
}
dataGridView3.DataSource = mrgList;
}