public void CountUserLogin(string userid)
{
LoginCounts countLogin = this.GetLoginCountById(userid);
if (countLogin != null)
{
countLogin.UserId = userid;
if (string.IsNullOrEmpty(countLogin.NumberOfTimes.ToString()))
{
countLogin.NumberOfTimes = 1;
}
else
{
countLogin.NumberOfTimes = countLogin.NumberOfTimes + 1;
}
countLogin.LastLoggedInDate = DateTime.Parse(GenericHelpers.Date());
this.Update(countLogin);
}
else
{
LoginCounts newcountLogin = new LoginCounts();
newcountLogin.UserId = userid;
if (string.IsNullOrEmpty(newcountLogin.NumberOfTimes.ToString()))
{
newcountLogin.NumberOfTimes = 1;
}
else
{
newcountLogin.NumberOfTimes = countLogin.NumberOfTimes + 1;
}
newcountLogin.LastLoggedInDate = DateTime.Parse(GenericHelpers.Date());
this.Insert(newcountLogin);
}
}
public int Update(LoginCounts lc)
{
string commandText = "UPDATE " + fullTableName + " set " +
FieldUserId.Quoted() + " = @UserId, " +
FieldNumberOfTimes.Quoted() + " = @NumberOfTimes, " +
FieldLastLoggedInDate.Quoted() + " = @LastLoggedInDate " +
" where " + FieldUserId.Quoted() + " = @UserId";
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@UserId", lc.UserId);
parameters.Add("@NumberOfTimes", lc.NumberOfTimes);
parameters.Add("@LastLoggedInDate", lc.LastLoggedInDate);
return(_database.Execute(commandText, parameters));
}
public int Insert(LoginCounts lc)
{
//var lowerCaseEmail = user.Email == null ? null : user.Email.ToLower();
string commandText = "insert into " + fullTableName +
"(" + FieldUserId.Quoted() + ", " +
FieldNumberOfTimes.Quoted() + ", " +
FieldLastLoggedInDate.Quoted() + ")" +
" VALUES (@UserId, @NumberOfTimes, @LastLoggedInDate);";
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@UserId", lc.UserId);
parameters.Add("@NumberOfTimes", lc.NumberOfTimes);
parameters.Add("@LastLoggedInDate", lc.LastLoggedInDate);
return(_database.Execute(commandText, parameters));
}
internal static LoginCounts loadLoginCount(Dictionary <string, string> row)
{
if (row == null)
{
return(null);
}
if (row.Count == 0)
{
return(null);
}
LoginCounts LC = null;
LC = (LoginCounts)Activator.CreateInstance(typeof(LoginCounts));
LC.UserId = row[FieldUserId];
LC.NumberOfTimes = string.IsNullOrEmpty(row[FieldNumberOfTimes]) ? 0 : long.Parse(row[FieldNumberOfTimes]);
LC.LastLoggedInDate = string.IsNullOrEmpty(row[FieldLastLoggedInDate]) ? DateTime.Now : DateTime.Parse(row[FieldLastLoggedInDate]);
return(LC);
}
