public CustomerSummary GetCustomerSummaryDetails(int seqPartyId) { CustomerSummary custSummary = new CustomerSummary(); try { object[] parameters = new object[1]; parameters[0] = seqPartyId; DataSet ds = database.ExecuteDataSet("dbp_summary_details", parameters); if (ds != null && ds.Tables != null && ds.Tables[0].Rows.Count > 0) { custSummary.DecisionMakerName = Convert.ToString(ds.Tables[0].Rows[0]["decision_maker_name"]); custSummary.BillingContactName = Convert.ToString(ds.Tables[0].Rows[0]["billing_contact_name"]); custSummary.SeqPartyId = Convert.ToString(seqPartyId); custSummary.AccMgrName = Convert.ToString(ds.Tables[0].Rows[0]["acc_mgr_name"]); custSummary.AvgMonthlySpend = Convert.ToString(ds.Tables[0].Rows[0]["avg_monthly_spend"]); custSummary.CreditStatusCode = Convert.ToString(ds.Tables[0].Rows[0]["seq_credit_status_code"]); custSummary.CurrPeriod = Convert.ToString(ds.Tables[0].Rows[0]["current_period"]); custSummary.CustomerName = Convert.ToString(ds.Tables[0].Rows[0]["party_name"]); custSummary.CustomerNo = Convert.ToString(ds.Tables[0].Rows[0]["party_code"]); custSummary.DistrictCode = Convert.ToString(ds.Tables[0].Rows[0]["district_code"]); custSummary.Fax = Convert.ToString(ds.Tables[0].Rows[0]["fax_no"]); custSummary.Phone = Convert.ToString(ds.Tables[0].Rows[0]["phone_no"]); custSummary.PostalAddr1 = Convert.ToString(ds.Tables[0].Rows[0]["postal_addr_1"]); custSummary.PostalAddr2 = Convert.ToString(ds.Tables[0].Rows[0]["postal_addr_2"]); custSummary.PostalAddr3 = Convert.ToString(ds.Tables[0].Rows[0]["postal_addr_3"]); custSummary.PostalPostCode = Convert.ToString(ds.Tables[0].Rows[0]["postal_post_code"]); custSummary.StreetAddr1 = Convert.ToString(ds.Tables[0].Rows[0]["street_addr_1"]); custSummary.StreetAddr2 = Convert.ToString(ds.Tables[0].Rows[0]["street_addr_2"]); custSummary.StreetAddr3 = Convert.ToString(ds.Tables[0].Rows[0]["street_addr_3"]); custSummary.StreetAddrNo = Convert.ToString(ds.Tables[0].Rows[0]["street_addr_no"]); custSummary.StreetPostCode = Convert.ToString(ds.Tables[0].Rows[0]["street_post_code"]); custSummary.TotalAmt = Convert.ToString(ds.Tables[0].Rows[0]["total_amount"]); custSummary.OverdueAmt = Convert.ToString(ds.Tables[0].Rows[0]["overdue_amount"]); custSummary.CurrAmt = Convert.ToString(ds.Tables[0].Rows[0]["current_amount"]); } } catch (Exception ex) { throw ex; } return custSummary; // exec dbo.dbp_summary_details N'79377' }
public CustomerSummary GetCustomerSummaryDetails(int seqPartyId) { CustomerSummary custSumm = new CustomerSummary(); try { custSumm = _dbManager.GetCustomerSummaryDetails(seqPartyId); } catch (Exception exceptionToHandle) { ExceptionPolicy.HandleException(exceptionToHandle, "Policy"); FaultDetail faultDetail = new FaultDetail { Type = exceptionToHandle.Message, ErrorCode = 63873928 }; //+ throw throw new FaultException<FaultDetail>(faultDetail, exceptionToHandle.Message); } return custSumm; }