protected void addClientToInvoice(Client client, Boolean isReceivable) { string ar = "", ap = ""; if (isReceivable) { ar = client.amount.ToString(); } else { ap = client.amount.ToString(); } ClientDataSource.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure; ClientDataSource.UpdateCommand = "dbo.AddClientToInvoice"; ClientDataSource.UpdateParameters.Clear(); ClientDataSource.UpdateParameters.Add(new Parameter("Invoice", System.TypeCode.String, txtInvoice.Text)); ClientDataSource.UpdateParameters.Add(new Parameter("Name", System.TypeCode.String, client.name)); ClientDataSource.UpdateParameters.Add(new Parameter("AccountPayable", System.TypeCode.Decimal, ap)); ClientDataSource.UpdateParameters.Add(new Parameter("AccountReceivable", System.TypeCode.Decimal, ar)); ClientDataSource.UpdateParameters.Add(new Parameter("comments", System.TypeCode.String, client.comment)); ClientDataSource.UpdateParameters.Add(new Parameter("paid", System.TypeCode.Boolean, client.paid.ToString())); ClientDataSource.Update(); }
public override void ViewDidLoad() { base.ViewDidLoad(); SendButton.Enabled = false; ChatMessageInput.Enabled = false; var dataSource = new ClientDataSource { Clients = this.Clients }; ClientTable.DataSource = dataSource; ClientTable.Delegate = new ClientTableDelegate(dataSource); }
public Task <Client> GetClientByReferenceAsync(string id) { var dataSource = new ClientDataSource(_connectionString); return(Task.FromResult(dataSource.FindByMemOrgId(id))); }