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; }
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); }
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; }