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();
    }
Example #2
0
        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);
        }
Example #3
0
        public Task <Client> GetClientByReferenceAsync(string id)
        {
            var dataSource = new ClientDataSource(_connectionString);

            return(Task.FromResult(dataSource.FindByMemOrgId(id)));
        }