Adding total payments of the whole month

Question

1.00/5 (3 votes)

See more:

C#

i want to add the total payments of the whole month...

how can i do it??

Posted 5-Oct-11 17:49pm

codegeekalpha

Add a Solution

Comments

Tejas Vaishnav 6-Oct-11 0:26am

Just Calculate it and add...
its so simple...

Tejas Vaishnav 6-Oct-11 0:27am

Please Write a question with proper detail..
give data and if it is needed then give some code also...

Xeshan Ahmed 6-Oct-11 1:37am

insufficient information.......

Xeshan Ahmed 6-Oct-11 1:37am

provide some details about your database structure

Madhana Kumar 6-Oct-11 1:43am

Pls little more precise.
Then only we can help you.

codegeekalpha 6-Oct-11 4:23am

i just simple want to add customers payments of the for the whole year

Morgs Morgan 6-Oct-11 10:29am

But you said you want to add payments for whole month!

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Accepted Answer · 2011-10-06T04:33:00

Without any information where that information you want is stored in your application and exact details about that, we'll be unable to help you. The following is a collection of tables that one could assume to be present in a system that deals with customers that pay for stuff:

Customer
Constains data about your customer base.
Product
Your products would be stored here
Order
Every time a customer purchases something an order will be placed. General information about which customer (FK) did this and the delivery adress (FK) and the billing address (FK) are stored there. Maybe you'd also want the total amount.
OrderItem
Every order consists of several positions as customers want to order more than one thing in one order. This table will have information about the product, the amount, the unit (pcs, kg, pounds, etc) and the price.
Payment
If the customer pays online this information will be automatically filled by your website with information about that payment. If the customer pays after receiving the bill this information will be filled from you ERP system.
PaymentDetail
Will contain information about when the payment history. Like when the bill is sent, when the amount due was payed etc.
Adress
This just a table that contains addresses that are linked to some of the other tables as needed

Without knowing anything about how your data is stored how can you even think we could give you concrete help.

Regards,

—MRB

Morgs Morgan · Accepted Answer · 2011-10-06T04:53:00

You can try something like this:
suppose you have the following table columns in your database
1. Payment (of type interger)
1. PaymentDate (of type DateTime)
Now that i don't know how you are accessing your database, i will assume you are using Linq-Sql!

C#

// suppose startDate=2011/10/01 and endDate=2011/10/31
public Int32 CalculateMonthlyPayment( DateTime startDate, DateTime endDate )
{ 
    //Linq-SQL query
    Int32 totalPayments = DataContext.TableName.Where( t => t.PaymentDate >= startDate && t.PaymentDate <= endDate ).Sum( t => t.Payment );
    return totalPayments;

    //or, T-SQL query
    /*
    String query = @"SELECT SUM(t.Payments) AS [Total Payments] FROM TableName t WHERE PaymentDate >= '" + startDate + "' AND PaymentDate <= '" + endDate + "';";
    */
}

Adding total payments of the whole month

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0