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); }