Exemple #1
0
        public CustomerDetails GetCustomerDetails(int customerNo)
        {
            CustomerDetails custDetails = new CustomerDetails();
            try
            {
                StringBuilder query = new StringBuilder();
                query.Append("  SELECT pty.seq_party_id,");
                query.Append(" eh.seq_element_type_id,");
                query.Append(" pty.party_code,");
                query.Append(" pty.party_name,");
                query.Append(" pty.first_name,");
                query.Append(" pty.last_name,");
                query.Append(" pty.initials,");
                query.Append(" pty.phone_no,");
                query.Append(" pty.std_code,");
                query.Append(" pty.fax_no,");
                query.Append(" pty.email_address,");
                query.Append(" pty.web_address,");
                query.Append(" pty.street_addr_no,");
                query.Append(" pty.street_post_code,");
                query.Append(" pty.postal_post_code,");
                query.Append(" pty.street_addr_1,");
                query.Append(" pty.street_addr_2,");
                query.Append(" pty.street_addr_3,");
                query.Append(" pty.street_addr_4,");
                query.Append(" pty.street_addr_5,");
                query.Append(" pty.postal_addr_1,");
                query.Append(" pty.postal_addr_2,");
                query.Append(" pty.postal_addr_3,");
                query.Append(" pty.postal_addr_4,");
                query.Append("pty.postal_addr_5,");
                query.Append("pty.notes,");
                query.Append(" pty.active,");
                query.Append(" pty.insert_datetime,");
                query.Append(" pty.insert_user,");
                query.Append(" pty.insert_process,");
                query.Append(" pty.update_datetime,");
                query.Append(" pty.update_user,");
                query.Append(" pty.update_process,");
                query.Append(" eh.element_id,");
                query.Append(" eh.element_struct_code,");
                query.Append(" eh.parent_id,");
                query.Append(" eh.parent_element_struct_code,");
                query.Append(" cli.seq_comp_type_id,");
                query.Append(" cli.seq_industry_id,");
                query.Append(" cli.seq_client_priority_id,");

                // Pay method
                query.Append(" cli.seq_pay_method_id,");

                //Billing cycle
                query.Append(" cli.seq_bill_cycle_id,");

                // Credit check id
                query.Append(" cli.seq_int_crd_chk_id,");

                // Delivery mode id
                query.Append(" cli.seq_inv_del_mode_id,");

                // Invoice style id
                query.Append(" cli.seq_inv_style_id,");

                // Tax indicator id
                query.Append(" cli.seq_tax_ind_id,");
                query.Append(" cli.password,");
                query.Append(" cli.employer,");
                query.Append(" cli.alert,");
                query.Append(" cli.estimate_date,");
                query.Append(" cli.auck_employ,");
                query.Append(" cli.nz_employ,");
                query.Append(" cli.annual_sale,");
                query.Append(" cli.mobile_user,");
                query.Append("cli.connect_call,");
                query.Append(" cli.credit_reseller_flag,");
                query.Append(" cli.date_received,");
                query.Append("cli.seq_staff_id,");
                query.Append("cli.credit_limit,");
                query.Append("cli.stop_credit_flag,");
                query.Append(" cli.bank,");
                query.Append(" cli.bank_branch,");
                query.Append(" cli.bank_account_no,");
                query.Append(" cli.credit_card_type_code,");
                query.Append(" cli.credit_card_name,");
                query.Append(" cli.credit_card_no,");
                query.Append(" cli.credit_card_expiry,");
                query.Append(" cli.credit_card_verif_no,");
                query.Append(" cli.prompt_payment_discount,");
                query.Append(" cli.bill_notes,");
                query.Append(" cli.avg_monthly_spend,");
                query.Append(" stf.party_code,");
                query.Append(" stf.party_name,");
                query.Append(" ind.industry_code,");
                query.Append(" ind.industry_desc,");
                query.Append(" override_name = 'N',");
                query.Append(" cli.additional_svce_0800,");
                query.Append(" cli.additional_svce_ccard,");
                query.Append(" cli.additional_svce_power,");
                query.Append(" cli.additional_svce_tolls,");
                query.Append(" cli.seq_pcms_int_status_id,");
                query.Append(" cli.calling_card_reseller,");

                // Credit status id
                query.Append(" cli.seq_credit_status_id,");
                query.Append(" cli.bond,");
                query.Append(" cli.developer,");
                query.Append(" cli.alert_expires,");
                query.Append(" cli.alert_expiry_date,");
                query.Append(" cli.agc_rewards,");
                query.Append(" cli.correspondence_by_email,");
                query.Append(" cli.correspondence_by_post,");
                query.Append(" cli.date_details_confirmed,");
                query.Append(" cli.bank_account_name,");

                // District id or Company name
                query.Append(" cli.district_id,");
                query.Append(" cli.trading_name,");

                // Bill type/unit id
                query.Append(" cli.seq_bill_type_id,");
                query.Append("cli.rest_assn_num,");

                // Treatment type id
                query.Append(" cli.treat_type_id");
                query.Append(" FROM dbo.nc_client             cli");
                query.Append(" JOIN dbo.crm_party             pty ON cli.seq_party_id = pty.seq_party_id");
                query.Append("  JOIN dbo.crm_element_hierarchy eh  ON cli.seq_party_id = eh.element_id");
                query.Append(" LEFT JOIN");
                query.Append("	 dbo.crm_party             stf ON cli.seq_staff_id = stf.seq_party_id");
                query.Append(" LEFT JOIN");
                query.Append("	 dbo.nc_industry           ind ON cli.seq_industry_id = ind.seq_industry_id");
                query.Append(" WHERE cli.seq_party_id = " + customerNo + "");
                DataSet ds = database.ExecuteDataSet(System.Data.CommandType.Text, query.ToString());
                if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                {
                    custDetails.SeqPartyId = Convert.ToString(ds.Tables[0].Rows[0]["seq_party_id"]).Trim();
                    custDetails.SeqPartyTypeId = Convert.ToString(ds.Tables[0].Rows[0]["seq_element_type_id"]).Trim();
                    custDetails.CustomerNo = Convert.ToString(ds.Tables[0].Rows[0]["party_code"]);
                    custDetails.CustomerName = Convert.ToString(ds.Tables[0].Rows[0]["party_name"]);
                    custDetails.CustomerFName = Convert.ToString(ds.Tables[0].Rows[0]["first_name"]).Trim();
                    custDetails.CustomerLName = Convert.ToString(ds.Tables[0].Rows[0]["last_name"]).Trim();
                    custDetails.CustomerInitial = Convert.ToString(ds.Tables[0].Rows[0]["initials"]).Trim();
                    custDetails.Phone = Convert.ToString(ds.Tables[0].Rows[0]["phone_no"]).Trim();
                    custDetails.STDCode = Convert.ToString(ds.Tables[0].Rows[0]["std_code"]).Trim();
                    custDetails.Fax = Convert.ToString(ds.Tables[0].Rows[0]["fax_no"]).Trim();
                    custDetails.EMailAddress = Convert.ToString(ds.Tables[0].Rows[0]["email_address"]).Trim();
                    custDetails.WebAddress = Convert.ToString(ds.Tables[0].Rows[0]["web_address"]).Trim();
                    custDetails.StreetAddrNo = Convert.ToString(ds.Tables[0].Rows[0]["street_addr_no"]).Trim();
                    custDetails.StreetPostCode = Convert.ToString(ds.Tables[0].Rows[0]["street_post_code"]).Trim();
                    custDetails.PostalPostCode = Convert.ToString(ds.Tables[0].Rows[0]["postal_post_code"]).Trim();
                    custDetails.StreetAddr1 = Convert.ToString(ds.Tables[0].Rows[0]["street_addr_1"]).Trim();
                    custDetails.StreetAddr2 = Convert.ToString(ds.Tables[0].Rows[0]["street_addr_2"]).Trim();
                    custDetails.StreetAddr3 = Convert.ToString(ds.Tables[0].Rows[0]["street_addr_3"]).Trim();
                    custDetails.StreetAddr4 = Convert.ToString(ds.Tables[0].Rows[0]["street_addr_4"]).Trim();
                    custDetails.StreetAddr5 = Convert.ToString(ds.Tables[0].Rows[0]["street_addr_5"]).Trim();
                    custDetails.PostalAddr1 = Convert.ToString(ds.Tables[0].Rows[0]["postal_addr_1"]).Trim();
                    custDetails.PostalAddr2 = Convert.ToString(ds.Tables[0].Rows[0]["postal_addr_2"]).Trim();
                    custDetails.PostalAddr3 = Convert.ToString(ds.Tables[0].Rows[0]["postal_addr_3"]).Trim();
                    custDetails.PostalAddr4 = Convert.ToString(ds.Tables[0].Rows[0]["postal_addr_4"]).Trim();
                    custDetails.PostalAddr5 = Convert.ToString(ds.Tables[0].Rows[0]["postal_addr_5"]).Trim();
                    custDetails.Notes = Convert.ToString(ds.Tables[0].Rows[0]["notes"]).Trim();
                    custDetails.TradingName = Convert.ToString(ds.Tables[0].Rows[0]["trading_name"]).Trim();
                    custDetails.RestaurantAssnNo = Convert.ToString(ds.Tables[0].Rows[0]["rest_assn_num"]).Trim();
                    custDetails.PromptPayDisc = Convert.ToString(ds.Tables[0].Rows[0]["prompt_payment_discount"]).Trim();
                    if (Convert.ToString(ds.Tables[0].Rows[0]["active"]) == "Y")
                    {
                        custDetails.IsActive = true;
                    }
                    else
                    {
                        custDetails.IsActive = false;
                    }


                    custDetails.SeqPayMethodId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_pay_method_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_pay_method_id"])) : 0;
                    custDetails.SeqBillCycleId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_bill_cycle_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_bill_cycle_id"])) : 0;
                    custDetails.SeqCreditCheckId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_int_crd_chk_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_int_crd_chk_id"])) : 0;
                    custDetails.SeqBillCycle = new BillingCycle
                    {
                        BillingCycleId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_bill_cycle_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_bill_cycle_id"])) : 0
                    };

                    custDetails.AccMgr = new Party
                    {
                        SeqPartyId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_staff_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_staff_id"])) : 0
                    };

                    custDetails.Type = new TreatmentType
                   {
                       TreatmentTypeId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["treat_type_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["treat_type_id"])) : 0
                   };

                    custDetails.PmtMethod = new PayMethod
                    {
                        PayMethodId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_pay_method_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_pay_method_id"])) : 0
                    };

                    custDetails.CreditCtrlStatus = new CreditControlStatus
                    {
                        CreditControlStatusId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_credit_status_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_credit_status_id"])) : 0
                    };

                    custDetails.CreditCardType = new CardType
                    {
                        CardTypeCode = Convert.ToString(ds.Tables[0].Rows[0]["credit_card_type_code"])

                    };

                    custDetails.InvDelivery = new InvoiceDelivery
                    {
                        InvoiceDeliveryId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_inv_del_mode_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_inv_del_mode_id"])) : 0

                    };

                    custDetails.InvStyle = new InvoiceStyle
                    {
                        InvoiceStyleId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_inv_style_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_inv_style_id"])) : 0

                    };

                    custDetails.CustType = new CustomerType
                    {
                        CustomerTypeId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_element_type_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_element_type_id"])) : 0

                    };

                    custDetails.CustCompany = new Company
                    {
                        CompanyId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["district_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["district_id"])) : 0

                    };


                    custDetails.Score = new CreditCheckScore
                    {
                        CreditCheckScoreId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_int_crd_chk_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_int_crd_chk_id"])) : 0
                    };

                    custDetails.IndustryDetails = new Industry
                    {
                        IndustryId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_industry_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_industry_id"])) : 0,
                        IndustryCode = Convert.ToString(ds.Tables[0].Rows[0]["industry_code"]),
                        IndustryDesc = Convert.ToString(ds.Tables[0].Rows[0]["industry_desc"])
                    };

                    custDetails.SeqPriority = new Priority
                    {
                        PriorityId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_client_priority_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_client_priority_id"])) : 0
                    };

                    if (!string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["agc_rewards"])))
                    {
                        custDetails.AgcRewards = Convert.ToDateTime(Convert.ToString(ds.Tables[0].Rows[0]["agc_rewards"]));
                    }

                    if (!string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["date_details_confirmed"])))
                    {
                        custDetails.DateDetailsConfirmed = Convert.ToDateTime(Convert.ToString(ds.Tables[0].Rows[0]["date_details_confirmed"]));
                    }

                    if (!string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["alert_expiry_date"])))
                    {
                        custDetails.AlertExpiryDate = Convert.ToDateTime(Convert.ToString(ds.Tables[0].Rows[0]["alert_expiry_date"]));
                    }

                    custDetails.SeqTaxIndId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_tax_ind_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_tax_ind_id"])) : 0;
                    custDetails.BondAmt = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["bond"])) ? double.Parse(Convert.ToString(ds.Tables[0].Rows[0]["bond"])) : 0;

                    custDetails.Password = Convert.ToString(ds.Tables[0].Rows[0]["password"]).Trim();
                    custDetails.Employer = Convert.ToString(ds.Tables[0].Rows[0]["employer"]).Trim();
                    custDetails.Alert = Convert.ToString(ds.Tables[0].Rows[0]["alert"]).Trim();
                    custDetails.EstimateDate = Convert.ToString(ds.Tables[0].Rows[0]["estimate_date"]).Trim();
                    custDetails.CreditLimit = Convert.ToString(ds.Tables[0].Rows[0]["credit_limit"]).Trim();
                    custDetails.Bank = Convert.ToString(ds.Tables[0].Rows[0]["bank"]).Trim();
                    custDetails.BankBranch = Convert.ToString(ds.Tables[0].Rows[0]["bank_branch"]).Trim();
                    custDetails.BankAccNo = Convert.ToString(ds.Tables[0].Rows[0]["bank_account_no"]).Trim();
                    custDetails.CreditCardTypeCode = Convert.ToString(ds.Tables[0].Rows[0]["credit_card_type_code"]).Trim();
                    custDetails.CreditCardName = Convert.ToString(ds.Tables[0].Rows[0]["credit_card_name"]).Trim();
                    custDetails.CreditCardNo = Convert.ToString(ds.Tables[0].Rows[0]["credit_card_no"]).Trim();
                    custDetails.CreditCardExpiry = Convert.ToString(ds.Tables[0].Rows[0]["credit_card_expiry"]).Trim();
                    custDetails.CreditCardVerifyNo = Convert.ToString(ds.Tables[0].Rows[0]["credit_card_verif_no"]).Trim();
                    custDetails.CreditCardNo = Convert.ToString(ds.Tables[0].Rows[0]["credit_card_no"]).Trim();
                    custDetails.BillNotes = Convert.ToString(ds.Tables[0].Rows[0]["bill_notes"]).Trim();
                    custDetails.AvgMonthlySpend = Convert.ToString(ds.Tables[0].Rows[0]["avg_monthly_spend"]).Trim();
                    if (Convert.ToString(ds.Tables[0].Rows[0]["override_name"]) == "Y")
                    {
                        custDetails.IsNameOverride = true;
                    }
                    else
                    {
                        custDetails.IsNameOverride = false;
                    }

                    if (Convert.ToString(ds.Tables[0].Rows[0]["developer"]) == "Y")
                    {
                        custDetails.IsDeveloper = true;
                    }
                    else
                    {
                        custDetails.IsDeveloper = false;
                    }

                    if (Convert.ToString(ds.Tables[0].Rows[0]["alert_expires"]) == "Y")
                    {
                        custDetails.IsAlertExpires = true;
                    }
                    else
                    {
                        custDetails.IsAlertExpires = false;
                    }

                    if (Convert.ToString(ds.Tables[0].Rows[0]["correspondence_by_email"]) == "Y")
                    {
                        custDetails.IsCorrespondenceByEMail = true;
                    }
                    else
                    {
                        custDetails.IsCorrespondenceByEMail = false;
                    }

                    if (Convert.ToString(ds.Tables[0].Rows[0]["correspondence_by_post"]) == "Y")
                    {
                        custDetails.IsCorrespondenceByPost = true;
                    }
                    else
                    {
                        custDetails.IsCorrespondenceByPost = false;
                    }

                    custDetails.BankAccName = Convert.ToString(ds.Tables[0].Rows[0]["bank_account_name"]).Trim();
                    custDetails.SeqBillTypeId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_bill_type_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_bill_type_id"])) : 0;

                    custDetails.TreatmentTypeId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["treat_type_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["treat_type_id"])) : 0;
                    custDetails.SeqTaxIndicator = new TaxIndicator
                    {
                        TaxIndicatorId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_tax_ind_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_tax_ind_id"])) : 0

                    };

                    custDetails.SeqBillingUnit = new BillingUnit
                    {
                        BillingUnitId = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["seq_bill_type_id"])) ? int.Parse(Convert.ToString(ds.Tables[0].Rows[0]["seq_bill_type_id"])) : 0
                    };
                    //

                }
            }
            catch (Exception ex)
            {

                throw ex;
            }
            return custDetails;

        }
Exemple #2
0
        public bool SaveCustomerDetails(CustomerDetails customerDetails)
        {
            bool retVal = false;
            try
            {
                StringBuilder query = new StringBuilder();
                query.Append("UPDATE crm_party set");

                if (!string.IsNullOrEmpty(customerDetails.CustomerFName))
                {
                    query.Append(" first_name = '" + customerDetails.CustomerFName.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.CustomerLName))
                {
                    query.Append(" last_name = '" + customerDetails.CustomerLName.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.CustomerInitial))
                {
                    query.Append(" initials = '" + customerDetails.CustomerInitial.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.Phone))
                {
                    query.Append(" phone_no = '" + customerDetails.Phone.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.Fax))
                {
                    query.Append(" fax_no = '" + customerDetails.Fax.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.EMailAddress))
                {
                    query.Append(" email_address = '" + customerDetails.EMailAddress.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.WebAddress))
                {
                    query.Append(" web_address = '" + customerDetails.WebAddress.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.StreetAddrNo))
                {
                    query.Append("street_addr_no = '" + customerDetails.StreetAddrNo.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.PostalPostCode))
                {
                    query.Append(" postal_post_code = '" + customerDetails.PostalPostCode.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.StreetAddr1))
                {
                    query.Append("street_addr_1 = '" + customerDetails.StreetAddr1.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.StreetAddr2))
                {
                    query.Append(" street_addr_2 = '" + customerDetails.StreetAddr2.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.StreetAddr3))
                {
                    query.Append(" street_addr_3 = '" + customerDetails.StreetAddr3.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.PostalAddr1))
                {
                    query.Append(" postal_addr_1 = '" + customerDetails.PostalAddr1.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.PostalAddr2))
                {
                    query.Append(" postal_addr_2 = '" + customerDetails.PostalAddr2.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.PostalAddr3))
                {
                    query.Append(" postal_addr_3 = '" + customerDetails.PostalAddr3.Replace("'", "''").Trim() + "',");
                }

                query.Append(" notes = '" + customerDetails.Notes + "', update_datetime =  '" + DateTime.UtcNow + "',");

                if (customerDetails.STDCode != null)
                {
                    query.Append(" std_code =  '" + customerDetails.STDCode.Replace("'", "''").Trim() + "',");
                }

                if (customerDetails.TradingName != null)
                {
                    query.Append(" trading_name =  '" + customerDetails.TradingName.Replace("'", "''").Trim() + "',");
                }


                if (customerDetails.CustomerName != null)
                {
                    query.Append(" party_name =  '" + customerDetails.CustomerName.Replace("'", "''").Trim() + "',");
                }
                query.Append(" update_user = '******', update_process = 'CMS2' WHERE seq_party_id = " + customerDetails.SeqPartyId + " ");
                int rowsAffected = database.ExecuteNonQuery(CommandType.Text, query.ToString());


                //CLIENT TABLE
                // Finance details query
                query = new StringBuilder();
                query.Append("UPDATE nc_client SET update_user = '******', update_process = '" + customerDetails.UpdateProcess + "',");
                if (customerDetails.PmtMethod != null && customerDetails.PmtMethod.PayMethodId != 0)
                {
                    query.Append(" seq_pay_method_id = " + customerDetails.PmtMethod.PayMethodId + ",");
                }

                if (customerDetails.IndustryDetails != null && customerDetails.IndustryDetails.IndustryId != 0)
                {
                    query.Append(" seq_industry_id = " + customerDetails.IndustryDetails.IndustryId + ",");
                }

                if (customerDetails.AvgMonthlySpend != null)
                {
                    query.Append(" avg_monthly_spend =  '" + customerDetails.AvgMonthlySpend.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.PromptPayDisc))
                {
                    query.Append(" prompt_payment_discount =  '" + customerDetails.PromptPayDisc.Replace("'", "''").Trim() + "',");
                }

                query.Append(" bond =  '" + customerDetails.BondAmt + "',");

                if (customerDetails.TradingName != null)
                {
                    query.Append(" trading_name =  '" + customerDetails.TradingName.Replace("'", "''").Trim() + "',");
                }

                if (customerDetails.Employer != null)
                {
                    query.Append(" employer =  '" + customerDetails.Employer.Replace("'", "''").Trim() + "',");
                }


                if (customerDetails.SeqBillingUnit != null && customerDetails.SeqBillingUnit.BillingUnitId != 0)
                {
                    query.Append("seq_bill_type_id =  " + customerDetails.SeqBillingUnit.BillingUnitId + ",");
                }

                if (customerDetails.SeqBillCycle != null && customerDetails.SeqBillCycle.BillingCycleId != 0)
                {
                    query.Append("seq_bill_cycle_id =  " + customerDetails.SeqBillCycle.BillingCycleId + ",");
                }

                if (customerDetails.Score != null && customerDetails.Score.CreditCheckScoreId != 0)
                {
                    query.Append(" seq_int_crd_chk_id =  " + customerDetails.Score.CreditCheckScoreId + ",");
                }

                if (customerDetails.InvDelivery != null && customerDetails.InvDelivery.InvoiceDeliveryId != 0)
                {
                    query.Append("seq_inv_del_mode_id = " + customerDetails.InvDelivery.InvoiceDeliveryId + ",");
                }

                if (customerDetails.InvStyle != null && customerDetails.InvStyle.InvoiceStyleId != 0)
                {
                    query.Append(" seq_inv_style_id =  " + customerDetails.InvStyle.InvoiceStyleId + ",");
                }

                if (customerDetails.SeqPriority != null && customerDetails.SeqPriority.PriorityId != 0)
                {
                    query.Append(" seq_client_priority_id =  " + customerDetails.SeqPriority.PriorityId + ",");
                }

                if (customerDetails.SeqTaxIndicator != null && customerDetails.SeqTaxIndicator.TaxIndicatorId != 0)
                {
                    query.Append(" seq_tax_ind_id =  " + customerDetails.SeqTaxIndicator.TaxIndicatorId + ",");
                }

                if (customerDetails.AlertExpiryDate != null && customerDetails.AlertExpiryDate.HasValue)
                {
                    query.Append(" alert_expiry_date =  '" + customerDetails.AlertExpiryDate.Value + "',");
                }

                if (customerDetails.AgcRewards != null && customerDetails.AgcRewards.HasValue)
                {
                    query.Append(" agc_rewards =  '" + customerDetails.AgcRewards.Value + "',");
                }

                if (customerDetails.IsAlertExpires)
                {
                    query.Append(" alert_expires = 'Y',");
                }
                else
                {
                    query.Append(" alert_expires = 'N',");
                }

                if (customerDetails.IsDeveloper)
                {
                    query.Append(" developer = 'Y',");
                }
                else
                {
                    query.Append(" developer = 'N',");
                }

                if (customerDetails.IsCorrespondenceByEMail)
                {
                    query.Append(" correspondence_by_email = 'Y',");
                }
                else
                {
                    query.Append(" correspondence_by_email = 'N',");
                }

                if (customerDetails.IsCorrespondenceByPost)
                {
                    query.Append(" correspondence_by_post = 'Y',");
                }
                else
                {
                    query.Append(" correspondence_by_post = 'N',");
                }

                if (customerDetails.DateDetailsConfirmed != null && customerDetails.DateDetailsConfirmed.HasValue)
                {
                    query.Append("date_details_confirmed =  '" + customerDetails.DateDetailsConfirmed.Value + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.RestaurantAssnNo))
                {
                    query.Append(" rest_assn_num =  '" + customerDetails.RestaurantAssnNo.Replace("'", "''").Trim() + "',");
                }

                if (customerDetails.AccMgr != null && customerDetails.AccMgr.SeqPartyId != 0)
                {
                    query.Append(" seq_staff_id =  " + customerDetails.AccMgr.SeqPartyId + ",");
                }

                if (!string.IsNullOrEmpty(customerDetails.Password))
                {
                    query.Append("password = '******'", "''").Trim() + "',");
                }


                if (!string.IsNullOrEmpty(customerDetails.Alert))
                {
                    query.Append(" alert = '" + customerDetails.Alert.Replace("'", "''").Trim() + "',");
                }


                if (!string.IsNullOrEmpty(customerDetails.CreditLimit))
                {
                    query.Append(" credit_limit =  " + customerDetails.CreditLimit.Replace("'", "''").Trim() + ",");
                }


                if (!string.IsNullOrEmpty(customerDetails.Bank))
                {
                    query.Append(" bank = '" + customerDetails.Bank.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.BankBranch))
                {
                    query.Append(" bank_branch = '" + customerDetails.BankBranch.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.BankAccNo))
                {
                    query.Append(" bank_account_no = '" + customerDetails.BankAccNo.Replace("'", "''").Trim() + "',");
                }

                if (customerDetails.CreditCardType != null && customerDetails.CreditCardType.CardTypeCode != string.Empty)
                {
                    query.Append(" credit_card_type_code = '" + customerDetails.CreditCardType.CardTypeCode.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.CreditCardName))
                {
                    query.Append(" credit_card_name = '" + customerDetails.CreditCardName.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.CreditCardNo))
                {
                    query.Append(" credit_card_no = '" + customerDetails.CreditCardNo.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.CreditCardExpiry))
                {
                    query.Append(" credit_card_expiry = '" + customerDetails.CreditCardExpiry.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.CreditCardVerifyNo))
                {
                    query.Append(" credit_card_verif_no = '" + customerDetails.CreditCardVerifyNo.Replace("'", "''").Trim() + "',");
                }

                if (!string.IsNullOrEmpty(customerDetails.BillNotes))
                {
                    query.Append(" bill_notes = '" + customerDetails.BillNotes.Replace("'", "''").Trim() + "',");
                }

                if (customerDetails.CreditCtrlStatus != null && customerDetails.CreditCtrlStatus.CreditControlStatusId != 0)
                {
                    query.Append(" seq_credit_status_id =  " + customerDetails.CreditCtrlStatus.CreditControlStatusId + ",");
                }

                if (!string.IsNullOrEmpty(customerDetails.BankAccName))
                {
                    query.Append(" bank_account_name = '" + customerDetails.BankAccName.Replace("'", "''").Trim() + "',");
                }

                query.Append(" treat_type_id =  " + customerDetails.Type.TreatmentTypeId + ",  update_datetime = '" + DateTime.UtcNow + "'  WHERE seq_party_id = " + customerDetails.SeqPartyId + " ");
                rowsAffected = database.ExecuteNonQuery(CommandType.Text, query.ToString());

                query = new StringBuilder();
                query.Append("  UPDATE crm_element_hierarchy SET update_datetime = '" + DateTime.UtcNow + "', update_user = '******', update_process = '" + customerDetails.UpdateProcess + "',");
                if (customerDetails.Type != null && customerDetails.CustType.CustomerTypeId != 0)
                {
                    query.Append(" seq_element_type_id =  '" + customerDetails.CustType.CustomerTypeId + "'");
                }

                query.Append("WHERE element_id = " + customerDetails.SeqPartyId + " AND element_struct_code = 'CLIENT' AND parent_id = 3 AND parent_element_struct_code = 'COMPANY'");
                rowsAffected = database.ExecuteNonQuery(CommandType.Text, query.ToString());
                if (rowsAffected > 0)
                {
                    retVal = true;
                }
            }
            catch (Exception ex)
            {

                throw ex;
            }
            return retVal;
        }
 public bool SaveCustomerDetails(CustomerDetails customerDetails)
 {
     return Database.SaveCustomerDetails(customerDetails);
 }
Exemple #4
0
 public bool SaveCustomerDetails(CustomerDetails customerDetails)
 {
     throw new NotImplementedException();
 }
 public bool SaveCustomerDetails(CustomerDetails customerDetails)
 {
     bool retVal = false;
     try
     {
         retVal = _dbManager.SaveCustomerDetails(customerDetails);
     }
     catch (Exception ex)
     {
         ExceptionPolicy.HandleException(ex, "Policy");
         FaultDetail faultDetail = new FaultDetail
         {
             Type = ex.Message,
             ErrorCode = 63873928
         };     //+ throw     
         throw new FaultException<FaultDetail>(faultDetail, ex.Message);
     }
     return retVal;
 }
        public CustomerDetails GetCustomerDetails(int customerNo)
        {
            CustomerDetails custDetails = new CustomerDetails();
            try
            {
                custDetails = _dbManager.GetCustomerDetails(customerNo);
            }
            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 custDetails;
        }