public bool UpdateClientWithPaymentDetails(string accNr, string bank, string branchCode) { Datahandler dh = Datahandler.getData(); PD = new PaymentDetails(this, accNr, bank, branchCode); Dictionary <string, string[]> client_details = new Dictionary <string, string[]>(); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_identifier, new string[] { DataAccesHelper.typeString, this.ClientIdentifier }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_id, new string[] { DataAccesHelper.typeString, this.PersonId }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_name, new string[] { DataAccesHelper.typeString, this.Name }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_surname, new string[] { DataAccesHelper.typeString, this.Surname }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_payMethod, new string[] { DataAccesHelper.typeString, this.PaymentMethod }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_status, new string[] { DataAccesHelper.typeString, this.Status }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_addrLine1, new string[] { DataAccesHelper.typeString, this.PersonAddress.AddressLine1 }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_addrLine2, new string[] { DataAccesHelper.typeString, this.PersonAddress.AddressLine2 }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_city, new string[] { DataAccesHelper.typeString, this.PersonAddress.City }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_postCode, new string[] { DataAccesHelper.typeString, this.PersonAddress.PostalCode }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_cell, new string[] { DataAccesHelper.typeString, this.PersonContact.Cell }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_email, new string[] { DataAccesHelper.typeString, this.PersonContact.Email }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_accNr, new string[] { DataAccesHelper.typeString, this.PD.AccNr }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_bank, new string[] { DataAccesHelper.typeString, this.PD.Bank }); client_details.Add(QueryBuilder.spUpdateClientWithPaymentDetails.sp_branch, new string[] { DataAccesHelper.typeString, this.PD.BranchCode }); return(dh.runStoredProcedure(QueryBuilder.spUpdateClientWithPaymentDetails.sp, client_details)); }
public override bool Equals(object obj) { if (obj == null) { return(false); } PaymentDetails pd = obj as PaymentDetails; if ((object)pd == null) { return(false); } return((this.PaymentDet_Client == pd.PaymentDet_Client) && (this.AccNr == pd.AccNr) && (this.Bank == pd.Bank) && (this.BranchCode == pd.BranchCode)); }
public List <PaymentDetails> GetAllPaymentDetails() { Datahandler dh = Datahandler.getData(); List <PaymentDetails> details = new List <PaymentDetails>(); DataTable table = dh.readDataFromDB(DataAccesHelper.QueryGetPaymentDetails); foreach (DataRow item in table.Rows) { PaymentDetails pd = new PaymentDetails(); pd.AccNr = item[DataAccesHelper.paymentDetAccNr].ToString(); pd.Bank = item[DataAccesHelper.paymentDetBank].ToString(); pd.BranchCode = item[DataAccesHelper.paymentDetBranch].ToString(); pd.PaymentDet_Client = new Client(); pd.PaymentDet_Client.ClientIdentifier = item[DataAccesHelper.paymentDetClientId].ToString(); details.Add(pd); } return(details); }