/*
* Used to populate Notes and VMFlagTypes of Customer Info Details
* LNotes - List object of type CustomerInfoNotes to be populated
* LVMFlagTypes - List object of type CustomerInfoVMFlagType to be populated
*/
private void Notes_VMFlagTypes(CustomerInfoDetail custDetail)
{
try
{
using (OracleConnection con = new OracleConnection(CRMDB))
{
DataSet ds = new DataSet();
// Initialize Command and DataAdapter.
OracleCommand cmd;
OracleDataAdapter da;
// Open Connection and call stored procedure.
con.Open();
cmd = new OracleCommand("SYSADM.GET_360_CUSTOMER_INFO_WIDGET", con);
cmd.CommandType = CommandType.StoredProcedure;
// Stored procedure parameters.
cmd.Parameters.Add("Acct_No", OracleType.VarChar, 256).Value = custDetail.id;
cmd.Parameters["Acct_No"].Direction = ParameterDirection.Input;
cmd.Parameters.Add("NOTEORESULTS", OracleType.Cursor).Direction = ParameterDirection.Output;
// Fill Dataset using DataAdapter
da = new OracleDataAdapter(cmd);
da.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
CustomerInfoNote note = new CustomerInfoNote();
note.Note_Date = row["NOTE_DATE"].ToString();
note.Note_User = row["NOTE_USER"].ToString();
note.Note_Description = row["NOTE_DESCRIPTION"].ToString();
custDetail.Notes.Add(note);
}
// Explicitly close connection
con.Close();
}
}
catch (Exception){
throw;
}
}
/*
* Used to populate Payments and CPEs of Customer Info Details
* LPayments - List object of type CustomerInfoPayment to be populated
* LCPEs - List object of type CustomerInfoCPE to be populated
*/
private void Payments_CPEs(CustomerInfoDetail custDetail)
{
try
{
using (OracleConnection con = new OracleConnection(KENANDB))
{
DataSet ds = new DataSet();
// Initialize Command and DataAdapter.
OracleCommand cmd;
OracleDataAdapter da;
// Open Connection and call stored procedure.
con.Open();
cmd = new OracleCommand("ARBOR.HT_ONE_PKG.GET_PAYMENT_AND_CPE_DETAILS", con);
cmd.CommandType = CommandType.StoredProcedure;
// Stored procedure parameters.
cmd.Parameters.Add("iAccountNo", OracleType.VarChar, 256).Value = custDetail.id;
cmd.Parameters["iAccountNo"].Direction = ParameterDirection.Input;
cmd.Parameters.Add("oPaymentDetails", OracleType.Cursor).Direction = ParameterDirection.Output;
cmd.Parameters.Add("oCPEDetails", OracleType.Cursor).Direction = ParameterDirection.Output;
// Fill Dataset using DataAdapter
da = new OracleDataAdapter(cmd);
da.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
CustomerInfoPayment payment = new CustomerInfoPayment();
payment.Amount = row["AMOUNT"].ToString();
payment.PostedDate = row["POSTED_DATE"].ToString();
custDetail.Payments.Add(payment);
}
foreach (DataRow row in ds.Tables[1].Rows)
{
CustomerInfoCPE cpe = new CustomerInfoCPE();
cpe.SID = row["SID"].ToString();
cpe.Contract = row["CPE_CONTRACT"].ToString();
cpe.Contract_End_Date = row["CPE_CONTRACT_END"].ToString();
custDetail.CPEs.Add(cpe);
}
// Explicitly close connection
con.Close();
}
}
catch (Exception){
throw;
}
}
/*
* This method is used to call for Customer Information Detail
* id - PK for Customer Info
*/
private CustomerInfoDetail CustomerInfoDetail(string id, string accountName, string btn, string accountType)
{
try
{
CustomerInfoDetail custInfoDetail = new CustomerInfoDetail();
custInfoDetail.id = id; //Not needed. Added for tracking purposes
custInfoDetail.AccountName = accountName;
custInfoDetail.Btn = btn;
custInfoDetail.AccountType = accountType;
// Populate Notes and VMFlagTypes of Customer Info Details
// from CRM
Notes_VMFlagTypes(custInfoDetail);
// Populate Payments and CPEs of Customer Info Details
// from Kenan
Payments_CPEs(custInfoDetail);
return custInfoDetail;
}
catch (Exception)
{
throw;
}
}