how i get condition for if the user got the payment once's in day can get it again

Question

1.00/5 (1 vote)

See more:

C#

if (DateTime.Now.Hour >= 10 && DateTime.Now.Hour < 20)
        {
           //i want here condition if its that id has access once in day he my not                   //access this code again          
            com = new SqlCommand("SELECT COUNT(*) FROM Registration_Master WHERE sponcorid='" + code + "'", con);
            int count = (int)com.ExecuteScalar();
            if (count == 2)
            {
                string query = "SELECT count_mem FROM Registration_Master WHERE sponcorid='" + code + "'";
                com = new SqlCommand(query, con);
                com.CommandType = CommandType.Text;
                da = new SqlDataAdapter(com);
                DataTable dtquery = new DataTable();
                da.Fill(dtquery);
                if (dtquery.Rows.Count == 1)
                {
                    double income = Convert.ToDouble(txtamount.Text.ToString());
                    double tds = ((income / 100.0) * 10.0);

                    double admin = ((income / 100.0) * 10.0);
                    double net = 0;
                    net = income - tds - admin;

                    double totdeduct = tds + admin;
                    int totbinary = 1;
                                   

                    com.Connection = con;
                    com.CommandText = "INSERT INTO Payout_Master (sponcorid,session,total_binary,gross_total,tds,admin_charges,binary_income,total_deduct,net_payment,createddate) VALUES('" + txtid.Text + "','MORNING',"+totbinary+"," + income + "," + tds + " ," + admin + "," + income + "," + totdeduct + "," + net + ","+DateTime.Now+")";
                    com.CommandType = CommandType.Text;
                    com.ExecuteNonQuery();

                    txtamount.Text = "";
                    txtid.Text = "";
                    DataTable dt1 = new DataTable();
                    dt1 = DAL.Payout_Master.View();
                    Repeater1.DataSource = dt1;
                    Repeater1.DataBind();
                    MultiView1.ActiveViewIndex = 1;
                    flag = true;
                }
                if (dtquery.Rows.Count == 2)
                {
                    
                    
                    double income = Convert.ToDouble(txtamount.Text.ToString());
                    double tds = ((income / 100.0) * 10.0);

                    double admin = ((income / 100.0) * 10.0);
                    double net = 0;
                    net = income - tds - admin;

                    double totdeduct = tds + admin;

                   int totbinary=2;
                   double gtot = 2 * 500;                   
                    com.Connection = con;
                    com.CommandText = "INSERT INTO Payout_Master (sponcorid,session,total_binary,gross_total,tds,admin_charges,binary_income,total_deduct,net_payment,createddate) VALUES('" + txtid.Text + "','MORNING'," + totbinary + "," + gtot + "," + tds + " ," + admin + "," + income + "," + totdeduct + "," + net + ",'" + DateTime.Now +"')";
                    com.CommandType = CommandType.Text;
                    com.ExecuteNonQuery();

                    txtamount.Text = "";
                    txtid.Text = "";
                    DataTable dt1 = new DataTable();
                    dt1 = DAL.Payout_Master.View();
                    Repeater1.DataSource = dt1;
                    Repeater1.DataBind();
                    MultiView1.ActiveViewIndex = 1;
                    flag = true;

                }
               
            }
            
        }

Posted 21-Nov-12 18:59pm

sumit kausalye

Updated 21-Nov-12 19:19pm

v4

Add a Solution

Comments

Mohd. Mukhtar 22-Nov-12 1:03am

What have you tried so for???

Nandakishore G N 22-Nov-12 2:04am

does your question means the user can get payment once a day.. right..i prefer using stored procedure it can be done...becoz, you are storing the transaction in Payoutmaster table....then you can get the count of it and perform it in sp itself..dont perform it in codebehind..

3 solutions

Solution 1

Hi Sumit,

You should check this condition on login button click.

See below code snippet.
First you need to create table DailyUserLoggedInStatus with below column.
UserID
LastLoginDate

C#

if (DateTime.Now.Hour >= 10 && DateTime.Now.Hour < 20)
{
  com = new SqlCommand("Select * from DailyUserLoggedInStatus  Where UserID = " + userId.ToString() + " AND LastLoginDate = '" DateTime.Now.ToString("d")+"'", con);
  da = new SqlDataAdapter(com);
  DataSet ds = new DataSet ();
  da.Fill(ds);
  if (ds.Table[0].Rows.Count>0)
  {
    //Already logged in today 
    return;
  }
  else
  {
    com = new SqlCommand("UPDATE DailyUserLoggedInStatus  SET LastLoginDate = '" + DateTime.Now.ToString("d")+"' WHERE UserID = " + userId.ToString(), con);
   com.ExecuteNonQuery();
  }
  //...Your more code
}

Follow below technique to implement this.

C#

protected void Login_Button_Click(object sender, EventArg e)
{
   //Check user credential
   if(AuthenticateUser)
   { 
     //Check if user logged in for today
     if(LoggedInToday)
        //Show error
     else
        //Update the table DailyUserLoggedInStatus
   }
}

If you are not able to solve the problem, Please copy your code here.

Posted 21-Nov-12 19:08pm

Mohd. Mukhtar

Updated 21-Nov-12 19:35pm

v3

Solution 3

Create a table with columns - usercode,date of login, page viewed & sysdate to store user login details. When a user logged in, make an entry in that table.
Then you can easily find out whether that user has logged into the application
or not. if the count per day for that particular user is greater than 1, then u can lock the user from logging in.

Thanks & regards,
Fathima.

Posted 21-Nov-12 19:46pm

Fathima, Coimbatore

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)

jkirkerx · Accepted Answer · 2012-11-21T19:21:00

Make 2 columns in a table, lastLogin and lockout, then Just write the last login date into a table column, and when they logout, flip the bit in the lockout column to 1.

Then when they login, if the lockout bit is 1, calculate the next available date to login, if it's the next day, unlock them and let them login.

[Edit]

you might need this to unlock the account

UPDATE CustomerInfo Set Lockout = 0 WHERE AccountName=@AccountName AND DATEDIFF(hour, LastLogin, GetDate()) > 0"