public HttpResponseMessage CheckExpireDate(string key)
{
UserKeyExpireCheck result = _sendGridProvider.CheckExpireDate(key);
if (result.ExpireBoolean == false)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, result));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
}
public UserKeyExpireCheck CheckExpireDate(string check)
{
UserKeyExpireCheck user = new UserKeyExpireCheck();
DateTime key = new DateTime();
using (var conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Users_Select_ByPasswordKey";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Key", check);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
key = (DateTime)reader["PWResetExireDate"];
user.Id = (int)reader["UserId"];
}
reader.Close();
}
conn.Close();
}
DateTime today = DateTime.UtcNow;
DateTime expireDate = key;
int result = DateTime.Compare(today, expireDate);
if (result <= 0)
{
user.ExpireBoolean = true;
user.ReturnMessage = "key not expired ";
}
else
{
user.ExpireBoolean = false;
user.ReturnMessage = "key expired ";
}
return(user);
}
